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 <[EMAIL PROTECTED]>
To: [email protected]
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




Reply via email to