Derby JDBC message store

[aavajava]

Hi,

I am using jdbc message store with the derby embedded datasource for providing persistence.Messages generated by the source are more than 1000 per second. The throughput is low as it is opening and closing the connection while writing each message to the message store. Ideally I would expect it to use the SmartDataSourceto avoid closing the conn everytime but not able to get it right.

[Mark Fisher]

You can reference any DataSource implementation you want. In fact, just using a pool like DBCP will avoid the constant opening and closing of connections.