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:arminw@apache.org]
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:arminw@apache.org] 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:eric.ferrer@transcore.com] 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: ojb-user-unsubscribe@db.apache.org For
>> additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org For
> additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
|