I am using a JDBC-ODBC driver with a Microsoft Access database.
My problem is that whenever I call the commit method.  It takes half a
second for the results to become permanent.  However my threads are
calling it at a far faster rate, and future thread processes are

I have a problem with filling data into cludscape database. I have a
procedure which reads some 4000 pictures (10k in average) from mysql
database and put those in cloudscape database.
Procedure is written in Java and use jdbc drivers.

I tried to store naked bytes in an OLE field using setBytes, but got
stuck on a 255 byte limit. My evil me whispers these OLE fields are
meant for large binary stuff, but I cannot figure out how to use them
through jdbc. Any clue?

I am looking for a simple free package to perform SELECT queries on csv
& xls files.
If there is a package which include also XML it will be great (no as
important as the other two)

I am writing a Java application that uses about 1000 parameters in
various calculations. All these parameters are displayed to the user in
a JTable, and any can be modified. I would like to persist the user
changes to these parameters, on the local machine. I'm new to Java, and

I got a very large recordset (around 1 billion records) require to
populate it into the JTable. As we all know, the standard way of
populating JTable are either using Vectors or TableModel. However, it
is not possible to load 1 billion records all at once. I do think many

I'm getting a SQLException Invalid Column Name in a JSP - but the query
works fine if I run it from SQL*Plus.  I'm new at JSP, is there something
basic about SQL commands I'm missing?
Here's the statement:

I'm using JDBC to connect to an Access database.
I'm doing to a direct connection to a local database, so i'm just using the
ODBC bridge.
I'm using JDBC to do queries, like join tables.

How do you enter a statement like:
update locations set name = 'bob's room'
I keep getting exceptions on the apostrophe.
Thanks in advance.

I have been following tomcat 5.5's dbcp example to set up.
My set up includes:
- copy and modiy the code in server.xml
- copy and modify the code in web.xml

I'm wondering if there is any basic "base" for a community website. With
things like support for user registration, login, individual homepages,
photo albums, sending messages, guestbooks, diaries and so on... And
ofcourse with optimised code (especially the code for the ...

I have an Informix database on my pc which is named INNO040. My
database server is called ol_inno040. When installing Informix, 3
databases where created on my server by the installation process. Using
dbaccess I, created a 4th database called testpush on this server.

I've got an app where users can query a remote database (Derby or MySQL)
through a JDBC Driver whith this kind of code :
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection connection = DriverManager.getConnection(dsURL);

Looking for some advice on which DB to use. I'm used to writing J2EE
apps with MySQL using sqlyog as my sql gui but i want to embark on
developing a desktop app which will need to have its own 'local' database.
I havent really a clue on how to use this, one of my aims is to make