Help with JDBC

nospam

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

Jul 19 '05 #1

Subscribe Post Reply

2982

Lewis C

On Thu, 14 Apr 2005 22:31:30 -0400, nospam <no****@goaway.com> wrote:

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
http://www.suite101.com/welcome.cfm/oracle

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

Jul 19 '05 #2

nospam

Thanks for your help Lewis!

ty

In article <3s********************************@4ax.com>, Lewis C
<le****@excite.com> wrote:

On Thu, 14 Apr 2005 22:31:30 -0400, nospam <no****@goaway.com> wrote:
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
http://www.suite101.com/welcome.cfm/oracle

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

Jul 19 '05 #3

by: JShurmatz | last post by:

If anyone can shed some light on this problem I would greatly appreciate it. I am unsuccessfully trying to use a database connnection retrieved from a pool configured using Java System Web...

Java

JDBC 3.08 nightly snapshot from 7/23/2003

by: Nils Valentin | last post by:

Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which...

MySQL Database

Help with java connection to MS SQL 2000 with windows integrated security

by: ebrahimbandookwala | last post by:

Hi , I am trying to connect to MS Sql server 2000 from Java (1.4.2 / 1.5 ). I installed my Sql Server(8.00.382) from the one supplied with VS.NET 2001. When I installed it on my laptop it did not...

Microsoft SQL Server

Error Reading DB2 BLOB field : Please Help

by: sid_mulpuru | last post by:

I am trying to read data from a DB2 Blob Data type Field (using wsad 5.1.0) using getBlob() which when executed gives an SQL Exception 2005-01-07 15:48:40,506 ERROR - Error in...

DB2 Database

HTTP status 500 eroor when connecting to db2 using jdbc .pls help. urgent

by: kommaraju | last post by:

iam a starter to db2 & jdbc.i have a servlet program which connects to ibm db2 using jdbc.when i run this using apache tomcat 4.1.34 , it is showing a error message of HTTP STATUS 500 my jdbc...

DB2 Database

need help about aglets

by: yksoni | last post by:

we are working in IBM aglets 2.0.2 with mysql 4.0.2. When we try to access database through tahiti server i.e.aglets we get following error. java.net.SocketException MESSAGE:...

Java

Deadlock within stored procedure - need help

by: byahne | last post by:

We just went live today with a production SQL Server 2005 database running with our custom Java application. We are utilizing the jTDS open source driver. We migrated our existing application...

Microsoft SQL Server

JDBC type 4 driver for DB2 v7.1

by: Anoop | last post by:

Is it true that there are no type 4 jdbc drivers to connect to a DB2 server v7.1? The DB2 server is hosted on ACF2 (OS/390). We would be connecting from windows and solaris boxes. If it is true,...

DB2 Database

Help with JDBC and MySQL

by: IvanJ2EE | last post by:

Hello partners. I have an issue using jdbc and a DB in MySQL. The problem is that I want to make a seach using the Last Name of a person stored in a MySQL DB, from a JSP The problem is that I...

MySQL Database

hello i need help with torque (java )to setup him to db2

by: yoach | last post by:

i dont the prpopties file withe db2 is this ok:? # The target database platform. torque.database = db2 # The target package to put the generated classes in. torque.targetPackage =...

DB2 Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics