hbm2dddl=update causes exception in proxool,but fine without

**adcspring** · May 12th, 2005, 10:58 AM

Hello,

I've bought into Spring for our DAO config and have been wiring up Hibernate 3 accordingly.

Everything was going very smoothly indeed. I have comprehensive log4j logging and no errors were being thrown and all the Hibernate3 related session factory stuff was happening without a fault.

However, I have caused an exception to occur in Proxool simply by adding the property asking Hibernate to create my tables. Interestingly if I change "update" to "create" the error again goes away but my tables do not get created which is the same without adding the hbm2ddl property - no tables, although clearly from the logging Hibernate is happy to load all my mappings.

The exception when adding hbm2ddl with an update value seems to be caused by a re-init of the Proxool pool even though it already got created without a hitch.

Anyone seen this before by any change? This is Spring 1.2.

Code:

		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
				<prop key="hibernate.proxool.xml">proxool.xml</prop>
				<prop key="hibernate.proxool.pool_alias">spring</prop>
			</props>
		</property>

[code:1:9bf8ee1e0f]2005-05-12 16:35:28,539 - DEBUG (org.apache.catalina.session.ManagerBase:6 97) - Registering Catalina:type=Manager,path=/,host=localhost
2005-05-12 16:35:28,539 - DEBUG (org.apache.catalina.session.StandardManager&# 58;627) - Force random number initialization starting
2005-05-12 16:35:28,539 - DEBUG (org.apache.catalina.session.ManagerBase:3 00) - Getting message digest component for algorithm MD5
2005-05-12 16:35:28,539 - DEBUG (org.apache.catalina.session.ManagerBase:3 14) - Completed getting message digest component
2005-05-12 16:35:28,539 - DEBUG (org.apache.catalina.session.ManagerBase:3 17) - getDigest() 0
2005-05-12 16:35:28,555 - DEBUG (org.apache.catalina.session.StandardManager&# 58;630) - Force random number initialization completed
2005-05-12 16:35:28,555 - DEBUG (org.apache.catalina.session.StandardManager&# 58;336) - Start: Loading persisted sessions
2005-05-12 16:35:28,555 - DEBUG (org.apache.catalina.session.StandardManager&# 58;346) - Loading persisted sessions from SESSIONS.ser
2005-05-12 16:35:28,726 - DEBUG (org.apache.catalina.session.StandardManager&# 58;360) - Creating custom object input stream for class loader
2005-05-12 16:35:28,726 - DEBUG (org.apache.catalina.session.StandardManager&# 58;390) - Loading 1 persisted sessions
2005-05-12 16:35:28,742 - DEBUG (org.apache.catalina.session.StandardManager&# 58;437) - Finish: Loading persisted sessions
2005-05-12 16:35:28,898 - INFO (org.springframework.web.context.ContextLoader :146) - Root WebApplicationContext: initialization started
2005-05-12 16:35:29,148 - INFO (org.springframework.beans.factory.xml.XmlBean DefinitionReader:132) - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2005-05-12 16:35:29,164 - DEBUG (org.springframework.beans.factory.xml.XmlBean DefinitionReader:136) - Using JAXP implementation [org.apache.xerces.jaxp.DocumentBuilderFactory Impl@b32ed4]
2005-05-12 16:35:29,336 - DEBUG (org.springframework.beans.factory.xml.BeansDt dResolver:50) - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system ID [http://www.springframework.org/dtd/spring-beans.dtd]
2005-05-12 16:35:29,336 - DEBUG (org.springframework.beans.factory.xml.BeansDt dResolver:54) - Trying to locate [spring-beans.dtd] under [/org/springframework/beans/factory/xml/]
2005-05-12 16:35:29,414 - DEBUG (org.springframework.beans.factory.xml.BeansDt dResolver:60) - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath
2005-05-12 16:35:29,429 - DEBUG (org.springframework.beans.factory.xml.Default XmlBeanDefinitionParser:173) - Loading bean definitions
2005-05-12 16:35:29,445 - DEBUG (org.springframework.beans.factory.xml.Default XmlBeanDefinitionParser:180) - Default lazy init 'false'
2005-05-12 16:35:29,445 - DEBUG (org.springframework.beans.factory.xml.Default XmlBeanDefinitionParser:181) - Default dependency check 'none'
2005-05-12 16:35:29,461 - DEBUG (org.springframework.beans.factory.xml.Default XmlBeanDefinitionParser:182) - Default autowire 'no'
2005-05-12 16:35:29,695 - DEBUG (org.springframework.beans.factory.xml.Default XmlBeanDefinitionParser:187) - Found 6 <bean> elements defining beans
2005-05-12 16:35:29,695 - INFO (org.springframework.context.support.AbstractR efreshableApplicationContext:90) - Bean factory for application context [org.springframework.web.context.support.XmlWe bApplicationContext;hashCode=25374911]: org.springframework.beans.factory.support.DefaultL istableBeanFactory defining beans [dsInternet,hibernateSessionFactory,hibernateT ransactionManager,pageServices,pageServicesImpl,pa geDAOImpl]; root of BeanFactory hierarchy
2005-05-12 16:35:29,726 - INFO (org.springframework.context.support.AbstractA pplicationContext:296) - 6 beans defined in application context [org.springframework.web.context.support.XmlWe bApplicationContext;hashCode=25374911]
2005-05-12 16:35:29,726 - INFO (org.springframework.core.CollectionFactory&#5 8;61) - JDK 1.4+ collections available
2005-05-12 16:35:29,726 - DEBUG (org.springframework.core.CollectionFactory&#5 8;108) - Creating java.util.LinkedHashMap
2005-05-12 16:35:29,742 - INFO (org.springframework.context.support.AbstractA pplicationContext:420) - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.Delegatin gMessageSource@35bb0f]
2005-05-12 16:35:29,742 - INFO (org.springframework.context.support.AbstractA pplicationContext:442) - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleAppli cationEventMulticaster@e4245]
2005-05-12 16:35:29,742 - INFO (org.springframework.ui.context.support.UiAppl icationContextUtils:67) - No ThemeSource found for [org.springframework.web.context.support.XmlWe bApplicationContext;hashCode=25374911]: using ResourceBundleThemeSource
2005-05-12 16:35:29,758 - DEBUG (org.springframework.core.CollectionFactory&#5 8;108) - Creating java.util.LinkedHashMap
2005-05-12 16:35:29,758 - INFO (org.springframework.beans.factory.support.Def aultListableBeanFactory:262) - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.Def aultListableBeanFactory defining beans [dsInternet,hibernateSessionFactory,hibernateT ransactionManager,pageServices,pageServicesImpl,pa geDAOImpl]; root of BeanFactory hierarchy]
2005-05-12 16:35:29,758 - INFO (org.springframework.beans.factory.support.Abs tractBeanFactory:219) - Creating shared instance of singleton bean 'dsInternet'
2005-05-12 16:35:29,758 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:277) - Creating instance of bean 'dsInternet' with merged definition [Root bean with class [org.springframework.jndi.JndiObjectFactoryBea n] defined in ServletContext resource [/WEB-INF/applicationContext.xml]]
2005-05-12 16:35:29,789 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:195) - Invoking BeanPostProcessors before instantiaion of bean 'dsInternet'
2005-05-12 16:35:29,836 - DEBUG (org.springframework.beans.CachedIntrospection Results:138) - Getting BeanInfo for class [org.springframework.jndi.JndiObjectFactoryBea n]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:154) - Caching PropertyDescriptors for class [org.springframework.jndi.JndiObjectFactoryBea n]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'cache' of type [boolean]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'class' of type [java.lang.Class]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'jndiEnvironment' of type [java.util.Properties]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'jndiName' of type [java.lang.String]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'jndiTemplate' of type [org.springframework.jndi.JndiTemplate]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'lookupOnStartup' of type [boolean]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'object' of type [java.lang.Object]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'objectType' of type [java.lang.Class]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'proxyInterface' of type [java.lang.Class]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'resourceRef' of type [boolean]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'singleton' of type [boolean]
2005-05-12 16:35:29,851 - DEBUG (org.springframework.beans.CachedIntrospection Results:85) - Class [org.springframework.jndi.JndiObjectFactoryBea n] is cache-safe
2005-05-12 16:35:29,867 - DEBUG (org.springframework.beans.BeanWrapperImpl&#58 ;780) - About to invoke write method [public void org.springframework.jndi.JndiObjectLocator.setJndi Name(java.lang.String)] on object of class [org.springframework.jndi.JndiObjectFactoryBea n]
2005-05-12 16:35:29,867 - DEBUG (org.springframework.beans.BeanWrapperImpl&#58 ;788) - Invoked write method [public void org.springframework.jndi.JndiObjectLocator.setJndi Name(java.lang.String)] with value [java:comp/env/jdbc/internet]
2005-05-12 16:35:29,867 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:213) - Invoking BeanPostProcessors before initialization of bean 'dsInternet'
2005-05-12 16:35:29,867 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:1112) - Invoking afterPropertiesSet() on bean with name 'dsInternet'
2005-05-12 16:35:29,867 - DEBUG (org.springframework.jndi.JndiTemplate:119 ) - Looking up JNDI object with name [java:comp/env/jdbc/internet]
2005-05-12 16:35:29,883 - DEBUG (org.springframework.jndi.JndiLocatorSupport&# 58;73) - Located object with JNDI name [java:comp/env/jdbc/internet]
2005-05-12 16:35:29,883 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:231) - Invoking BeanPostProcessors after initialization of bean 'dsInternet'
2005-05-12 16:35:29,883 - DEBUG (org.springframework.beans.factory.support.Abs tractBeanFactory:774) - Calling code asked for FactoryBean instance for name 'dsInternet'
2005-05-12 16:35:29,883 - DEBUG (org.springframework.beans.factory.support.Abs tractBeanFactory:186) - Returning cached instance of singleton bean 'dsInternet'
2005-05-12 16:35:29,883 - DEBUG (org.springframework.beans.factory.support.Abs tractBeanFactory:757) - Bean with name 'dsInternet' is a factory bean
2005-05-12 16:35:29,883 - INFO (org.springframework.beans.factory.support.Abs tractBeanFactory:219) - Creating shared instance of singleton bean 'hibernateSessionFactory'
2005-05-12 16:35:29,883 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:277) - Creating instance of bean 'hibernateSessionFactory' with merged definition [Root bean with class [org.springframework.orm.hibernate3.LocalSessi onFactoryBean] defined in ServletContext resource [/WEB-INF/applicationContext.xml]]
2005-05-12 16:35:29,883 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:195) - Invoking BeanPostProcessors before instantiaion of bean 'hibernateSessionFactory'
2005-05-12 16:35:29,898 - DEBUG (org.springframework.beans.CachedIntrospection Results:138) - Getting BeanInfo for class [org.springframework.orm.hibernate3.LocalSessi onFactoryBean]
2005-05-12 16:35:29,914 - DEBUG (org.springframework.beans.CachedIntrospection Results:154) - Caching PropertyDescriptors for class [org.springframework.orm.hibernate3.LocalSessi onFactoryBean]
2005-05-12 16:35:29,914 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'class' of type [java.lang.Class]
2005-05-12 16:35:29,929 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'collectionCacheStrategies' of type [java.util.Properties]
2005-05-12 16:35:29,929 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'configLocation' of type [org.springframework.core.io.Resource]
2005-05-12 16:35:29,929 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'configuration' of type [org.hibernate.cfg.Configuration]
2005-05-12 16:35:29,929 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'configurationClass' of type [java.lang.Class]
2005-05-12 16:35:29,929 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'dataSource' of type [javax.sql.DataSource]
2005-05-12 16:35:29,929 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'entityCacheStrategies' of type [java.util.Properties]
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'entityInterceptor' of type [org.hibernate.Interceptor]
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'eventListeners' of type [java.util.Map]
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'filterDefinitions' of type [[Lorg.hibernate.engine.FilterDefinition;& #93;
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'hibernateProperties' of type [java.util.Properties]
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'jtaTransactionManager' of type [javax.transaction.TransactionManager]
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'lobHandler' of type [org.springframework.jdbc.support.lob.LobHandl er]
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'mappingDirectoryLocations' of type [[Lorg.springframework.core.io.Resource;&# 93;
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'mappingJarLocations' of type [[Lorg.springframework.core.io.Resource;&# 93;
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'mappingLocations' of type [[Lorg.springframework.core.io.Resource;&# 93;
2005-05-12 16:35:29,945 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'mappingResources' of type [[Ljava.lang.String;]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'namingStrategy' of type [org.hibernate.cfg.NamingStrategy]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'object' of type [java.lang.Object]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'objectType' of type [java.lang.Class]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'schemaUpdate' of type [boolean]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'singleton' of type [boolean]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:162) - Found property 'useTransactionAwareDataSource' of type [boolean]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.CachedIntrospection Results:85) - Class [org.springframework.orm.hibernate3.LocalSessi onFactoryBean] is cache-safe
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.BeanWrapperImpl&#58 ;780) - About to invoke write method [public void org.springframework.orm.hibernate3.LocalSessionFac toryBean.setMappingResources(java.lang.String& #91;])] on object of class [org.springframework.orm.hibernate3.LocalSessi onFactoryBean]
2005-05-12 16:35:29,961 - DEBUG (org.springframework.beans.BeanWrapperImpl&#58 ;788) - Invoked write method [public void org.springframework.orm.hibernate3.LocalSessionFac toryBean.setMappingResources(java.lang.String& #91;])] with value [[Ljava.lang.String;@c5aa00]
2005-05-12 16:35:29,976 - DEBUG (org.springframework.beans.BeanWrapperImpl&#58 ;780) - About to invoke write method [public void org.springframework.orm.hibernate3.LocalSessionFac toryBean.setHibernateProperties(java.util.Prop erties)] on object of class [org.springframework.orm.hibernate3.LocalSessi onFactoryBean]
2005-05-12 16:35:29,976 - DEBUG (org.springframework.beans.BeanWrapperImpl&#58 ;791) - Invoked write method [public void org.springframework.orm.hibernate3.LocalSessionFac toryBean.setHibernateProperties(java.util.Prop erties)] with value of type [java.util.Properties]
2005-05-12 16:35:29,976 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:213) - Invoking BeanPostProcessors before initialization of bean 'hibernateSessionFactory'
2005-05-12 16:35:29,976 - DEBUG (org.springframework.beans.factory.support.Abs tractAutowireCapableBeanFactory:1112) - Invoking afterPropertiesSet() on bean with name 'hibernateSessionFactory'
2005-05-12 16:35:29,992 - INFO (org.hibernate.cfg.Environment:456) - Hibernate 3.0rc1
2005-05-12 16:35:29,992 - INFO (org.hibernate.cfg.Environment:469) - hibernate.properties not found
2005-05-12 16:35:29,992 - INFO (org.hibernate.cfg.Environment:502) - using CGLIB reflection optimizer
2005-05-12 16:35:29,992 - INFO (org.hibernate.cfg.Environment:532) - using JDK 1.4 java.sql.Timestamp handling
2005-05-12 16:35:30,133 - DEBUG (org.hibernate.util.DTDEntityResolver:42&# 41; - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
2005-05-12 16:35:30,945 - DEBUG (org.hibernate.util.DTDEntityResolver:53&# 41; - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
2005-05-12 16:35:31,195 - INFO (org.hibernate.cfg.HbmBinder:256) - Mapping class: com.qas.newmedia.internet.core.page.bo.Page -> tblPage
2005-05-12 16:35:31,211 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: id -> page_id
2005-05-12 16:35:31,226 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: parentId -> parent_id
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: peerPosition -> peer_pos
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: nameId -> name_id
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: created -> created
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: site -> site
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: path -> path
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: country -> country
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: language -> language
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: templateId -> template_id
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: title -> title
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: description -> description
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: keywords -> keywords
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: noIndex -> no_index
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: enabled -> enabled
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: permanentRedirectUrl -> perm_red_url
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: permanentRedirectDate -> perm_red_date
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: pnsLabel -> pns_label
2005-05-12 16:35:31,242 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: bnsLabel -> bns_label
2005-05-12 16:35:31,258 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: snsLabel -> sns_label
2005-05-12 16:35:31,258 - DEBUG (org.hibernate.cfg.HbmBinder:1086) - Mapped property: fnsLabel -> fns_label
2005-05-12 16:35:31,258 - INFO (org.springframework.orm.hibernate3.LocalSessi onFactoryBean:611) - Building new Hibernate SessionFactory
2005-05-12 16:35:31,258 - DEBUG (org.hibernate.cfg.Configuration:1035&# 41; - Preparing to build session factory with filters : {}
2005-05-12 16:35:31,258 - INFO (org.hibernate.cfg.Configuration:844&#4 1; - processing extends queue
2005-05-12 16:35:31,258 - INFO (org.hibernate.cfg.Configuration:848&#4 1; - processing collection mappings
2005-05-12 16:35:31,258 - INFO (org.hibernate.cfg.Configuration:857&#4 1; - processing association property references
2005-05-12 16:35:31,258 - INFO (org.hibernate.cfg.Configuration:884&#4 1; - processing foreign key constraints
2005-05-12 16:35:31,398 - INFO (org.hibernate.dialect.Dialect:89) - Using dialect: org.hibernate.dialect.SQLServerDialect
2005-05-12 16:35:31,398 - DEBUG (org.hibernate.exception.SQLExceptionConverter Factory:52) - Using dialect defined converter
2005-05-12 16:35:31,414 - INFO (org.hibernate.cfg.SettingsFactory:90&# 41; - Default batch fetch size: 1
2005-05-12 16:35:31,414 - INFO (org.hibernate.cfg.SettingsFactory:94&# 41; - Generate SQL with comments: disabled
2005-05-12 16:35:31,414 - INFO (org.hibernate.cfg.SettingsFactory:98&# 41; - Order SQL updates by primary key: disabled
2005-05-12 16:35:31,414 - INFO (org.hibernate.cfg.SettingsFactory:273&#41 ; - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2005-05-12 16:35:31,414 - INFO (org.hibernate.hql.ast.ASTQueryTranslatorFacto ry:21) - Using ASTQueryTranslatorFactory
2005-05-12 16:35:31,414 - INFO (org.hibernate.cfg.SettingsFactory:106&#41 ; - Query language substitutions: {}
2005-05-12 16:35:31,429 - INFO (org.hibernate.connection.ProxoolConnectionPro vider:110) - Configuring Proxool Provider using JAXPConfigurator: proxool.xml
2005-05-12 16:35:31,461 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:105) - Configuring from reader: java.io.InputStreamReader@63a721
2005-05-12 16:35:31,461 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:72) - SAXParserFactory class: org.apache.xerces.jaxp.SAXParserFactoryImpl
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:77) - sax parser classorg.apache.xerces.jaxp.SAXParserImpl
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:81) - XML reader class: org.apache.xerces.parsers.SAXParser
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:114) - Setting sax feature: 'http://xml.org/sax/features/namespaces'. State: true.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:114) - Setting sax feature: 'http://xml.org/sax/features/namespace-prefixes'. State: false.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:241) - Adding driver property: user=sa
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:239) - Adding driver property: password=*******
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.minimum-connection-count' to value '2'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.maximum-connection-count' to value '20'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.maximum-connection-lifetime' to value '9000000'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.house-keeping-test-sql' to value 'SELECT 1 + 1'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.statistics' to value '1m,15m,1d'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.statistics-log-level' to value 'INFO'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.fatal-sql-exception' to value 'Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01'.
2005-05-12 16:35:31,476 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.fatal-sql-exception-wrapper-class' to value 'org.logicalcobwebs.proxool.FatalRuntimeException' .
2005-05-12 16:35:31,492 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.verbose' to value 'true'.
2005-05-12 16:35:31,492 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:191) - Created url: proxool.spring:net.sourceforge.jtds.jdbc.Drive r:jdbc:jtds:sqlserver://intratestgbr:1433/dbInternet;charset=Cp1252;TDS=8.0
2005-05-12 16:35:31,508 - INFO (org.logicalcobwebs.proxool.ProxoolFacade: 77) - Proxool 0.8.3 (14-Dec-2003 16:06)
2005-05-12 16:35:31,554 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.driver=net.sourceforge.jtds.jdbc.Driver
2005-05-12 16:35:31,554 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.url=jdbc:jtds:sqlserver://intratestgbr:1433/dbInternet;charset=Cp1252;TDS=8.0
2005-05-12 16:35:31,554 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.minimum-connection-count=2
2005-05-12 16:35:31,554 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.statistics=1m,15m,1d
2005-05-12 16:35:31,554 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.statistics-log-level=INFO
2005-05-12 16:35:31,601 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Delegating property to driver: user=sa
2005-05-12 16:35:31,601 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.maximum-connection-lifetime=9000000
2005-05-12 16:35:31,601 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.verbose=true
2005-05-12 16:35:31,601 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.fatal-sql-exception=Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01
2005-05-12 16:35:31,601 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Delegating property to driver: password=********
2005-05-12 16:35:31,617 - DEBUG (org.logicalcobwebs.proxool.FatalSqlExceptionH elper:71) - Wrapping up a fatal exception: Test
java.sql.SQLException: Test
at org.logicalcobwebs.proxool.ConnectionPoolDefinitio n.setFatalSqlExceptionWrapper(ConnectionPoolDe finition.java:964)
at org.logicalcobwebs.proxool.ConnectionPoolDefinitio n.setAnyProperty(ConnectionPoolDefinition.java :365)
at org.logicalcobwebs.proxool.ConnectionPoolDefinitio n.doChange(ConnectionPoolDefinition.java:2 25)
at org.logicalcobwebs.proxool.ConnectionPoolDefinitio n.<init>(ConnectionPoolDefinition.java:134 )
at org.logicalcobwebs.proxool.ProxoolFacade.registerC onnectionPool(ProxoolFacade.java:87)
at org.logicalcobwebs.proxool.ProxoolFacade.registerC onnectionPool(ProxoolFacade.java:60)
at org.logicalcobwebs.proxool.configuration.XMLConfig urator.endElement(XMLConfigurator.java:196 )
at org.apache.xerces.parsers.AbstractSAXParser.endEle ment(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.sc anEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unkn own Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse& #40;Unknown Source)
at javax.xml.parsers.SAXParser.parse(SAXParser.ja va:375)
at org.logicalcobwebs.proxool.configuration.JAXPConfi gurator.configure(JAXPConfigurator.java:87 )
at org.logicalcobwebs.proxool.configuration.JAXPConfi gurator.configure(JAXPConfigurator.java:10 7)
at org.hibernate.connection.ProxoolConnectionProvider .configure(ProxoolConnectionProvider.java: 120)
at org.hibernate.connection.ConnectionProviderFactory .newConnectionProvider(ConnectionProviderFacto ry.java:80)
at org.hibernate.cfg.SettingsFactory.createConnection Provider(SettingsFactory.java:301)
at org.hibernate.cfg.SettingsFactory.buildSettings&#4 0;SettingsFactory.java:111)
at org.hibernate.cfg.Configuration.buildSettings( Configuration.java:1497)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1041)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.newSessionFactory(LocalSessionFactory Bean.java:678)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.afterPropertiesSet(LocalSessionFactor yBean.java:613)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.invokeInitMethods(A bstractAutowireCapableBeanFactory.java:1114&#4 1;
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(Abstract AutowireCapableBeanFactory.java:349)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(Abstract AutowireCapableBeanFactory.java:257)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java&# 58;223)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java&# 58;147)
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.preInstantiateSingletons(De faultListableBeanFactory.java:271)
at org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContex t.java:319)
at org.springframework.web.context.support.AbstractRe freshableWebApplicationContext.refresh(Abstrac tRefreshableWebApplicationContext.java:131&#41 ;
at org.springframework.web.context.ContextLoader.crea teWebApplicationContext(ContextLoader.java&#58 ;230)
at org.springframework.web.context.ContextLoader.init WebApplicationContext(ContextLoader.java:1 56)
at org.springframework.web.context.ContextLoaderListe ner.contextInitialized(ContextLoaderListener.j ava:48)
at org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:3669)
at org.apache.catalina.core.StandardContext.start&#40 ;StandardContext.java:4104)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild&#4 0;ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild&#40 ;StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDirec tory(HostConfig.java:894)
at org.apache.catalina.startup.HostConfig.deployDirec tories(HostConfig.java:857)
at org.apache.catalina.startup.HostConfig.deployApps& #40;HostConfig.java:475)
at org.apache.catalina.startup.HostConfig.start(H ostConfig.java:1102)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(C ontainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(St andardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(C ontainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start( StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start&#40 ;StandardService.java:450)
at org.apache.catalina.core.StandardServer.start( StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Cat alina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(N ative Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Na tiveMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke&#4 0;DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java&#5 8;585)
at org.apache.catalina.startup.Bootstrap.start(Bo otstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Boo tstrap.java:409)
2005-05-12 16:35:31,617 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.fatal-sql-exception-wrapper-class=org.logicalcobwebs.proxool.FatalRuntimeExcep tion
2005-05-12 16:35:31,617 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.house-keeping-test-sql=SELECT 1 + 1
2005-05-12 16:35:31,617 - DEBUG (org.logicalcobwebs.proxool.ConnectionPoolDefi nition:249) - Recognised proxool property: proxool.maximum-connection-count=20
2005-05-12 16:35:31,664 - DEBUG (org.logicalcobwebs.proxool.admin.StatsRoller& #58;86) - Collecting first statistics for '1m' at Thu May 12 16:36:00 BST 2005
2005-05-12 16:35:31,679 - DEBUG (org.logicalcobwebs.proxool.admin.StatsRoller& #58;86) - Collecting first statistics for '15m' at Thu May 12 16:45:00 BST 2005
2005-05-12 16:35:31,679 - DEBUG (org.logicalcobwebs.proxool.admin.StatsRoller& #58;86) - Collecting first statistics for '1d' at Fri May 13 16:00:00 BST 2005
2005-05-12 16:35:31,679 - DEBUG (org.logicalcobwebs.proxool.ShutdownHook:7 9) - Registered shutdownHook
2005-05-12 16:35:31,695 - DEBUG (org.logicalcobwebs.proxool.HouseKeeperControl ler:81) - Registering 'spring' house keeper
2005-05-12 16:35:31,711 - DEBUG (org.logicalcobwebs.proxool.HouseKeeperControl ler:89) - Starting a house keeper thread
2005-05-12 16:35:31,711 - INFO (org.hibernate.connection.ProxoolConnectionPro vider:130) - Configuring Proxool Provider to use pool alias: proxool.spring
2005-05-12 16:35:31,711 - INFO (org.hibernate.connection.ProxoolConnectionPro vider:166) - autocommit mode: false
2005-05-12 16:35:31,804 - INFO (org.logicalcobwebs.proxool.ConnectionPool&#58 ;613) - Proxool statistics legend: "s - r (a/t/o)" > s=served, r=refused (only shown if non-zero), a=active, t=total, o=offline (being tested)
2005-05-12 16:35:31,804 - DEBUG (org.logicalcobwebs.proxool.HouseKeeper:16 4) - 000000 (00/00/00) - House keeping triggerSweep done
2005-05-12 16:35:31,929 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :162) - Remembering default value: isReadOnly() = false
2005-05-12 16:35:31,929 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :162) - Remembering default value: getHoldability() = 1
2005-05-12 16:35:31,929 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :162) - Remembering default value: getTransactionIsolation() = 2
2005-05-12 16:35:31,945 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :162) - Remembering default value: getTypeMap() = {}
2005-05-12 16:35:31,945 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :177) - net.sourceforge.jtds.jdbc.Driver does not support setTypeMap. Proxool doesn't mind.
2005-05-12 16:35:31,945 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :162) - Remembering default value: getCatalog() = dbInternet
2005-05-12 16:35:32,304 - DEBUG (org.logicalcobwebs.proxool.Prototyper:181 ) - 000000 (01/01/00) - Connection #1 (670479) created on demand = ACTIVE -> jdbc:jtds:sqlserver://intratestgbr:1433/dbInternet;charset=Cp1252;TDS=8.0 (156b386) by thread Thread-1
2005-05-12 16:35:32,304 - DEBUG (org.logicalcobwebs.proxool.ConnectionPool&#58 ;266) - 000001 (01/01/00) - Connection #1 served
2005-05-12 16:35:32,476 - DEBUG (org.logicalcobwebs.proxool.Prototyper:181 ) - 000001 (01/02/00) - Connection #2 (fb6c5f) created to achieve minimum of 2 = AVAILABLE -> jdbc:jtds:sqlserver://intratestgbr:1433/dbInternet;charset=Cp1252;TDS=8.0 (87e704) by thread Prototyper
2005-05-12 16:35:32,492 - DEBUG (org.logicalcobwebs.proxool.ConnectionResetter :283) - #1 - autoCommit reset back to true
2005-05-12 16:35:32,492 - DEBUG (org.logicalcobwebs.proxool.ConnectionPool&#58 ;364) - 000001 (00/02/00) - Connection #1 returned (now AVAILABLE)
2005-05-12 16:35:32,492 - INFO (org.hibernate.cfg.SettingsFactory:156&#41 ; - Scrollable result sets: enabled
2005-05-12 16:35:32,492 - DEBUG (org.hibernate.cfg.SettingsFactory:160&#41 ; - Wrap result sets: disabled
2005-05-12 16:35:32,492 - INFO (org.hibernate.cfg.SettingsFactory:164&#41 ; - JDBC3 getGeneratedKeys(): enabled
2005-05-12 16:35:32,492 - INFO (org.hibernate.transaction.TransactionFactoryF actory:31) - Using default transaction strategy (direct JDBC transactions)
2005-05-12 16:35:32,507 - INFO (org.hibernate.transaction.TransactionManagerL ookupFactory:33) - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2005-05-12 16:35:32,507 - INFO (org.hibernate.cfg.SettingsFactory:176&#41 ; - Automatic flush during beforeCompletion(): disabled
2005-05-12 16:35:32,507 - INFO (org.hibernate.cfg.SettingsFactory:179&#41 ; - Automatic session close at end of transaction: disabled
2005-05-12 16:35:32,539 - INFO (org.hibernate.cfg.SettingsFactory:260&#41 ; - Cache provider: org.hibernate.cache.EhCacheProvider
2005-05-12 16:35:32,539 - INFO (org.hibernate.cfg.SettingsFactory:187&#41 ; - Second-level cache: enabled
2005-05-12 16:35:32,539 - INFO (org.hibernate.cfg.SettingsFactory:192&#41 ; - Optimize cache for minimal puts: disabled
2005-05-12 16:35:32,554 - INFO (org.hibernate.cfg.SettingsFactory:199&#41 ; - Structured second-level cache entries: enabled
2005-05-12 16:35:32,554 - INFO (org.hibernate.cfg.SettingsFactory:203&#41 ; - Query cache: disabled
2005-05-12 16:35:32,554 - INFO (org.hibernate.cfg.SettingsFactory:210&#41 ; - Echoing all SQL to stdout
2005-05-12 16:35:32,554 - INFO (org.hibernate.cfg.SettingsFactory:214&#41 ; - Statistics: disabled
2005-05-12 16:35:32,554 - INFO (org.hibernate.cfg.SettingsFactory:218&#41 ; - Deleted entity synthetic identifier rollback: disabled
2005-05-12 16:35:32,554 - INFO (org.hibernate.cfg.SettingsFactory:232&#41 ; - Default entity-mode: pojo
2005-05-12 16:35:32,867 - INFO (org.hibernate.impl.SessionFactoryImpl:140 ) - building session factory
2005-05-12 16:35:32,882 - DEBUG (org.hibernate.impl.SessionFactoryImpl:149 ) - Session factory constructed with filter configurations : {}
2005-05-12 16:35:32,882 - DEBUG (org.hibernate.impl.SessionFactoryImpl:152 ) - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_03\jre\bin, java.vm.version=1.5.0_03-b07, hibernate.proxool.pool_alias=spring, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Server VM, tomcat.util.buf.StringCache.byte.enabled=true, file.encoding.pkg=sun.io, user.country=GB, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\WINNT\system32, java.runtime.version=1.5.0_03-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironm ent, java.endorsed.dirs=c:\jakarta-tomcat\common\endorsed, os.arch=x86, java.io.tmpdir=c:\jakarta-tomcat\temp, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, java.naming.factory.url.pkgs=org.apache.naming, os.name=Windows 2000, sun.jnu.encoding=Cp1252, java.library.path=c:\jakarta-tomcat\bin;.;C:\WINNT\system32;C:\WINNT;C& #58;\WINNT\system32;C:\WINNT;C:\WINNT\Syst em32\Wbem;c:\apache-ant-1.6.1\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\GNU\WinCvs 1.3\CVSNT;C:\Program Files\Java\jdk1.5.0_02\bin;C:\Program Files\JProbe Suite 5.2.3\bin;C:\jvmstat-3_0\jvmstat\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Server Compiler, os.version=5.0, user.home=C:\Documents and Settings\allistairc, user.timezone=Europe/London, catalina.useNaming=true, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, catalina.home=c:\jakarta-tomcat, java.class.path=c:\jakarta-tomcat\bin\bootstrap.jar, user.name=SYSTEM, hibernate.show_sql=true, java.naming.factory.initial=org.apache.naming.java .javaURLContextFactory, package.definition=sun.,java.,org.apache.catalina. ,org.apache.coyote.,org.apache.tomcat.,org.apache. jasper., java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_03\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.SQLServerD ialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.5.0_03, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_03\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_03\jre\lib\rt.jar;C:\Progr am Files\Java\jdk1.5.0_03\jre\lib\i18n.jar;C:\Pro gram Files\Java\jdk1.5.0_03\jre\lib\sunrsasign.jar;C&#5 8;\Program Files\Java\jdk1.5.0_03\jre\lib\jsse.jar;C:\Pro gram Files\Java\jdk1.5.0_03\jre\lib\jce.jar;C:\Prog ram Files\Java\jdk1.5.0_03\jre\lib\charsets.jar;C: \Program Files\Java\jdk1.5.0_03\jre\classes, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, java.vendor=Sun Microsystems Inc., catalina.base=c:\jakarta-tomcat, file.separator=\, hibernate.hbm2ddl.auto=update, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, common.loader=${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, package.access=sun.,org.apache.catalina.,org.apach e.coyote.,org.apache.tomcat.,org.apache.jasper.,su n.beans., sun.desktop=windows, hibernate.proxool.xml=proxool.xml, sun.cpu.isalist=}
2005-05-12 16:35:32,882 - DEBUG (net.sf.ehcache.CacheManager:191) - Creating new CacheManager with default config
2005-05-12 16:35:32,882 - DEBUG (net.sf.ehcache.CacheManager:164) - Configuring ehcache from classpath.
2005-05-12 16:35:32,898 - WARN (net.sf.ehcache.config.Configurator:126&#4 1; - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: file:/C:/jakarta-tomcat/work/Catalina/localhost/_/loader/ehcache-failsafe.xml
2005-05-12 16:35:32,914 - DEBUG (net.sf.ehcache.config.Configuration$DiskStore :185) - Disk Store Path: c:\jakarta-tomcat\temp
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2191) - Static SQL for entity: com.qas.newmedia.internet.core.page.bo.Page
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2193) - Version select: select page_id from dbInternet.dbo.tblPage where page_id =?
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2194) - Snapshot select: select page_.page_id, page_.parent_id as parent2_0_, page_.peer_pos as peer3_0_, page_.name_id as name4_0_, page_.created as created0_, page_.site as site0_, page_.path as path0_, page_.country as country0_, page_.language as language0_, page_.template_id as template10_0_, page_.title as title0_, page_.description as descrip12_0_, page_.keywords as keywords0_, page_.no_index as no14_0_, page_.enabled as enabled0_, page_.perm_red_url as perm16_0_, page_.perm_red_date as perm17_0_, page_.pns_label as pns18_0_, page_.bns_label as bns19_0_, page_.sns_label as sns20_0_, page_.fns_label as fns21_0_ from dbInternet.dbo.tblPage page_ where page_.page_id=?
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2196) - Insert 0: insert into dbInternet.dbo.tblPage (parent_id, peer_pos, name_id, created, site, path, country, language, template_id, title, description, keywords, no_index, enabled, perm_red_url, perm_red_date, pns_label, bns_label, sns_label, fns_label, page_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2197) - Update 0: update dbInternet.dbo.tblPage set parent_id=?, peer_pos=?, name_id=?, created=?, site=?, path=?, country=?, language=?, template_id=?, title=?, description=?, keywords=?, no_index=?, enabled=?, perm_red_url=?, perm_red_date=?, pns_label=?, bns_label=?, sns_label=?, fns_label=? where page_id=?
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2198) - Delete 0: delete from dbInternet.dbo.tblPage where page_id=?
2005-05-12 16:35:33,976 - DEBUG (org.hibernate.persister.entity.BasicEntityPer sister:2201) - Identity insert: insert into dbInternet.dbo.tblPage (parent_id, peer_pos, name_id, created, site, path, country, language, template_id, title, description, keywords, no_index, enabled, perm_red_url, perm_red_date, pns_label, bns_label, sns_label, fns_label) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2005-05-12 16:35:34,007 - DEBUG (org.hibernate.loader.entity.EntityLoader: 118) - Static select for entity com.qas.newmedia.internet.core.page.bo.Page: select page0_.page_id as page1_0_, page0_.parent_id as parent2_0_0_, page0_.peer_pos as peer3_0_0_, page0_.name_id as name4_0_0_, page0_.created as created0_0_, page0_.site as site0_0_, page0_.path as path0_0_, page0_.country as country0_0_, page0_.language as language0_0_, page0_.template_id as template10_0_0_, page0_.title as title0_0_, page0_.description as descrip12_0_0_, page0_.keywords as keywords0_0_, page0_.no_index as no14_0_0_, page0_.enabled as enabled0_0_, page0_.perm_red_url as perm16_0_0_, page0_.perm_red_date as perm17_0_0_, page0_.pns_label as pns18_0_0_, page0_.bns_label as bns19_0_0_, page0_.sns_label as sns20_0_0_, page0_.fns_label as fns21_0_0_ from dbInternet.dbo.tblPage page0_ where page0_.page_id=?
2005-05-12 16:35:34,007 - DEBUG (org.hibernate.loader.entity.EntityLoader: 118) - Static select for entity com.qas.newmedia.internet.core.page.bo.Page: select page0_.page_id as page1_0_, page0_.parent_id as parent2_0_0_, page0_.peer_pos as peer3_0_0_, page0_.name_id as name4_0_0_, page0_.created as created0_0_, page0_.site as site0_0_, page0_.path as path0_0_, page0_.country as country0_0_, page0_.language as language0_0_, page0_.template_id as template10_0_0_, page0_.title as title0_0_, page0_.description as descrip12_0_0_, page0_.keywords as keywords0_0_, page0_.no_index as no14_0_0_, page0_.enabled as enabled0_0_, page0_.perm_red_url as perm16_0_0_, page0_.perm_red_date as perm17_0_0_, page0_.pns_label as pns18_0_0_, page0_.bns_label as bns19_0_0_, page0_.sns_label as sns20_0_0_, page0_.fns_label as fns21_0_0_ from dbInternet.dbo.tblPage page0_ where page0_.page_id=?
2005-05-12 16:35:34,007 - DEBUG (org.hibernate.loader.entity.EntityLoader: 118) - Static select for entity com.qas.newmedia.internet.core.page.bo.Page: select page0_.page_id as page1_0_, page0_.parent_id as parent2_0_0_, page0_.peer_pos as peer3_0_0_, page0_.name_id as name4_0_0_, page0_.created as created0_0_, page0_.site as site0_0_, page0_.path as path0_0_, page0_.country as country0_0_, page0_.language as language0_0_, page0_.template_id as template10_0_0_, page0_.title as title0_0_, page0_.description as descrip12_0_0_, page0_.keywords as keywords0_0_, page0_.no_index as no14_0_0_, page0_.enabled as enabled0_0_, page0_.perm_red_url as perm16_0_0_, page0_.perm_red_date as perm17_0_0_, page0_.pns_label as pns18_0_0_, page0_.bns_label as bns19_0_0_, page0_.sns_label as sns20_0_0_, page0_.fns_label as fns21_0_0_ from dbInternet.dbo.tblPage page0_ where page0_.page_id=?
2005-05-12 16:35:34,007 - DEBUG (org.hibernate.loader.entity.EntityLoader: 118) - Static select for entity com.qas.newmedia.internet.core.page.bo.Page: select page0_.page_id as page1_0_, page0_.parent_id as parent2_0_0_, page0_.peer_pos as peer3_0_0_, page0_.name_id as name4_0_0_, page0_.created as created0_0_, page0_.site as site0_0_, page0_.path as path0_0_, page0_.country as country0_0_, page0_.language as language0_0_, page0_.template_id as template10_0_0_, page0_.title as title0_0_, page0_.description as descrip12_0_0_, page0_.keywords as keywords0_0_, page0_.no_index as no14_0_0_, page0_.enabled as enabled0_0_, page0_.perm_red_url as perm16_0_0_, page0_.perm_red_date as perm17_0_0_, page0_.pns_label as pns18_0_0_, page0_.bns_label as bns19_0_0_, page0_.sns_label as sns20_0_0_, page0_.fns_label as fns21_0_0_ from dbInternet.dbo.tblPage page0_ where page0_.page_id=?
2005-05-12 16:35:34,023 - DEBUG (org.hibernate.impl.SessionFactoryObjectFactor y:39) - initializing class SessionFactoryObjectFactory
2005-05-12 16:35:34,023 - DEBUG (org.hibernate.impl.SessionFactoryObjectFactor y:76) - registered: 16161cfa03d18bd80103d18bdd770000 (unnamed)
2005-05-12 16:35:34,023 - INFO (org.hibernate.impl.SessionFactoryObjectFactor y:82) - Not binding factory to JNDI, no JNDI name configured
2005-05-12 16:35:34,023 - DEBUG (org.hibernate.impl.SessionFactoryImpl:249 ) - instantiated session factory
2005-05-12 16:35:34,023 - INFO (org.hibernate.dialect.Dialect:89) - Using dialect: org.hibernate.dialect.SQLServerDialect
2005-05-12 16:35:34,023 - INFO (org.hibernate.connection.ProxoolConnectionPro vider:110) - Configuring Proxool Provider using JAXPConfigurator: proxool.xml
2005-05-12 16:35:34,023 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:105) - Configuring from reader: java.io.InputStreamReader@56fc16
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:72) - SAXParserFactory class: org.apache.xerces.jaxp.SAXParserFactoryImpl
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:77) - sax parser classorg.apache.xerces.jaxp.SAXParserImpl
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:81) - XML reader class: org.apache.xerces.parsers.SAXParser
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:114) - Setting sax feature: 'http://xml.org/sax/features/namespaces'. State: true.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.JAXP Configurator:114) - Setting sax feature: 'http://xml.org/sax/features/namespace-prefixes'. State: false.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:241) - Adding driver property: user=sa
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:239) - Adding driver property: password=*******
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.minimum-connection-count' to value '2'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.maximum-connection-count' to value '20'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.maximum-connection-lifetime' to value '9000000'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.house-keeping-test-sql' to value 'SELECT 1 + 1'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.statistics' to value '1m,15m,1d'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.statistics-log-level' to value 'INFO'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.fatal-sql-exception' to value 'Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01'.
2005-05-12 16:35:34,039 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.fatal-sql-exception-wrapper-class' to value 'org.logicalcobwebs.proxool.FatalRuntimeException' .
2005-05-12 16:35:34,054 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:224) - Setting property 'proxool.verbose' to value 'true'.
2005-05-12 16:35:34,054 - DEBUG (org.logicalcobwebs.proxool.configuration.XMLC onfigurator:191) - Created url: proxool.spring:net.sourceforge.jtds.jdbc.Drive r:jdbc:jtds:sqlserver://intratestgbr:1433/dbInternet;charset=Cp1252;TDS=8.0
2005-05-12 16:35:34,054 - FATAL (org.hibernate.connection.ProxoolConnectionPro vider:124) - Proxool Provider unable to load JAXP configurator file: proxool.xml
org.logicalcobwebs.proxool.ProxoolException: Parsing failed.
at org.logicalcobwebs.proxool.configuration.JAXPConfi gurator.configure(JAXPConfigurator.java:91 )
at org.logicalcobwebs.proxool.configuration.JAXPConfi gurator.configure(JAXPConfigurator.java:10 7)
at org.hibernate.connection.ProxoolConnectionProvider .configure(ProxoolConnectionProvider.java: 120)
at org.hibernate.connection.ConnectionProviderFactory .newConnectionProvider(ConnectionProviderFacto ry.java:80)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.<init>&#40 ;SchemaUpdate.java:46)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.<init>&#40 ;SchemaUpdate.java:37)
at org.hibernate.impl.SessionFactoryImpl.<init>(S essionFactoryImpl.java:252)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1043)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.newSessionFactory(LocalSessionFactory Bean.java:678)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.afterPropertiesSet(LocalSessionFactor yBean.java:613)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.invokeInitMethods(A bstractAutowireCapableBeanFactory.java:1114&#4 1;
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(Abstract AutowireCapableBeanFactory.java:349)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(Abstract AutowireCapableBeanFactory.java:257)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java&# 58;223)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java&# 58;147)
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.preInstantiateSingletons(De faultListableBeanFactory.java:271)
at org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContex t.java:319)
at org.springframework.web.context.support.AbstractRe freshableWebApplicationContext.refresh(Abstrac tRefreshableWebApplicationContext.java:131&#41 ;
at org.springframework.web.context.ContextLoader.crea teWebApplicationContext(ContextLoader.java&#58 ;230)
at org.springframework.web.context.ContextLoader.init WebApplicationContext(ContextLoader.java:1 56)
at org.springframework.web.context.ContextLoaderListe ner.contextInitialized(ContextLoaderListener.j ava:48)
at org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:3669)
at org.apache.catalina.core.StandardContext.start&#40 ;StandardContext.java:4104)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild&#4 0;ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild&#40 ;StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDirec tory(HostConfig.java:894)
at org.apache.catalina.startup.HostConfig.deployDirec tories(HostConfig.java:857)
at org.apache.catalina.startup.HostConfig.deployApps& #40;HostConfig.java:475)
at org.apache.catalina.startup.HostConfig.start(H ostConfig.java:1102)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(C ontainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(St andardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(C ontainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start( StandardEngine.java:442)
at org.apache.catali

**adcspring** · May 13th, 2005, 02:58 AM

i tried the same config with a jndi datasource instead of adding the proxool options to hibernateProperties and create/update works.

it looks like it's

1. Proxool related
2. caused by hbm2ddl being present with update value

I'll copntinue to use the data source instead.

**Costin Leau** · May 13th, 2005, 05:42 AM

Try using the c3p0 datasource and see how things are going. AFAIK, c3p0 is the default DS in HB because it was used a lot, second comes proxool - Commons-DBCP it's a no-go.
Search the hibernate forums for more information, maybe you'll find your answer there.

Thread: hbm2dddl=update causes exception in proxool,but fine without

Thread Tools

Display

hbm2dddl=update causes exception in proxool,but fine without

Similar Threads

Unit testing with JOTM and JtaTransactionManager

Context initialization failed

Odd behaviour when injecting TransactionTemplate

AndroMDA/Swing - problem with remote connecting...

i am tired.I am very disappointed to spring!!

Posting Permissions