java - Hibernate UserType working in a testapplication but not on web service on tomcat -

i have set web service using hibernate 4.2.8 running on tomcat 7.0.41. use postgres 9.2 database it.

i created hibernate usertype use point datatype provided postgres. first tried small demo application test , play around with, working fine far.

when tried code on web service, reported following error when trying insert row custom type:

error (2014-03-10 15:58:49,226) der in sql für eine instanz von org.postgresql.geometric.pgpoint zu verwendende datentyp kann nicht abgeleitet werden. benutzen sie 'setobject()' mit einem expliziten typ, um ihn festzulegen. [sqlexceptionhelper.java:147]     org.hibernate.exception.sqlgrammarexception: not insert: [com.zhs.dbaccess.tableclasses.zhsjunk]     @ org.hibernate.exception.internal.sqlstateconversiondelegate.convert(sqlstateconversiondelegate.java:123)     @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49)     @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125)     @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:3099)     @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:3521)     @ org.hibernate.action.internal.entityinsertaction.execute(entityinsertaction.java:88)     @ org.hibernate.engine.spi.actionqueue.execute(actionqueue.java:393)     @ org.hibernate.engine.spi.actionqueue.executeactions(actionqueue.java:385)     @ org.hibernate.engine.spi.actionqueue.executeactions(actionqueue.java:301)     @ org.hibernate.event.internal.abstractflushingeventlistener.performexecutions(abstractflushingeventlistener.java:349)     @ org.hibernate.event.internal.defaultflusheventlistener.onflush(defaultflusheventlistener.java:56)     @ org.hibernate.internal.sessionimpl.flush(sessionimpl.java:1159)     @ org.hibernate.internal.sessionimpl.managedflush(sessionimpl.java:404)     @ org.hibernate.engine.transaction.internal.jdbc.jdbctransaction.beforetransactioncommit(jdbctransaction.java:101)     @ org.hibernate.engine.transaction.spi.abstracttransactionimpl.commit(abstracttransactionimpl.java:175)     @ com.zhs.servicebase.clienthandling.clientrequesthandler.inserttaps(clientrequesthandler.java:609)     @ com.zhs.zhsservice.zhsservice.tap(zhsservice.java:69)     @ org.apache.jsp.test.requestresult_jsp._jspservice(requestresult_jsp.java:391)     @ org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70)     @ javax.servlet.http.httpservlet.service(httpservlet.java:728)     @ org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:432)     @ org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:390)     @ org.apache.jasper.servlet.jspservlet.service(jspservlet.java:334)     @ javax.servlet.http.httpservlet.service(httpservlet.java:728)     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305)     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210)     @ org.netbeans.modules.web.monitor.server.monitorfilter.dofilter(monitorfilter.java:393)     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243)     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210)     @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222)     @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123)     @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472)     @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:171)     @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99)     @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:953)     @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118)     @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:408)     @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1023)     @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:589)     @ org.apache.tomcat.util.net.aprendpoint$socketprocessor.run(aprendpoint.java:1852)     @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145)     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615)     @ java.lang.thread.run(thread.java:722) caused by: org.postgresql.util.psqlexception: der in sql für eine instanz von org.postgresql.geometric.pgpoint zu verwendende datentyp kann nicht abgeleitet werden. benutzen sie 'setobject()' mit einem expliziten typ, um ihn festzulegen.     @ org.postgresql.jdbc2.abstractjdbc2statement.setobject(abstractjdbc2statement.java:1914)     @ org.postgresql.jdbc3g.abstractjdbc3gstatement.setobject(abstractjdbc3gstatement.java:36)     @ org.postgresql.jdbc4.abstractjdbc4statement.setobject(abstractjdbc4statement.java:47)     @ org.apache.tomcat.dbcp.dbcp.delegatingpreparedstatement.setobject(delegatingpreparedstatement.java:169)     @ org.apache.tomcat.dbcp.dbcp.delegatingpreparedstatement.setobject(delegatingpreparedstatement.java:169)     @ com.zhs.dbaccess.pgtypes.pointusertype.nullsafeset(pointusertype.java:281)     @ org.hibernate.type.customtype.nullsafeset(customtype.java:158)     @ org.hibernate.persister.entity.abstractentitypersister.dehydrate(abstractentitypersister.java:2798)     @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:3076)     ... 39 more 

i using same dbs different database, both set utf-8 character encoding

since hibernate connected db through jndi ressource provided tomcat, thought maybe tomcat breaking insert statement. removed jndi ressource , connected db directly, following result:

org.hibernate.exception.dataexception: not execute statement     @ org.hibernate.exception.internal.sqlstateconversiondelegate.convert(sqlstateconversiondelegate.java:135)     @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49)     @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125)     @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:110)     @ org.hibernate.engine.jdbc.internal.resultsetreturnimpl.executeupdate(resultsetreturnimpl.java:189)     @ org.hibernate.engine.jdbc.batch.internal.nonbatchingbatch.addtobatch(nonbatchingbatch.java:58)     @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:3079)     @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:3521)     @ org.hibernate.action.internal.entityinsertaction.execute(entityinsertaction.java:88)     @ org.hibernate.engine.spi.actionqueue.execute(actionqueue.java:393)     @ org.hibernate.engine.spi.actionqueue.executeactions(actionqueue.java:385)     @ org.hibernate.engine.spi.actionqueue.executeactions(actionqueue.java:301)     @ org.hibernate.event.internal.abstractflushingeventlistener.performexecutions(abstractflushingeventlistener.java:349)     @ org.hibernate.event.internal.defaultflusheventlistener.onflush(defaultflusheventlistener.java:56)     @ org.hibernate.internal.sessionimpl.flush(sessionimpl.java:1159)     @ org.hibernate.internal.sessionimpl.managedflush(sessionimpl.java:404)     @ org.hibernate.engine.transaction.internal.jdbc.jdbctransaction.beforetransactioncommit(jdbctransaction.java:101)     @ org.hibernate.engine.transaction.spi.abstracttransactionimpl.commit(abstracttransactionimpl.java:175)     @ com.zhs.servicebase.clienthandling.clientrequesthandler.inserttaps(clientrequesthandler.java:609)     @ com.zhs.zhsservice.zhsservice.tap(zhsservice.java:69)     @ org.apache.jsp.test.requestresult_jsp._jspservice(requestresult_jsp.java:391)     @ org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70)     @ javax.servlet.http.httpservlet.service(httpservlet.java:728)     @ org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:432)     @ org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:390)     @ org.apache.jasper.servlet.jspservlet.service(jspservlet.java:334)     @ javax.servlet.http.httpservlet.service(httpservlet.java:728)     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305)     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210)     @ org.netbeans.modules.web.monitor.server.monitorfilter.dofilter(monitorfilter.java:393)     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243)     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210)     @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222)     @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123)     @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472)     @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:171)     @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99)     @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:953)     @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118)     @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:408)     @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1023)     @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:589)     @ org.apache.tomcat.util.net.aprendpoint$socketprocessor.run(aprendpoint.java:1852)     @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145)     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615)     @ java.lang.thread.run(thread.java:722) caused by: org.postgresql.util.psqlexception: error: invalid byte sequence encoding "utf8": 0x00     @ org.postgresql.core.v3.queryexecutorimpl.receiveerrorresponse(queryexecutorimpl.java:2161)     @ org.postgresql.core.v3.queryexecutorimpl.processresults(queryexecutorimpl.java:1890)     @ org.postgresql.core.v3.queryexecutorimpl.execute(queryexecutorimpl.java:255)     @ org.postgresql.jdbc2.abstractjdbc2statement.execute(abstractjdbc2statement.java:559)     @ org.postgresql.jdbc2.abstractjdbc2statement.executewithflags(abstractjdbc2statement.java:417)     @ org.postgresql.jdbc2.abstractjdbc2statement.executeupdate(abstractjdbc2statement.java:363)     @ org.hibernate.engine.jdbc.internal.resultsetreturnimpl.executeupdate(resultsetreturnimpl.java:186)     ... 41 more 

does know might cause this? since error changes when reconfiguring db connection, guess might have tomcat messing it.

ok, switched tomcat 8.03 , first error gone, realiszed somehow had values in sql null, that's second error. null values should have been handled db, somehow didn't.