Cannot connect to Progress DB

Classic Servoy
21

I was forgotten to mention that it was tested on Progress 9.1D and the files you need are in de java directory of your Progress installation. It should also work for Progress 10.x.

22

Great, i’m gonne test that out
Thanks
=)

23

coan:
Cleaned installed Servoy 3.5.4
jdbc driver from Progress OpenEdge: openedge.jar (in attachment)
Placed in the Servoy/driver/ folder

But Servoy does not recognize the driver…
I tried to set manually the driver “com.ddtek.jdbc.openedge.OpenEdgeDriver”
But no go… error message:

java.sql.SQLException: JDBC Driver ‘com.ddtek.jdbc.openedge.OpenEdgeDriver’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: com.ddtek.jdbc.openedge.OpenEdgeDriver com.ddtek.jdbc.openedge.OpenEdgeDriver

when you install a new driver, you need to quit & re-launch Developer. Developer loads its driver jars upon startup. Could that be the answer …?

kazar

24

You must include the following jar files in your classpath:
%DLC%/java/openedge.jar;%DLC%/java/util.jar:%DLC%/java/base.jar

see also: http://www.psdn.com/library/servlet/KbS … /dmsdv.pdf

25

YES!!!
Servoy talks to Progress OpenEdge 10.1B!!!

So, thanks to the hints of Danny I just threw:
openedge.jar
progress.jar
base.jar
util.jar
in the /Servoy/drivers/

URL: jdbc:datadirect:openedge://host:port;databaseName=dns;
Driver: com.ddtek.jdbc.openedge.OpenEdgeDriver
:D

Up to the next issue…

com.servoy.j2db.persistence.RepositoryException: org.apache.commons.dbcp.DbcpException: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519) java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)

:?

Koen

26

No more errors at this point.
The error:

Table/View/Synonym not found (7519)

Is due to the schema: it was set to , and should be “pub”… (don’t ask me why)

I changed the URL:
URL: jdbc:datadirect:openedge://host:port;databaseName=dns;defaultSchema=pub

I found this in this link:
http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/12273?OpenDocument

8)

Koen