It is currently Thu Apr 17, 2014 4:23 pm




Post new topic Reply to topic  [ 10 posts ] 
 JDBC driver for Progress 9.1E 
Author Message
General
General

Joined: Fri Dec 03, 2010 6:58 am
Posts: 153
Post JDBC driver for Progress 9.1E
I am hoping to be able to connect to Progress 9.1E database.

Help///


Wed Sep 28, 2011 12:43 pm
Profile
General
General

Joined: Tue May 31, 2011 6:27 am
Posts: 313
Location: Minnesota
Post Re: JDBC driver for Progress 9.1E
If I'm not mistaken on the media provided with Progress there is a set of "client components" including a driver that will operate with JDBC.


Wed Sep 28, 2011 1:03 pm
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2417
Post Re: JDBC driver for Progress 9.1E
Generally, with JDBC available, we can get it to work with the system. Sometimes there are some intricacies that make things difficult, but hopefully we can work around those.

Unfortunately, none of us here have any experience with that system, so we can't help too much off the bat, but we can help with the process. Conveniently, I found a pretty good user's guide for the jdbc driver here.

The basic process:
1) Create a new database translator from System>Database>Drivers>Translators Tab.
2) Create a new driver entry
2b) Add the jar file(s)
2c) Configure the settings:
Class name: com.progress.sql.jdbc.JdbcProgressDriver
Url Format: jdbc:JdbcProgress:T:isis:5000:testdb
DB Translator: As created above
3) Create a new connection using that driver
4) Try to figure out what to tweak to make it work!

I got these values from the guide, hopefully they're correct. Obviously, the trickiest part is #4. Each database has a variety of quirks- from a decent validation query (a query that can be run to make sure the connection is ok, that returns 1 value), to the specific syntax for creating tables, indexes, id columns, etc.

Depending on what you want to do you may not have to get into all of that. If you just want to read data, for example, you may just need to get the validation query to work (and there's a good chance that the default "select 1" is fine). If you want to use all features, including transaction groups and sqltags (external, or sqltags history), you might have a bit more work on your hands.

Hope this gets you started,

_________________
Colby Clegg
Inductive Automation
Software Development


Wed Sep 28, 2011 5:11 pm
Profile
General
General

Joined: Fri Dec 03, 2010 6:58 am
Posts: 153
Post Re: JDBC driver for Progress 9.1E
Thank you both. I will work on this.


Thu Sep 29, 2011 4:38 am
Profile
General
General

Joined: Fri Dec 03, 2010 6:58 am
Posts: 153
Post Re: JDBC driver for Progress 9.1E
Quote:
Url Format: jdbc:JdbcProgress:T:isis:5000:testdb

It seems you may be an Archer fan...


I am having trouble in Data Type Mapping section.

What is this page asking for?
Attachment:
File comment: The Ignition Translator page...
jdbcTrans.jpg
jdbcTrans.jpg [ 105.94 KiB | Viewed 1913 times ]


Do any of these keywords go in the fields above?
Attachment:
jdbc1.jpg
jdbc1.jpg [ 214.37 KiB | Viewed 1913 times ]

Attachment:
jdbc2.jpg
jdbc2.jpg [ 166.49 KiB | Viewed 1915 times ]

Attachment:
jdbc3.jpg
jdbc3.jpg [ 79.99 KiB | Viewed 1916 times ]


Mon Mar 12, 2012 1:01 pm
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2417
Post Re: JDBC driver for Progress 9.1E
Quote:
It seems you may be an Archer fan...

I actually just copied that directly from something I found online... so any clever references are (unfortunately) not my responsibility! :lol:

So, that table is mapping our types to the database types. You can pretty much pull them directly from that first table you posted. We tend to just use "integer" for the main integer number types, but you can try using the more specific types. So, it looks like you would use the following:

I1=TINYINT
I2=SMALLINT
I4=INTEGER
I8=INTEGER? Maybe NUMERIC
Boolean=BIT
Datetime=TIMESTAMP
R4=REAL
R8=DOUBLE
String=VARCHAR
Binary=LONGVARBINARY

Hope this helps,

_________________
Colby Clegg
Inductive Automation
Software Development


Mon Mar 12, 2012 3:48 pm
Profile
Moderator
Moderator

Joined: Mon Oct 27, 2008 4:10 pm
Posts: 1904
Location: Folsom, CA
Post Re: JDBC driver for Progress 9.1E
Perhaps I don't understand what's going on here...

...but I have a connection to Postgres 9.1 on my dev machine and I did zero configuration work other than making sure the username, password, and database name were specified.

What are you guys doing?

_________________
Kevin Herron
Software Developer
Inductive Automation


Mon Mar 12, 2012 3:58 pm
Profile WWW
General
General

Joined: Tue May 31, 2011 6:27 am
Posts: 313
Location: Minnesota
Post Re: JDBC driver for Progress 9.1E
Kevin.Herron wrote:
Perhaps I don't understand what's going on here...

...but I have a connection to Postgres 9.1 on my dev machine and I did zero configuration work other than making sure the username, password, and database name were specified.

What are you guys doing?


er... Progress 9.1E?


Mon Mar 12, 2012 8:14 pm
Profile
General
General

Joined: Wed Jul 29, 2009 10:55 pm
Posts: 156
Location: Ireland
Post Re: JDBC driver for Progress 9.1E
Hi

This topic explains connecting to a 10.1.C progress DB. Might be of some help

Aidan

http://inductiveautomation.com/forum/viewtopic.php?f=54&t=7677&p=23736&hilit=progress#p23736


Mon Mar 12, 2012 11:31 pm
Profile
Moderator
Moderator

Joined: Mon Oct 27, 2008 4:10 pm
Posts: 1904
Location: Folsom, CA
Post Re: JDBC driver for Progress 9.1E
Oh wow, I see my problem... :oops:

You guys are talking about "Progress", not "Postgres". Durrrrrh. :oops:

_________________
Kevin Herron
Software Developer
Inductive Automation


Tue Mar 13, 2012 6:31 am
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron