Armin, Thanks for the info. Do you know what the jdbc. Argument is to allow the setting of transaction isolation levels are for MSSQLServer Driver or any other drivers?
Also, when I open up these XML files in ALTOVE XMLSpy it complains because there is no parent element wrapping the repository_database.xml contents ever thought of adding one? Last question(s) a) Ever add support for Native SQL Calls? b) Ever add support for DBCP initialSize of pooled connections? Thanks -Eric -----Original Message----- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 8:01 AM To: OJB Users List Subject: Re: Driver Specific Parameters 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-N 10329 > > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
