This one time, at band camp, tek1 said: t>hi mickael. t> t>in regards to this bug, were you able to read my last post entitled: t> t>"Re: [castor-dev] MANY-TABLE strange behavior -> looking for" t> t>does your solution solve the problem with many-tables? i attached a patch t>for the problem with many-tables. castor was issuing the correct sql t>statement, but postgresql (pg) was having problems with it because the t>table and field names were not in quotes. the patch that i submitted t>solved the problem. otherwise, i wasn't having any problems with pg. t> t>please let me know if our patches solve the same problem. if not, i can t>enter a new bug (and patch).
The patch offered for bug #1161 will not fix your problem because it simply forces identifiers to lowercase. Because you have mixed-case identifiers in your schema, the only fix is adding the quotes. However, because this bug only applies to PostgreSQL, the SQLRelationLoader is not the right location for this fix. The correct place would be in the src/main/org/exolab/castor/jdo/drivers/PostgreSQLFactory. t>At 16:17 03/02/20 +0100, you wrote: t>>tek1 wrote: t>>>hi hiran. t>>>since you experienced the opposite behavior, i'm wondering if it has t>>>something to do with the jdbc driver? perhaps it could be the jdbc t>>>driver that's converting to either all uppercase or all lowercase? t>>>which database driver and version are you using? t>>>i'm using postgresql's pg73jdbc3.jar driver. t>>No, it's not a driver problem, I created a bugzilla entry for this : t>>http://bugzilla.exolab.org/show_bug.cgi?id=1161 t>> t>> t>>-- t>>Mickael Guessant Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
