Connection to the datebase can't be established

[dsagud]

Connection code:

Connection veza = DriverManager.getConnection("jdbc:derby:C://Documents and Settings/$agud/MyDB", "abc", "abc");

Error:

java.sql.SQLException: No suitable driver found for jdbc:derby:C://Documents and Settings/$agud/MyDB
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at paketjdbcprimjer1.GlavnaKlasa.main(GlavnaKlasa.java:20)

I made the database "MyDB" and add derby to the Eclipse.

[JosAH]

Did you load and register the derby driver with Class.forName( ... )? Also, read the derby documentation, it is very detailed and explains it all.

kind regards,

Jos

[dsagud]

private static String dbURL = "jdbc:derby:C://Documents and Settings/$agud/MyDB;create=true;user=abc;password=abc";
	public static String driver = "org.apache.derby.jdbc.EmbeddedDriver";

Class.forName(driver).newInstance();

Connection veza = DriverManager.getConnection(dbURL);

Error:

java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at paketjdbcprimjer1.GlavnaKlasa.main(GlavnaKlasa.java:22)

[JosAH]

There's a derby.jar file somewhere on your system (I hope) that contains your driver class; is that jar file on your classpath? The error message indicates it isn't.

kind regards,

Jos

[dsagud]

Thx Jos.

I finally find out what I have missed.

I did copied derby.jar in lib folder in Java project, but I didn't "Add JARs" in Project properties.

[JosAH]

Thx Jos.

I finally find out what I have missed.

I did copied derby.jar in lib folder in Java project, but I didn't "Add JARs" in Project properties.

Good you found it; all classes (and jar files) have to present on the classpath unless you store them in the JRE/lib/ext directory; those IDEs put them on your classpath when you add them to your project.

kind regards,

Jos

[Tolls]

Good you found it; all classes (and jar files) have to present on the classpath unless you store them in the JRE/lib/ext directory; those IDEs put them on your classpath when you add them to your project.

kind regards,

Jos

And that's generally considered a bad idea.

[JosAH]

And that's generally considered a bad idea.

True, but notice that I didn't encourage the OP to put the .jar files in there. ;-)

kind regards,

Jos