Progress 4GL connection

[istvan.hollo]

Have anyone of you tried to connect a Progress 4GL database via JDBC driver? (OpenEdge 10.1A or 10.1B)

TIA
-istvan

[Isomorphic]

Our current built-in JDBC connectivity is mainly for prototyping purposes and doesn't support the Progress DB, but you should be able to connect to Progress 9 (if I'm reading your requirement correctly) via Hibernate.

See path 1b in the diagram here: http://www.smartclient.com/docs/5.5....verIntegration and take a look at the custom datasource integration example in the downloadable SDK. You can download our SDK here:

http://www.smartclient.com/product/download.jsp

Once you have it running, navigate to this url for the custom datasource integration example:

http://localhost:8080/examples/serve...rceIntegration

[istvan.hollo]

First of all, thank you for your response.

To use v9 database is not an option because we are on OpenEdge already.
But, are few movements: now I'm succeeded to adapt OE JDBC driver by editing server.properties. It seems is called but returns back with an error about the url was passed is not correct. I do not see any mistake in the url and it should work. I guess the problem can be avoided to look for what SmartClient is doing with this url and how use it. Could you give any help on where should I check this ? (In which source.)

TIA,
-istvan

PS: not sure if it works with a v9 DB because in Progress v9 the supported java version is 1.3 which I can not use for SmartClient.

[Isomorphic]

Hi istvan -

Can you post your server.properties configuration (just your database portion) here so we can take a look?

[istvan.hollo]

Sure, I'll do it offline to support at your server.

TIA,
-istvan

[Isomorphic]

Hi istvan -

Thanks for sending your configuration. I see several potential problems. First, the SQL databinding layer that we currently provide only works against Postgres, Mysql, Oracle, DB2 and HSQL. What I was recommending before was using an Object-Relational Mapping technology like Hibernate to expose your database records as beans which can then be integrated with SmartClient using path 1b or 1c in the diagram here:

http://www.smartclient.com/docs/5.5....verIntegration


I'm not personally very familiar with OpenEdge, but if you know which one of the databases I listed above OpenEdge is most like in terms of SQL syntax, data types, etc, then you can tell SmartClient to use one of the supported drivers to connect to OpenEdge. In your server.properties you need to set e.g:

sql.OpenEdge.database.type: oracle

Next, you need to change the sql.defaultDatabase property to OpenEdge like so:

sql.defaultDatabase: OpenEdge

Finally, you need to make sure you've included the JARs for the JDBC driver for OpenEdge in WEB-INF/lib.

Also note that you can use the "Admin Console" to play with these settings interactively. The Admin Console is available at this URL in your local SmartClient SDK:

http://localhost:8080/tools/adminConsole.jsp

Good luck - hope this helps.

[istvan.hollo]

Finally, you need to make sure you've included the JARs for the JDBC driver for OpenEdge in WEB-INF/lib.

Thanks for your response.
I did everything you suggested but no success, I still have this "url problem".
One small thing, somewhere in the doc I found that JDBC files need to be copied into WEB-INF/classes, here you mentioned WEB-INF/lib. Anyway, I tred both and also tried to add these jar files manually in ebmeddedtomcat.sh, the result is the same.

Do you change anything on the url typed by me before calling the driver?
Anyway, I think this will not work in that version but if we decide to use SmartClient we should solve it, in which I can offer my help, of course.

Greetings,
-istvan

[dinuka]

First of all you have create a user in OpenEdge Database using AppBuilder in order to connect to database.
Then you will find all supported .jar files on OpenEdge/java folder.Add those to you /lib folder and you may write a normal jdbc connection class.
For more information : https://documentation.progress.com/o...l%23wwID0EJ3BK