| Summary: | jbossesb.esb can't be deployed because of SqlSyntaxErrorException | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Filip Elias <felias> | ||||||
| Component: | EAP | Assignee: | Default User <jbpapp-maint> | ||||||
| Status: | CLOSED WONTFIX | QA Contact: | |||||||
| Severity: | urgent | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 5.3.0 GA | CC: | atangrin, jcoleman, kejohnso, ldimaggi, pmacik, sdorfiel, soa-p-jira, stliu, tcunning | ||||||
| Target Milestone: | ER3 | Keywords: | TestBlocker | ||||||
| Target Release: | 5.3.0 GA | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: |
An error occurs when using SOA-P 5.3.0 DR3 to deploy jbossesb.esb. Upon attempting to launch the .esb, a SqlSyntaxErrorException message appears. You can work around this by using org.hibernate.type.NumericBooleanType type instead of BooleanType or adding the XML code referred to in the Bugzilla for this issue.
|
Story Points: | --- | ||||||
| Clone Of: | Environment: |
SOA-P 5.3.0 DR3
with database IBM DB2 9.7
|
|||||||
| Last Closed: | 2012-06-26 14:06:37 UTC | Type: | Bug | ||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Attachments: |
|
||||||||
|
Description
Filip Elias
2012-04-06 10:54:04 UTC
Created attachment 575704 [details]
Server log
Can we retest this with ER2? Same problem with ER2. Looks like there's a Hibernate fix for this : https://issues.jboss.org/browse/JBPAPP-8627 https://hibernate.onjira.com/browse/HHH-7317 as said in jira JBPAPP-8627, this can be easily workaround Madhumita Sadhukhan <msadhukh> made a comment on jira JBPAPP-8627 All other tests pass when testsuite is run on DB2-97 after skipping hanging LockTest or LockModeTest https://hudson.qa.jboss.com/hudson/view/EAP6/view/EAP6-Hibernate/job/eap6-hibernate-core-master-testsuite-testDB2Sybase/ Also fixes Envers testsuite failures on DB2 https://hudson.qa.jboss.com/hudson/view/EAP6/view/EAP6-Hibernate/job/eap-60-hibernate-envers-testsuite/database=db2-97,jdk=java16_default,label=hibernate/2/ Madhumita Sadhukhan <msadhukh> updated the status of jira JBPAPP-8627 to Closed do you have a simple test case? or, enable org.hibernate to debug level log, please Created attachment 590207 [details]
SOA-P 5.3 ER3 server.log (org.hibernate set to debug level)
This (In reply to comment #13) > do you have a simple test case? > > or, enable org.hibernate to debug level log, please This exception is thrown while booting SOA-P 5.3 ERx. I have added server log with org.hibernate set to debug level. This work around is valid. Is is necessary to add "<connection-property name="deferPrepares">false</connection-property>" to the "/jboss-as/server/db2-97/deploy/jbossesb-registry.sar/juddi-ds.xml". Strong Liu <stliu> made a comment on jira JBPAPP-9059 yeah, this is an option, not so sure about the eap5 ds format Strong Liu <stliu> made a comment on jira JBPAPP-9059 after talking with my team, we think there is no way to fix this in EAP5 w/o breaking compatibility change. and since there already are workarounds, I'd like to resolve this as won't fix. Strong Liu <stliu> updated the status of jira JBPAPP-9059 to Resolved
Technical note added. If any revisions are required, please edit the "Technical Notes" field
accordingly. All revisions will be proofread by the Engineering Content Services team.
New Contents:
An error occurs when using SOA-P 5.3.0 DR3 to deploy jbossesb.esb. Upon attempting to launch the .esb, a SqlSyntaxErrorException message appears. You can work around this by creating a new dialect and adding the XML code referred to in the Bugzilla for this issue.
Suz, I think it should be "An error occurs when using SOA-P 5.3.0 DR3 to deploy jbossesb.esb. Upon attempting to launch the .esb, a SqlSyntaxErrorException message appears. You can work around this by using org.hibernate.type.NumericBooleanType type instead of BooleanType OR adding the XML code referred to in the Bugzilla for this issue."
Technical note updated. If any revisions are required, please edit the "Technical Notes" field
accordingly. All revisions will be proofread by the Engineering Content Services team.
Diffed Contents:
@@ -1 +1 @@
-An error occurs when using SOA-P 5.3.0 DR3 to deploy jbossesb.esb. Upon attempting to launch the .esb, a SqlSyntaxErrorException message appears. You can work around this by creating a new dialect and adding the XML code referred to in the Bugzilla for this issue.+An error occurs when using SOA-P 5.3.0 DR3 to deploy jbossesb.esb. Upon attempting to launch the .esb, a SqlSyntaxErrorException message appears. You can work around this by using org.hibernate.type.NumericBooleanType type instead of BooleanType or adding the XML code referred to in the Bugzilla for this issue.
Zbyněk Roubalík <zroubali> updated the status of jira JBPAPP-9059 to Closed Zbyněk Roubalík <zroubali> made a comment on jira JBPAPP-9059 Known issue, closing. Scott Mumford <smumford> updated the status of jira JBPAPP-9059 to Reopened Scott Mumford <smumford> updated the status of jira JBPAPP-9059 to Closed Scott Mumford <smumford> updated the status of jira JBPAPP-9059 to Reopened |