Problem with Trailblazer example and PostgreSQL
daniel.roeder Sep 14, 2006 3:30 AMHi @ALL,
I installed JBossESB and the TestJBossESB worked fine, but I have problems with the trailblazer example. The following error-messages are presented by the JBoss AS output:
09:09:01,139 INFO [TomcatDeployer] deploy, ctxPath=/loanbroker, warUrl=.../tmp/deploy/tmp8103loanbroker-exp.war/ 09:09:01,670 INFO [WSDLFilePublisher] WSDL published to: file:/C:/JBoss_SOA/jboss-4.0.4.GA/server/default/data/wsdl/loanbrok er.war/LoanBrokerWSService8104.wsdl 09:09:01,983 INFO [ServiceEndpointManager] WebService started: http://w2k3srv:8080/loanbroker/LoanBrokerWS 09:11:39,951 INFO [STDOUT] -6101458123877306066 09:11:39,951 INFO [STDOUT] file:/C:/JBoss_SOA/jboss-4.0.4.GA/server/default/tmp/deploy/tmp8101jbossesb-appl.ear-contents/jbo ssesb-common.jar 09:11:39,951 INFO [STDOUT] 2006-09-14 09:11:39,951 [http-0.0.0.0-8080-1] INFO org.jboss.soa.esb.services.beans.PersistHandle rBean - org.jboss.soa.esb.services.beans.PersistHandlerBean@2ad6a0 Created 09:11:39,951 INFO [PersistHandlerBean] org.jboss.soa.esb.services.beans.PersistHandlerBean@2ad6a0 Created 09:11:41,483 ERROR [JdbcCleanConn] execUpdWait() FAILED org.postgresql.util.PSQLException: ERROR: column "xml_data" is of type text but expression is of type bytea at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251) at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execUpdWait(JdbcCleanConn.java:122) at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:307) at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:288) at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.java:167) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) .....
Any suggestions about the problem?
Daniel Röder