aspose file tools*
The moose likes JDBC and the fly likes Connection to Progress Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection to Progress Database" Watch "Connection to Progress Database" New topic
Author

Connection to Progress Database

Pinik Tilli
Greenhorn

Joined: Jul 19, 2006
Posts: 19
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29219
    
135

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Pinik Tilli
Greenhorn

Joined: Jul 19, 2006
Posts: 19
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
Greenhorn

Joined: Jul 19, 2006
Posts: 19
I found the required drivers for ProgressDB and its working now.

Thanks,
Pinik.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29219
    
135

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

Joined: Jul 19, 2006
Posts: 19
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection to Progress Database
 
Similar Threads
DataSource?????
How Tomcat Works: connection pooling in tomcat
How to use Type 3 - Database Server Driver
ProgressBar & mysql
JdbcProgress connectivity