Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsIntegrityChecker with PostgreSQL
https://www.eclipse.org/forums/index.php/mv/msg/314425/826543/#msg_826543
I'm trying to use the IntegrityChecker. I registered my session customizer and activated the default IntegrityChecker. It complains about missing tables that in reality exist (I also let EcliseLink generate the schema to verify I didn't do something wrong). I debugged it a bit and found that in IntegrityChecker#initializeTables it uses row.get("TABLE_NAME") to read a table name. But this returns null because in the row the key is "table_name".
Then i used my custom IntegrityChecker which "fixes" this, but there's the same issue with column names. They are checked in ClassDescriptor which isn't so easy to change afaik.
I suspect that IntegrityChecker works but my configuration is somehow broken. The PostgreSQLPlatform is set correctly. Any ideas what I could try?]]>Christoph L2012-03-22T07:38:17-00:00Re: IntegrityChecker with PostgreSQL
https://www.eclipse.org/forums/index.php/mv/msg/314425/826815/#msg_826815
"eclipselink.jpa.uppercase-column-names"
To upper case both sides if you also have native query issues, or just
"eclipselink.jdbc.uppercase-columns"
to have column name metadata returned from the driver put int uppercase.
Best Regards,
Chris
]]>Chris Delahunt2012-03-22T14:44:00-00:00Re: IntegrityChecker with PostgreSQL
https://www.eclipse.org/forums/index.php/mv/msg/314425/827699/#msg_827699
thanks for your advice. I set both options to true, but unfortunately the keys in "row" are still lowercase. Any other suggestions?]]>Christoph L2012-03-23T17:28:47-00:00Re: IntegrityChecker with PostgreSQL
https://www.eclipse.org/forums/index.php/mv/msg/314425/828104/#msg_828104
Thanks for your help!]]>Christoph L2012-03-24T07:43:27-00:00