Hello, i am running a java application connected via JDBC Driver
3.00.JC1 to an Informix 9.40.FC4 database. After executing several
querys, when the application commits a transaction i get "Not in
transaction" SQLException. The getAutoCommit() attribute is false, so

Upgraded to 12.5.3, from 12.5.0, on Saturday.  No problems Saturday, no
problems processing Sunday (mostly C programs with a single Java app
(piped through Sun Java Application Server using jDTS).  Today, started
receiving the following errors when processing started to get heavy:

does anybody can tell me how to get connected to AS400 via JDBC or in any
other way?
Thank you
Alessandro

All,
I have a method that calls an Oracle Stored Procedure from an Oracle
Package.  Everything works fine but the last two lines in my code below
where I get the Cursor from the procedure and cast it to a ResultSet is

The JDK (j2se ) 1.4 ships with JDBC 3.0 standard, and JDK 1.3 shipped
with JDBC 2.0 standard.
Question is If I have a driver which is based on JDBC 2.0 standard,
will it work properly with the JDK 1.4 or JDBC 3.0 standard??

Hi all. I'm newbie in java and i have a problem: I have a program
written in java which create a XML file. In this file are types like
string (for example NAME, SURNAME etc.),float etc. My task is to create
program (in java) which will export from this XML file its content(NAME

Ok,
The DB URL typically looks like...
jdbc:oracle:thin:@HOSTNAME:1521:SID
But what if my database has failover and there's actually 2 hosts that

I'm new to jdbc programming, and I can't find an answer for my problem.
Take for example this bunch of code:
protected void executeQuery( Connection con, String sqlStatement )
     throws Exception {

We aren't allowed to create packages and procedures in the database.
So I have to use JDBC to do what a script which contains DML (Alter
Table Disable Constraint) and an Anonymous PL/SQL block (not
server-side compiled).

I'm not sure whether i'm running into a problem with hsqldb or more
simply my understanding of SQL indexes is to pot.
I've got a number of table in a hsqldb, i.e  DIVES, LOCATIONS
My Locations table as a column called Location_ID which is its primary

Here are a few things I don't understand about connection pooling.
The DBCP API seems to be what I need, but I've read some articles about
using Tomcat to manage connection pooling rather than doing it by hand.
What I don't understand is that I need a servlet and my app isn't a

We have a strange problem when Java talks to SQL Server 2000.
The following query runs great when executed from Query Analyzer.
SELECT prlc_plis_code, prlc_cust_id, prlc_startdate,
prlc_enddate, prlc_type FROM   PriceListCustomer WHERE 1 = 1

I'm running parallel java threads each concurrently processing
addbatch() / batchExecute() statements. The set of rows being operated
on by any thread are guaranteed independent. But It's still getting
deadlocks. If I read oracle's enterprise manage console output

I'm quite new to j2se apps but have started doing one using swing for
the gui. Anyway my previous work has been mainly J2EE apps where I
always create a new connection to the DB using jdbc/connection pooling.
I've taken the same approach in my desktop application, each time I need ...

I'm looking for some kinda gui to speed data transfers up for me from
mySQL to a standalone hsqldb file.  I noticed in the docs for hsqldb
there is supposed to be a Transfer tool but I cant find it in the
version i download a few days ago.