Problem: Try to connect Oracle Database7.3.4 with Oracle thin driver got the
following error. This error did not happen on previous JDK1.2 beta4, JDK1.2 beta3 and JDK1.1.6 version. This bug was found in java application by using JDK1.2 fcs solaris.


*** SQLException caught ***

SQLState: 08001
Message: No suitable driver


Test case: In /home/sophias/java/javablend/jdbc
Edit testcon_12.sh and make sure you set correct JDK version from variable NEWJDK.

Type: testcon_12.sh
The output file is : result_mail

Attached three files for your reference: conTest12.java jdbcT12.java, testcon_12.sh

------Detail trace message for your reference (by using JDK1.2 fcs)

blender% more result_mail
Test: 30 concurrent with 50 loops by using distinct --con close Wed Aug 5 19:25:12 PDT 1998
finish compiling conTest12.java by -- /usr/local/java/jdk1.2fcs/solaris/bin/javac
Test directory: /home/sophias/java/javablend/jdbc
OS: SunOS blender 5.6 Generic_105181-05 sun4u sparc SUNW,Ultra-1
path =
/export/oracle/app/oracle/product/7.3.4/bin:/usr/local/java/jdk1.2fcs/solaris/bin:/bin:/usr/bin:/usr/ucb:/usr/dist/exe:/usr/dist/local/exe:/usr/ccs/bin:/etc:.
 
classpath =
/home/sophias/java/javablend/jdbc:/net/ultratiger/export/ultratiger2/database/driver/oracle/oracle_thin/lib/classes111.zip
 
#####loop = 0 #####thread number = 0
     
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@3d8ef4c2]
DriverManager.getConnection("jdbc:oracle:thin:@neptuen:1521:dbcomp")
    skipping: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@3d8ef4c2]
getConnection: no suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at jdbcT12.run(Compiled Code)
SQLException: SQLState(08001)

*** SQLException caught ***

SQLState: 08001
Message: No suitable driver
Vendor: 0

#####loop = 1 #####thread number = 0
     
DriverManager.getConnection("jdbc:oracle:thin:@neptuen:1521:dbcomp")
    skipping: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@3d8ef4c2]
getConnection: no suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at jdbcT12.run(Compiled Code)
SQLException: SQLState(08001)

*** SQLException caught ***

SQLState: 08001
Message: No suitable driver
Vendor: 0


====correct message should be (by using JDK1.2 beta4 or previous JDK version==

.....
#####loop = 0 #####thread number = 27
     
#####loop = 0 #####thread number = 28
     
#####loop = 0 #####thread number = 29
     

!!!loop # 0 #####thread number = 0
Connected to jdbc:oracle:thin:@neptuen:1521:dbcomp
Driver Oracle JDBC driver
Version 7.3.4


!!!loop # 0 #####thread number = 1
Connected to jdbc:oracle:thin:@neptuen:1521:dbcomp
Driver Oracle JDBC driver
Version 7.3.4