Thanx guys. ur suggestions helped me alot..but now i am facing new error. it is saying that "INVALID ORACLE URL" despite that i am mentioning right. so have a look on the error and tell me the solution.
Mar 26, 2012 3:33:50 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: started configuration loading. Mar 26, 2012 3:33:50 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loaded domain: UntitledDomain Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loaded <map name='UntitledDomainMap' location='UntitledDomainMap.map.xml'>. Mar 26, 2012 3:33:51 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 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: using factory: org.apache.cayenne.conf.DriverDataSourceFactory Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loading driver information from 'UntitledDomainNode.driver.xml'. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loading driver oracle.jdbc.driver.OracleDriver Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loading user name and password. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: Created connection pool: jdbc:oracle:[email protected]:1521:Georli03 Driver class: oracle.jdbc.driver.OracleDriver Min. connections in the pool: 1 Max. connections in the pool: 1 Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loaded datasource. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: no adapter set, using automatic adapter. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: loaded map-ref: UntitledDomainMap. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: finished configuration loading in 172 ms. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: Opening connection: jdbc:oracle:[email protected]:1521:Georli03 Login: t404819 Password: ******* Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: *** Connecting: FAILURE. Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: Opening connection: jdbc:oracle:[email protected]:1521:Georli03 Login: t404819 Password: ******* Mar 26, 2012 3:33:51 PM org.apache.cayenne.modeler.util.ModelerLogger info INFO: *** Connecting: FAILURE. 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: Invalid Oracle URL specified at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:505) at org.apache.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:156) at org.apache.cayenne.conn.PooledConnectionImpl.reconnect(PooledConnectionImpl.java:83) at org.apache.cayenne.conn.PooledConnectionImpl.getConnection(PooledConnectionImpl.java:120) at org.apache.cayenne.conn.PoolManager.uncheckConnection(PoolManager.java:369) at org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:353) at org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:330) at org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:364) at org.apache.cayenne.conf.NodeDataSource.getConnection(NodeDataSource.java:46) at org.apache.cayenne.dba.AutoAdapter.loadAdapter(AutoAdapter.java:170) at org.apache.cayenne.dba.AutoAdapter.getAdapter(AutoAdapter.java:155) at org.apache.cayenne.dba.AutoAdapter.tableTypeForTable(AutoAdapter.java:308) at org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy.getNameTablesInDB(CreateIfNoSchemaStrategy.java:93) at org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy.processSchemaUpdate(CreateIfNoSchemaStrategy.java:47) at org.apache.cayenne.access.dbsync.BaseSchemaUpdateStrategy.updateSchema(BaseSchemaUpdateStrategy.java:48) at org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:355) at org.apache.cayenne.conf.NodeDataSource.getConnection(NodeDataSource.java:46) at org.apache.cayenne.dba.AutoAdapter.loadAdapter(AutoAdapter.java:170) at org.apache.cayenne.dba.AutoAdapter.getAdapter(AutoAdapter.java:155) at org.apache.cayenne.dba.AutoAdapter.supportsGeneratedKeys(AutoAdapter.java:228) at org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:108) at org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:77) at org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:79) at org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:182) at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:134) 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-tp3848066p3857801.html Sent from the Cayenne - User mailing list archive at Nabble.com.
