Luis Colorado wrote:
Armin,
Well, it's interesting you mention that, because I tried to use
custom attributes, but it didn't work. Now I'm becoming aware that
you are suggesting adding the "jdbc." prefix to the attribute name.
My original, and failed, attempt looked something like:
<attribute attribute-name="zeroDateTimeBehavior"
attribute-value="convertToNull"/>
So I guess I will try later your suggestion:
<attribute attribute-name="jdbc.zeroDateTimeBehavior"
attribute-value="convertToNull"/>
Perhaps I missed it, but I never saw the "jdbc." prefix in the
documentation... did you?
Please see the link in my previous post (repository guide). You can find
a note in the 1.0.4 release notes too (New features: OJB-14):
http://db.apache.org/ojb/release-notes.txt
And it's commented in the repository-database.xml example file:
http://db.apache.org/ojb/repository_database.xml.txt
regards,
Armin
Thanks!
Luis
-----Original Message----- From: Armin Waibel
[mailto:[EMAIL PROTECTED] Sent: Mon 2/12/2007 10:07 PM To: OJB Users
List Subject: Re: Driver Specific Parameters
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
