users@glassfish.java.net

Issue in findByPrimaryKey in glassfish with oracle

From: <glassfish_at_javadesktop.org>
Date: Sat, 17 Oct 2009 11:12:50 PDT

Hi ,

I am getting the following error, while starting the glassfish server.

[i]com.sun.jdo.api.persistence.support.JDODataStoreException: JDO76400: Got a JDBC SQLException while executing the SQL statement:
SQL statement<select t0."userid", t0."usertype", t0."webstatus", t0."channel2status", t0."enccertid", t0."sigcertid", t0."enrollmentdate", t0."approvaldate", t0."lastaccessdate", t0."passwordexpirydate", t0."password2expirydate", t0."retrycount", t0."retrycount2", t0."devicestatus", t0."deviceactivationdate" from "wsc_user" t0 where t0."userid" = ?> with input values:java.lang.Long:1.
Please examine the SQLException for more information.
NestedException: java.sql.SQLException: ORA-00942: table or view does not exist[/i]


Same build is working fine with Mysql.

I checked all descriptor files as well as table names. Everything seems to be fine.

Can anybody help me in this regard

Thanks in advance
[Message sent by forum member 'p_madhavi77' (madhavi.latha_at_mgl.com)]

http://forums.java.net/jive/thread.jspa?messageID=368315