Unable to connect Progress database via jdbc

does

sqlexp -char -url jdbc:jdbcprogress:T:localhost::

work if you run that command on the server machine ?

Hi Bunty,

Did you look at below articles?

knowledgebase.progress.com/.../000053196

knowledgebase.progress.com/.../P15898

Thanks,

Akthar.

thanks gus bjorklund and sorry for late reply. We are getting below result for this command

batch-2.05a$ /app/dlc/91d/bin/sqlexp -char -url jdbc:jdbcprogress:T:localhost::5160

PROGRESS Version 9.1D09 as of Tue May 25 05:35:09 EDT 2004

Progress sqlexp Messages:

Java Virtual Machine could not be found

JREHOME environment variable may not be set correctly.

Set JREHOME variable to a valid directory.

JREHOME setting: /usr/java/j2re1.4.2.2_04

Thanks

Hi Makhtar

I tried with driver configuration details given on these posts but it return JDBC Drvier did not return any connection.

>>

Java Virtual Machine could not be found

JREHOME environment variable may not be set correctly.

Set JREHOME variable to a valid directory.

JREHOME setting: /usr/java/j2re1.4.2.2_04

<<

This needs fixing. No java, no _sqlsrv2 spawned, no _sqlsrv2 no JDBC/ODBC connection.

This is defined in DLC/bin/java_env and has to point to an existing JAVA version. (which also should be 1.3 seeing you are on 9.1D).

Also see knowledgebase.progress.com/.../P5893 about settings in java_env.

Hi Libor Laubacher

I have configured JREHome. Now I am receiving below result for command

bash-2.05a$ /app/dlc/91d/bin/sqlexp -char -url jdbc:jdbcprogress:T:localhost::5160

PROGRESS Version 9.1D09 as of Tue May 25 05:35:09 EDT 2004

A port number or a service name must be specified. (8987)

batch-2. 05a$

sorry. my example was bad. there should be one colon before the port number, not two

so try thusly

bash-2.05a$ /app/dlc/91d/bin/sqlexp -char -url jdbc:jdbcprogress:T:localhost:5160

+ :dbname

+ after fixing java_env you also need to bounce the database, as same settings (JREHOME) are used to spawn _sqlsrv2 process

Here is output for command :

bash-2.05a$ /app/dlc/91d/bin/sqlexp -char -url jdbc:jdbcprogress:T:localhost:5160:hklive

PROGRESS Version 9.1D09 as of Tue May 25 05:35:09 EDT 2004

Connecting user "mfg" to URL "jdbc:jdbcprogress:T:localhost:5160:hklive"... (8920)

Error: [JDBC Progress Driver]atabase not started. (8933)

See "/home/mfg/sqlexp.log" and "/home/mfg/SQLExplorer.exceptions" files for more information. (8950)

bash-2.05a$

Also in Java folder for establish connection from java application, I can see below jar files. Do I need to ask them any other file

jdbc.jar

messages.jar

progress.jar

prosp.jar

schema.jar

/ext/fm.jar

/ext/jmxri.jar

/ext/mgmt_agent.jar

/ext/mgmt_client.jar

/ext/mgmt_config.jar

> Error: [JDBC Progress Driver]atabase not started. (8933)

+ after fixing java_env you also need to bounce the database, as same settings (JREHOME) are used to spawn _sqlsrv2 process

By bounce the database, you mean to restart database server?

Yes, sorry, restart.

You can double check first on a test database whether jdbc now works or not

on the server:

proenv

prodb abc sports

proserve abc -S 9940

sqlexp -char -url jdbc:jdbcprogress:T:localhost:9940:abc

does that work ? If so, the JDBC connection to 'hklive' should work after it has been restarted.

Hi Libor Laubacher

After restart server, I am getting below error.

Error: [JDBC Progress Driver]:Database not started

Were you able to connect using the test above or that failed too ?

Last but not least, please do following and post the output of the ldd command

proenv

. java_env

. slib_env

ldd $DLC/bin/_sqlsrv2

for proenv :

DLC: /app/dlc/91d

WRKDIR: /app/dlc/91d/work

Inserting /app/dlc/91d/bin to beginning of path and

the current directory is /app/dlc/91d/work.

PROGRESS Version 9.1D09 as of Tue May 25 05:35:09 EDT 2004

and .java_env and slib_env does not return anything.

proenv>ldd $DLC/bin/_sqlsrv2

       libprosqlsnd.so => not found

       libprosqlrds.so => not found

       libprosqlsnw.so => not found

       libprosqlgeneric.so => not found

       libprosqldb.so => not found

       libprosqlmm.so => not found

       libpronls.so => not found

       libprosqlss.so => not found

       libprosqljava.so => not found

       libprosqlos.so => not found

       librocket_r.so => not found

       libusort.so => not found

       libjvm.so => not found

       libhpi.so => not found

       libnsl.so.1 => /lib/libnsl.so.1 (0x4002b000)

       libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40040000)

       libcrypt.so.1 => /lib/libcrypt.so.1 (0x40054000)

       libdl.so.2 => /lib/libdl.so.2 (0x40081000)

       libstdc++-libc6.1-1.so.2 => /usr/lib/libstdc++-libc6.1-1.so.2 (0x40085000)

       libm.so.6 => /lib/i686/libm.so.6 (0x400c7000)

       libc.so.6 => /lib/i686/libc.so.6 (0x42000000)

       /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

Hmmm. Did you run ". java_env" nad ". slib_env" or just java_env and slib_env (note the dot space) ?

it return nothing

proenv>. java_env

proenv>. slib_env

It supposed to return nothing. My question was whether you run those 2 commands with dot space command before doing the ldd $DLC/bin/_sqlsrv2.

It is supposed to return nothing. My question was whether you run those 2 commands with dot space command before doing the ldd $DLC/bin/_sqlsrv2.

before ldd command, I tried without space.