Hi, > How can I create the prepared statements for each > new connection the pool manager creates?
If you use a more advanced connection pool than the build-in connection pool (for example DBCP) then prepared statements are automatically cached. The built-in connection pool doesn't cache prepared statements yet (patches are welcome!). I'm not sure if it's really a big problem in reality if prepared statements are not automatically cached. What I usually do is, I cache prepared statements in the application (this works well when not using connections pools): http://code.google.com/p/h2database/source/browse/trunk/h2/src/test/org/h2/samples/CachedPreparedStatements.java > Or do I? Currently, yes. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
