If anyone could post a short and easy example of inserting a clob via
jdbc, that would be great. The docs don't have this.

I'm having trouble creating a proper Java connection URL for an
embedded apache derby database on Windows. My database folder was
created with ij and is located at
C:\mytestdb

I can't connect to a mysql db with an applet and J-Connector although
the applet is on the same server (from my point of view).
I suspect the problem is that we are using a virtual hosting server.
I have tried url like

In my JSP-Page I have this Code:
<sql:query dataSource="${foo}" var="bar">
select ID from table
</sql:query>

I have a DB2 stored procedure that I call using JDBC. Now I'm trying to
batch the call. This is done by the book:
stmt = connection.prepareCall(" ... ");
stmt.setString(1, "foo");

I am testing out Oracle 10g.  I have created the database, but I can't seem
to set up any driver for odbc.  I only know how to set up access db.  Does
anybody know how to create a connection to an oracle database from java?

I want to do the following and I hope you can give me hints on how to do
this:
We have a Database (MS SQL over JDBC) which is not always necessary
accessible. But this fact has to be transparent for the application

I'm using OracleConnectionCacheImpl. It is worked fine with unit tests
(using small amount of connections). The pool creates logical
connections and release them after the end of transaction.
But once in production, it works correctly for 1 hour. When the system

how to display / get that query ?
Hi,
I am using JDBC to insert data into a table.
A bit like this:

Can anyone tell me if it is possible to have hsqldb compress its .script
file when in standalone mode ?
I love the performance of hsqldb, its really very good but I dont like
the idea of shipping my product with a plaintext load of SQL statements

What are the relative strengths and weaknesses of the several
remaining all-Java relational databases? Which are the easiest to
install, best maintained, best documented, and least likely to fall
into disuse and abandonment?