How can I connect to a Access Database (*.mdb) file stored on a Unix
System through a Java Program running on the same.
Thanks,
Tush

When using Java's sql ResultSet class I've used getDate() to retreive a
date. However Java 1.5 makes clear Date is deprecated.
My code to get the date (actually I'm interested only in the year although
the MySQL 'date' type is used in the table) looks like this:

I have an application that uses a connectionpool with connections to
SQLServer2000 through the MS JDBC driver, current version.
The writes are very basic and so they are mostly done in autocommit mode. In
one location where a set of rows read from a tabular source like Excel are

Hi,
 We are using weblogic8.1 jdk1.4.2 And oracle 8i.  
 We are trying to set the value for Blob column using the following
code snippet :-

I am unsure whether it is good Java practise to use Close() to close a
database Connection.
EG:
dbConnection = DriverManager.getConnection(url, user, pass);

DB ORACLE
Calendar stCal = Calendar.getInstance();
stmt.setDate(COLUMN_DATA, stCal.getTime());
doesn't work because setDate method

Hi,
I use Java JDBC.ODBC connect to an excel spreadsheet. I used executSQL to
get data from excel. That is fine. But when I use rs.getObject(column) to
get the object in excel, Java report " numeric overflow error". How can I