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? 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]
