java - SQLException: No suitable driver found for jdbc:derby://localhost:1527 -


i error in netbeans:

java.sql.sqlexception: no suitable driver found jdbc:derby://localhost:1527/ 

how caused , how can solve it?

java.sql.sqlexception: no suitable driver found jdbc:derby://localhost:1527/

this exception has 2 causes:

  • the driver not loaded.
  • the jdbc url malformed.

in case, i'd expect see database name @ end of connection string. example (use create=true if want database created if doesn't exist):

jdbc:derby://localhost:1527/dbname;create=true 

databases created default in directory network server started up. can specify absolute path database location:

jdbc:derby://localhost:1527//home/pascal/derbydbs/dbname;create=true 

and in case, check derbyclient.jar on class path , loading appropriate driver org.apache.derby.jdbc.clientdriver when working in server mode.


Comments

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -