Which DLLs are needed when connecting to Progress 9.0B using JDBC?

[MagnusOlofsson]

Dear all.

I'm trying to connect to a Progress database using the 9.0B java driver.

I have been able to eliminate a lot of java.lang.UnsatisfiedLinkErrors by copying the required DLLs, but there is one java.lang.UnsatisfiedLinkError which is not going away.

java.lang.UnsatisfiedLinkError: nativeConnect
	at com.progress.sql.jdbc.ProgressConnection.nativeConnect (Native Method)

	at com.progress.sql.jdbc.ProgressConnection.<init>(ProgressConnection.java:109)

	at com.progress.sql.jdbc.ProgressDriver.connect(ProgressDriver.java:160)

	at java.sql.DriverManager.getConnection(DriverManager.java:517)

	at java.sql.DriverManager.getConnection(DriverManager.java:177)

	at com.eds.cpadsfs.DatabaseConnection.connect(DatabaseConnection.java:54)

	at com.eds.cpadsfs.DatabaseConnection.main(DatabaseConnection.java:106)

Any hints is greatly appreciated.
/Magnus

 

[EpicXtreme]

Hi Magnus,
I don't know anything on Java but I found this in Progress and this is what progress says about JDBC drivers hope it helps you.

SUMMARY:

This solution applies to Progress Version 9.1A and Apptivity (or java
application) Versions 3.1 and 3.2. It explains the requirements to
establish a connection through the Progress Version 9.x JDBC Driver.

The solution assists you if you need to run your Java application
against a Progress Version 9.x database using the native Progress
Version 9.1 JDBC driver to get faster access. Tests show it works with
the JDK 1.1.8 release.

SOLUTION:

In order to get the native JDBC connection working, it is important to
set the correct CLASSPATH and PATH to let the application find the
shared libraries:

- Classpath:

In addition to the Apptivity classes set by the Progress
Apptivity installation, the CLASSPATH must contain the
classes for the native Version 9.x database JDBC driver. If
Progress is installed on E:\DLC91A:

set CLASSPATH=
E:\DLC91A\java\jdbc.zip;
E:\DLC91A\java\progress.zip;
E:\DLC91A\java

The path must contain the Version 9.x shared libraries. If
Progress is installed on E:\DLC91A:

set PATH=
E:\DLC91A\BIN;
E:\DLC91A\jdk\BIN;
E:\DLC91A\jre\BIN

- Other environment variables, for example:

set JAVAHOME=E:\DLC91A\java
set JDKHOME=E:\DLC91A\jdk
set JREHOME=E:\DLC91A\jre
set DLC=E:\DLC91A

- The Progress Version 9.x native JDBC driver name:

com.progress.sql.jdbc.JdbcProgressDriver

- The database connection URL:

The database connection URL is the same as you use with your
Progress SQL Explorer. As soon as you can connect with the
SQL Explorer using the native Version 9.x JDBC driver you
see the correct URL to use with Apptivity and you also have
the correct environment settings on that machine.

Example URL for the Sports database:

on host: pcebi2
port: 3001

jdbc:jdbcprogress:Tcebi2:3001:sports

Reference to Written Documentation:

Progress JDBC Driver Guide, Release Note 091A-00256.
Carmelo Brual (IT Specialist)
Progress DBA
Cognos Impromptu Administrator
Cognos Impromptu Reporting

 

[poepie]

Hi,

I'm a java programmer for almost 4 years.

Now I have a client who has a progress application. I want to write an additional program, connected to his progress DB. I thought the progress version was 8.3, but I'm not sure. Where can I find a JDBC driver to connect to the progress DB? Is it standard installed with Progress?

Thanks,
Bert Sucaet (Programmer)

 

[EpicXtreme]

Hi Bert,

The above zip files come with the installation of progress, but it is only in version 9.x as far as I know. I've checked to see if I could find literature on JDBC drivers for version 8.x but came up empty. So I think it's only for version 9.x and up. Good luck. Carmelo Brual (IT Specialist)
Progress DBA
Cognos Impromptu Administrator
Cognos Impromptu Reporting

 

[poepie]

Hi Carmelo.

Have you already tested that JDBC driver for an older version of progress. Because my client has version 8.3 and he he will not upgrade, because the software he uses is an standard 3th party application and all there clients have 8.3. I will create extra reports using the data from the 3th party company.

On

http://www.minq.se

you can download a free database tool using JDBC (DBVisualiser) for testing the JDBC driver.

Maybe you can mail these 2 zip files to poepie123456@hotmail.com and I will test it.

Do you know a JDBC driver for version 8.3? Do you know an URL were I can download it. I've been searching on the web for several hours, but I can't find it.

Thank you for the time.
Bert