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 <[email protected]> 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. >
