We are considering a solution for a J2EE application
that stores the whole database in memory
(using a persistence layer as hibernate in order to manager
concurrency and transactions).

we have the follwoing strange problem using an Oracle connection cache.
The cache uses a OracleConnectionCacheImpl object. This worked fine so
far. After changing some minor things in the app and redeploying it to
tomcat the app hangs just before creating the ...

I'm writing a java program that uses transactions. For this reason I
turned of the autocimmit in java (sqlConnection.setAutocommit(false);)
This seems to work but now he also seems to lock the tables when I
only do a select. I can solve this bij doing a commit after each

Java Libraries + Python Syntax
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0404yang/index.html

we're developing an application in which performance is a very important
issue.
Database is Oracle 9.2, application language is Java 1.4.2., OS is Solaris 8
(RAM 8GB, 4x750Mhz CPU).

OK,
After reviewing some articles, it appears that we can't use
"select * from mytable where mycol = ?"
when we >>might<< have a null value for mycol and we have to use a

I'm trying to insert a row into my XMLDB table but I have the
following problem:
My xml is too big for varchar2 (>4k) so I have to use a CLOB in the
constructor for XMLType. However I can't create a new CLOB complete

I query an Oracle 9i database and present on the web using TomCat and JSP. I
am wondering if the way I do it (see code snip below) is the
best/recommended way to do it or are there other/better recommended ways. I
am using TomCat 5 with JDK 1.4 and latest JDBC drivers from Oracle.

Hi netpeople.
I have got a problem with setting parameters to a statement. I would
like get the last inserted id of a table.
The SQL statement for this on mssqlserver is: