Good evening,
I ran into the "No suitable driver.(8933)" error after making an SQL-server beside an existing 4GL-server.
PROGRESS Version is 9.1E. on Red Hat Enterprise Linux ES release 4. I know, both are old. But I have some SQL-servers succesfully running.
When I start the database with the new pfs-sql everything seems fine:
# ACTION |Starting database server (comptist)...
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
18:37:15 BROKER 0: Multi-user session begin. (333)
18:37:15 BROKER 0: Begin Physical Redo Phase at 14144 . (5326)
18:42:43 BROKER 0: Physical Redo Phase Completed at blk 121456 off 7549 upd 4622207. (7161)
18:42:43 BROKER 0: Started for comptist using TCP, pid 13000. (5644)
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
18:42:43 BROKER 1: Started for comptist-sql using TCP, pid 13120. (5644)
18:42:43 BROKER 1: This is an additional broker for this protocol. (5645)
18:42:43 BROKER 1: This broker supports SQL server groups only. (8864)
# INFO |Database server (comptist) started
When trying to connect with the sql-user I run into an error I can't quite cope with, because further down you 'll see that the jdbc-driver is in the PATH.
# sqlexp -S tist-sql -H localhost -db tist -user username -password pass
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
Connecting user "username" to URL "jdbc:jdbcprogress:T:localhost:comptist-sql:tist"... (8920)
Error: No suitable driver. (8933)
See "/usr/local/comp/tist/db/sqlexp.log" and "/usr/local/comp/tist/db/SQLExplorer.exceptions" files for more information. (895
Taking a look in exceptions doesn't bring me any further:
====== Start exception logging == "/usr/local/comp/tist/db/SQLExplorer.exceptions" opened == Wed Jun 13 18:54:14 CEST 2012 ======
**** 1 ****
Exception at Wed Jun 13 18:54:14 CEST 2012: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): No suitable driver
Stack Trace:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)
Error: No suitable driver. (8933)
sqlexp.log says:
[6/13/12 6:54:14 PM] [3] [SQLExplorer] Loading JDBC driver com.progress.sql.jdbc.JdbcProgressDriver.
[6/13/12 6:54:14 PM] [0] [*UnexpectedError*] * recorded as exception #1 in file /usr/local/comp/tist/db/SQLExplorer.exceptions.
My CLASSPATH and PATH show clearly where the driver is:
# echo $CLASSPATH
/usr/local/dlc91e/java/jdbc.jar
# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/java/bin:/root/bin:/usr/java/bin:/usr/local/dlc91e/java
Could someone put me on the right track to solve this?
Thanks.
I ran into the "No suitable driver.(8933)" error after making an SQL-server beside an existing 4GL-server.
PROGRESS Version is 9.1E. on Red Hat Enterprise Linux ES release 4. I know, both are old. But I have some SQL-servers succesfully running.
When I start the database with the new pfs-sql everything seems fine:
# ACTION |Starting database server (comptist)...
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
18:37:15 BROKER 0: Multi-user session begin. (333)
18:37:15 BROKER 0: Begin Physical Redo Phase at 14144 . (5326)
18:42:43 BROKER 0: Physical Redo Phase Completed at blk 121456 off 7549 upd 4622207. (7161)
18:42:43 BROKER 0: Started for comptist using TCP, pid 13000. (5644)
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
18:42:43 BROKER 1: Started for comptist-sql using TCP, pid 13120. (5644)
18:42:43 BROKER 1: This is an additional broker for this protocol. (5645)
18:42:43 BROKER 1: This broker supports SQL server groups only. (8864)
# INFO |Database server (comptist) started
When trying to connect with the sql-user I run into an error I can't quite cope with, because further down you 'll see that the jdbc-driver is in the PATH.
# sqlexp -S tist-sql -H localhost -db tist -user username -password pass
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
Connecting user "username" to URL "jdbc:jdbcprogress:T:localhost:comptist-sql:tist"... (8920)
Error: No suitable driver. (8933)
See "/usr/local/comp/tist/db/sqlexp.log" and "/usr/local/comp/tist/db/SQLExplorer.exceptions" files for more information. (895
Taking a look in exceptions doesn't bring me any further:
====== Start exception logging == "/usr/local/comp/tist/db/SQLExplorer.exceptions" opened == Wed Jun 13 18:54:14 CEST 2012 ======
**** 1 ****
Exception at Wed Jun 13 18:54:14 CEST 2012: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): No suitable driver
Stack Trace:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)
Error: No suitable driver. (8933)
sqlexp.log says:
[6/13/12 6:54:14 PM] [3] [SQLExplorer] Loading JDBC driver com.progress.sql.jdbc.JdbcProgressDriver.
[6/13/12 6:54:14 PM] [0] [*UnexpectedError*] * recorded as exception #1 in file /usr/local/comp/tist/db/SQLExplorer.exceptions.
My CLASSPATH and PATH show clearly where the driver is:
# echo $CLASSPATH
/usr/local/dlc91e/java/jdbc.jar
# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/java/bin:/root/bin:/usr/java/bin:/usr/local/dlc91e/java
Could someone put me on the right track to solve this?
Thanks.
