----
hi hiran.
since you experienced the opposite behavior, i'm wondering if it has something to do with the jdbc driver? perhaps it could be the jdbc driver that's converting to either all uppercase or all lowercase?
which database driver and version are you using?
i'm using postgresql's pg73jdbc3.jar driver.
At 19:00 03/02/18 +0100, you wrote:
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail toHi, tek1. I experienced the opposite behaviour: I had a table named ProductBO, and inserted name="ProductBO" into my mapping file. Adabas D came up with an error message "Table named PRODUCTBO does not exist".Here the name was put into upper case from Adabas D during query processing. As the same error occurred with the Adabas D SQL query tool with the query select * from ProductBO I changed it into select * from "ProductBO" and that worked. Unfortunately I was not able to place name=""ProductBO"" into the mapping.xml file, as Castor complains that the table name is not an NMTOKEN. As I am evaluating currently, my thoughts are whether to rename the table (ugly), provide views with different name (still ugly) or change the behaviour of Castor.... Hiran ----- Original Message ----- From: "tek1" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 6:05 PM Subject: [castor-dev] [JDO] how does castor handle case of table names? > when castor accesses tables in the database, does it look for a table name > that's in all lower case letter? i have a table named "dept_deptEmployee", > but castor is reporting: > > java.sql.SQLException: ERROR: Relation "dept_deptemployee" does not exist > > when i change the table name to all lower-case (i.e. "dept_deptemployee"), > it works. > > can someone please clarification on this? > > thank you.
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
