Do you use db2 express- 8.2 or 9.0? I tried 9.0 and didn't have had problems with constraints names. In my memory, 9.0 comes with a new JDBC driver.
> -----Message d'origine----- > De : David E Jones [mailto:[EMAIL PROTECTED] > Envoye : jeudi 2 novembre 2006 05:52 > A : [email protected] > Objet : Re: db2 express-c and ofbiz > > > > 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 > > > > > > > > >
