BPEL Installation Question
jgreiner Feb 8, 2007 12:56 PMI am trying to install the BPEL Engine on my JBOSS Server. I need it to point to an oracle database which I have it doing. However the tables do not exist on the Oracle database server.
When I run ant create-schema I get the error below. I have set my Dialect to Oracle9Dialect which worked when I deployed JBPM. I was wonder does anyone know where the scripts are to build the BPEL Tables manually? I would like to try that once and see how she shakes out.
2007-02-08 11:20:02,268 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jbpm-bpel].[dbSchemaServlet]] Servlet.service() for servlet org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 at org.hibernate.dialect.TypeNames.get(TypeNames.java:56) at org.hibernate.dialect.TypeNames.get(TypeNames.java:81) at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:241) at org.hibernate.mapping.Column.getSqlType(Column.java:181) at org.hibernate.mapping.Table.sqlCreateString(Table.java:383) at org.hibernate.cfg.Configuration.generateSchemaCreationScript(Configuration.java:774) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:92) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:59) at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSchemaExport(DbPersistenceServiceFactory.java:77) at org.jbpm.persistence.db.DbPersistenceServiceFactory.createSchema(DbPersistenceServiceFactory.java:108) at org.jbpm.JbpmConfiguration.createSchema(JbpmConfiguration.java:441) at org.jbpm.JbpmConfiguration.createSchema(JbpmConfiguration.java:433) at org.jbpm.bpel.web.DBSchemaServlet.createSchema(DBSchemaServlet.java:39) at org.jbpm.bpel.web.DBSchemaServlet.doGet(DBSchemaServlet.java:28) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595)