Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-1568

JDBC Cachestore unable to insert data into Oracle12 DB

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • JDG 7.2 CR1
    • JDG 7.2 ER3
    • unspecified
    • None
    • JDG Sprint #10, JDG Sprint #11

    Description

      Test fails with following error:

      java] WARN: ISPN004005: Error received from the server: java.sql.SQLException: ORA-12899: value too large for column "DBALLO12"."JDG_BINARY_defaultx_xx"."ID" (actual: 346, maximum: 255)
      [java] Error : 12899, Position : 65, Sql = INSERT INTO "JDG_BINARY_defaultx_xx" (id,version,datum) VALUES (:1 ,:2 ,:3 ), OriginalSql = INSERT INTO "JDG_BINARY_defaultx_xx" (id,version,datum) VALUES (?,?,?), Error Msg = ORA-12899: value too large for column "DBALLO12"."JDG_BINARY_defaultx_xx"."ID" (actual: 346, maximum: 255)
      [java] Feb 15, 2018 5:30:47 AM org.jboss.arquillian.container.test.impl.client.container.ClientContainerController stop
      [java] INFO: Manual stopping of a server instance
      [java] [0m[31m05:30:47,968 ERROR [org.infinispan.persistence.jdbc.binary.JdbcBinaryStore] (HotRodServerHandler-6-3) ISPN008012: Sql failure while inserting bucket: Bucket{entries={WrappedByteArray

      {bytes=0x033E286D7942657374506572736F6E616C4B657957686963684861734E657665724265656E426574746572, hashCode=-836605432}=MarshalledEntryImpl{keyBytes=51 bytes, valueBytes=9 bytes, metadataBytes=47 bytes, key=WrappedByteArray{bytes=0x033E286D7942657374506572736F6E616C4B657957686963684861734E657665724265656E426574746572, hashCode=-836605432}

      , value=WrappedByteArray

      {bytes=0x033E027632, hashCode=0}

      , metadata=InternalMetadataImpl{actual=EmbeddedExpirableMetadata{lifespan=-1, maxIdle=-1, version=NumericVersion{version=2}}, created=-1, lastUsed=-1}, marshaller=org.infinispan.marshall.core.GlobalMarshaller@48189ed4}}, bucketId='-836605952'}: java.sql.SQLException: ORA-12899: value too large for column "DBALLO12"."JDG_BINARY_defaultx_xx"."ID" (actual: 346, maximum: 255)
      [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      ...
      [java] at java.lang.Thread.run(Thread.java:748)
      [java] Caused by: Error : 12899, Position : 65, Sql = INSERT INTO "JDG_BINARY_defaultx_xx" (id,version,datum) VALUES (:1 ,:2 ,:3 ), OriginalSql = INSERT INTO "JDG_BINARY_defaultx_xx" (id,version,datum) VALUES (?,?,?), Error Msg = ORA-12899: value too large for column "DBALLO12"."JDG_BINARY_defaultx_xx"."ID" (actual: 346, maximum: 255)
      [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      [java] ... 69 more

      Attachments

        Issue Links

          Activity

            People

              remerson@redhat.com Ryan Emerson
              zhostasa_jira Zdenek Hostasa (Inactive)
              Zdenek Hostasa Zdenek Hostasa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: