That's a good question :)
right now, batch enablement is the same as with the current JDBC connector descriptor
way of doing thing:
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Oracle9i"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@plqaibm2:1521:QADBI2"
username="mbaird"
password="mbaird"
eager-release="false"
batch-mode="false" <--------------- batch mode setting
useAutoCommit="1"
ignoreAutoCommitExceptions="false">
but the other stuff is not configurable yet. I wanted to think about how to do this
and I came up with this idea (not implemented yet)
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@plqaibm2:1521:QADBI2"
username="mbaird"
password="mbaird"
eager-release="false"
batch-mode="false"
useAutoCommit="1"
platform="Oracle9i"
ignoreAutoCommitExceptions="false">
<platform>
<property name="useRowPrefetch" value="true"/>
<property name="rowPrefetchSize" value="100"/>
<property name="useStatementCache" value="true"/>
<property name="setStatementCacheSize" value="100"/>
</platform>
<connection>
<property name="fetchSize" value="25"/>
</connection>
</jdbc-connection-descriptor>
and then make the platform options configurable for any property you want to set (just
use reflection to find the set method for the property you want. You could also use
this to set any connection info like fetch size, and this would just be passed through
to the connection.
Of course this would mean changing the XML for jdbc connections again, but it would be
backwards compatible.
any comments?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 1:45 PM
To: OJB Users List
Cc: OJB Users List
Subject: Re: New Oracle 9i Feature
And how are these two things configured?
|---------+--------------------------->
| | "Matthew Baird" |
| | <[EMAIL PROTECTED]|
| | otiva.com> |
| | |
| | 06/26/2003 03:07|
| | PM |
| | Please respond |
| | to "OJB Users |
| | List" |
| | |
|---------+--------------------------->
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: "OJB Users List" <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: New Oracle 9i Feature
|
|
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
I added support for Statement Caching (
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/jdbc30/StmtCacheSample/Readme.html
)
and Row Prefetching (
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/advanced/RowPrefetchSample/Readme.html
)
this is for 9i only
Enjoy.
---------------------------------------------------------------------
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]
