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:44:41 GMT
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 <coolyunus1986@gmail.com> 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: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 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:thin@10.122.130.39: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:thin@10.122.130.39: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.
>

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