I have found few JDBC driver for SQL queries commited on csv files.
But I need something more complicated:
My csv files can be located in sereval places: local file, remote file
or as data in a DB cell.

I have to many objects(10m+) to persist in hashmap, I run out of
memory. So I've been experimenting with Sleepycat Java, HSQLDB, XXL and
my own version of a disk backed collection. I've found that persisting
objects in HSQLDB to be most scalable.

I have an application that dumps data into a database. The data is
time-sensitive. Meaning that I need a client to know (within a few
milliseconds) when a new record has been added to a table.
What's the best way to do this? Can I set something up in MySQL that

One of the very cool things about ADO is the ability to have virtual
recordsets.  
How easy is this using java?
For example, build a recordset object for an amortization schedule,

I need to insert data into a table only if that data does not already
exist.
So I want to do something like
IF NOT EXIST (SELECT * FROM MyTable WHERE MyColumn = '?') INSERT INTO

a newbie question...

DatabaseMetaData.getSchemas() retrieves the schema names available in a
database.  These "schema names", however, include user names.
How can I tell that a given name represents a schema, or, conversely,
doesn't represent a user?

I need some advice in deciding the technology stack for my project.
We have a new project to start with.
We are planning to use a combination of struts+hibernate. Will this
suffice all our needs. We are comfortable with JSP, and Servlets.

How do I get the resultset metadata for storedprocedure without
executing the stored procedure in JDBC?
Irfan.

I think I just got a jconnect BUG. I am doing a simple query on a
Sybase Server on a table (AstAddress) having 1,545,282 rows. I have
build an index on the primary key . (I have try clustered and
non-clustered with the same result)

it drive me crazy!
where is the error?
when i use hibernate to connect to the mySQL,some error happens,just
like: