Connecting from java to Progress DB using RDBMS

O

ocohen

New Member
Hello,
I am new to the JDBC. I am writing a Java application, that have to monipulate data retrieved from Progress DB. I am using JDK1.7 and Eclipse Indigo. I searched all the instalations top-down and didn't find any JAR that contains the Progress connector. Where can I find it?

Regards
ocohen
 
Re: nnecting from java to Progress DB using RDBMS

A great deal depends upon which version of Progress you are using. You can find out by going to a "proenv" prompt and typing "showcfg".

If it has not already been done you will also need your Progress administrator to configure SQL access for you and provide you with the connection credentials.
 
Re: nnecting from java to Progress DB using RDBMS

Tom,
Thank you for your comment. The environment includes
  • Progress 10.1, running on Linux RedHat 5
  • Progress OpenEdge 10.1, running on Windows XT
  • JDK 6 EE, running on Windows XT
My first task is to write the generic class that will establish the communication with the DB, pass the query (will be received from the using classes as parameter) and return the results. I want also to build hook-up for future uploading data into dedicated tables. All these tasks will run in the Windows environment.

I am looking for is Java connector class that contains the Progress Edge driver. Can anyone help me with this?

Regards
Ocohen
 
Re: nnecting from java to Progress DB using RDBMS

Sorry, I know nothing about that sort of thing (Java coding).

If 10.1 has been setup properly you should be able to connect to it. I would think that you would want to confirm that before you go too far.

I would do the following on the Linux box:

1) Login and start "proenv". You should see a "proenv>" prompt. This confirms that you have a functioning Progress environment.
2) Type "ps -ef | grep -i sql" You should see some results -- if you don't then you need to talk to your DBA about configuring SQL-92 access.
3) Talk to your DBA anyway -- you need to know the port# (after the -S in the output above), a userid and a password in order to connect.
4) Connect using something similar to this:

sqlexp -user UserName -password Password -db dbName -S port

If that all works then you have a functioning SQL-92 on the Linux server. You should be able to do the same things (except for the "ps" command) from your Windows box. (You will need to add -H hostNameOrIPAddr.)

If that works you have a fully functional SQL-92 environment and you only need to figure out the Java part.

If the stuff above doesn't work then no amount of Java coding is going to help you.
 
Re: nnecting from java to Progress DB using RDBMS

Just to be a nitpicker... :D ... it is possible, if unlikely, that SQL-92 access is configured for your database but the ps | grep shows nothing, if (a) the broker (_mprosrv) was started without the "-ServerType SQL" startup parameter and (b) no SQL clients have connected to the DB since it started, so there are no SQL server (_sqlsrv2) processes running yet.

If this is the case, you should talk to your DBA anyway. It's not advisable to use the same broker for both 4GL and SQL clients.
 
You must log in or register to reply here.
Back
Top