Help with JDBC

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nospam
    #1

    Help with JDBC

    Hello all,

    I have a question about the Oracle 10g thin JDBC driver. I was
    wondering if anyone knows what the default prefetch size is (in number
    of rows). Also, does anyone know if an entire packet is sent (i.e.
    padded with null values) if there is not enough data to fill it?

    Thanks for your help!

    ty
    Tags: None
    • Lewis C
      #2
      Re: Help with JDBC

      On Thu, 14 Apr 2005 22:31:30 -0400, nospam <nospam@goaway. comwrote:
      >Hello all,
      >
      >I have a question about the Oracle 10g thin JDBC driver. I was
      >wondering if anyone knows what the default prefetch size is (in number
      >of rows). Also, does anyone know if an entire packet is sent (i.e.
      >padded with null values) if there is not enough data to fill it?
      >
      >Thanks for your help!
      >
      >ty
      Oracle defaults the prefetch to 10 rows. You can modify that using
      setRowPrefetch.

      I don't believe it will pad if not found. Seems kind of silly if it
      did. Wouldn't it then have null rows in the rowset? That's just a
      guess on my part though.

      Lewis

      -----------------------------------------------------------
      Lewis R Cunningham

      Author, ItToolBox Blog: An Expert's Guide to Oracle
      http://blogs.ittoolbox.com/oracle/guide/


      Topic Editor, Suite101.com: Oracle Database
      Page not found - Suite 101
      http://www.suite101.com/welcome.cfm/oracle


      Sign up for courses here:
      Error 406 - Not Acceptable
      http://www.suite101.com/suiteu/default.cfm/416752

      -----------------------------------------------------------

        Comment

        • nospam
          #3
          Re: Help with JDBC

          Thanks for your help Lewis!

          ty

          In article <3s0v51t8t2p2pa 32e5i3q57u9nkpu lct1h@4ax.com>, Lewis C
          <lewisc@excite. comwrote:
          On Thu, 14 Apr 2005 22:31:30 -0400, nospam <nospam@goaway. comwrote:
          >
          Hello all,

          I have a question about the Oracle 10g thin JDBC driver. I was
          wondering if anyone knows what the default prefetch size is (in number
          of rows). Also, does anyone know if an entire packet is sent (i.e.
          padded with null values) if there is not enough data to fill it?

          Thanks for your help!

          ty
          >
          Oracle defaults the prefetch to 10 rows. You can modify that using
          setRowPrefetch.
          >
          I don't believe it will pad if not found. Seems kind of silly if it
          did. Wouldn't it then have null rows in the rowset? That's just a
          guess on my part though.
          >
          Lewis
          >
          -----------------------------------------------------------
          Lewis R Cunningham
          >
          Author, ItToolBox Blog: An Expert's Guide to Oracle
          http://blogs.ittoolbox.com/oracle/guide/

          >
          Topic Editor, Suite101.com: Oracle Database
          Page not found - Suite 101
          http://www.suite101.com/welcome.cfm/oracle

          >
          Sign up for courses here:
          Error 406 - Not Acceptable
          http://www.suite101.com/suiteu/default.cfm/416752

          -----------------------------------------------------------

            Comment

            Previous template Next
            Working...