File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Using Jenny with Postgres...is there a mechanism to set the schema being used? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using Jenny with Postgres...is there a mechanism to set the schema being used?" Watch "Using Jenny with Postgres...is there a mechanism to set the schema being used?" New topic
Author

Using Jenny with Postgres...is there a mechanism to set the schema being used?

Jim Adametz
Greenhorn

Joined: Nov 03, 2009
Posts: 1
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!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using Jenny with Postgres...is there a mechanism to set the schema being used?