Hello everyone!
I am using sapdb 7.4 and the newest jdbc driver. For connection, the URL
"jdbc:sapdb://localhost:7210/DatabaseName?cache=all" will be used.
While processing requests, the following fragment is quite often executed:
pStatement = connection.prepareStatement("Some sql command with ?");
pStatement.setString(1,"Test");
pStatement.executeUpdate();
pStatement.close();
The connection 'connection' is from a connection pool and the connection
will be given back to the pool after every single request.
(Every request is a stateless request for which a own instance of a
requesthandler will be generated. That's why every request the connection
will be given back.)
Am I right, that the connection.prepareStatement()-method will cause the
JDBC-driver to lookup in his own preparedStatement-Cache?
Would it be better to implement a preparedStatement-Cache by my own?
What's best practice?
Thanx a lot for help to everyone!
Chris
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
