[tcljava-user] Class not found after successful class import.

[<PFi...@hb...>]

The following code is executed inside a proc.  The "EmbeddedDriver" class 
is imported successfully but attempts to call it generate a class not 
found error. 


# import required classes 
   java::import org.apache.derby.jdbc.EmbeddedDriver
   java::import org.apache.derby.drda.NetworkServerControl
   java::import org.apache.derby.jdbc.ClientDriver
   java::import java.sql.Connection
   java::import java.sql.DriverManager
   java::import java.sql.ResultSet
   java::import java.sql.SQLWarning
   java::import java.sql.Statement
   java::import java.sql.ResultSetMetaData 

   puts "\nimported classes are:\n"
 
   foreach i [java::import] {
 
      puts [ format "%-5s %-50s" " " $i ] 

   }

This generates ==>

imported classes are:

      org.apache.derby.drda.NetworkServerControl
      java.sql.DriverManager
      org.apache.derby.jdbc.ClientDriver
      java.sql.ResultSetMetaData
      java.sql.Statement
      org.apache.derby.jdbc.EmbeddedDriver
      java.sql.ResultSet
      java.sql.Connection
      java.sql.SQLWarning


The  JAVA call fails.
 
java::call Class forName org.apache.derby.jdbc.EmbeddedDriver


*** Stack trace is:

java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
        at java.net.URLClassLoader.findClass(URLClassLoader.java:375)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:562)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:442)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:494)
        at java.lang.Class.forName1(Native Method)
        at java.lang.Class.forName(Class.java:180)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:85)




Regards.


PATRICK FINNEGAN.
WebSphere Consultant.
HBF Web Master
LDAP Administrator.

===================================================
HBF Health Funds Inc. a registered organisation under the National Health Act
HBF Insurance Pty Ltd ACN  009 268 277
This email is a confidential communication intended only for the named Addressee(s). 
If you are not that person any disclosure, copying, distribution or use of this email
or the information in it is prohibited. Please notify us immediately by 
telephone, (+61) 08 9265 6111 or return email and delete this email.
The views in this email may be personal to the author and not those of HBF.