Thanks Dario. UDFs are working well for us but I like the fact that the link table has indexes defined when doing joins within h2. I have a nice h2 UDF that supports doing any mysql query and it is good for many situations.
We have the following in our jboss datasource, which normally takes care of providing a new connection when the socket is broken: <exception-sorter-class- name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</ exception-sorter-class-name> <valid-connection-checker-class- name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</ valid-connection-checker-class-name> I think h2 circumvents this by keeping a particular connection object around for the life of the server. I tried setting h2.shareLinkedConnections to false but it didn't help with this issue. I'll try fiddling with some mysql parameters. Otherwise, I have the h2 source checked out and compiling, so maybe I'll try patching it. Regards, Kim -- 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.
