Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0
DB: Sybase 10
Mapping documents:
<hibernate-mapping default-lazy="false">
<class name="TestClass" table="TestTable" schema="DBA">
<id name="ID" type="long" unsaved-value="0">
<column name="ID" not-null="true"/>
<generator class="identity"/>
</id>

Tables are owned by DBA
The user which the application(running on weblogic) uses to connect to DB is a non-admin user say 'testuser'.
testuser has the privileges to 'insert,update,delete and select' on the tables

Problem:
The insertion of data into the table works fine,but when ever application is trying to update the data in the table it throws the following error.
Session.saveorupdate(object)

Caused by: org.hibernate.exception.SQLGrammarException: could not update: [TestClass#409472]
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][Adaptive Server Anywhere]Table 'TestTable' not found

Any help in this regard is appreciated

1. Capture the exact SQL logged by org.hibernate.SQL (fill in bind params as necessary)
2. Login with the same db user directly to the database.
3. Execute the SQL

This will tell you what's going on, hopefully.

I printed the query generated by Hibernate for update and found that it is not prefixing the schema name to the table name when it is trying the update the data.

But, i have specified 'schema=DBA' in the hbm file.

Any pointers on missing link would help