Connection to Progress Database

[Pinik Tilli]

Hi,

I would appreciate if anyone could let me know how to connect to the Progress Database using JDBC. The driver installed is MERANT3.70 32-bit progress ODBC driver. I am able to connect and view the records in Excel.
But i need to write a java application for this.

Thanks,
Pinik.

[Jeanne Boyarsky]

Pinik,
Start with the JDBC tutorial. After you've started reading it, feel free to post back here with any questions.

[Pinik Tilli]

Hi Jeanne,

Thanks for your reply. I have used JDBC extensively before so connecting and retreiving the records is not a problem. A special driver is required to access the Progress9.1 Database. I assume JdbcProgress Driver is required to connect but not able to find this driver.
Can you suggest me where can i download this driver?

Thanks.

[Pinik Tilli]

I found the required drivers for ProgressDB and its working now.

Thanks,
Pinik.

[Jeanne Boyarsky]

Pinik,
Great. Would you care to share where you found the driver for people reading this in the future?

[Pinik Tilli]

Hi,

I have found the drivers by installing the client components in the ProgressCD, these client components consists of the required jar files.
I am able to load the driver but not able to make a connection with database.


I am trying to connect to the remote Progress database9.1E on unix using JDBC from windows client. But the program would never return anything.


There are 2 issues:


1) When trying to make a connection from the java application, no exception is thrown but getConnection(url,username,password) method never returns. The program gets hang forever.


Here is the code snippet :



String URL = "jdbc:jdbcprogress:T:hp19rm5:4008:vgb";
String username = "eduard";
String password = "sav3uka";
try {
// Class.forName("com.progress.sql.jdbc.JdbcProgressDriver");

DriverManager.registerDriver(new com.progress.sql.jdbc.JdbcProgressDriver());
System.out.println(" Driver loaded ");

Connection con = DriverManager.getConnection(URL,username,password); // gets hang here.

System.out.println(" connection obtained"); // is never printed
}



Note : I have set the classpath and path varaibles exactly as documented in the progress documentation.

Included progress.jar and jdbc.jar in classpath

and C:\Program Files\Progress\bin in path.
(bin contains the .dll files)


2) I am trying to connect to the Progress Database9.1E using SqlExplorer tool. But still i am not able to get the connection with the database. And the exception is:

java.lang.UnsatisfiedLinkError: java/security/AccessController.doPrivileged Possible causes: If you are trying to use J/Direct (@dll.import), check your compiler version (for JVC, requires 4336 or greater.) If you are trying to use RNI, there are new requirements: see documentation.
at java/security/AccessController.doPrivileged
at java/rmi/server/RemoteServer.<clinit>
at com/progress/vj/explorer/ProgressExplorer.getClientEventBroker
at com/progress/vj/util/ProDialog.<clinit>
at com/progress/vj/util/ProDialog.getActiveProDlg
at com/progress/vj/util/ProMsgBox.show
at com/progress/vj/util/ProMsgBox.error
at com/progress/vj/util/ProMsgBox.error
at com/progress/vj/sql/explorer/SQLExplorerGUI.workingCallback
at com/ms/lang/Delegate.dynamicInvoke0
at com/ms/lang/Delegate.dynamicInvoke
at com/ms/wfc/ui/Control.invokeMarshaledCallback
at com/ms/wfc/ui/Control.wndProc
at com/ms/wfc/ui/Form.wndProc
at com/ms/wfc/app/Application$ParkingForm.wndProc
at com/ms/wfc/ui/Control$ControlWindow.wndProc
at com/ms/wfc/app/Window.callback
at com/ms/wfc/win32/Windows.DispatchMessage
at com/ms/wfc/app/Application$ThreadContext.runMessageLoop
at com/ms/wfc/app/Application.run
at com/progress/vj/sql/explorer/SQLExplorerGUI.main


Please write me some solution for these issues.



Thanks,

Pinik.