You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Sambaiah Kilaru <ks...@gmail.com> on 2010/09/16 23:00:28 UTC
issue with Oracle and openjpa1.2.1
Hi,
We are using Oracle database and openjpa1.2.1 with tomcat in an application.
Having trouble with the error
Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.open
jpa.persistence.PersistenceException: ORA-00942: table or view does not exist
FailedObject: prepstmnt 30551515 INSERT INTO COORD_JOBS ( some thing goes here )
[org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedState
ment]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:423
2)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
ry.java:4197)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:102)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:72)
at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.f
lushBatch(BatchingPreparedStatementManagerImpl.java:195)
at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(
BatchingConstraintUpdateManager.java:63)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUp
dateManager.java:89)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUp
dateManager.java:72)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManage
r.java:717)
at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStor
eManager.java:130)
... 44 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not e
xist
Any light thrown will be helpful.
thanks,
Sam
Re: issue with Oracle and openjpa1.2.1
Posted by Sambaiah Kilaru <ks...@gmail.com>.
----- Original Message -----
From: "Michael Dick" <mi...@gmail.com>
To: users@openjpa.apache.org
Sent: Friday, September 17, 2010 7:21:52 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Re: issue with Oracle and openjpa1.2.1
That's odd.
The exception is coming from Oracle, OpenJPA is just reporting it. Are you
using OpenJPA's internal datasources (openjpa.ConnectionDriverName,
openjpa.ConnectionURL, etc) or a datasource from JNDI?
Hi Michael,
We are using openjpa's internal datasources not JNDI.
thanks,
Sam
Re: issue with Oracle and openjpa1.2.1
Posted by Michael Dick <mi...@gmail.com>.
That's odd.
The exception is coming from Oracle, OpenJPA is just reporting it. Are you
using OpenJPA's internal datasources (openjpa.ConnectionDriverName,
openjpa.ConnectionURL, etc) or a datasource from JNDI?
-mike
On Thu, Sep 16, 2010 at 9:11 PM, Sambaiah Kilaru <ks...@gmail.com>wrote:
>
> ----- Original Message -----
> From: "Michael Dick" <mi...@gmail.com>
> To: users@openjpa.apache.org
> Sent: Friday, September 17, 2010 5:17:32 AM GMT +05:30 Chennai, Kolkata,
> Mumbai, New Delhi
> Subject: Re: issue with Oracle and openjpa1.2.1
>
> >> Hi Sam,
>
> >> Does the COORD_JOBS table exist, and is it readable by the Oracle user?
>
>
> Yes, the table exist and I can login using the same username and pass my
> application is using
> and insert entries
>
> thanks,
> Sam
>
>
Re: issue with Oracle and openjpa1.2.1
Posted by Sambaiah Kilaru <ks...@gmail.com>.
----- Original Message -----
From: "Michael Dick" <mi...@gmail.com>
To: users@openjpa.apache.org
Sent: Friday, September 17, 2010 5:17:32 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Re: issue with Oracle and openjpa1.2.1
>> Hi Sam,
>> Does the COORD_JOBS table exist, and is it readable by the Oracle user?
Yes, the table exist and I can login using the same username and pass my application is using
and insert entries
thanks,
Sam
Re: issue with Oracle and openjpa1.2.1
Posted by Michael Dick <mi...@gmail.com>.
Hi Sam,
Does the COORD_JOBS table exist, and is it readable by the Oracle user?
-mike
On Thu, Sep 16, 2010 at 4:00 PM, Sambaiah Kilaru <ks...@gmail.com>wrote:
> Hi,
> We are using Oracle database and openjpa1.2.1 with tomcat in an
> application.
> Having trouble with the error
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error>
> org.apache.open
> jpa.persistence.PersistenceException: ORA-00942: table or view does not
> exist
>
> FailedObject: prepstmnt 30551515 INSERT INTO COORD_JOBS ( some thing goes
> here )
> [org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedState
> ment]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:423
> 2)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
> ry.java:4197)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
> :102)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
> :72)
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.f
> lushBatch(BatchingPreparedStatementManagerImpl.java:195)
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(
> BatchingConstraintUpdateManager.java:63)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUp
> dateManager.java:89)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUp
> dateManager.java:72)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManage
> r.java:717)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStor
> eManager.java:130)
> ... 44 more
> Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does
> not e
> xist
>
> Any light thrown will be helpful.
> thanks,
> Sam
>