You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Kurt T Stam (JIRA)" <ju...@ws.apache.org> on 2010/11/09 23:00:24 UTC

[jira] Commented: (JUDDI-374) openjpa + postgresql has problems with timestamps

    [ https://issues.apache.org/jira/browse/JUDDI-374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12930306#action_12930306 ] 

Kurt T Stam commented on JUDDI-374:
-----------------------------------

When the coverage period goes out too far postgres has issues. The coverage periods are specified in the uddi-tck-base module in the directory
src/main/resources/uddi_data/subscription; the files subscriptionresults3.xml and subscriptionresults4.xml:

Changing the endPoint from 2100 to 2030:

<get_subscriptionResults xmlns="urn:uddi-org:sub_v3">
  <subscriptionKey>uddi:www.samco.com:subscriptionthree</subscriptionKey>
  <coveragePeriod>
    <startPoint>2009-01-01T00:00:00.000Z</startPoint>
    <endPoint>2030-01-01T00:00:00.000Z</endPoint>
  </coveragePeriod>
</get_subscriptionResults>

This is clearly a bug in postgres or the postgres driver. On saving no error is thrown, however the endpoint field is set to 'invalid' which is an issue
when the date is parsed back into a timedate.



> openjpa + postgresql has problems with timestamps
> -------------------------------------------------
>
>                 Key: JUDDI-374
>                 URL: https://issues.apache.org/jira/browse/JUDDI-374
>             Project: jUDDI
>          Issue Type: Bug
>    Affects Versions: 3.0.2
>            Reporter: Tom Cunningham
>            Assignee: Kurt T Stam
>             Fix For: 3.0.5
>
>         Attachments: persistence.xml
>
>
> Seeing a problem with timestamps on postgres / openjpa.      Two tests fail.     Attaching persistence.xml to bug.
> -------------------------------------------------------
>  T E S T S
> -------------------------------------------------------
> Running org.apache.juddi.v3.tck.UDDI_010_PublisherIntegrationTest
> 16:05:46,827 INFO  [ClientConfig] Reading UDDI Client properties file file:/home/tcunning/src/juddi/trunk/uddi-tck/target/classes/META-INF/uddi.xml
> 16:05:46,872 INFO  [ClientConfig] XRegistration 0 servicebindingKeys
> 16:05:46,873 INFO  [ClientConfig] XRegistration 0 businessKeys
> 16:05:46,874 INFO  [UDDIClerkManager] Starting UDDI Clerks for manager test-manager...
> 16:05:46,874 INFO  [UDDIClerkManager] Clerks started succesfully for manager test-manager
> authtoken:b68ce324-d442-47a8-b4b0-b35fd5ff608b
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.659 sec
> Running org.apache.juddi.v3.tck.UDDI_020_TmodelIntegrationTest
> Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.361 sec
> Running org.apache.juddi.v3.tck.UDDI_060_PublisherAssertionIntegrationTest
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.132 sec
> Running org.apache.juddi.v3.tck.UDDI_040_BusinessServiceIntegrationTest
> Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.948 sec
> Running org.apache.juddi.v3.tck.UDDI_030_BusinessEntityIntegrationTest
> Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.151 sec
> Running org.apache.juddi.v3.tck.JUDDI_010_PublisherIntegrationTest
> authtoken:da270762-869e-48a4-ba3f-2c5e0fae57e9
> Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.104 sec
> Running org.apache.juddi.v3.tck.UDDI_070_FindEntityIntegrationTest
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.669 sec
> Running org.apache.juddi.v3.tck.UDDI_080_SubscriptionIntegrationTest
> 16:06:12,216 ERROR [TckSubscription] Bad value for type timestamp : invalid
> javax.xml.ws.soap.SOAPFaultException: Bad value for type timestamp : invalid
> 	at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:188)
> 	at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:122)
> 	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119)
> 	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89)
> 	at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118)
> 	at $Proxy49.getSubscriptionResults(Unknown Source)
> 	at org.apache.juddi.v3.tck.TckSubscription.getSamSyndicatorSubscriptionResultsWithChunkingOnFind(TckSubscription.java:202)
> 	at org.apache.juddi.v3.tck.UDDI_080_SubscriptionIntegrationTest.samSyndicatorWithChunkingOnFind(UDDI_080_SubscriptionIntegrationTest.java:139)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> 	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> 	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> 	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> 	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
> 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
> 	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
> 	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
> 	at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
> 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> 	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> 	at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
> 	at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
> 	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
> 	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
> 	at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:334)
> 	at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:980)
> 16:06:13,994 ERROR [TckSubscription] Bad value for type timestamp : invalid
> javax.xml.ws.soap.SOAPFaultException: Bad value for type timestamp : invalid
> 	at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:188)
> 	at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:122)
> 	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119)
> 	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89)
> 	at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118)
> 	at $Proxy49.getSubscriptionResults(Unknown Source)
> 	at org.apache.juddi.v3.tck.TckSubscription.getSamSyndicatorSubscriptionResultsWithChunkingOnGet(TckSubscription.java:251)
> 	at org.apache.juddi.v3.tck.UDDI_080_SubscriptionIntegrationTest.samSyndicatorWithChunkingOnGet(UDDI_080_SubscriptionIntegrationTest.java:157)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> 	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> 	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> 	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> 	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
> 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
> 	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
> 	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
> 	at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
> 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> 	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> 	at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
> 	at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
> 	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
> 	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
> 	at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:334)
> 	at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:980)
> Tests run: 4, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 8.581 sec <<< FAILURE!
> Running org.apache.juddi.v3.tck.UDDI_050_BindingTemplateIntegrationTest
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.692 sec
> Running org.apache.juddi.v3.tck.UDDI_090_SubscriptionListenerIntegrationTest
> Going to read from file: /home/tcunning/src/juddi/trunk/uddi-tck/temp/uddiclient.log
> ....Found String@SLTests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.629 sec
> Results :
> Failed tests: 
>   samSyndicatorWithChunkingOnFind(org.apache.juddi.v3.tck.UDDI_080_SubscriptionIntegrationTest)
>   samSyndicatorWithChunkingOnGet(org.apache.juddi.v3.tck.UDDI_080_SubscriptionIntegrationTest)
> Tests run: 19, Failures: 2, Errors: 0, Skipped: 0

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.