Changing database twice using Database Configuration Tool and getting error in SOA-P
Issue
- I converted the database from MySQL to MSSQL, running the Ant script under
$SOA_ROOT/jboss-as/tools/schema. - Not all the files related to dialects and SQL inits are updated.
- I'm getting the following error. Which file needs to be fixed?
2014-03-25 14:12:52,870 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=BPELDatabaseInitializer state=Create
java.lang.RuntimeException: Failed to create database
at org.jboss.soa.bpel.runtime.db.DatabaseInitializer.executeSql(DatabaseInitializer.java:179)
at org.jboss.soa.bpel.runtime.db.DatabaseInitializer.initDatabase(DatabaseInitializer.java:126)
at org.jboss.soa.bpel.runtime.db.DatabaseInitializer.startService(DatabaseInitializer.java:187)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.pojoStart(ServiceMBeanSupport.java:216)
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'IF'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:633)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:253)
at org.jboss.soa.bpel.runtime.db.DatabaseInitializer.executeSql(DatabaseInitializer.java:160)
... 69 more
Environment
- Red Hat JBoss SOA Platform (SOA-P)
- 5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.