Just had a quick question. Assume that we made a singleton class which
would return the reference to an already existing Connection (made
using DriverManager.. no connection pooling).
I would assume, that calling createStatements in a server/client

Just had a quick question. Assume that we made a singleton class which
would return the reference to an already existing Connection (made
using DriverManager.. no connection pooling).
I would assume, that calling createStatements in a server/client

I am trying to create a resultset from an Access DB. I am using the a Select
Distinct statement to get unique results.
Then I am using a while  resultset.next .....statement to step thru the
result set. The SQL works perfect in Access so I am happy with that. The

I'm sorry if this is a very noddy question, but I seem to have a block
on how to do this...
I am in the process of refactoring a Java application which uses JDBC
to talk to Oracle and MySQL.  The old way used to have a DateTime

Please let me start by saying that I'm new to programming, but I've heard
from a lot of guys that it's best to create database applications in Java
because of the cross platform capabilities..
Is this true?

I need an open source persistence layer products for my web
application. There are some of them out there. I would appreciate if
some one can point out the most popular one.
Thanks,

I want my Java stored procedure to return (as an out parameter) a resultset
back to my java program but getting an error
Here is the Java stored procedure ( only relevant parts of code are shown.
public class StrTokenDB2

I have a MySQL table of type InnoDB and try to make updates via JDBC
(mysql-connector-java-3.0.14-production-bin.jar). If the update can be
executed everything is ok. But if my SQL syntax is wrong, or referential
integrity is violated etc. then executedUpdate() does not throw an

to all the geniuses out there,
does anyone here know a java method/program that would transfer my M
ACCESS records to MYSQL?
i already know the easy way which is by exporting, what i need is

Hi.  I'm a .NET VB programmer realizing the error of my ways, and just
turning to Java.  I need to find a database that I can embed in my
applications.  The apps will run on desktops and on PDAs (perhaps
later on some other mobile devices).

Iam getting java.sql.SQLException: Closed Statement in the following code:
CallableStatement cs = null;
   long          noteID = -1;
   try

I am writing a new kind of database (in Java) object-oriented. I mean that
it has not tables, rows and cols, but abstract elements with properties to
query for.
It communicates with the clients in XML (custom format).

I am a beginner - trying to get going with JDBC programming, but having a
difficulty getting the connection setup right. Have spent tons of stuff
reading - but obviously do not get it - and would appreciate any help you
may be able to provide.

I just got Tomcat 5.0.27 installed (with Apache 2.0.50), and am trying
to get a simple JDBC JSP working.  The JSP is called 'test.jsp'.
I have the JDBC-ODBC bridge installed and am going through that and the
Oracle ODBC driver to get to an Oracle database.  I've been using the

I would like to hear opinions as I am venturing into the murky world of Java
databases for a project I wish to undertake.
Agents are wanting to use laptops to collect information. It's been decided
that they will need to go online twice a day and connect to a MySQL