I'm trying to creating a web app using GWT. In my application, I use MySQL as database. I tried to use a connection pool to control the number of connections to the database. However, Google web toolkit doesn't support CachedRowSet, which prevent me from closing the connections. Does any one know a walk around for this? (except making a deep copy of the ResultSet)
I think the best approach would be to make a deep copy of the result set into a List of Maps. Each element in the list would be a map or the row in the result set where the map key is the column name and the value is the column value. If you want to be able to sync data back from the client this would be quite a bit more complicated.