Looking for a good desicions for trasfering more than  10000 rows from
oracle to mysql using only jdbc. Connect is mostly slow about 1 row in
a second, rights on oracle are just for select, update, insert
operations. I think if I can devide 10000 rows in 10 parts and transfer

Can anyone point me (share code) to a Java wrapper (aka DB-Mngr, aka
data access object) that supports a call to Oracle SPs.
Something that would basicly implement:
Interface DatabaseMgnr

I am a university student using a program that requires updated xml
from a webpage (well, a webserver).  Now i know this can be done with
php and apparently quite easily but I would really rather do this with
Java (as the program that will be manipulating the information to be

About to embark on a new project... no customer at this time.
I've narrowed the backend choices down to MySQL and Oracle (partly a
tech decision, partly a market reality decision).  In a world without
constraints, I'd choose Oracle since I have used it since version 7 and

I am working on a beginner's entry for SQL and MySQL in the Java
glossary.
Consider this query:
SELECT last_name, first_name, city, state

I am using :
mysql-connector-java-3.1.7-bin.jar
to connect to a MySQL database on a MySQL server ver 4.0.25.
After Mysql 4.1.1 there is a new password hashing algorithm involved. Does

I am developing an application that must gracefully recover from
network failures, however I noticed that executeQuery() never returns
or throws an exception for a time out when the network goes down (which
I simulated by unplugging my ethernet cable). The TCP connections of

Have you ever had a piece of database code in which you wanted to test every
probable and improbable error condition that might occur?
For example, suppose you had this code and wanted to make sure that the
error handling did the right thing when an InstantiationException occurred ...

I try to insert many rows (up to 5000) with ca. 40 Columns into MS
Access over the driver sun.jdbc.odbc.JdbcOdbcDriver. Autocommit is
false.
So to have a better performace I tried to use a PreparedStatement:

Is there an official way to snoop on what the app and database say to
each other?  Just what does PreparedStatement send?  Just what does a
raw resultset coming back look like?

I have a Hibernate 2 application that has worked continuously for about
a year running on OS X with MySQL. Now we need to deploy it for a
different customer on Windows, and it is failing, specifically, it can
read from the database fine, but upon trying to insert an object with a

  I get the following error when I connect to the Sybase database from my
web-app. I put Set chained off in the procedure and nothing happenend. There
seems to be a probelm in the Java Side.
Exception :

How to write a program that can simiulate a car-parking garage that can
handle unlimited number of cars. The garage is very narrow such that
its' width can accomodate only one car. There is only one entry point
to the garage at one of its end where the car can be parked or taken

We are running java servlet application on Websphere 5.0.1 and every 2
days or so we are experiencing the websphere slowly running out of
memory and it starts to bring down the application. Is it possible that
not closed database connections could have something to do with this?

Hello, everyone.  Unfortunately, I'm pretty new to databases - I've
been searching this and other newsgroups for information I need to
build a (relatively) small application in Java.  I've gathered some
good information, and I was hoping someone could give me some