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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
