Re: Driver Specific Parameters
Armin Waibel <[email protected]>
| Newsgroups | gmane.comp.jakarta.ojb.user |
|---|---|
| Message-ID | <[email protected]> |
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] > >