You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "Thavutam, Prashanth" <1t...@toysrus.com> on 2003/11/20 21:22:41 UTC

Schema name in DB2

Hi,

I need to use schema name to qualify the table names in DB2, so I created an
entry in the properties file, getting it in the *Peer classes and prefixing
it to the table names. I left the database name to default.
When I run the application, BasePeer.doSelect(criteria) throws SQLException
with "<username>.<schemaname> is undefined name. 
Is this the right way of using schema-name prefix?.

Database name, user name and schema name are different in my environment.

Thanks,
Prashanth

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org