In my program I have only access to a object of PreparedStatement
class. I would like to ask somebody how I can retrive a SQL query from
that object.
Regards

Hello all...
I have not attempted to add a gif\png to a database column before using
java, only 4gl lang. So correct me if I am on the wrong path. I have lot
of questions. I am using HSQLDB.

Hi all. i know this is not directly related to java databases, but i thought
this might be a good place to ask.
I have a table in MsAccess that i created as follows:
create table ITEM (

in simple Session Bean running in JBoss I tested Hibernate with
MySql-Database. According to the usual I did something like this:
Session l_sess = null;
       Transaction l_tx = null;

what should i put to the getData() method to get some data?
public class Jdbctesti {
public static void main(String[] args) {
 try {

I'm having problems trying to connect to a remote mySQL db. I have have
got this working on localhost but can get it to work for my website db.
Can anyone point out problems with the code or general problems I shoudl
be looking out for?

I just put together some servlets to communicate with MYSQL. One merely
accepts a string as input in a form and sends it to MYSQL. I have a table
named 'articles', with columns 'name' and 'summary'. I can INSERT values
in to the table, by sending:

 I was reading the Tomcat documentation, and I found that jdbc:odbc
bridge should not be used.
http://jakarta.apache.org/tomcat/faq/database.html
Do not use JDBC-ODBC bridge bundled with Sun's JDK with Tomcat. It was

I would like to know whether possible or not to make a transaction
using db connection pool.
I have db connection pool to MS SQL 2000 using Tomcat 5.0's JDBC
DataSource (see on :

Execution of my query to Oracle db stops. My system is running on
Resin (v2.1) and Oracle 8i as database (on the same machine).
The system has been working fine for 2 years but problem appeared
recently. Code below is executed many times although problem with

I've got an already existing data base (Postgres) which consists of a
couple of tables and connections. There exist also some stored
procedures. Now, how can I get java-classes generated of this
information? Which tool can do this?

I want to federate (aggregate) several physical datasources, each having
its JDBC driver.
My idea is that this aggregator could be implemented as a special JDBC
driver or Connection, that will respond to queries from the application

A null pointer exception is being given on this line
    while (result.next())
I am trying to add an if statment but the compiler is reporting an error.
if (result.next() == null)