Posted by
Jason Lane-2 on
Nov 02, 2006; 7:25pm
URL: http://ofbiz.116.s1.nabble.com/db2-express-c-and-ofbiz-tp142441p142449.html
Well, I have figured out why it was not able to get the table names. The code to look the tables in the DatabaseUtil is this:
dbData.getTables(null, lookupSchemaName, null, types);
But DB2 does work with that. If you change the line to this:
dbData.getTables(null, "%" , null , types);
It then works. I assume that this is because since I am logged in as the schema owner (login id and schema are the same) it is under the covers trying to look the specific schema inside of the schema.
Would it be worth while for me to add in a parameter to the entityengine.xml to allow for "%" instead of a specific schemaname lookup or is this something that already exists but I'm just missing it?
----- 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