Hi, I have a question regarding the schema naming process. When I create a class "Person" with SQLObject it automatically adds a person table to the "public" schema in my postgres database. If I want it to add this table into a different schema, lets say "hr", then I am unsure of the correct way to implement this. I know if I set the tag "_tableName=hr.person" in the class itself, it works and the table is added where I want it. On the other hand, after doing this I created an Address class with a foreign key to Person. When I add a join to these two tables everything works correctly, but then when I query the person table to look for resulting address's I run into an error.
For example when I run this line of code I get an inner-join error: "Person.get(1).addresses" the sql generated is incorrect. It doesn't add the tablename person to the corresponding field. Here is the result: SELECT address_id FROM hr.address WHERE hr.person_id = (1) It should say "WHERE hr.Person.person_id = (1)". Does anyone know how to fix this problem? -- Tyson Wenger Computer Programmer V&L Tool,Inc. 2021 MacArthur Rd. Waukesha, WI 53188 (262)547-1226 x178 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
