Error conecting with sqlexp,no situable driver found

A

Arawaco

New Member
Greetings.
Before to post here, i read the following:
http://www.progresstalk.com/showthread.php?t=113025
but does not work for me. :confused:
I am using OpenEdge ver 10.1A oe101a_linux
My jdk is: java-6-sun-1.6.0.07
My environment variables (/etc/profile):
DLC=/usr/dlc;
JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.07
JDK_HOME=/usr/lib/jvm/java-6-sun-1.6.0.07
JAVA_PATH="$JAVA_HOME"
PATH=$PATH:$JAVA_HOME/bin
JDK_HOME="$JAVA_HOME"
CLASSPATH=".:/usr/lib/jvm/java-6-sun-1.6.0.07/jre/lib/rt.jar:/usr/lib/jvm/java-6-sun-1.6.0.07/lib/tools.jar:/usr/dlc/java/openedge.jar:/usr/dlc/java/pool.jar:/usr/dlc/java/progress.jar"
I try to use the following command to connect :
sqlexp -char -url jdbc:jdbcprogress:T:localhost:5000:familia
and i get the following:

Conectando usuario "familia" al URL "jdbc:jdbcprogress:T:localhost:5000:familia"... (8920)
Error: No suitable driver found for jdbc:jdbcprogress:T:localhost:5000:familia. (8933)
Ver archivos "/home/familia/sqlexp.log" y "/home/familia/SQLExplorer.exceptions" para más información. (8950)

The file SQLExplorer.exceptions:
Exception at Tue Sep 30 13:21:45 GMT 2008: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): No suitable driver found for jdbc:jdbcprogress:T:localhost:5000:familia
Stack Trace:
java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:localhost:5000:familia
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)

Any help is welcome.
Thanks in advance.
 
C

Casper

ProgressTalk.com Moderator
Staff member
I;m not sure if I can help you, but I'll try:

First: The right java version for 10.1A is java1.4.2.
Second: what Linux distribution do you use?
Third: what happens if you run sqlexp from within proenv?

Casper.
 
A

Arawaco

New Member
Greetings
Answers:
Fisrts: i am going to change java to 1.4
Second: My linux is Debian lenny with kernel 2.6.22-3-vserver-k7
Third:whe i run sqlexp within proenv the result is the same.
 
A

Arawaco

New Member
With java 1.4.2 i get the same error :confused:

Local /usr/wrk/SQLExplorer.properties file will be used. (SQLMsg036)
Setting Connect to jdbc:jdbcprogress:T:localhost:5000:familia
Setting Connect to jdbc:jdbcprogress:T:localhost:5000:familia
=== SQLExplorer starting. ===
### ARGS: -char -url jdbc:jdbcprogress:T:localhost:5000:familia
Conectando usuario "familia" a URL "jdbc:jdbcprogress:T:localhost:5000:uno"... (8920)
[SQLExplorer] Loading JDBC driver com.ddtek.jdbc.openedge.OpenEdgeDriver.
[*UnexpectedError*] * recorded as exception #23 in file /usr/wrk/SQLExplorer.exceptions.


SQLExplorer.exceptions file:
java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:localhost:5000:familia
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)

Thanks
 
C

Casper

ProgressTalk.com Moderator
Staff member
This Linux distribution isn't supported by Progress BTW....
But anyway:
What is the output of: ldd _sqlsrv2?

Casper
 
C

Casper

ProgressTalk.com Moderator
Staff member
I meant: ldd $DLC/bin/_sqlsrv2 :awink:

or maybe even clearer: lss /path/to/progress/installdir/bin/_sqlsrv2

Casper.
 
A

Arawaco

New Member
ldd $DLC/bin/_sqlsrv2 :)
linux-gate.so.1 => (0xffffe000)
libnsl.so.1 => /lib/i686/cmov/libnsl.so.1 (0xb7eb9000)
libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb7ea1000)
libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb7e6e000)
libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb7e6a000)
libstdc++-libc6.2-2.so.3 => not found
libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7e45000)
libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb7cf8000)
/lib/ld-linux.so.2 (0xb7f01000)
 
C

Casper

ProgressTalk.com Moderator
Staff member
You miss the libstdc++ library on your system. Try to find that and install it, and see if it works....

I know the packages on Suse and Red hat, but not on Debian...

Casper.
 
A

Arawaco

New Member
now is installed
when i write:
/usr/dlc/bin# ld ./_sqlsrv2
i get:
ld: error in ./_sqlsrv2(.eh_frame); no .eh_frame_hdr table will be created
and when i write
ldd $DLC/bin/_sqlsrv2
i get
linux-gate.so.1 => (0xffffe000)
libnsl.so.1 => /lib/i686/cmov/libnsl.so.1 (0xb7f8d000)
libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb7f75000)
libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb7f42000)
libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb7f3e000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0xb7ef6000)
libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7ed1000)
libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb7d84000)
/lib/ld-linux.so.2 (0xb7fd5000)
 
A

Arawaco

New Member
Sorry nop :(
same error..
probably i had something wrong in the path, but i do know what
:(
anyway.. thank you for you time :)

Exception at Wed Oct 01 09:41:26 COT 2008: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): No suitable driver found for jdbc:jdbcprogress:T:localhost:9100:uno
Stack Trace:
java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:localhost:9100:uno
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)
 
A

Arawaco

New Member
Probably is the path i do not know
in this site (internet too :) i found a java test i try it:

java -classpath :.:/usr/dlc/java/openedge.jar:/usr/dlc/java/pool.jar:/usr/dlc/java/progress.jar:$DLC/java/base.jar:$DLC/java/message.jar:$DLC/java/util.jar ProAccess

And i get:
hi there
Driver 1: com.ddtek.jdbc.openedge.OpenEdgeDriver@1c78e57
hi there 2
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at ProAccess.main(ProAccess.java:23)

The program:
import java.sql.*;
import java.util.*;

public class ProAccess {
public static void main(String[] args) {
System.out.println("hi there");
try
{
//com/ddtek/jdbc/openedge/
//com.progress.sql.jdbc.JdbcProgressDriver
//com.ddtek.jdbc.openedge.OpenEdgeDriver
Class.forName("com.ddtek.jdbc.openedge.OpenEdgeDriver");
Enumeration enu = DriverManager.getDrivers();
int i=1;
while (enu.hasMoreElements())
{
System.out.println("Driver "+ i + ": " +
enu.nextElement().toString());
i++;
}
System.out.println("hi there 2");
String databaseURL ="jdbc:jdbcprogress:T:localhost:5001:uno";
Connection con = DriverManager.getConnection(databaseURL); //DriverManager.getConnection(databaseURL, "shashi","mypassword");
//Statement stmt = con.createStatement();
//ResultSet rs = stmt.executeQuery("select * from PUB.company");
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
}
 
A

Arawaco

New Member
I am very happy, ¡¡works...!! :awink:
Thanks
how i did:

1st use java 1.4 as you told me (i am going to try with java 1.6)
2nd set the enviorement variables in /etc/profile:
DLC=/usr/dlc;
export DLC
JAVA_HOME=/usr/lib/j2se/1.4
JDK_HOME=/usr/lib/j2se/1.4
JAVA_PATH="$JAVA_HOME"
JDK_HOME="$JAVA_HOME"
CLASSPATH=".:/usr/dlc/java:/usr/lib/j2se/1.4/bin/jar:/usr/lib/j2se/1.4/bin/jdb:/usr/dlc/java/openedge.jar:/usr/dlc/java/pool.jar:/usr/dlc/java/progress.jar: $DLC/java/base.jar:$DLC/java/message.jar:$DLC/java/util.jar:$DLC/java/spy.jar"
PATH="$PATH:/usr/lib/j2se/1.4/bin:$DLC/bin"
export JAVA_HOME
export CLASSPATH
export JAVA_PATH
export PATH

3rd mkdir /usr/wrk; chown user:user /usr/wrk
4th #:proenv
5th proenv>proserve database -S port_desire
6th proenv>sqlexp -db database -S port_desire
In 6th stept i try without proenv enviorement and works.

PD/
Debian package can get it from:
http://packages.debian.org/etch/i386/libstdc++2.10-glibc2.2/download

I also try with java 1.6 (default debian lenny) an works too :cool:
this is the enviorment vars..
DLC=/usr/dlc;
export DLC
JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.07
JDK_HOME=/usr/lib/jvm/java-6-sun-1.6.0.07
JAVA_PATH="$JAVA_HOME"
PATH=$PATH:$JAVA_HOME/bin:$DLC/bin
JDK_HOME="$JAVA_HOME"
CLASSPATH=".:/usr/lib/jvm/java-6-sun-1.6.0.07/jre/lib/rt.jar:/usr/lib/jvm/java-6-sun-1.6.0.07/lib/tools.jar:/usr/dlc/java/openedge.jar:/usr/dlc/java/pool.jar:/usr/dlc/java/progress.jar:$DLC/java/base.jar:$DLC/java/message.jar:$DLC/java/util.jar:$DLC/java/spy.jar"
 
You must log in or register to reply here.

Similar threads

D
  • Locked
Progress 9.1D Driver error java
Replies
0
Views
937
Dzshean
D
K
  • Locked
[progress Communities] [progress Openedge Abl] Wiki Page: Openedge 11.7 Release Notes
Replies
0
Views
13K
Kris Murphy
K
A
No suitable driver. (8933)
Replies
0
Views
1K
algernonz
A
jeremysimmons
Configuration errors using SQLEXP in OpenEdge 10.2B
Replies
6
Views
10K
jeremysimmons
jeremysimmons
R
How to setup a 64 bit ODBC connection to make a connection with PHP to a 10.2B db?
Replies
0
Views
7K
rweller
R
Top