Not really (see trace below), or I miss something...
2009-09-15 17:11:55,602 [main] WARN
net.sf.ehcache.config.ConfigurationFactory - No configuration found.
Configuring ehcache from ehcache-failsafe.xml found in the classpath:
jar:file:/users/integ.continue/apache-tomcat-6.0.18/webapps/
continuum/WEB-IN
F/lib/ehcache-1.5.0.jar!/ehcache-failsafe.xml
2009-09-15 17:11:57,175 [main] ERROR JPOX.RDBMS.Schema - Failed
initialising database. Please check that your database JDBC driver is
accessible, and the database URL and userna
me/password are correct. Exception : Cannot create
PoolableConnectionFactory
(Failed to start database
'/users/integ.continue/continuum/data/databases/continuum', see the
next ex
ception for details.)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to start database
'/users/integ.continue/continuum/data/databases/continuum', see
the next exception for details.)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource
(BasicDataSource
.java:1225)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection
(BasicDataSource.ja
va:880)
at org.jpox.util.FailoverUtils.getConnection
(FailoverUtils.java:51)
at org.jpox.store.rdbms.RDBMSManager.<init>(RDBMSManager.java:
244)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0
(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAcces
sorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstruc
torAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:
513)
at org.jpox.util.ClassUtils.newInstance(ClassUtils.java:73)
at
org.jpox.store.StoreManagerFactory.getStoreManager
(StoreManagerFactory.java:
73)
at
org.jpox.AbstractPersistenceManager.getStoreManager
(AbstractPersistenceManag
er.java:295)
at
org.jpox.AbstractPersistenceManager.<init>
(AbstractPersistenceManager.java:2
17)
at
org.jpox.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:42)
at
org.jpox.PersistenceManagerFactoryImpl.getPersistenceManager
(PersistenceMana
gerFactoryImpl.java:178)
at
org.jpox.PersistenceManagerFactoryImpl.getPersistenceManager
(PersistenceMana
gerFactoryImpl.java:153)
at
org.apache.continuum.dao.AbstractDao.getPersistenceManager
(AbstractDao.java:
178)
at
org.apache.continuum.dao.AbstractDao.getPersistenceManager
(AbstractDao.java:
173)
at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached
(AbstractDao.java:
153)
at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached
(AbstractDao.java:
148)
at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached
(AbstractDao.java:
143)
at
org.apache.continuum.dao.SystemConfigurationDaoImpl.getSystemConfiguration
(S
ystemConfigurationDaoImpl.java:52)
at
org.apache.maven.continuum.configuration.DefaultConfigurationService.loadDat
a(DefaultConfigurationService.java:707)
at
org.apache.maven.continuum.configuration.DefaultConfigurationService.initial
ize(DefaultConfigurationService.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:380)
at
org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(Ab
stractBeanFactory.java:264)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:222)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean
(Abst
ractBeanFactory.java:261)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(Abstra
ctBeanFactory.java:185)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(Abstra
ctBeanFactory.java:168)
at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection
(DriverC
onnectionFactory.java:38)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject
(PoolableCon
nectionFactory.java:294)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory
(BasicD
ataSource.java:1247)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource
(BasicDataSource
.java:1221)
... 84 more
-----Message d'origine-----
De : Brett Porter [mailto:[email protected]] De la part de Brett
Porter
Envoyé : vendredi 18 septembre 2009 15:11
À : [email protected]
Objet : Re: configuration of jdbc URL in context.xml
Is there a "next exception" as it states? With Derby, common causes
might be that another instance is connected to it at the same time
(eg, the old standalone server).
- Brett
On 18/09/2009, at 10:53 PM, Martin Sudmann wrote:
I get the trace below, but actually I a afraid that the problem
isn't really
the DB access, as I got the same error later with relative paths as
well...
2009-09-15 17:11:57,175 [main] ERROR JPOX.RDBMS.Schema - Failed
initialising database. Please check that your database JDBC driver is
accessible, and the database URL and userna
me/password are correct. Exception : Cannot create
PoolableConnectionFactory
(Failed to start database
'/users/integ.continue/continuum/data/databases/continuum', see the
next ex
ception for details.)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to start database
'/users/integ.continue/continuum/data/databases/continuum', see
the next exception for details.)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource
(BasicDataSource
.java:1225)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection
(BasicDataSource.ja
va:880)
at org.jpox.util.FailoverUtils.getConnection
(FailoverUtils.java:51)
at org.jpox.store.rdbms.RDBMSManager.<init>(RDBMSManager.java:
244)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0
(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAcces
sorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstruc
torAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:
513)
at org.jpox.util.ClassUtils.newInstance(ClassUtils.java:73)
at
org.jpox.store.StoreManagerFactory.getStoreManager
(StoreManagerFactory.java:
73)
at
org.jpox.AbstractPersistenceManager.getStoreManager
(AbstractPersistenceManag
er.java:295)
at
org.jpox.AbstractPersistenceManager.<init>
(AbstractPersistenceManager.java:2
17)
at
org.jpox.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:
42)
at
org.jpox.PersistenceManagerFactoryImpl.getPersistenceManager
(PersistenceMana
gerFactoryImpl.java:178)
at
org.jpox.PersistenceManagerFactoryImpl.getPersistenceManager
(PersistenceMana
gerFactoryImpl.java:153)
at
org.apache.continuum.dao.AbstractDao.getPersistenceManager
(AbstractDao.java:
178)
at
org.apache.continuum.dao.AbstractDao.getPersistenceManager
(AbstractDao.java:
173)
at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached
(AbstractDao.java:
153)
at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached
(AbstractDao.java:
148)
at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached
(AbstractDao.java:
143)
at
org.apache.continuum.dao.SystemConfigurationDaoImpl.getSystemConfiguration
(S
ystemConfigurationDaoImpl.java:52)
at
org.apache.maven.continuum.configuration.DefaultConfigurationService.loadDat
a(DefaultConfigurationService.java:707)
at
org.apache.maven.continuum.configuration.DefaultConfigurationService.initial
ize(DefaultConfigurationService.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
Thx,
Martin
-----Message d'origine-----
De : Brett Porter [mailto:[email protected]] De la part de Brett
Porter
Envoyé : vendredi 18 septembre 2009 04:31
À : [email protected]
Objet : Re: configuration of jdbc URL in context.xml
What exception do you obtain? The Derby documentation indicates that
an absolute path should work.
- Brett
On 16/09/2009, at 4:55 PM, Martin Sudmann wrote:
Hi all,
I am running Continuum as a webapp on Tomcat.
I first installed it as the standalone version (thus creating the
databases
in the continuum install directory), but now I want to run it as
a .war on
Tomcat.
I don't know how to configure the JDBC URL correctly:
I want to use the databases from the initial install (not inside the
Tomcat
directory), but when I use an absolute unix file path the logs say
that they
cannot find the database.
<Context path="/continuum"
docBase="/users/integ.continue/tomcat/webapps/continuum/
continuum.war">
<Resource name="jdbc/users"
auth="Container"
type="javax.sql.DataSource"
username="sa"
password=""
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:/users/integ.continue/continuum/data/databases/
users;create=
false" />
<Resource name="jdbc/continuum"
auth="Container"
type="javax.sql.DataSource"
username="sa"
password=""
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:/users/integ.continue/continuum/data/databases/
continuum;cre
ate=false" />
..
Can anyone help me?
Thanks,
Martin
