Posted by
Jason Lane-2 on
Nov 03, 2006; 7:28am
URL: http://ofbiz.116.s1.nabble.com/db2-express-c-and-ofbiz-tp142441p142445.html
I just posted a page on the wiki. I'll update it as I run through some of the issues. Anyone who has any thoughts on some of the current issues please let me know or post to that page.
http://docs.ofbiz.org/display/OFBIZ/Entity+Engine+DB2+Express-C+integration----- Original Message ----
From: Jacopo Cappellato <
[hidden email]>
To:
[hidden email]
Sent: Friday, November 3, 2006 12:22:10 AM
Subject: Re: db2 express-c and ofbiz
Hi Jason,
all your notes are interesting and I guess that could be beneficial to
others that in the future will need to run OFBiz on db2; would you mind
collecting your notes in our documentation site?
Here is the link:
http://docs.ofbiz.org/homepage.actionYou could put your notes in a new Wiki page here:
http://docs.ofbiz.org/pages/listpages-dirview.action?key=OFBIZor even create your own homepage (it is a very simple task) in the doc
site and add your notes there.
Thanks for sharing your experience with us.
Jacopo
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
>
>
>
>