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.
