I am connecting the mdb file using JdbcOdbcDriver. I need get the
metadata information. I can get the table name and column name its
datatype etc. however am not able to get the column constraints like
NOT NULL constraint, CHECK constraints etc. Is it possible to get it

do you have any experience using "MySql 5" (with MySql jdbc connector) or
"SQL Server 2005 Express" (with jtds connector http://jtds.sf.net) as
database-engine in a java web application?
I have to choose one of them for a commercial web application that is

When executing a prepared statement I get a null pointer exception
in jdbcResultSet.
It only occurs on my Solaris box intermittently. I havent seen it happen
on my Linux box. I suspect its a sync/race condition issue in hsqldb,

I am aware that ther are many tutorials online but due to so many
things I have to take care of all by myself  (right now AC's been
broken for 3 1/3 days at this house my sister owns and I can't get any
HVAC to come and I am missing my work), I want

Does anyone know what drivers to use for Open Office ? I am using MAC
OSX and do not have ODBC...
Class.forName("OpenOffice.Driver");
           String url = "jdbc:OpenOfficexxxxxxxx";

Hello Java gurus,
Here is my background before my question.  I was a chemist (master's in
Chemistry and worked about 2 years) before I studied Computer Science.
Due to health reasons (breast surgery - minor - and nasal condition, I

I'm running out of ideas on this. Basicly I wrote my own console to act as a
more userfriendly interface to interact with an underlyding MySQL database.
Whenever i issue a query i get a pop-up window displaying the results in a
JTable.

select convert(numeric(16,2), 5.325),convert(numeric(16,2), '5.325')
returns
5.32     5.33
I would like to understand the logic behind this behavior, if any.

I am calling a stored procedure on MS SQL Server using the MS JDBC
drivers with code like this
CallableStatement cs = dbConnection.prepareCall("{call sp_myproc(?)}");
cs.setString(1, value);

I'm helping someone on another newsgroup but I need to know something. This
person wants to store a four dimensional boolean array, i.e.
boolean[][][][], in a column of a database. There are 53,000 entries in a
single occurrence of this array and they wan to store over 200,000 ...

I am using Eclipse 3.2 (Callisto) and I would like to integrate it with
an Apache Derby Database.
Which is the best plug-in to do so.
I want to be able to execute queries, start and stop database server,

Dudes,
I have tried to add JDBC driver  for MySQL to apache-tomcat-5.5.17,but
unsuccesfully.
In the materials i have read , it was adviced to add a Resource tag in

Has anybody used db4o. I found it whilst I was looking for an open source
object database. The website (obviously) sings its praises. But I would like
some opinion before investing any time in it.
It can be found on: http://www.db4o.com/s/osdb.aspx

Please help me learn how can I create a MySQl database and then
modify/update it with Java. Please give me some helpfull code...