How can I set null on a TEXT or VARCHAR field ?
I've tried using the PreparedStatement.setNull(int, int) method but seem to
get no joy, it defaults to  the empty string as soon as I re-read the data
back.

I am slightly confused. We can specify "Holdability" while creating a
statement.
Statement stmt = conn.createStatement(int resultSetType, int
resultSetConcurrency, int resultSetHoldability);

I have an Oracle database, from which I am trying to select a DATE column.
In the database I can see that the value of the DATE is for example
"09-07-2004 12:55:50", but when I fetch the column as a java.sql.Date object
(from my result set) I do not see the hours, minutes, seconds ...

when i was working in windows 2000 (2000 Advanced Server,windows XP,9x
i wrote program which used DB (Microsoft SQL Server 2000) but yestarda
i was installed Windows 2003 Server my program is not working ........
it's throws Exception ........ :

Hi, all.
I'm using Java and JDBC to connect to an Access database.  This is only a
sample application I'm writing to get used to things (I'm moving to SQL
Server once I get round to bringing the disk home lol).

I'm using j2se 1.4.x
I'm trying to obtain (whatever jar file) I need to connect via jdbc. Can
someone tell me how to do this so that U can acces MS-ODBC? My code - and
thrown exceptions, are distilled below. Thanks, -Ike

Following is the API documentation for getNextResultSet() method of Class
ExecutionContext
(http://www.ifs.uni-linz.ac.at/ifs/teaching/java/sqlj/doc/runtime/javadoc/):
"Moves to the currently registered statement's next result. The first time

I'm trying to work with PreparedStatement and the addBatch.
I tried to use the first query (query1) also as a PreparedStatement but
it doesn't work.
For some reason it only adds the last query (query3).

First I hope this post is not too long for a newbie but I think it has
to be that long to describe my problem...
I'm developing a web application using Struts framework, Oracle 9i and
the oracle thin client with jdbc.

Can I ask some advice in regards database solutions and content management
solutions.?  Do you have a philosophy on what is the best for databases -
ASP, JSP, Cold fusion, PHP, etc.  My company website site is going to be
rebuilt and I am the lucky one to do this but I am unsure of ...

In a JDBC program, I am importing javax.sql.* (for using DataSource
interface), but during compilation, it says: Package javax.sql does not
exist.
Any solutions to this. I am on Java version 1.3.1.

How can I find what JDBC version is installed on my machine?
Thanks.
Raquel.

Im looking for a opensource Database, that i could use for Developing Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.

UDB PE 8.1.3 on XP. This simple JDBC program fails to compile.
import java.sql.*;        // JDBC base
import javax.sql.*;       // JDBC 2.0 standard extension APIs
import com.ibm.db2.jcc.*; // DB2 Universal JDBC Driver  

Can anyone suggest a (preferably open-source) library that would allow
for disk-based collections (kind of an application's own VM)?
Thanks.