org.springframework.jdbc.CannotGetJdbcConnectionException
843859Oct 1 2006 — edited Oct 1 2006this is the error message
2006-10-01 22:45:46,813 [main] INFO org.springframework.core.CollectionFactory - JDK 1.4+ collections available
2006-10-01 22:45:46,813 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashMap]
2006-10-01 22:45:46,953 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [gix-beans.xml]
2006-10-01 22:45:46,964 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl@1c54796]
2006-10-01 22:45:46,984 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system ID [http://www.springframework.org/dtd/spring-beans.dtd]
2006-10-01 22:45:46,984 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Trying to locate [spring-beans.dtd] in Spring jar
2006-10-01 22:45:46,984 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath
2006-10-01 22:45:47,084 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Loading bean definitions
2006-10-01 22:45:47,094 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Default lazy init 'false'
2006-10-01 22:45:47,094 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Default autowire 'no'
2006-10-01 22:45:47,094 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Default dependency check 'none'
2006-10-01 22:45:47,174 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser - Found 5 <bean> elements in class path resource [gix-beans.xml]
2006-10-01 22:45:47,234 [main] INFO org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [jdbc.properties]
2006-10-01 22:45:47,244 [main] DEBUG org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Resolved placeholder 'jdbc.driverClassName' to value [org.apache.derby.jdbc.EmbeddedDriver]
2006-10-01 22:45:47,244 [main] DEBUG org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Resolved placeholder 'jdbc.url' to value [jdbc:derby:GIXDS]
2006-10-01 22:45:47,244 [main] DEBUG org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Resolved placeholder 'jdbc.username' to value [ixtive]
2006-10-01 22:45:47,254 [main] DEBUG org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Resolved placeholder 'jdbc.password' to value [1234]
2006-10-01 22:45:47,254 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'gixAuthenticator'
2006-10-01 22:45:47,254 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'gixAuthenticator' with merged definition [Root bean: class [com.ixtive.gix.core.GixAuthenticator]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [gix-beans.xml]]
2006-10-01 22:45:47,254 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before instantiation of bean 'gixAuthenticator'
2006-10-01 22:45:47,334 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting BeanInfo for class [com.ixtive.gix.core.GixAuthenticator]
2006-10-01 22:45:47,344 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching PropertyDescriptors for class [com.ixtive.gix.core.GixAuthenticator]
2006-10-01 22:45:47,344 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'class' of type [java.lang.Class]
2006-10-01 22:45:47,344 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'dataSource' of type [com.ixtive.gix.core.ds.IMemberDS]
2006-10-01 22:45:47,344 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [com.ixtive.gix.core.GixAuthenticator] is not cache-safe
2006-10-01 22:45:47,364 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean with name 'gixAuthenticator' to allow for resolving potential circular references
2006-10-01 22:45:47,374 [main] DEBUG org.springframework.beans.factory.support.BeanDefinitionValueResolver - Resolving reference from property 'bean property 'dataSource'' in bean 'gixAuthenticator' to bean 'dbMemberDS'
2006-10-01 22:45:47,374 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashSet]
2006-10-01 22:45:47,374 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'dbMemberDS'
2006-10-01 22:45:47,374 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'dbMemberDS' with merged definition [Root bean: class [com.ixtive.gix.core.ds.DbMemberDS]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [gix-beans.xml]]
2006-10-01 22:45:47,374 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before instantiation of bean 'dbMemberDS'
2006-10-01 22:45:47,404 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting BeanInfo for class [com.ixtive.gix.core.ds.DbMemberDS]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching PropertyDescriptors for class [com.ixtive.gix.core.ds.DbMemberDS]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'class' of type [java.lang.Class]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'dataSource' of type [javax.sql.DataSource]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'sqlMapClient' of type [com.ibatis.sqlmap.client.SqlMapClient]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'sqlMapClientTemplate' of type [org.springframework.orm.ibatis.SqlMapClientTemplate]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [com.ixtive.gix.core.ds.DbMemberDS] is not cache-safe
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean with name 'dbMemberDS' to allow for resolving potential circular references
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.factory.support.BeanDefinitionValueResolver - Resolving reference from property 'bean property 'sqlMapClient'' in bean 'dbMemberDS' to bean 'sqlMapClient'
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashSet]
2006-10-01 22:45:47,474 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'sqlMapClient'
2006-10-01 22:45:47,484 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'sqlMapClient' with merged definition [Root bean: class [org.springframework.orm.ibatis.SqlMapClientFactoryBean]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [gix-beans.xml]]
2006-10-01 22:45:47,484 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before instantiation of bean 'sqlMapClient'
2006-10-01 22:45:47,484 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting BeanInfo for class [org.springframework.orm.ibatis.SqlMapClientFactoryBean]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching PropertyDescriptors for class [org.springframework.orm.ibatis.SqlMapClientFactoryBean]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'class' of type [java.lang.Class]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'configLocation' of type [org.springframework.core.io.Resource]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'dataSource' of type [javax.sql.DataSource]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'lobHandler' of type [org.springframework.jdbc.support.lob.LobHandler]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'object' of type [java.lang.Object]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'objectType' of type [java.lang.Class]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'singleton' of type [boolean]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'sqlMapClientProperties' of type [java.util.Properties]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'transactionConfigClass' of type [java.lang.Class]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'transactionConfigProperties' of type [java.util.Properties]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'useTransactionAwareDataSource' of type [boolean]
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [org.springframework.orm.ibatis.SqlMapClientFactoryBean] is cache-safe
2006-10-01 22:45:47,514 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean with name 'sqlMapClient' to allow for resolving potential circular references
2006-10-01 22:45:47,524 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Converting String to [interface org.springframework.core.io.Resource] using property editor [org.springframework.core.io.ResourceEditor@1827d1]
2006-10-01 22:45:47,534 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public void org.springframework.orm.ibatis.SqlMapClientFactoryBean.setConfigLocation(org.springframework.core.io.Resource)] on object of class [org.springframework.orm.ibatis.SqlMapClientFactoryBean]
2006-10-01 22:45:47,534 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public void org.springframework.orm.ibatis.SqlMapClientFactoryBean.setConfigLocation(org.springframework.core.io.Resource)] with value of type [org.springframework.core.io.Resource]
2006-10-01 22:45:47,534 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before initialization of bean 'sqlMapClient'
2006-10-01 22:45:47,534 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking afterPropertiesSet() on bean with name 'sqlMapClient'
2006-10-01 22:45:48,235 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors after initialization of bean 'sqlMapClient'
2006-10-01 22:45:48,245 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Bean with name 'sqlMapClient' is a factory bean
2006-10-01 22:45:48,245 [main] DEBUG org.springframework.beans.factory.support.BeanDefinitionValueResolver - Resolving reference from property 'bean property 'dataSource'' in bean 'dbMemberDS' to bean 'dbDataSource'
2006-10-01 22:45:48,245 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.util.LinkedHashSet]
2006-10-01 22:45:48,245 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'dbDataSource'
2006-10-01 22:45:48,245 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'dbDataSource' with merged definition [Root bean: class [org.springframework.jdbc.datasource.DriverManagerDataSource]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [gix-beans.xml]]
2006-10-01 22:45:48,305 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before instantiation of bean 'dbDataSource'
2006-10-01 22:45:48,315 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting BeanInfo for class [org.springframework.jdbc.datasource.DriverManagerDataSource]
2006-10-01 22:45:48,325 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching PropertyDescriptors for class [org.springframework.jdbc.datasource.DriverManagerDataSource]
2006-10-01 22:45:48,325 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'class' of type [java.lang.Class]
2006-10-01 22:45:48,325 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'connection' of type [java.sql.Connection]
2006-10-01 22:45:48,335 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'connectionProperties' of type [java.util.Properties]
2006-10-01 22:45:48,335 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'driverClassName' of type [java.lang.String]
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'logWriter' of type [java.io.PrintWriter]
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'loginTimeout' of type [int]
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'password' of type [java.lang.String]
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'url' of type [java.lang.String]
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found property 'username' of type [java.lang.String]
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [org.springframework.jdbc.datasource.DriverManagerDataSource] is cache-safe
2006-10-01 22:45:48,376 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean with name 'dbDataSource' to allow for resolving potential circular references
2006-10-01 22:45:48,386 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setDriverClassName(java.lang.String) throws org.springframework.jdbc.CannotGetJdbcConnectionException] on object of class [org.springframework.jdbc.datasource.DriverManagerDataSource]
2006-10-01 22:45:49,267 [main] INFO org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: org.apache.derby.jdbc.EmbeddedDriver
2006-10-01 22:45:49,267 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setDriverClassName(java.lang.String) throws org.springframework.jdbc.CannotGetJdbcConnectionException] with value of type [java.lang.String]
2006-10-01 22:45:49,267 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setUrl(java.lang.String)] on object of class [org.springframework.jdbc.datasource.DriverManagerDataSource]
2006-10-01 22:45:49,267 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setUrl(java.lang.String)] with value of type [java.lang.String]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setUsername(java.lang.String)] on object of class [org.springframework.jdbc.datasource.DriverManagerDataSource]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setUsername(java.lang.String)] with value of type [java.lang.String]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setPassword(java.lang.String)] on object of class [org.springframework.jdbc.datasource.DriverManagerDataSource]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public void org.springframework.jdbc.datasource.DriverManagerDataSource.setPassword(java.lang.String)] with value of type [java.lang.String]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before initialization of bean 'dbDataSource'
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors after initialization of bean 'dbDataSource'
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public final void org.springframework.orm.ibatis.support.SqlMapClientDaoSupport.setSqlMapClient(com.ibatis.sqlmap.client.SqlMapClient)] on object of class [com.ixtive.gix.core.ds.DbMemberDS]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public final void org.springframework.orm.ibatis.support.SqlMapClientDaoSupport.setSqlMapClient(com.ibatis.sqlmap.client.SqlMapClient)] with value of type [com.ibatis.sqlmap.client.SqlMapClient]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public final void org.springframework.orm.ibatis.support.SqlMapClientDaoSupport.setDataSource(javax.sql.DataSource)] on object of class [com.ixtive.gix.core.ds.DbMemberDS]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public final void org.springframework.orm.ibatis.support.SqlMapClientDaoSupport.setDataSource(javax.sql.DataSource)] with value of type [javax.sql.DataSource]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before initialization of bean 'dbMemberDS'
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking afterPropertiesSet() on bean with name 'dbMemberDS'
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors after initialization of bean 'dbMemberDS'
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke write method [public void com.ixtive.gix.core.GixAuthenticator.setDataSource(com.ixtive.gix.core.ds.IMemberDS)] on object of class [com.ixtive.gix.core.GixAuthenticator]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write method [public void com.ixtive.gix.core.GixAuthenticator.setDataSource(com.ixtive.gix.core.ds.IMemberDS)] with value of type [com.ixtive.gix.core.ds.IMemberDS]
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors before initialization of bean 'gixAuthenticator'
2006-10-01 22:45:49,277 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invoking BeanPostProcessors after initialization of bean 'gixAuthenticator'
2006-10-01 22:45:49,287 [main] DEBUG com.ixtive.gix.core.ds.DbMemberDS - validate member result true
2006-10-01 22:45:49,287 [main] DEBUG com.ixtive.gix.core.ds.DbMemberDS - loginMember leong
2006-10-01 22:45:49,297 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
2006-10-01 22:45:49,297 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:derby:GIXDS]
2006-10-01 22:45:49,367 [main] ERROR com.ixtive.gix.core.ds.DbMemberDS - loginMember leong
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is SQL Exception: Database 'GIXDS' not found.
SQL Exception: Database 'GIXDS' not found.
and this is my bean file
<beans>
<bean id="dbDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" singleton="true">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
i set the properties on another file the driver, url, username, and password as below
org.apache.derby.jdbc.EmbeddedDriver
jdbc:derby:GIXDS
user
password
the possible is cannot get the connection pls show me
how configure that
thank for reply...