Re: db2 express-c and ofbiz

Posted by David E Jones-2 on Nov 02, 2006; 4:52am
URL: http://ofbiz.116.s1.nabble.com/db2-express-c-and-ofbiz-tp142441p142455.html


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
>
>
>
>