Bug 779744 (SOA-2106)

Summary: it is not possible to certify jUDDI on PostgreSQL
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Jiri Pechanec <jpechane>
Component: jUDDI - within SOAAssignee: Default User <jbpapp-maint>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.0.0 GAKeywords: Regression, TestBlocker
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2106
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
5.0.2 CR1
Last Closed: 2010-07-29 12:54:15 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:

Description Jiri Pechanec 2010-06-02 11:02:58 UTC 
project_key: SOA

See
http://hudson.qa.jboss.com/hudson/view/SOA-Release/job/soa-juddi3-db-OpenJDK-maven/14/DATABASE=postgresql82,jdk=openjdk-local,label=RHEL5_x86_64_res/
http://hudson.qa.jboss.com/hudson/view/SOA-Release/job/soa-juddi3-db-OpenJDK-maven/13/DATABASE=postgresql83,jdk=openjdk-local,label=RHEL5_x86_64_res/

org.apache.juddi.api.impl.API_080_SubscriptionTest.samSyndicatorWithChunkingOnGet is failing and the exceptions are
java.sql.SQLException: Failed to find Statement: 480396620
2010-05-26 06:16:10,556 ERROR [org.hibernate.util.JDBCExceptionReporter] (main) The column name authorized2_6_0_ was not found in this ResultSet.
2010-05-26 06:16:10,557 ERROR [org.hibernate.util.JDBCExceptionReporter] (Timer-7) This ResultSet is closed.

Does this test run in multi-threaded environment? It seems that this issue and SOA-2100 are not working due to the same cause
Comment 1 Jiri Pechanec 2010-06-02 11:04:52 UTC 
Link: Added: This issue is related to SOA-2100
Comment 2 Len DiMaggio 2010-06-02 11:09:06 UTC 
Affects Testing: Added: [Regression, Blocks Testing]
Blocked Tests: Added: jUDDI certification with PostgreSQL
Comment 3 Len DiMaggio 2010-06-02 12:16:00 UTC 
Link: Added: This issue related SOA-2100
Comment 4 Len DiMaggio 2010-06-03 02:07:28 UTC 
Link: Removed: This issue related SOA-2100
Comment 5 Len DiMaggio 2010-07-29 12:54:15 UTC 
This is the same (remote JBDC) issue as https://jira.jboss.org/browse/SOA-2100