Posted by
Jason Lane-2 on
Nov 02, 2006; 4:34am
URL: http://ofbiz.116.s1.nabble.com/db2-express-c-and-ofbiz-tp142441p142454.html
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 <
[hidden email]>
To:
[hidden email]
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