Establishing a JDBC Connection to Progress Databas

[stefanm]

Hi there,

i downloaded yesterday the Jaspersoft Enterprise Edition 3.7 Trial. So far so good, Jasper Server is runnig well on my localhost.

What i am trying now is adding a OpenEdge 10 Progress Database as Datasource via JDBC Driver.

I ve made the following steps and hope u can tell me where i did a mistake or why it doesnt work:

1. I put the openedge 10.1 JDBC Driver(openedge.jar) in the jasperserver-pro-3.7apache-tomcatwebappsjasperserver-proWEB-INFlib Directory.

2. I restarted my Tomcat Server

3. I logged into JasperServer as Superuser and created a new Folder in the Repository.

4. I tried to add a new Datasource and entered the following values:

Driver: com.ddtek.jdbc.openedge.OpenEdgeDriver
URL: jdbc:datadirect:openedge://localhost:-1;databaseName=hhhkr;serviceName=hkrolap

5. When i click on Connection Test i get the following exceptions(Code section)

The Progress database is running properly, i get an access through SQL Explorer.
Iam sure i did something wrong with the JDBC Driver i hope you can give me a Tip

 

Greets from Germany,

Stefan

 

P.S.: Please excuse my bad english, school is over a long time ago ;-)

 

Code:

Post Edited by stefanm at 07/28/2010 08:11

[stefanm]

I found the solution.

I took the wrong/not all .jar Files that are needed.

If anyone have the same problem with OpenEdge 10.1C you need the following files:

dlc/java/pool.jar
dlc/java/spy.jar
dlc/java/openedge.jar
dlc/java/util.jar
dlc/java/base.jar

In Progressversions < 10.1C you need only progress.jar and jdbc.jar.

 

Greets,
Stefan

[kblackwel]

Stefan,

 

I'm trying to get Jasper to work with openedge? Not having any luck. Got any pointers? Here's my posting.

 

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=107&topicid=77886