cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Lewis <jbryanle...@gmail.com>
Subject Re: Error in using cayenne modeler
Date Mon, 26 Mar 2012 10:47:13 GMT
Well, it looks like you got past the inability to connect.  Now Oracle (not
Cayenne) is complaining that the Artist table doesn't exist.


On Mon, Mar 26, 2012 at 6:43 AM, yunus <coolyunus1986@gmail.com> wrote:

> thanx guys.Ur suggestion helped me alot.but now i am facing this new
> error.Please help in this..
>
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: started configuration loading.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded domain: UntitledDomain
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded <map name='UntitledDomainMap'
> location='UntitledDomainMap.map.xml'>.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading <node name='UntitledDomainNode'
> datasource='UntitledDomainNode.driver.xml'
> factory='org.apache.cayenne.conf.DriverDataSourceFactory'
>
> schema-update-strategy='org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy'>.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: using factory: org.apache.cayenne.conf.DriverDataSourceFactory
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading driver information from 'UntitledDomainNode.driver.xml'.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading driver oracle.jdbc.driver.OracleDriver
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading user name and password.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: Created connection pool: jdbc:oracle:thin:@10.122.130.39:1521
> :Georli03
>         Driver class: oracle.jdbc.driver.OracleDriver
>        Min. connections in the pool: 1
>        Max. connections in the pool: 1
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded datasource.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: no adapter set, using automatic adapter.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded map-ref: UntitledDomainMap.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: finished configuration loading in 171 ms.
> Mar 26, 2012 4:06:06 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: Opening connection: jdbc:oracle:thin:@10.122.130.39:1521:Georli03
>        Login: t404819
>        Password: *******
> Mar 26, 2012 4:06:07 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: +++ Connecting: SUCCESS.
> Mar 26, 2012 4:06:07 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: --- transaction started.
> Mar 26, 2012 4:06:07 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: Detected and installed adapter:
> org.apache.cayenne.dba.oracle.OracleAdapter
>
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: No schema detected, will create mapped tables
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: CREATE TABLE Artist (DateOfBirth DATE NOT NULL, ID INTEGER NOT NULL,
> Name VARCHAR NOT NULL, PRIMARY KEY (ID))
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: *** error.
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: CREATE SEQUENCE pk_artist START WITH 200 INCREMENT BY 20
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: *** error.
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: Detected and installed adapter:
> org.apache.cayenne.dba.oracle.OracleAdapter
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: SELECT pk_artist.nextval FROM DUAL
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: --- will run 1 query.
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: INSERT INTO Artist (DateOfBirth, ID, Name) VALUES (?, ?, ?)
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: [batch bind: 1->DateOfBirth:'1881-10-25 00:00:00.0', 2->ID:1000,
> 3->Name:'Pablo Picasso']
> Mar 26, 2012 4:09:42 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: *** error.
> Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
> [v.3.0.2 Jun 11 2011 09:52:20] Commit Exception
>        at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1149)
>        at
> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1060)
>        at org.example.cayenne.persistent.Main.main(Main.java:17)
> Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
>
>        at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
>        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:753)
>        at
>
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:218)
>        at
>
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:971)
>        at
>
> oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10664)
>        at
>
> oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10762)
>        at
> org.apache.cayenne.access.jdbc.BatchAction.runAsBatch(BatchAction.java:158)
>        at
>
> org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:88)
>        at
>
> org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
>        at
> org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
>        at
>
> org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:226)
>        at
>
> org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:144)
>         at
> org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
>        at
> org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
>        at
> org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
>        at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
>        at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1121)
>        ... 2 more
>
>
> --
> View this message in context:
> http://cayenne.195.n3.nabble.com/Error-in-using-cayenne-modeler-tp3848066p3857847.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message