Postgres JDBC-hibernate Problem - Mailing list pgsql-bugs

From Freddie Burgess
Subject Postgres JDBC-hibernate Problem
Date
Msg-id 000901cd9039$11ac90f0$3505b2d0$@radiantblue.com
Whole thread Raw
Responses Re: Postgres JDBC-hibernate Problem
List pgsql-bugs
We have upgraded from PostgreSQL 8.4.3 to PostgreSQL 9.1.4 and we are
getting the following errors when attempting to auto-gen schema DDL.

Old Configuration:

WEB-INF/lib/postgis-jdbc-1.3.3.jar,
WEB-INF/lib/postgis-stubs-1.3.3.jar,
WEB-INF/lib/postgresql-8.3-603.jdbc4.jar,

New Configuration:

Tomcat 7
Java 1.6.0_35

Spring Framework 3.1.2, hibernate sessionFactory via
'org.springframework.orm.hibernate4.LocalSessionFactoryBean'
Hibernate Core 4.1.6.Final
Hibernate Spatial 4.0.M1
PostgreSQL JDBC4 9.1-901
postgis-jdbc 1.5.2
c3p0 0.9.1.2

auto DDL update phase fails with Exception:

11:59:23,736 [localhost-startStop-1]  INFO java.sql.DatabaseMetaData:120 -
HHH000262: Table not found: SOME_TABLE
11:59:23,738 [localhost-startStop-1] ERROR
org.hibernate.tool.hbm2ddl.SchemaUpdate:245 - HHH000299: Could not complete
schema update

org.hibernate.MappingException: No Dialect mapping for JDBC type: 1852802018
(**Changes at each webapp startup)
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:76)
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:99)
        at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:299)
        at
org.hibernate.spatial.dialect.postgis.PostgisDialect.getTypeName(PostgisDial
ect.java:247)
        at org.hibernate.mapping.Column.getSqlType(Column.java:227)
        at org.hibernate.mapping.Table.sqlCreateString(Table.java:481)
        at
org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.jav
a:1140)
        at
org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:212)
        at
org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
        at
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:492
)
        at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1746)
        at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1784)
        at
org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFa
ctory(LocalSessionFactoryBuilder.java:242)
        at
org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFacto
ry(LocalSessionFactoryBean.java:372)
        at
org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSe
t(LocalSessionFactoryBean.java:357)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:294)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:225)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abst
ractBeanFactory.java:291)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:193)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:322)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:106)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:294)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:225)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abst
ractBeanFactory.java:291)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:193)
        at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:609)
        at
org.springframework.context.support.AbstractApplicationContext.finishBeanFac
toryInitialization(AbstractApplicationContext.java:918)
        at
org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:469)
        at
org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicat
ionContext(ContextLoader.java:383)
        at
org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:283)
        at
org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:111)
        at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
4791)
        at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:
5285)
        at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:9
01)
        at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
        at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:963)
        at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1600)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.ja
va:886)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:9
08)
        at java.lang.Thread.run(Thread.java:662)

Dialect specification in hibernate.properties is:
hibernate.dialect=org.hibernate.spatial.dialect.postgis.PostgisDialect

Any assistance will be greatly appreciated.

thanks
--

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #7529: Support different error handling behavior than auto rollback
Next
From: Marko Tiikkaja
Date:
Subject: Re: BUG #7516: PL/Perl crash