;-)
cheers, thomas
Matthew Baird wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
