hi

i am getting the exception

java.sql.SQLException: ORA-00942: table or view does not exist
this will be occur in the line which is in bold(see the snippet of code)

query.append("SELECT groupHBM FROM ");
query.append(com.liferay.portal.ejb.UserHBM.class.getName());
query.append(" userHBM ");
query.append("JOIN userHBM.groups AS groupHBM ");
query.append("WHERE userHBM.userId = ? ").append(" AND ");
query.append("userHBM.portalId = ? ");
query.append("ORDER BY ");
query.append("name ASC");

String pk1 = userPK.userId;
String pk2 = userPK.portalId;

Query q = session.createQuery(query.toString());
q.setString(0, pk1);
q.setString(1, pk2);
Iterator itr = q.list().iterator();

but we r having table "tcps_group" as well as table "tcps_user" in my database. but the exception is table does not exist.

i don't have idea regarding that.

please any body know the answer. please reavel to me
thanks lot from ur side.

any schema visibility