topic Re: TOS with Progress OpenEdge 10 in Talend Studio

TOS with Progress OpenEdge 10

Anonymous — Sat, 16 Nov 2024 14:05:51 GMT

Has anyone tried TOS with OpenEdge 10.1 ?
I'm using it through general JDBC but I had to do some major adaptations:
1. The jdbc driver is containes in 3 jar files and TOS does not seems to allow to specify 3 jars for the driver. I combined all the 3 jars into one jar file but this is a really buggy solution.
2. I had to modify a new mapping files because some datatypes were not reconized.
Anybody else had to go through this or had a better solution ?

Re: TOS with Progress OpenEdge 10

_AnonymousUser — Fri, 24 Apr 2009 12:49:44 GMT

As far as I know the Progress odbc requires 5 jar files, maybe that's the reason for the buggyness
The files are base.jar, openedge.jar, pool.jar, spy.jar and util.jar

Re: TOS with Progress OpenEdge 10

_AnonymousUser — Fri, 24 Apr 2009 13:10:09 GMT

No need to make a new jar, just specify mutliple jars.
I can connect using following settings
DB Type : Generic JDBC
JDBC URL : jdbc:datadirect penedge://host ort;databaseName=DBNAME
Driver jar : c:\progress\oe101c\java\base.jar;c:\progress\oe101c\java\openedge.jar;c:\progress\oe101c\java\pool.jar;c:\progress\oe101c\java\spy.jar;c:\progress\oe101c\java\util.jar
User name : sysprogress
Password (must not be empty) : ******
Mapping file (I didn't enter this value) : mysql_id

Re: TOS with Progress OpenEdge 10

Anonymous — Wed, 13 May 2009 09:13:16 GMT

Hi !
Where can I find these 5 jar file ? Are they in the installation cd of progress ?
PS : i use OpenEdge 10.0B
Thanks !

Re: TOS with Progress OpenEdge 10

Anonymous — Mon, 18 May 2009 14:29:43 GMT

Thanks for your reply ! lol
For your information, with OpenEdge 10.0B, it's not these files but just jdbc.jar and progress.jar which are in $dlc/java directory.

Re: TOS with Progress OpenEdge 10

tale103108 — Fri, 22 Jun 2012 20:13:04 GMT

isn't a Class name also required. I have tried "com.ddtek.jdbc.openedge.OpenEdgeDriver" with no luck.
Any suggestions?
Cheers!

Re: TOS with Progress OpenEdge 10

Anonymous — Fri, 23 Oct 2015 13:59:29 GMT

I have the same problem.... any idea ??
url jdbc : jdbc:datadirect: openedge://xxx.xxx.xxx.xxx:xxx;databaseName=XXX
pilotejar: messages.jar;progress.jar;prosp.jar;prowin.jar;schema.jar
nom de la classe : com.ddtek.jdbc.openedge.OpenEdgeDriver
utilisateur: xxx
mot de passe : xxx

Echec de la connexion Vous devez modifier les paramètres de la base de données.
  java.lang.RuntimeException: java.lang.ClassNotFoundException: com.ddtek.jdbc.openedge.OpenEdgeDriver
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1033)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2663)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
  Caused by: java.lang.ClassNotFoundException: com.ddtek.jdbc.openedge.OpenEdgeDriver
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:90)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:115)
      ... 9 more