A query is taking more than 2 minutes to fetch 51 rows using
SelectMethod=cursor, when I change that to SelectMethod=direct I get the
results split seccond.  So in the system only the SelectMethod has been
changed nothing else.

I'm a relative newbie at this, but I'm looking for an easier way. I'm
using the 1.4.2 SDK (can't upgrade to 1.5).
When I create an object, I always create the object and an associated
DAO to go with it. Here's a quick example:

   PreparedStatements are the correct means for executing a stored procedure,
but in my current case I am limited to a plain Statement object. Is there a
SQL string that would allow a plain statement to execute a simple non-parameterized
procedure? Eg:

Database product version=3.23.41
Database driver name=MySQL-AB JDBC Driver
Database driver version=3.0.8-stable ( $Date: 2003/05/19 00:57:19 $,
$Revision: 1.27.2.18 $ )

I need advice on choice of tools for my project. What I'm considering are
JBuilder and Eclipse. The project is Uni assignment for DB class, carried
out by team of 6 people, with me being toolsmith. So here I am, trying to
decide.

I want to access/connect to MS Access database NOT via DriverManager
(the old way) but with using DataSource objects which I understand needs
system setup with JNDI...
what (if possible) does on need to do to setup for MS Access database

Hello, can some one give me the size limite of a table in Postgres and
MysqL ?
thanks !

I am using Tomcat 5.5.7 and Oracle 8.1.6 on my computer (localhost). I am
trying to connect to Oracle using JNDI follow the Tomcat Documentation.
I use this to make a connection
Context initContext = new InitialContext();

I'm having a couple of issues with using Oracle and JDBC.
Environment:
Windows XP Pro
j2sdk1.4.2_07

Hi all, I'm relatively new to JNDI concepts and need some help.  I am
writing a web app that accepts a variable specifying a jndi pooled
connection datasource as a url variable.  This is a requirement and
cannot be changed.  For example index.jsp?db=java:defaultdb

I am looking for a (open-source) tool, which can generate Java Value
Object against database table structure.
Thanks in advance,...

I'm looking for a way to decide, from getting an SQLException,
that the database has been shutdown or is not otherwise
reachable. For any given database this could of probably be
deducted from the exception text (e.g. Microsoft SQlServer

Hello, I've heard that Hypersonic SQL doesn't support foreign keys? This
is a bit confusing. I'm pretty much an SQL newbie and am having a bit of
a problem, though I suspect it's more to do with my rubbish SQL than
hypersonic.

I haven't been involved in testing of database queries in quite some time
and I feel sure there have been many developments and improvements in the
intervening years. Can anyone tell me what today's "preferred" tools are for
database testing?

We are trying to insert to a db, until it gets fairly full, in which case
it gets purges of a portion of the oldest data so that we can go on
inserting more. It is basically a rolling log, limited by size (could not
be by row count, since the row sizes are varying).