I am wondering if there is a generic
way to list all triggers and procedures in
a database, that will work for all DBs (that
supports triggers and procedures)?

I have a question regarding connection.createStatement()
which I wonder if someone know how it function.
I am looking/reviewing some customer code and I found
the code below in one place (some code are converted

I am developing a client/server application where my server needs to
get data from a separate SQL Server 2000 server. I have the option of
performing one large query, returning about 1500 rows, or 50 small
queries, returning 30 rows each. I am using the Microsoft JDBC driver

Hi. I am an amateur Java enthusiast. I currently work as a carpenter
and I moonlight on the weekends as a photographer. I'm trying to
transition a career change.
Which Java exam should I start with? Programmer? Or Developer?

I have a table:
CREATE TABLE data (region INT, value FLOAT, averageValue FLOAT);
In the table, there are 10 rows with 3 distinct values for region.
I want to set the averageValue column to contain the avg(value) for

I've been digging for a while, found several post that supposedly do
this but none seem to work.
Using Oracle 9i, JAVA 1.4.1, and the latest JDBC from oracle. How do
you insert a binary file into a oracle BLOB field?

Hi,
Can an Oracle JDBC connection string take a username and password?  
The plain version of an Oracle connection string is username and
password on Oracle connection string

I want to improve the performance of a Java Application using
PreparedStatements instead of Statements. I have some kind of problems with
null fields because the same query does not return the same results in both
cases:

I am wondering if someone here knows of a good overview (preferably
http accessible) of the pros and cons of Connection pooling and
statement caching.
Also: does anyone know if it is possible to use a plain connection

  I'm using WebLogic 5.1 sp12 and Oracle 8.1.7 with JDBC 1.2 drivers.
I was wondering, if I know that a column is a vARCHAR2 column, how
could i deduce the maximum length of that column, short of repeatedly
inserting larger and larger strings until I genertae an exception.  I

I'm trying to find a copy of MS's beta JDBC drivers, as i've read they
support SQL7 (they took support for 7 out of the release drivers -
thanks bill). anyone know where i can find a copy? i've done extensive
google searches.

Hello, I am setting up a ConnectionPooling dbHandler class for a JSP
application connecting to an AS400.  We are using Tomcat 4.1.27 and
precompiling everything as servlets with ANT.  I have a dbHandler
class that works just fine, along with the connecting pooling.  My

How to process multiple ResultSets?
I have a stored procedure which returns two select queries.
The fist Query is a Result of a Select Statement
the second one is a self build costruct which shows the state of

I have a problem with memory using SQLserver on a server running WIN2K
Advanced Server with 2 GB! of internal memory.  We limmited the SQLserver
memory to 1 GB and 512 MB for JVM (version 1.4.2_01).  The OutOfMemory error
is always ate the same place in the jdbc driver as shown ...

Hey all,
Question........
I use two different webpages that are Java run. One using Version 1.3
and the other 1.4. If one of the versions is installed the other page