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

by

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

This exception has two causes:

  • The driver is not loaded.
  • The JDBC URL is malformed.

In your case, I’d expect to see a database name at the end of the connection string. For example (use create=true if you want the database to be created if it doesn’t exist):

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

Databases are created by default in the directory where the Network Server was started up. But you can also specify an absolute path to the database location:

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

And just in case, check that derbyclient.jar is on the class path and that you are loading the appropriate driver org.apache.derby.jdbc.ClientDriver when working in server mode.

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. PreparedStatement IN clause alternatives?
  3. AbstractTableModel GUI display issue
  4. Using “like” wildcard in prepared statement
  5. Can we connect remote MySQL database in Android using JDBC? [closed]
  6. Android JDBC not working: ClassNotFoundException on driver
  7. Variable column names using prepared statements
  8. Where’s my invalid character (ORA-00911)
  9. JDBC MySql connection pooling practices to avoid exhausted connection pool
  10. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  11. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  12. PLSQL JDBC: How to get last row ID?
  13. Is asynchronous jdbc call possible?
  14. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  15. JPA SQL Server No Dialect mapping for JDBC type: -9
  16. JPA or JDBC, how are they different?
  17. How to write / update Oracle blob in a reliable way?
  18. Execute anonymous pl/sql block and get resultset in java
  19. Setting Network Timeout for JDBC connection
  20. how to get list of Databases “Schema” names of MySql using java JDBC
  21. NamedParameterJdbcTemplate vs JdbcTemplate
  22. When my app loses connection, how should I recover it?
  23. Access denied for user ‘root’@’localhost’
  24. How to use prepared statement for select query in Java?
  25. Oracle JDBC : invalid username/password (ora-01017)
  26. Why do we use a DataSource instead of a DriverManager?
  27. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  28. Do I need to close ‘PreparedStatement’? [closed]
  29. Database independence through JDBC in java
  30. java.sql.SQLException: No database selected – why?

Leave a Comment