Posted by
Jason Lane-2 on
Nov 03, 2006; 7:30am
URL: http://ofbiz.116.s1.nabble.com/db2-express-c-and-ofbiz-tp142441p142443.html
Yes, I saw in the code a TODO on the primary key section that mentions looping through the tables to get the primary keys for each. If I get some time I might add some code there to add that ability. Right now on DB2 it cannot get the primary keys for the various tables. I'm not sure if that actually will cause any problems since the primary keys are there, OFBiz just can't see them in that particular instance.
----- Original Message ----
From: David E Jones <
[hidden email]>
To:
[hidden email]
Sent: Friday, November 3, 2006 12:46:43 AM
Subject: Re: db2 express-c and ofbiz
Based on your description of the column problem I'd guess it is
similar to another problem we talked about a bit ago. OFBiz sends
null for the table name so that it can get back all column info in a
single pass, rather than doing 700 round trips to the database. The
time difference for most databases is a few seconds instead of a few
minutes, so it makes a very big startup difference. I'm not sure this
is the problem, but I'm guessing it is based on your description and
that error message.
-David
On Nov 2, 2006, at 2:23 PM, Jason Lane wrote:
> Well, I actually found the proper way to fix this, without changing
> code. It turns out that the schema name needs to be all upper case
> since DB2 treats it as an ordinary identifier that must be
> uppercase. After I fixed that I was able to get the table names
> without changing any code.
>
> Now it seems thee is something going on with the column info
> portion. When it tries to get the column information I get an error:
>
> "Invalid getIndexInfo call: null not allowed for table name.. Not
> checking columns."
>
> I guess I will need to debug and step through until I find why it's
> null. I'm guessing the ArrayList that holds the table names was
> maybe not resized to remove null identifiers and so it's getting a
> null on one of the calls, but I'll have to take a look.
>
> Unless of course if someone else has seen this and knows what I'm
> doing wrong.
>
> ----- Original Message ----
> From: David E Jones <
[hidden email]>
> To:
[hidden email]
> Sent: Thursday, November 2, 2006 9:56:33 AM
> Subject: Re: db2 express-c and ofbiz
>
>
> On Nov 2, 2006, at 7:38 AM, Jason Lane wrote:
>
>> 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.
>
> These can usually be added on the JDBC URI.
>
> -David
>
>
>
>