Ah yes, lovely. You might want to try a commercial JDBC driver
instead of the default DB2 one... Oracle had a bunch of problems like
this a few years ago in their JDBC drivers that they have mostly now
addressed, but for a long time in order to get a full JDBC spec
implementation and avoid vendor lock-in we had to use a third party
driven like the ones from Data Direct.
-David
On Nov 1, 2006, at 9:34 PM, Jason Lane wrote:
Well, there's another issue too. On the Survey portion it seems
that one of the SQL statements is using a cursor to perform it's
select, and either by default or how it's configured it's using a
scrollable insensitive cursor, but db2 does not seem to support
retrieving some of the columns (mainly CLOBs it seems) that way.
The db2 documentation basically says to remove those columns from
the select, or don't use cursors. This is starting to get interesting.
I'll take a look at the metadata issue and see what I can come up
with.
----- Original Message ----
From: David E Jones <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, November 1, 2006 10:10:30 PM
Subject: Re: db2 express-c and ofbiz
On Nov 1, 2006, at 8:57 PM, Jason Lane wrote:
Oh well, I'm still trying to get DB2 Express-C setup (for some
reason even after the ant build.xml creates all the tables and
data, when I start the server the process seems to think the tables
do not exist and they try to recreate. Still working on that one).
It sounds like the JDBC driver doesn't support getting all table meta
data in a single request. You may have to change this to get the
tables one by one, which is a LOT slower (why we don't do it by
default), but should work fine. This would probably require a code
change to the DatabaseUtil.java file. If you make it configurable (ie
a true/false attribute in the entityengine.xml file or something) I'd
be happy to review this and get it into the OFBiz SVN.
-David
