I am in the beggining stages of designing a J2EE application.  The
current application that I am porting to J2EE maintains real users in
the database, not just a user table.  That is, every connection to the
database must be made with the individual username/password for each

I am designing a j2ee-based web service (web site + personal profile pda
client) and i'm trying to determing whether i should be using mysql or
postgreSQL at the back end. I was using mysql in prototype development,
and was perfectly happy with stability and performance.

Myself and a colleague of mine we're looking at Hibernate and are very
interested in its power.
I wanted to know what you folks thought about Hibernate and what
alternatives may exist.

Is there a way to specifically identify the insert failure to a DB2
table due to duplicate index. I am geting "General Error". I am using
JDBC-ODBC bridge. I have tried getting SQLCode and SQLSate, but gives
0.

I'm using MySQL 4.0.16
How do I join two tables - one a master table, the second a detail table
holding multiple status entries for each master table entry - so that a
query can return the master table fields plus the latest status fields (the

I have a little program here that uses JDBC to connect to a mySQL
server.  (Doesnt connect remotely yet :) ill cross that bridge when I
get there, still new to sql servers and if everyone needs a user/psw
or whatnot).

Is there a way to use a datasource to connect to a DB besides using JNDI?
Right now, my connection string is hard-coded and it's a minor pain to change
between the production and test databases. I'd prefer to have it in a config
file somehow, but JNDI seems like way more than I ...

   I'm looking for a standar way to know when a connection has been
timed out.
   Right now, I found the following solutions:
       - Make a query and check out the result. If it's an exception,

I think there is a valid approach to retrieving records based on a criteria
object that is of the same class as the object you are retrieving.
A Record object may be used as the criteria to find other Record objects.
If we have a method such as

I'm just scratching the surface of Hibernate at the moment and I'm
running into problems.
I'm trying it out with Eclipse, Hibernate Synchronizer and MySQL and
things are vaguely working I think - although I can't seem to get

When using Jturbo 3.0 JDBC driver we are seeing the SQl sent to MS SQL
Server 2000 with Unicode N prepended to the string parameters.
Example:
Parameterized SQL:  Select name, address, phone from myaddresstable

Would anybody know the driver property to set to remove the Unicode
character N from the SQl that is sent to Sql Server from Java?
We are using JTurbo 3.0 with charset=Cp1252 in the connection string.
Thanks in advance.

I was wondering if anyone knows if there is any vendor-inspecific way
of storing and querying a polygon shape via the JDBC?
I currently have an application that stores a simple rectangle across
4 decimal columns: top left lat; top left lon; bottom left lat; bottom

I am newbie to Hibernate. I followed the instructions on the following
page to configure Tomcat to work with Hibernate.
http://www.hibernate.org/hib_docs/reference/en/html/quickstart.html
I tested hibernate with a simple Employee table and Employee.hbm.xml

I am looking for example of standalone Java database desktop application
 that uses Firebird & JayBird 1.5 or less (or anyone SQL Db server)
Can someone tell me where I can found such kind of application ?
-And yet another question : where I can  learn more about developing