You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by yunus <co...@gmail.com> on 2012/03/22 11:33:57 UTC
Error in using cayenne modeler
Hi can anyone tell me why this error is coming????
Mar 22, 2012 3:43:17 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: started configuration loading.
Mar 22, 2012 3:43:17 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: loaded domain: UntitledDomain
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: loaded <map name='UntitledDomainMap'
location='UntitledDomainMap.map.xml'>.
Mar 22, 2012 3:43:18 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 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: using factory: org.apache.cayenne.conf.DriverDataSourceFactory
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: loading driver information from 'UntitledDomainNode.driver.xml'.
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: loading driver oracle.jdbc.driver.OracleDriver
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: loading user name and password.
Mar 22, 2012 3:43:18 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 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: *** Connecting: FAILURE.
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: Error: DataSource load failed
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: no adapter set, using automatic adapter.
Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
INFO: loaded map-ref: UntitledDomainMap.
Exception in thread "main" org.apache.cayenne.ConfigurationException:
[v.3.0.2 Jun 11 2011 09:52:20] Error during Configuration initialization.
[v.3.0.2 Jun 11 2011 09:52:20] Load failures. Main configuration class:
org.apache.cayenne.conf.DefaultConfiguration, details:
domain.node.name=UntitledDomainNode,
domain.node.datasource=UntitledDomainNode.driver.xml, reason: DataSource
load failed - Can not load JDBC driver named
'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
at
org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:168)
at
org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:141)
at
org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:121)
at
org.apache.cayenne.conf.Configuration.getSharedConfiguration(Configuration.java:91)
at
org.apache.cayenne.access.DataContext.createDataContext(DataContext.java:143)
at org.example.cayenne.Main.main(Main.java:15)
Caused by: org.apache.cayenne.ConfigurationException: [v.3.0.2 Jun 11 2011
09:52:20] Load failures. Main configuration class:
org.apache.cayenne.conf.DefaultConfiguration, details:
domain.node.name=UntitledDomainNode,
domain.node.datasource=UntitledDomainNode.driver.xml, reason: DataSource
load failed - Can not load JDBC driver named
'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
at
org.apache.cayenne.conf.RuntimeLoadDelegate.finishedLoading(RuntimeLoadDelegate.java:489)
at org.apache.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:79)
at
org.apache.cayenne.conf.DefaultConfiguration.initialize(DefaultConfiguration.java:152)
at
org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:159)
... 5 more
--
View this message in context: http://cayenne.195.n3.nabble.com/Error-in-using-cayenne-modeler-tp3848066p3848066.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: Error in using cayenne modeler
Posted by Bryan Lewis <jb...@gmail.com>.
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 <co...@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.
>
Re: Error in using cayenne modeler
Posted by yunus <co...@gmail.com>.
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.
Re: Error in using cayenne modeler
Posted by Michael Gentry <mg...@masslight.net>.
This also looks like you are running an application and not Cayenne
Modeler. As Joe suggested, it seems like your application does not
include the Oracle JDBC driver JAR, which needs to be in your
application's classpath.
mrg
On Thu, Mar 22, 2012 at 6:33 AM, yunus <co...@gmail.com> wrote:
> Hi can anyone tell me why this error is coming????
>
>
>
> Mar 22, 2012 3:43:17 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: started configuration loading.
> Mar 22, 2012 3:43:17 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded domain: UntitledDomain
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded <map name='UntitledDomainMap'
> location='UntitledDomainMap.map.xml'>.
> Mar 22, 2012 3:43:18 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 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: using factory: org.apache.cayenne.conf.DriverDataSourceFactory
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading driver information from 'UntitledDomainNode.driver.xml'.
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading driver oracle.jdbc.driver.OracleDriver
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading user name and password.
> Mar 22, 2012 3:43:18 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 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: *** Connecting: FAILURE.
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: Error: DataSource load failed
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: no adapter set, using automatic adapter.
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded map-ref: UntitledDomainMap.
> Exception in thread "main" org.apache.cayenne.ConfigurationException:
> [v.3.0.2 Jun 11 2011 09:52:20] Error during Configuration initialization.
> [v.3.0.2 Jun 11 2011 09:52:20] Load failures. Main configuration class:
> org.apache.cayenne.conf.DefaultConfiguration, details:
> domain.node.name=UntitledDomainNode,
> domain.node.datasource=UntitledDomainNode.driver.xml, reason: DataSource
> load failed - Can not load JDBC driver named
> 'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:168)
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:141)
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:121)
> at
> org.apache.cayenne.conf.Configuration.getSharedConfiguration(Configuration.java:91)
> at
> org.apache.cayenne.access.DataContext.createDataContext(DataContext.java:143)
> at org.example.cayenne.Main.main(Main.java:15)
> Caused by: org.apache.cayenne.ConfigurationException: [v.3.0.2 Jun 11 2011
> 09:52:20] Load failures. Main configuration class:
> org.apache.cayenne.conf.DefaultConfiguration, details:
> domain.node.name=UntitledDomainNode,
> domain.node.datasource=UntitledDomainNode.driver.xml, reason: DataSource
> load failed - Can not load JDBC driver named
> 'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
> at
> org.apache.cayenne.conf.RuntimeLoadDelegate.finishedLoading(RuntimeLoadDelegate.java:489)
> at org.apache.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:79)
> at
> org.apache.cayenne.conf.DefaultConfiguration.initialize(DefaultConfiguration.java:152)
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:159)
> ... 5 more
>
>
> --
> View this message in context: http://cayenne.195.n3.nabble.com/Error-in-using-cayenne-modeler-tp3848066p3848066.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: Error in using cayenne modeler
Posted by Bryan Lewis <jb...@gmail.com>.
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 <co...@gmail.com> 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.
>
Re: Error in using cayenne modeler
Posted by yunus <co...@gmail.com>.
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.
Re: Error in using cayenne modeler
Posted by Joe Baldwin <jf...@earthlink.net>.
load failed - Can not load JDBC driver named 'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
eliminate the simple solutions first:
Verify that the Oracle JDBC jar file is the proper version and included in your classpath
On Mar 22, 2012, at 6:33 AM, yunus wrote:
> Hi can anyone tell me why this error is coming????
>
>
>
> Mar 22, 2012 3:43:17 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: started configuration loading.
> Mar 22, 2012 3:43:17 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded domain: UntitledDomain
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded <map name='UntitledDomainMap'
> location='UntitledDomainMap.map.xml'>.
> Mar 22, 2012 3:43:18 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 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: using factory: org.apache.cayenne.conf.DriverDataSourceFactory
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading driver information from 'UntitledDomainNode.driver.xml'.
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading driver oracle.jdbc.driver.OracleDriver
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loading user name and password.
> Mar 22, 2012 3:43:18 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 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: *** Connecting: FAILURE.
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: Error: DataSource load failed
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: no adapter set, using automatic adapter.
> Mar 22, 2012 3:43:18 PM org.apache.cayenne.modeler.util.ModelerLogger info
> INFO: loaded map-ref: UntitledDomainMap.
> Exception in thread "main" org.apache.cayenne.ConfigurationException:
> [v.3.0.2 Jun 11 2011 09:52:20] Error during Configuration initialization.
> [v.3.0.2 Jun 11 2011 09:52:20] Load failures. Main configuration class:
> org.apache.cayenne.conf.DefaultConfiguration, details:
> domain.node.name=UntitledDomainNode,
> domain.node.datasource=UntitledDomainNode.driver.xml, reason: DataSource
> load failed - Can not load JDBC driver named
> 'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:168)
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:141)
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:121)
> at
> org.apache.cayenne.conf.Configuration.getSharedConfiguration(Configuration.java:91)
> at
> org.apache.cayenne.access.DataContext.createDataContext(DataContext.java:143)
> at org.example.cayenne.Main.main(Main.java:15)
> Caused by: org.apache.cayenne.ConfigurationException: [v.3.0.2 Jun 11 2011
> 09:52:20] Load failures. Main configuration class:
> org.apache.cayenne.conf.DefaultConfiguration, details:
> domain.node.name=UntitledDomainNode,
> domain.node.datasource=UntitledDomainNode.driver.xml, reason: DataSource
> load failed - Can not load JDBC driver named
> 'oracle.jdbc.driver.OracleDriver': oracle.jdbc.driver.OracleDriver
> at
> org.apache.cayenne.conf.RuntimeLoadDelegate.finishedLoading(RuntimeLoadDelegate.java:489)
> at org.apache.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:79)
> at
> org.apache.cayenne.conf.DefaultConfiguration.initialize(DefaultConfiguration.java:152)
> at
> org.apache.cayenne.conf.Configuration.initializeSharedConfiguration(Configuration.java:159)
> ... 5 more
>
>
> --
> View this message in context: http://cayenne.195.n3.nabble.com/Error-in-using-cayenne-modeler-tp3848066p3848066.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.