Thanks Luis, Moving forward I will try this out. With all these layers its difficult to know where stuff should go and if they are visible at all unless x component supports it. I know OJB is working to support the initialSize of a connection pool object and with JDBC 4.0 lots of new stuff to play with.
We are trying to evaluate drivers at the moment and its amazing how many more options are available per driver. I am unfortunately forced to use SQL Server 2005 and jTDS does not support the snapshot isolation level. -Eric -----Original Message----- From: Luis Colorado [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 3:29 PM To: OJB Users List Subject: RE: Driver Specific Parameters Eric, I'm not sure if this answers your question, but I was doing some similar research to set up a parameter for jetspeed-1, which also uses OJB. When I upgraded from MySQL version 4 to version 5, I discovered that I had to set up a parameter to handle timestamps equal to zero, and I was looking for a bit for the right place to put this parameter. The parameter was "zeroDateTimeBehavior=convertToNull". In the end, I discovered that the right place to put it at the end of the dbalias as shown below: <jdbc-connection-descriptor jcd-alias="essential" default-connection="yes" platform="MySQL" jdbc-level="3.0" driver="org.gjt.mm.mysql.Driver" protocol="jdbc" subprotocol="mysql" dbalias="//localhost/essential?zeroDateTimeBehavior=convertToNull" username="xxxxxx" password="yyyyy" > I hope this helps. Luis -----Original Message----- From: Ferrer, Eric [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 4:02 PM To: OJB Users List Subject: Driver Specific Parameters Since we are using OJB and DBCP for connection pooling, with the introduction of JDBC 4.0 a lot of drivers have additional parameters that we can set for performance tuning. What are the options for setting this in OJB's repository_database.xml or other properties file? Thanks -Eric --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]