Bug 894323

Summary: Juddi unit tests are failing with DB2 97, column key_data_value in table j3_key_data_value is too short
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Jiri Sedlacek <jsedlace>
Component: jUDDI - within SOAAssignee: Nobody <nobody>
Status: VERIFIED --- QA Contact: Matej Melko <mmelko>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 5.3.1CC: jcoleman, oskutka, soa-p-jira, tcunning
Target Milestone: ER4   
Target Release: 5.3.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
DB2-97, all JDKs, all OSs
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
test log resulting from unit tests none

Description Jiri Sedlacek 2013-01-11 12:26:01 UTC
Created attachment 676838 [details]
test log resulting from unit tests

Description of problem:

Some unit tests for juddi 3.1.4 are failing:

    [junit] Running org.apache.juddi.api.impl.API_010_PublisherTest
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 32,25 sec
    [junit] Running org.apache.juddi.api.impl.API_020_TmodelTest
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 55,68 sec
    [junit] Running org.apache.juddi.api.impl.API_030_BusinessEntityTest
    [junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 125,03 sec
    [junit] TEST org.apache.juddi.api.impl.API_030_BusinessEntityTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_040_BusinessServiceTest
    [junit] Tests run: 5, Failures: 5, Errors: 0, Time elapsed: 260,38 sec
    [junit] TEST org.apache.juddi.api.impl.API_040_BusinessServiceTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_050_BindingTemplateTest
    [junit] Tests run: 2, Failures: 2, Errors: 0, Time elapsed: 102,32 sec
    [junit] TEST org.apache.juddi.api.impl.API_050_BindingTemplateTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_060_PublisherAssertionTest
    [junit] Tests run: 3, Failures: 3, Errors: 0, Time elapsed: 224,45 sec
    [junit] TEST org.apache.juddi.api.impl.API_060_PublisherAssertionTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_070_FindEntityTest
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 57,02 sec
    [junit] TEST org.apache.juddi.api.impl.API_070_FindEntityTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_080_SubscriptionTest
    [junit] Tests run: 4, Failures: 1, Errors: 0, Time elapsed: 660,94 sec
    [junit] TEST org.apache.juddi.api.impl.API_080_SubscriptionTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_090_SubscriptionListenerIntegrationTest
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 59,24 sec
    [junit] TEST org.apache.juddi.api.impl.API_090_SubscriptionListenerIntegrationTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_091_RMISubscriptionListenerIntegrationTest
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 57,12 sec
    [junit] TEST org.apache.juddi.api.impl.API_091_RMISubscriptionListenerIntegrationTest FAILED
    [junit] Running org.apache.juddi.api.impl.API_100_ClientSubscriptionInfoTest
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 25,99 sec
    [junit] Running org.apache.juddi.auth.AuthenticatorTest
    [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 18,85 sec
    [junit] Running org.apache.juddi.config.ApplicationConfigurationTest
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0,01 sec
    [junit] Running org.apache.juddi.keygen.KeyGeneratorTest
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0,01 sec
    [junit] Running org.apache.juddi.rmi.JNDIRegistrationTest
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0,11 sec
    [junit] Running org.apache.juddi.subscription.SubscriptionNotifierTest
    [junit] Tests run: 0, Failures: 2, Errors: 0, Time elapsed: 62,99 sec
    [junit] TEST org.apache.juddi.subscription.SubscriptionNotifierTest FAILED
    [junit] Running org.apache.juddi.subscription.notify.NotifierTest
    [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0,27 sec
    [junit] Tests FAILED


How reproducible:
Configure juddi unit tests to use db2 97 db and then run unit tests.



In some cases when saving data to j3_key_data_value table, exception is thrown.
Full log is attached, DEBUG and TRACE output was set for org.hibernate.SQL and org.hibernate.type

If I changed column to use blob(2048), tests passed, I could see that problem row has data of size larger than 700 bytes.

Comment 1 Julian Coleman 2013-01-21 12:31:44 UTC
Revision 11674 of:

  soa-p/src/main/resources/soa-p/add-juddi-tables.db2.txt

Commit log:

  BZ-894323
  Increase size of key_data_value in the j3_key_data_value table to 2048
  in the DB2 upgrade script.  Mirrors change in the ESB create table script.

Comment 2 Jiri Sedlacek 2013-01-29 14:40:58 UTC
verified in soa-p-5.3.1.ER4