This piece of code in a JDBC program executes fine:
  Statement st = conn.createStatement();
  ResultSet rec = st.executeQuery( "SELECT DEPTNO FROM TABLE1");
But when I see the documentation for "Statement" at the following URL, it

ok, this is a SQL program program that runs fine (on DB2). What does it
mean to have iterator declared outside the class declaration (from a Java
perspective, what are we doing here??)...I was under the impression that
import statements were the only statements that could come ...

Please help:)
I have a TaskManager class which is running as a timer, say every minute.In
evenry minute, the TaskManager instantiates an EJB which makes a connection
to the database and brings a file name which then will be loaded.When I run

This is not legit SQL.  I wondered if you could do what I was
attempting here in one statement though.
conn.prepareStatement( "UPDATE vendors SET
highestVendorConfirm=MAX(?,highestVendorConfirm),

Could someone let me know the website where all the classes for SQLJ are
documented (classes like ConnectionContext, DefaultContext, Iterator
etc.)
TIA

I'm writing some java code that reads data from a DB2 table on an IBM
iSeries which is then used to update a Clipper database on a Windows
server.
We have been instructed that the majority of the code needs to run on the

Hi all,
I have looked everywhere for an answer....
Any help would ... help
followed the instructions from

I need to update datas from some tables in one database to another database
(databases are placed on the defferent servers) ones every day. Both
databases are made in MS SQL Server 2000.
Is there any standard stored procedure that I can run, or may be any class

I get error message -245 in JDBC Informix and the database is defect.
What could be the problem?
Thanks
Norbert

I am rather amazed at the quality of documentation of MySQL and
HSQLDB. I would think given the extreme competition in this area, that
the documentation on the popular databases would be first class.
Yet it is abominable.  You could easily waste 2 days just getting

I'm using jdbc-odbc bridge to try and update a .dbf table.
My code is as follows:
stmt.executeUpdate(
            "INSERT INTO sas.dbf VALUES ('1234', '1234567', '1', '1234',

When I wanna remove a record from my Database or update a record in my
database. I get a java.sql.SQLException: General error, but he does
remove the record. what does it mean java.sql.SQLException: General
error and how can i fix it?!

You can see a picture of my first personal computer, an LGP-30 at
http://mindprod.com/jgloss/mindprod.com/equipment.html
It had no transistors, just tubes, a rotating drum, and a few diodes.
You programmed the thing with absolute addresses, a hex track and

Folks!
Somehow delete statements inside a transaction do not seem to have any
effect when I set the isolation level to *serializable* in Oracle 10g.
With the default isolation level (read committed) everything works fine.

I, as a java developer, find myself constantly switching among
different DBMS.
The JDBC easies it greatly, but I am thinking about a Portable DATA
Layer kind of functionality to aliviate the problems when you must do