Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Using Jenny with there a mechanism to set the schema being used?  RSS feed

Jim Adametz
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!