I am relatively new to Java/JDBC programming.
I know that you can count columns in a resultset row using the
getColumnsCount() method. However, given a resultset, is there one
simple method that can be called to count the number of rows in the

Should connection pools release all resources associated with a
Connection when a user calls Connection.close()?
Connection.close() just returns the Connection back to the pool.  The
pool that I'm using C3P0 doesn't seem to close any Statement,

I'm using MySQL database with Java and the connector (in subject line).
I have read and searched the group prior to posting, and find no clear
answer.
I would like to lock my table for writing, so would it be like this?

I am developing an application where i need to write XML data in database
tables.
Is there any way in Hibernate so that i don't need to create DAO objects in
by code, i.e. it automatically create DAO's from XML and update in database.

getConnection problem.
I run this on windows XP. I have MS ACCESS
database working well.
The problem is with trying to connect to the database (?).

Hi all....
I have this situation where i need to move data in an MS ACCESS
database from one table to the other using an sql script, and i am
having trouble dong that.

Presently i am working with Cloudscape 3.6 database, i want to migrate
to oracle 9i,please guide me so as that i can migrate to oracle.
Thanks & regards
Kiran.

We have developed an application in java running on jboss that uses
mysql as the database with hibernate persistence. Hibernate
automatically creates all the associated mysql tables, but at present
we have to create a schema manually using mysql's admin GUI on a new

How to find with DatabaseMetaData the check constraints on a table ?
ALTER TABLE T_DISTAN ADD CONSTRAINT CHECK_DISTAN_PDL1_PDL2
CHECK (NO_PDL1 != NO_PDL2);
I can find FOREIGN KEY, UNIQUE AND PRIMARY KEY

I would like to return 2 values (String, number prefered but String,
String will work) from a java stored function.
I was able to successfully return a varray of varchar2 values but I was
wondering if it is possible to return 2 values by using a varray?

I'm currently in the throes of replacing my in-house persistence layer with
JDO2, and I was wondering whether anyone out there can recommend a specific
open source JDO implementation.
I've been testing with one such implementation for the past couple of weeks,

Basically issue is simple: How to store enum values into database. Sounds
simple, but when going after robust solution, then problems start to
appear.
Some approaches,

Hi!  I'm using MS Access for a database to store a public key.
My java application should store the bytes in the database and then
load the bytes later in the application where the bytes are converted
back to the public key.

Is there any opensource database for small devices (mobiles, PDASs)
similar to e.g. PointBase Micro
(http://www.pointbase.com/products/micro.aspx) around?
The only one I came accross is HSQLDB (http://hsqldb.org/).

I've a newbie-question I'd like to ask...
I've searched the archive with no luck...
I can't establish a connection within my local machine.
I'm doing the following: