Android JDBC not working: ClassNotFoundException on driver

by

Does JDBC not work with Android?

JDBC is infrequently used on Android, and I certainly would not recommend it.

IMHO, JDBC is designed for high-bandwidth, low-latency, highly-reliable network connections (e.g., desktop to database server, Web application server to database server). Mobile devices offer little of these, and none of them consistently.

If so, tell me what alternatives I should look into for remote MySQL database access.

Create a Web service around your database and access that from Android.

As side benefits, you improve security (vs. leaving your database open), can offload some business logic from the client, can better support other platforms (e.g., Web or Web-based mobile frameworks), etc.

More Related Contents:

  1. Can we connect remote MySQL database in Android using JDBC? [closed]
  2. Connect Java to a MySQL database
  3. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Using “like” wildcard in prepared statement
  6. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  7. Cannot issue data manipulation statements with executeQuery()
  8. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  9. JDBC MySql connection pooling practices to avoid exhausted connection pool
  10. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  11. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. Java JDBC Access denied for user [closed]
  15. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  16. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  17. Passing parameters to a JDBC PreparedStatement
  18. JDBC character encoding
  19. JDBC returning MySQLSyntaxError Exception with correct statement
  20. how to get list of Databases “Schema” names of MySql using java JDBC
  21. com.mysql.jdbc.PacketTooBigException
  22. Access denied for user ‘root’@’localhost’
  23. Should a database connection stay open all the time or only be opened when needed?
  24. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  25. How to use prepared statement for select query in Java?
  26. Converting mysql table to spark dataset is very slow compared to same from csv file
  27. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  28. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  29. java.sql.SQLException: No database selected – why?
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment