I am looking for the best way to check whether several oracle (or any
database)  databases is running or not.
At the moment I just attempt to connect to the server IP using Socket
and conclude the database is not running if connection timed out.

I have a query that is expecting multiple numeric parameters, and I am
trying to make it generic enough so that if any of these numeric
parameters is not provided, i can still execute the query and get  all
matches as if i'm using '%' for a Varchar parameter.  The reason for

I'm using Hibernate for O/R-mapping. I want to create an entity who's
data comes from multiple tables. I already figured out that I have to
use @SecondaryTable to achieve that.
My question is: Is there a way to map an entity to different tables in

i amjoining your group

I have an application that writes to an Oracle SQL database.  The main
loop reads one data record from an external source, splits it into
fields then writes it to a database table with a Statement.ExecuteUpdate
method call, using SQL insert.

After a SELECT query via JDBC, is there a fast way to find out the
number of
rows in the result? Of course I could do something like:
  Statement s = ...;

I have a mysql table with 9M records which I am reading row by row though
j/connection/jdbc..
The program stops around 100,000 records with the following Exception(s):
com.mysql.jdbc.CommunicationsException: Communications link failure due to

I have an application that's sending the below SQL to a Sybase
database. Version 12.5
---
  String proc is set to

Hi experts,
which approaches would you suggest for:
- Reading a database schema (tables, fields, relationships) from SQL
Server 2005?

I have one JDBC connection, which works with one particular SID
jdbc:oracle:oci8:@MYSID
I need to find out what's the host and the port of that instance,
because I have to use Thin JDBC, which requires hostname and port.

We are facing some problem in our batch application.
This java based application is reading a file with 25 lakh records
and
updating in Oracle DB.

I'm not terribly familiar with JDBC but I'm willing to dive in.
I'm considering writing a database upgrade java application for an app that
runs on a couple of major relational db's.
I think I might be able to get away with using jdbc and metadata to do this..

I am using Sun JDK 1.5.0_09, Tomcat 5.5.17, MySQL 5.0 .
I am gathering data from a webpage using jsp. Beans are handling the
database operations. I have tested the Bean code and it correctly adds
data to the database table.

I have db2 running on an AIX machine, and running my program from
JBuilder on a WinXP machine.  I downloaded the newest db2jcc.jar and
lecense file today and installed them.
If I get an exception, the rollback() is called (I stepped thru the

I write a lot of JSP pages with backend classes to access MySQL
databases.  One of my biggest problems is having the SQL statements
hardcoded in class.
Everytime I have to make a slight change to the sql statement, I have