I have the following sql statement:
SELECT code,fname,lname FROM employee WHERE datestarted = '02/12/2001'
This works fine when executed through dbaccess, but when I use JDBC to get a
ResultSet nothing is returned.

how to read all tables name and thier constraints in relational scheam in
oracle using Java,because I would like to convert the schema into Object
oriented scheam
thanks.

As part of a uni project I have to allow users to nominate a file to create
an MSAccess database.  I have to then archive records held in an oracle
database into the newly created file.  I am using jsp, beans and tomcat in
my application.  From what I have read on the web you need ...

I want to use ojb(http://db.apache.org/ojb) to access the database in
my eclipse
plug-in, any one has the same experience?
My problem is that, the plugin class loader seems can not find the

We are facing a java issue. We are looping thru a resultset which has about
40 K records. The process terminates abnormally after about 20-25K record(
It differs across runs).
The Query has 400 columns. We have recently modified the Query,earlier it

Assume you have a page with the following drop down select lists
List_Of_States       (Contains 50 States)
List_Of_Counties   (Contains a list of counties in the selected state)
List_Of_Cities        (Contains a list of cities/towns in the selected

We are having problems with a propritary application server
(Epicentric foundation server, which is now owned by vignette)
connecting to an oracle 8.1.6 database.  The problem we are seeing is
connections in the connection pool are being cycled through very

i'm trying to realize a conncetion pool in Tomcat, using the jdbc driver of
MySQL.
i'm desperate, i used the information found in the tomcat documetation, but
it doesn't function.

I am using JDBC driver
I would like to know if there is a way to display the SQL query associated
with a
PreparedStatement.

I am an experienced programmer looking to learn Java.  I am currently
program in C/C++, Pascal (Delphi), Perl, PHP and JavaScript (some small web
page scripts).  Most of my applications connect to MySQL or Postgres
databases.

A bit of a naive question, I'm working with some folks who have written a
web data entry system for my company; they suggest I deploy it  websphere on
AIX as it uses JDBC to DB2. We expect no more than 1,000 transactions per
hour. They are reluctant to advise us what size machine to ...

I'm using JDO for a short while and have a lot of methods that perform a
jdo query.
I wonder how inefficient it is to recreate a query object each time a
method is run:

Does anyone have any clue how to save and retrieve an Image object under
JDBC ? //Ike

Suppose I have the following dummy stored procedure on Sybase or MS
SQL Server:
create procedure foo
as

I have cross posted this as it is a frustration we are having with the use
of DB2 in Java applications.
We have had DB2 installed now for a few months and we have been trying to
develop stored procedures etc.