Is asynchronous jdbc call possible?

by

I don’t understand how any of the proposed approaches that wrap JDBC calls in Actors, executors or anything else can help here – can someone clarify.

Surely the basic problem is that the JDBC operations block on socket IO. When it does this it blocks the Thread its running on – end of story. Whatever wrapping framework you choose to use its going to end up with one thread being kept busy/blocked per concurrent request.

If the underlying database drivers (MySql?) offers a means to intercept the socket creation (see SocketFactory) then I imagine it would be possible to build an async event driven database layer on top of the JDBC api but we’d have to encapsulate the whole JDBC behind an event driven facade, and that facade wouldn’t look like JDBC (after it would be event driven). The database processing would happen async on a different thread to the caller, and you’d have to work out how to build a transaction manager that doesn’t rely on thread affinity.

Something like the approach I mention would allow even a single background thread to process a load of concurrent JDBC exec’s. In practice you’d probably run a pool of threads to make use of multiple cores.

(Of course I’m not commenting on the logic of the original question just the responses that imply that concurrency in a scenario with blocking socket IO is possible without the user of a selector pattern – simpler just to work out your typical JDBC concurrency and put in a connection pool of the right size).

Looks like MySql probably does something along the lines I’m suggesting —
http://code.google.com/p/async-mysql-connector/wiki/UsageExample

More Related Contents:

  1. What are the best use cases for Akka framework [closed]
  2. non-blocking IO vs async IO and implementation in Java
  3. Hours and seconds are lost when storing a date in the database [closed]
  4. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  5. ClassNotFoundException com.mysql.jdbc.Driver [duplicate]
  6. Efficient way to do batch INSERTS with JDBC
  7. Java: Insert multiple rows into MySQL with PreparedStatement
  8. What is the actual use of Class.forName(“oracle.jdbc.driver.OracleDriver”) while connecting to a database?
  9. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  10. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  11. Asynchronous IO in Java?
  12. “eval” in Scala
  13. Get the changed HTML content after it’s updated by Javascript? (htmlunit)
  14. java.sql.SQLException: Exhausted Resultset
  15. java.util.stream with ResultSet
  16. Is there a PriorityQueue implementation with fixed capacity and custom comparator?
  17. Retrieve an Image stored as BLOB on a MYSQL DB
  18. UNIX socket implementation for Java? [closed]
  19. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  20. Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
  21. Iterating over Java collections in Scala
  22. Why does SimpleDateFormat parse incorrect date?
  23. mysql prepared statement error: MySQLSyntaxErrorException
  24. Call an Oracle function from Java
  25. Why is CompletableFuture.supplyAsync succeeding a random number of times?
  26. How to get the number of columns from a JDBC ResultSet?
  27. Resultset To List
  28. How do you enforce foreign key constraints in SQLite through Java?
  29. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment