i am trying to use a dns-less jdbc-odbc connection to connect to an
msaccess database using the following connection string:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\db1.mdb
is there a way to use this connection to compact the database?

I got the problem with inserting clobs into Oracle.
This process is very slow when I run java code on Tomcat.
(same code (same driver, same database, same data, same computer) running
from Eclipse is 10x faster).

I dont how to create tables:
create table tblTable (id number, description text)
but how do you check if the table already exist before you create it?
Cheers

I'm planning a small Java app using JDBC and have question about making
multiple result sets in a loop.
My program will make a query once and then use one of the fields from
each row in the result set as an argument in a second query. It would

Is it possible to determine if a column has some form of "auto
increment" modifier applied to it though the JDBC metadata services?
The closest thing I've found is DatabaseMetaData.getVersionColumns(),
but I haven't had much luck getting it to return anything but empty

I have a strange problem with JDBC and Access.
Im trying to create a table and insert values into it,
but i'm getting an error saying it doesn't like the syntax, and is "expected
1".

I'm having a strange problem with establishing a JDBC connection.
I'm using the following code to make the connection:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("About to open connection");

How does MSN allow user to connect to other users to chat if the end
user is behind a router/NAT?   I'm thinking in terms of Java and using
Sockets and I can't think of a way for myself to connect to my friend
when he is behind a NAT.

I am executing a stored procedure using CallableStatement. This
procedure takes a paramter and creates a table in database with that
parameter as one of the columns in the table. Immediately after
procedure returns, I use the same db connection to read the data from

Hi.  I am querying an Oracle 9i database that in some cases will return
very large resultSets (up to 95,000 rows).  I am using Java Server
Faces for my front end but I am having some major performance issues,
for obvious reasons.  My question is this: Can I start flushing the

I currnently am working on a project which is supposed to run with an
Objectstore (actually PSE-Pro) DB-backend.
Now i have a little question to the group: Would any of you like to share a
design pattern or code snippet for a transaction manager class? It should

I use an application with dynamically creates SQL.
Using Postgres I can simply create a statement and call
statement.execute(sql);
Informix, however, doesn't accept this (complains about temp tables not

1 - Date now = new Date();
2 - uprs.updateDate("LASTMODIFIED", now);
Error i get is "Cannot resolve symbol" on line 2
Any suggestions?

Can anyone suggest a methodology for finding out programatically what
JDBC drivers may be on a machine?
Here's what I intend to attempt:
Get the paths for ext, endorsed, library and classpath

Does anyone know of a good open source Database query tool that I can
use the Oracle thin driver with?
Thanks in advance,
Bob