It looks like a simple case of not being able to connect to the Oracle database. It's happening the very first time Cayenne tries to connect.
Some other error message might've suggested an invalid URL, but your URL syntax looks correct. I'd make sure that the server can connect to the database without your application; try it from a SQL tool. On Mon, Mar 26, 2012 at 6:11 AM, yunus <[email protected]> wrote: > 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. >
