Luis Colorado wrote:
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"
>
since OJB 1.0.4: Another option is to use "custom attributes" to specify
jdbc-driver parameter (if supported by the jdbc-driver):
http://db.apache.org/ojb/docu/guides/repository.html#Custom+attributes-N10329
the example above would look like (don't know if mysql support this too)
<attribute attribute-name="jdbc.zeroDateTimeBehavior"
attribute-value="convertToNull"/>
regards,
Armin
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]
