0 Replies Latest reply on Dec 26, 2005 5:17 PM by Manjula Jayaraman

    How to set the DB fetch size at Connection level in JBoss?

    Manjula Jayaraman Newbie

      Hi all,

      We are using JBoss connection pooling in our application for the Oracle DB. Could someone please let me know how to set the fetch size at connection level in JBoss? For example, in the JDBC applications, we can set the Oracle Row Prefetch size at the DriverManager.getConnection method level. Is there any equivalent way to do this in our J2EE application that runs on JBoss? It seems that the default Fetch size is 10 which is obviously not sufficient for us.

      Thanks for any input in advance!