This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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 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?
Joined: Jul 19, 2006
I found the required drivers for ProgressDB and its working now.
author & internet detective
Pinik, Great. Would you care to share where you found the driver for people reading this in the future?
Joined: Jul 19, 2006
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.
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