well that's the beauty of the Platform design. They just work! No need to do anything other than set your platform to Oracle9i
I promise I will get around to documenting at some point. m -----Original Message----- From: Thomas Mahler [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 2:08 PM To: OJB Users List Subject: Re: New Oracle 9i Feature how about a short howto-use-advanced9i-features.html ? ;-) 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]