I'm not sure why you mentioned batch mode in your answer, as it didn't seem
to be relevant to the two OTN articles you pointed (that I noticed anyway).
I was thinking that you might want to have different pre-fetch sizes based
on the object type, though having a connection wide default would be a good
thing too.
David
|---------+--------------------------->
| | Thomas Mahler |
| | <[EMAIL PROTECTED]> |
| | Sent by: |
| | [EMAIL PROTECTED] |
| | |
| | |
| | 06/26/2003 05:08|
| | PM |
| | Please respond |
| | to "OJB Users |
| | List" |
| | |
|---------+--------------------------->
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: OJB Users List <[EMAIL PROTECTED]>
|
| cc:
|
| 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]
