db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: Database not found - JPetStoreApp on Tomcat 6.0
Date Wed, 09 Jan 2008 07:59:59 GMT
Lo, George C wrote:
> While trying to deploy the JPetStoreApp demo on Tomcat 6.0 on JDK 1.6, I 
> got the following error.   Did I miss something?

Hello,

Not having tried the JPetStoreApp demo, my pieces of advice are pretty 
general. Since the database can't be found;

  1) Verify that the database has indeed been created.
     (and that it is not being deleted)
  2) Make sure the JDBC connection URL is valid.

I notice you are using a relative path in the JDBC connection URL 
(Databases/JPetStoreDB). This might not work as expected based on 
whether derby.system.home is set, or from which directory the container 
(Tomcat) starts Derby.
You can see if this is indeed the problem by trying with an absolute 
path to the database.



hth,
-- 
Kristian

> 
>  
> 
>  
> 
> /Caused by: com.ibatis.dao.client.DaoException: Error starting SQL Map transaction. 
Cause: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory
(Database 'Databases/JPetStoreDB' not found.)/
> 
> /Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory
(Database 'Databases/JPetStoreDB' not found.)/
> 
> /        at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.(SqlMapDaoTransaction.java:25)/
> 
> /        at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.startTransaction(SqlMapDaoTransactionManager.java:48)/
> 
> /        at com.ibatis.dao.engine.impl.DaoContext.startTransaction(DaoContext.java:82)/
> 
> /        at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:60)/
> 
> /        at $Proxy12.getProductListByCategory(Unknown Source)/
> 
> /        at com.ibatis.jpetstore.service.CatalogService.getProductListByCategory(CatalogService.java:60)/
> 
> /        at com.ibatis.jpetstore.presentation.CatalogBean.viewCategory(CatalogBean.java:134)/
> 
> /        ... 24 more/
> 
>  
> 


Mime
View raw message