Re: db2 express-c and ofbiz

Posted by Jason Lane-2 on Nov 02, 2006; 2:38pm
URL: http://ofbiz.116.s1.nabble.com/db2-express-c-and-ofbiz-tp142441p142451.html

Yes, I'm using 9. Just downloaded it from IBM yesterday. The JDBC driver is listed as version 3.1.57.

I might go ahead and completely re-install DB2 and see if it clears up.

One thing I have not figured out yet. It seems that ofbiz supports sending properties for database connections (via a Properties object) but where can I change or add different properties? I wanted to play around with changing the cursor sensitivity, driver type, etc. I assume that the properties can be placed in a config file somewhere (either properties or XML) but the entityengine.xml doesn't seem to be the place.

----- Original Message ----
From: Jean-Sebastien Hederer <[hidden email]>
To: [hidden email]
Sent: Thursday, November 2, 2006 4:16:09 AM
Subject: RE: db2 express-c and ofbiz

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:[hidden email]]
> Envoye : jeudi 2 novembre 2006 05:52
> A : [hidden email]
> 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 <[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
> >
> >
> >
> >
>