JDBC connection to derby from an applet
I'm doing the JDBC tutorial at java.sun.com
Everything runs fine from the Netbeans IDE. I'm not sure whether the applet is supposed to work inside the IDE or not, I figure that's meant for the web.
Within Netbeans, the following URL works:
String url = "jdbc:derby:C:\\Documents and Settings\\HP_Administrator\\.netbeans-derby\\helpme";
When I load a webpage with the applet, I get:
java.SQLException: No suitable driver found for jdbc:derby:C:\Documents and Settings\HP_Administrator\.netbeans-derby\helpme.
Now, I know it found the driver Class, otherwise I would have gotten Class Not Found -- so I assume its just not making the connect to the database from the applet.
I have tried many formats for the url --
String url = "jdbc:derby://localhost:1527/C:\\Documents and Settings\\HP_Administrator\\.netbeans-derby\\helpme";
String url = "jdbc:derby://localhost:1527/helpme";
String url = "jdbc:derby:helpme";
Nothing I've tried has worked. Can someone point me in the right direction please?
Everything is running on the same machine.
