aspose file tools*
The moose likes Applets and the fly likes JDBC Applet problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Applets
Bookmark "JDBC Applet problem" Watch "JDBC Applet problem" New topic
Author

JDBC Applet problem

Arthur Johnson
Greenhorn

Joined: Feb 04, 2004
Posts: 2
I am trying to run a sample JDBC Applet code I picked from Sun's Java web site. I have a Derby DB sitting on my local PC and thought I would be able to leverage the sample to connect to this local DB and issue a select SQL statement and display the results. But it throws me an error stating:

SQLException: java.sql.SQLException: Not suitable driver found
Any pointers as to why I am getting this error?

My CLASSPATH environment variable is set to:
C:\db-derby-10.3.2.1-bin\lib\derby.jar;.;C:\Program Files\Java\jre1.6.0_03\lib\ext\QTJava.zip

Sample Java Code:

Thanks in advance for any help.

Arthur
[ December 19, 2007: Message edited by: Arthur Johnson ]
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30776
    
157

Arthur,
Welcome to JavaRanch!

I'm going to move this to our Applets forum where they know about how classpaths affect applets.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42292
    
  64
Applets do not use the CLASSPATH variable. You need to include all necessary jar files in the archive attribute of the applet tag. See here for more detail on that.

Also be aware that if Derby needs access to the local file system (and I think it does, although it may have in-memory modes), which applets do not have for security reasons - it would need to be signed. See HowCanAnAppletReadFilesOnTheLocalFileSystem for further information.
[ December 21, 2007: Message edited by: Ulf Dittmer ]

Ping & DNS - my free Android networking tools app
 
jQuery in Action, 2nd edition
 
subject: JDBC Applet problem