Is JBoss CMP currently making any use
of proprietary JDBC Driver implementation
features?
Specifically, is the method
setDefaultRowPrefetch(int rows) provided
by the Oracle thin client driver used?
My experience is, that this setting can have
a huge impact on the performance of data-oriented
applications, especially if they read large datasets.
Using reflection, the code need not directly depend on
on the Oracle driver being in the classpath and still
get compiled, like this:
java.lang.reflect.Method method = conn.getClass().getMethod("setDefaultRowPrefetch",
new Class[]{ int.class });
method.invoke(conn, new Object[]{ new Integer(rowPrefetch) });
This could be added to (standardjboss)cmp-jdbc.xml
configuration parameters.
JDBC3.0 defines a (small) set of standard properties for
pooled connection sources (in section 11.7), so
this is a first step in standardizing this process.
Just a suggestion...
And a happy easter to the JBoss team!
Georg
_________________________________________________________
View thread online: http://main.jboss.org/thread.jsp?forum=66&thread=11768
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
