From: Nils Hartmann <nils.hartmann@curry.de>
To: pgsql-interfaces@postgresql.org
Subject: JDBC-Driver with Weblogic
Date: Mon, 13 Nov 2000 19:40:48 +0100
Message-ID: <3A1035B0.7D2FB02A@curry.de> (raw)
Hello,
maybe this post is off topic, than please ignore it....
We have a very special problem here: we're using Weblogic Application
Server (WLS) 5.1 as EJB-Container, and want to use Postgres as database
backend. I have a problem with nearly *all* tested JDBC-Drivers from
different Vendors (including Oracle and Informix): it seems that they
are not able to work with Weblogic when they should write serialized
Java-Objects. According to EJB specification one can have on CMP Beans
attributes that implement java.io.Serializable. Unfortunatly I don't
find a JDBC-Driver that works with that. Now I'm trying Postgres, and I
made a little "hack" to the JDBC driver to get it work: WLS calls the
"setObject" method on PreperedStatement to write serializable objects to
the database. Since the setObject method of PG's JDBC driver tries to
"map" an Object to a postgresql table it fails for unkown types. Now I
modified this method, that it converts this object to byte[] and calls
setBytes. This method seems to work but it is pretty slooooow :(. (Note
good news is, that it actualy works, in opposite to Oracle, Informix,
... :-)
My question is: do you know some better way to store Serializable
objects? Maybe in 7.1? Note: I'have to call the setObject method, since
that is called from WLS.
Thanks for your comments!
nils
--
NILS HARTMANN
CURRY. SMILE @ WORK.
Curry Communication GmbH
Behringstr. 28a
22765 Hamburg
TEL +49.40.398 344 00
FAX +49.40.398 344 09
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: nils.hartmann@curry.de
Subject: Re: JDBC-Driver with Weblogic
In-Reply-To: <3A1035B0.7D2FB02A@curry.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox