Hibernate and DB2 data fetching

Question

I am using struts and hibernate application. I have a problem while fetching records from DB2 via hibernate.

I am getting this error

14:22:17,804 WARN  [JDBCExceptionReporter] SQL Error: -204, SQLState: 42704
14:22:17,804 ERROR [JDBCExceptionReporter] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TABLENAME, DRIVER=3.57.82
14:22:17,804 WARN  [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098
14:22:17,804 ERROR [JDBCExceptionReporter] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.TABLENAME, DRIVER=3.57.82
14:22:17,804 WARN  [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098
14:22:17,804 ERROR [JDBCExceptionReporter] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.TABLENAME, DRIVER=3.57.82
14:22:17,804 ERROR [VisualListAction] com.sit.exceptions.DaoException: Unable to fetch tablenameItems.
14:22:17,804 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception

Error code 42704 means that tableName table does not exist. But it exists in the database.

Any idea what could be the problem? Problem with schema or anything else?

Muhammad Imran Tariq · Accepted Answer · 2013-05-10 11:57:52Z

1

Problem is with database schema.

i was using

schema.tableName

when I use

schema1.tableName

it works. Because in DB schema was schema1.

edited May 10, 2013 at 11:57

answered Mar 31, 2011 at 10:32

Muhammad Imran Tariq

23.4k47 gold badges130 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate and DB2 data fetching

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related