I am experiencing some problems with MSSQL (ver 8.0).
While I can execute sub-select statement directly on a MSSQL server,
I cannot do the same thing in JDBC.
Like the following statement( JDBC throws exception about mismatched

I've got an access database with approximately 47000 records in a
table. These records are inserted through Java in 30 seconds using a
PreparedStatement INSERT query.
When I want to update those records in that table using an UPDATE

Is there any way to convert an *.ODB file (i. e. a database file generated  
by OpenOffice 2.0 working with HSQLDB) into a typical set of HSQLDB files  
for embedded use in a Java standalone application, and vice versa?
Thank you.

Does anyone know if JDBC can access linked tables in a Microsoft
Access?
We have a Mictosoft Access database that contains linked tables that
are physically on a network drive. On a windows machine, We set up a

I have a situation I'm completely stuck on. I'm creating some POJOs for
use in conjunction with Hibernate. Now some of my POJOs have class
(static) variables that contain shared configuartion information. For
example:

I am planning on developing an application which will involve skills that I
have very little experience of - therefore I would appreciate comments on my
initial design thoughts.
Overview on system:

In our application, the JDBC jar files are stored in pre configured
location. say c:\server\libs\1.jar, 2.jar
We don't want to include these jars file in the class path. However,
whenever, we receive a jdbc request, we want to be able to load all the

I'm just thinking... I have all my programs written in Clipper Summer '87.
I'm interested in accessing my DBF and NTX files (dBase IV) from Java.
Thanx.
Greetings from Croatia.

Here is my code. It is an update of another program. For some reason
says my jcd_id cannot be initialized. Here is the error   -
"c:\Java\oraclePgms>javac update.java
update.java:81: Variable jcd_id may not have been initialized.

  I am new to java environment.Can any of my friends like to help the
installation procedures of sql server 2000(during installation which
options to choose), creating the DSN, and creating a my own databse in
sql server 2000..

We have this database that where one of the feilds is going to be a
HUGE block of text, several megabytes. Right now we're saving that by
doing a simple
statement.execute(SQL) where SQL is a string that may be tens of

Is anyone aware of any software - freeware, shareware, or commercial - that
can be used to compare the contents of two tables to see if they are
identical, or, if not, to highlight the differences between them?
Ideally, such a program would compare tables from different databases, e ...

Is there a way to retrieve a list of all database triggers using the
ODBC API?
I'm looking for something like SQLProcedures that can retrieve a list
of all database procedures.

Here is what I am trying to do:
In servlet:
1. Get queries from an applet.
2. Do the queries against SQL Server and return a QueryDataSet to the

Hi,all.
  Can a connection be modified to change the username and password? I
have got a connection, it is better to modify it with new username and
password than creating a new one, for some special use.