Using Jenny with Postgres...is there a mechanism to set the schema being used?
posted 7 years ago
Hello! I am new to this site, and came to it by looking for a code generator for ODBC table accessors. I am testing Jenny out to see if it suits my needs. I have run into an issue with using a Postgres DB. When using the Jenny generated method for getting a row from a table, the generated SQL statement looks like this:
SELECT Column_1, Column_2, Column_3 FROM table_1
When executing the SQL statement, Postgres issues this exception: org.postgresql.util.PSQLException: ERROR: relation "table_1" does not exist
I ran the SQL in the Postgres query tool, and modified it until it worked. Here is what was required:
SELECT Column_1, Column_2, Column_3 FROM "schema_1".table_1
My Postgres DBs contain many schemas, and I need to be able to specify which schema within a DB is currently in use. I am about to modify the DBFacade class to be able to specify the current schema, but before I dive into those waters, I wanted to see if there was already a mechanism built in to the Jenny generated code that supports this, and I am just not smart enough to figure it out .
Any help is appreciated!
BTW: The code generated by Jenny is really quite excellent! I am impressed with the way the generated code looks and runs! Kudos to the authors!