JDBC adapter connection to Progress database

, ,
1

Has anyone successfully configured a JDBC Adapter connection to a Progress database? I have installed the Progress JDBC driver and can connect to the database, execute a select statement and close the connection using services in the WmDB package (pub.db:connect, pub.db:execSQL and pub.db:close). What I’d like to do, if it’s possible, is to set up a connection using the wM JDBC adapter package, but I’m not sure what the settings should be, especially the DataSource class. I’m using IS 6.1_SP1 with the JDBC Adapter 6.0.3. The Progress database is version 9.1E. Thanks,

Tim

2

I got it! I peeked at the classes in the jar file and found com.progress.sql.jdbcx.datasource.JdbcProgressDataSource and it worked. Thanks,

Tim

3

When you move up to Progress 10, you need to use class “com.ddtek.jdbcx.openedge.OpenEdgeDataSource” with the JDBC adapter. Works :slight_smile:

Chris

4

Hi Tim,

Can you please advise what all jars files have you loaded to make it work with Progress 9.
I am using the same driver but the below error persist.

zzTest.jdbcConn:ProgressConn: after 1 attempt(s). null

5

Hi Sunkari,
jdbc.jar or openedge.jar can be used to connect to Progress database… I haven’t worked on this. Below link has some information that might be useful for you…

[URL]http://www.progresstalk.com/showthread.php?109511-JDBC-Connection[/URL]

HTH
Senthil

6

Hi Senthil,

Thanks for the information.
I am using the above jar and able to connect via wMDB adapter but using JDBC adapter which i am having issue.
I used
com.progress.sql.jdbcx.datasource.JdbcProgressDataSource driver
still not able to connect.

Regards,
Srini.

7

Hi Srini,
Were you able to find that class file when you extract the jdbc jar in the same path ?

If you can find, keep the file under IntegrationServer/lib/jars and restart the server once…

If you cannot find, then you will have to look for a different class file that can be used to connect…

Regards
Senthil

8

Hi Senthil,

I can find the classes in jdbc.jar and i already did the same as mentioned by you,still it doesnt work.

Regards,
Srini.