Re: Driver Specific Parameters

Hi Eric,

Ferrer, Eric wrote:
> 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?

Sorry I don't know this for MSSQL (it's jdbc driver vendor dependent, 
see vendor docs).
mysql:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
can't find a property to specify the isolation level.

maxdb:
http://dev.mysql.com/doc/maxdb/en/43/68a541a1166153e10000000a1553f6/content.htm
for maxdb this should work:
<attribute attribute-name="jdbc.isolation" 
attribute-value="TRANSACTION_READ_COMMITTED"/>

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

The repository_database.xml is included in the repository.xml file. We 
using a "entity reference" in the repository.xml file to copy the 
content of the repository_database.xml file into the repository.xml 
file. OJB never use the repository_database.xml file.

> 
> Last question(s)
> a) Ever add support for Native SQL Calls?

If you mean native LIMIT and OFFSET support? Yes. In a few days I will 
check in support for native LIMIT and OFFSET. Need some time to do 
additional tests against hsql, maxdb, mysql and oracleXE. Currently I 
try to "harmonize" native LIMIT/OFFSET with the software emulated 
limit/paging support in OJB.


> b) Ever add support for DBCP initialSize of pooled connections?

This property is already added in 1.0.x release branch and will be 
included in 1.0.5.

<attribute attribute-name="initialSize" attribute-value="0"/>

see
http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/src/test/org/apache/ojb/repository_database.xml?view=markup

regards,
Armin

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