Progress with Java

[sureshp]

Can i use java application to access data from Progress Database. If so wat driver i hav to use and where can i get it from

 

[parul]

Yes you can access progress database from java.
URL and classname depends on your Progress version.

It's always good to give progress version with your question.
KB id : P110482
Does give you example and sample code. There are a lot of articles on JDBC on Knowledge base and PSDN try searching there as well.

-Parul.

 

[DevTeam]

I hope that you have to connect to a Progress v10 database, because JDBC access from Java to a v9 DB is quite slow..........

 

[sureshp]

I hope that you have to connect to a Progress v10 database, because JDBC access from Java to a v9 DB is quite slow..........

Progress version is 9.1D09

 

[TomBascom]

Of course you really ought to upgrade to OE10 but if you cannot there are major improvements between 9.1d09 and 9.1e04. 9.1e04 is the final release of version 9, there will be no more, and anyone still running version 9 should upgrade to 9.1e04.

Any vendor that claims you cannot upgrade from 9.x to 9.1e04 is full of bologna. If they claim that they "won't support you" if you do it anyway then you really ought to be asking yourself if their "support" is worth having in the first place...

 

[DevTeam]

Progress version is 9.1D09

Bad luck, the SQL engine has been really improved in OpenEdge...

Anyway, you can use the JDBC driver to connect a V9 database from Java, here's an example of the connection properties :

String drv = "com.progress.sql.jdbc.JdbcProgressDriver";
String url = "jdbc:jdbcprogress:T:" + host + ":" + port + ":" + dbname;

If ever you manage to get an OpenEdge version, it's quite different :

String drv = "com.ddtek.jdbc.openedge.OpenEdgeDriver";
String url = "jdbc:datadirect:openedge://" + host + ":" + port  + ";databaseName=" + dbname;