JDBC driver to connect a Progress Database

Marian EDU

Member
Abdel,

do you continue to use Birt and Progress ?
(je serai très intéressé par une démo)

Salut Roland, we're more that using it (along with Jasper Reports or Pentaho)

If you are interested on a demo just let me know and we can arrange that ;)
 

AdanGMC

New Member
Hello all.

This is my first post. Sorry for my English,i speak Spanish :p.

Like AbdelBorowsky, i am in the same situation. I have a project and i try to make a connection with a Progress DataBase v10.0B. I use the .jars that was in the instalation folder (progress.jar & jdbc.jar). I call for the driver with com.progress.sql.jdbc.JdbcProgressDriver and use the url format like "jdbc:jdbcprogress:T:hostname:port:database".

My CLASSPATH = %CLASSPATH%; C:\Progress\OpenEdge\java\jdbc.jar; C:\Program Files\Java\jdk1.6.0_27\bin;

And my PATH = %path%; C:\Progress\OpenEdge\java; C:\Progress\OpenEdge\bin; %DLC%\bin\procli92.dll; %DLC%\bin\JdbcProgress.dll;

But it launch the same exception:

"No suitable driver found for..."

I was looking for answers on the web, but this is the only place when i found answers. Sadly, i try all the solutions you post but i cant make it work.

I´m desperate. could someone explain me where is the problem, please[FONT=arial, sans-serif].

[/FONT]I thank you all.

Adan GMC.
 

Marian EDU

Member
Is it an application writted by yourself ? Because with some application, .jar files have to be put in a specific folder.

Exactly, specifically for Birt but other Java report engines have different ways of handling those drivers...
 

AdanGMC

New Member
Yes, i write the Application. I also write a class only for test the connection but i have the same error. This is the code that i write:

__________________________________________________________________________________

public class ConnectProgress{
public static void main(String []args){
try {
Class.forName ("com.progress.sql.jdbc.JdbcProgressDriver");
String url = "jdbc:jdbcprogress:T:148.234.5.83:2500:sports";
String user = "usuario";
String pass = "contrasena";

Driver progressDriver = DriverManager.getDriver(url);

System.out.println("Driver for this url = " + progressDriver.toString());

Connection con = DriverManager.getConnection(url, user, pass);


if(con != null){
System.out.println("Conexion Open.");
con.close();
System.out.println("Conexion Close.");
}

} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
_____________________________________________________________________________

I put the jars in the Birt of my project and i add those to the Builid Path.
 

Marian EDU

Member
Adding the jar's to build path really makes no difference, you don't need them to compile the code as the driver will be loaded dynamically... when you do need them to be in the CLASSPATH is at run-time, depending on your development platform you have to change some settings to make those jar's available at run-time, for Eclipse you might consider this other post http://www.progresstalk.com/showthread.php?120282-JDBC-CLASSPATH-through-Eclipse

Sorry if my english is poor... I'm french...:D
There is no excuse for having great wine, beautiful ladies and 'la vie en rose' ;)
 

AdanGMC

New Member
hello, again me :p

I configure the path and classpath in my eclipse and add all the .jars.

And when i run the project it doesn´t work, but i can read in the generated log this.
-----------------------------------------------------------------------
Loading JdbcProgress library
******************java.library.path is $PATH$; C:\ProgressTest\bin;.
******************java.class.path is C:\Users\sams\Progress\bin;C:\Progress\OpenEdge\java\jdbc.jar;C:\Progress\OpenEdge\java\messages.jar;C:\Progress\OpenEdge\java\progress.jar;
Unable to load JdbcProgress library
no JdbcProgress in java.library.path-----------------------------------------------------------------------
After that, i change my library.path to point the dll files. and the log show this:

-------------------------------------------------------------------------
Loading JdbcProgress library
******************java.library.path is $PATH$; C:\Progress\OpenEdge\bin; C:\Progress\OpenEdge\lib;.
******************java.class.path is C:\Users\sams\Progress\bin;C:\Progress\OpenEdge\java\jdbc.jar;C:\Progress\OpenEdge\java\messages.jar;C:\Progress\OpenEdge\java\progress.jar;
Unable to load JdbcProgress library
C:\Progress\OpenEdge\bin\JdbcProgress.dll: Can't find dependent libraries
------------------------------------------------------------------------

Has anyone seen this before?

Saludos!
 

Marian EDU

Member
If you try it from Eclipse and you did follow the other thread on setting the CLASSPATH in the 'run configuration' then I think what you need to do is to add the path to JdbcProgress.dll to the PATH system variable... you either do it at the system level or add it in Eclipse's run configuration (on Environment tab select PATH variable and update the value, probably better to use 'append to existing environment' than replace).

http://progresscustomersupport-surv...1245?retURL=/apex/KnowledgeSearch&popup=false
 

phamthanhnhan14

New Member
Salut Roland, we're more that using it (along with Jasper Reports or Pentaho)

If you are interested on a demo just let me know and we can arrange that ;)
Hi Marian,
I want to connect from Pentaho to Progress OpenEdge 10.2 B via JDBC, what could i do next?
I can't find this
%DLC%\java\openedge.jar
%DLC%\java\util.jar
%DLC%\java\base.jar
%DLC%\java\pool.jar
%DLC%\java\spy.jar
in my DLC.
Any helps?
Regards,
Nhan
 
Top