JDBC Connection

[linkjaya]

Hello All,

I have progress OpenEdge 10.A installed in my machine.
I was trying to connect a progress database in java using JDBC driver.
I went through Progress® JDBC Configuration manual given in psdn.com.
According to that manual i must be finding following files.
$DLC\java\jdbc.jar
$DLC\bin\JdbcProgress.dll
$DLC\bin\procli92.dll

First thing was i could not find these files, i found those files in previous installation i.e on previous version of progress.

I tried to use those files and jdbc.jar, but i could not connect to my database.

Is there any specific jdbc.jar , JdbcProgress.dll and procli92.dll for each version of Progress OpenEdge
If yes, then where could i find those files
if no, why i counld not connect the to progress database.

Can some one help me.
please send me sample codes and necessary instructions for configuring Progress for JDBC connection.


Any Help will be appreciated.


Regards
Jaya

 

[sarani]

Add to the PATH $DLC/lib

Copy $DLC/java/jdbc.jar and $DLC/java/progress.jar in $DLC/lib

Add a user or SYSPROGRESS in your database user, with a password( i think it's necessary for mode SQL )

And now this is my code

I start my database in port 25003

/********************Essai.java***********************/
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;

public class Essai
{

public Essai()
{
}

public static void main(String args[])
{
try
{
Class.forName("com.progress.sql.jdbc.JdbcProgressDriver");
Connection connection = DriverManager.getConnection("jdbc:JdbcProgress:T:192.168.124.23:25005:bddecision", "SYSPROGRESS", "test");
java.sql.Statement statement = connection.createStatement();
System.out.println("Execution reussie");
}
catch(Exception exception)
{
System.out.println("Execution impossible");
}
}
}
/**************************************************/

And now enjoy, i think my English is not so bad.

Je crois que je me suis bien exprimé. Allez, ciao.

 

[linkjaya]

Thanks for your reply sinary.

The problem with me was, i could not find jdbc.jar in my installation directory.
Do i need to install something extra to get thar jdbc.jar file?

My progress openEdge version is 10.A.

By the way , you can express your things in english very well.


Regards
Jaya

 

[sarani]

In Windows intallation or Linux, you can see the file jdbc.jar in the INSTALL_DIR/java.

Best Regards ) .

 

[linkjaya]

Sorry to say, but there is no such jdbc.jar in my INSTALL_DIR/java directory.
Can some one give me that file.


Regards
Jaya

 

[KlausErichsen]

Sorry to say, but there is no such jdbc.jar in my INSTALL_DIR/java directory.
Can some one give me that file.

Hello Jaya,
the file names have changed.

See documentation
Book: OpenEdge® Data Management: SQL Development
Chapter: JDBC Client

"The JDBC architecture consists of several files. The JDBC driver includes the openedge.jar, util.jar, base.jar, pool.jar, and spy.jar files. Table 2–1 lists the locations of the files."

Do not use the old 9.1x driver!

Best Regards
Klaus

 

[istvan.hollo]

Do not use the old 9.1x driver!

Hi Klaus,
On 10.0B/Linux was still jdbc.jar and other ones provided and Jaya mentioned 10.0, but you are right, in 10.1A and B new JDBC driver was introdueced. Additionally, messages.jar should be included in the CLASSPATH as well.

So, Jaya, if you do not found jdbc.jar nor openedge.jar, it means JDBC driver is not installed and you have to reinstall your progress. On "how to set up" both environment you find enough information in KB.

Greetings,
-istvan