I'm making a JDBC SQL query that looks something like this:
select <a bunch of columns>, a.shortcode, <some more coumns>,
z.shortcode from Table1 a, Table2 b, Table3 z where <join conditions>,
<more conditions>

I have a stored procedure that calls a remote database and returns a
refcursor.  In SQL*Plus, everything works great and I can print the
refcursor and the data is all there.  When attempting to call this from
a JSP page using JDBC (Oracle thin driver 10.1.0.2 or 9.5.0.2) I get an

For the following tables, which is a general rdbms design, what classes will
you create for accessing these tables ?
Table 1 : Group
group_id (PK)

Hey All,
I am having problems trying to insert a TIMESTAMP value into a simple
HSQL database, see code below.  The print statement indicates the
formatting of the timestamp looks reasonable, but I can never get past

My question stems purely from curiousity, and I'd be much obliged if
you'd help, but it's not imperative that I get an answer.  I wrote some
code that runs a whole bunch of queries for me and it works, but I'm
very put off by the extremely long time it takes.  I'm sure there is a

Hibernate 2.1.6
DB2 8.1
Java 1.5
I am trying to debug a Swing/Hibernate database app that was written

I am a relative newbie to Hibernate, and I have managed so far to
persist 2-3 tables, however, on this one table, I am having some real
difficulty.  I keep getting this exception:
net.sf.hibernate.id.IdentifierGenerationException: ids for this class

    I have a problem with unicode data when I use PreparedStatement or not.
I am on SQL Server 2000.
Basically, if I use a PreparedStatement to insert unicode in a NVARCHAR,
the unicode is correctly inserted and when Iwant to retrieve it, it is

This may be just a privilege thing.  But, we loade dthe JVM and have
this Java mail routine working fine under this one schema.  The Java
was loaded, of course, using the SYS schema.
Anyhow, we now create a new procedure that will use this Java mail

does any know:
Which database servers support IPv6 currently ?
Which database servers (name, version) will support IPv6 with which time frame?
Volker

I'm searching for a simple Java database for mobile phone (motorola v550).
I would like to create a database with few fields containing texts.
Is there some free/shareware software?
Is there a very simple Java spreadsheet for mobile phone motorola v550?

Is it possible to use java/jdbc to lengthen columns in, say, ms sql tables?
Please note (sorry) I already asked this in an ms sql group... it is not quite
a cross post, but an after thought that I might get some good information
here.

I have this problem: I use as400 jdbc connection to connect to few DBs
but every two weeks the users have to change the password because it
expired... In the connection I have to put prompt=true to they can
change their passwords when it was expired but the user change it and

I originally posted the msg below on the Oracle.server NG, and since
then, I've found that I was able to get this working by simply adding a
COMMIT at the end of my PL/SQL procedure (see msg below for code).  Now
that it's kind of working, I am trying to understand "why?".

Perhaps this is a FAQ but a fairly extensive web search did not turn up
anything of value.
I am looking for Free and Open Source data aware components in the manner of
Delphi, C++ Builder, JBuilder and VB for NetBeans.