JDBC connection to Progress database 9.1E

P

pinik_03

New Member
Hi,

I am trying to connect to the remote Progress database9.1E on unix machine 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.

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.
 
Do you have a secondary SQL broker configured?
If the 4GL remote clients are using all of the remote servers then the database can't serve SQL-92 clients.

I think both issues have the same cause.

Regards,

Casper.
 
Hi Casper,

Thanks for the reply.

I think SQL broker configuration need to be done on server side to accept java client calls. But how do i check whether this has been configured or not. Because i am trying to access progress database from windows client using SQL explorer tool. Database is in HP-UNIX macihne.

And i got to know that Progress8.3b is installed on the Hp-Unix. On my machine windows client Progress9.1E is installed. That means should i also install the Progress8.3b on my machine. And does SQL-89 support java? I mean can i make JDBC connection with the Progress8.3b. Is SQL explorer tool available with 8.3b version?

Please let me know. I will make an action accordingly.

Thanks,
Pinik
 
And does SQL-89 support java? I mean can i make JDBC connection with the Progress8.3b. Is SQL explorer tool available with 8.3b version?
Click to expand...

I'm affraid it doesn't support. JAVA support has been presented since 9.0 and SQL92
 
Is there any other way to connect to Progress8.3b from Java application. If so where can i download the JDBC drivers to connect to Progress8.3b database? PLease let me know.

I tried OpenLink JDBC drivers which is universal to access any database but still not working.

Have Downloaded for Single Tier(Database specific networking) here : http://www.openlinksw.com/

Should i need to download for Multi-Tier(Database independent networking)?

Please provide some help. Its very urgent.

Thanks,
Nalini.
 
pinik_03 said:
Is there any other way to connect to Progress8.3b from Java application. If so where can i download the JDBC drivers to connect to Progress8.3b database? PLease let me know.
Click to expand...

You can consider using external call or something like that to get data from the database. But the best way is to update PROGRESS.
 
No, upgrading the Progress version is not possible. So i need to work with the existing 8.3B
If any idea please do let me know.
 
You must log in or register to reply here.
Back
Top