0 Replies Latest reply on Sep 6, 2013 1:52 PM by daniel.trieu

    JdbcStringBasedCacheStore and ORA-000972 identifier too long

    daniel.trieu

      Hello,

       

      I'm using ISPN516 to do a prefetched cachestore of an oracle table.

       

      The oracle account I have to work with has been given read-only rights to a schema. So my stringsTableNamePrefix is of the form schema.tablename.

       

      This causes the initial query to fail because schema.tablename.columnname creates an identifier that is too long.

       

      The TableManipulation class doesn't provide a way to leverage aliases so I was wondering if anyone has a workaround, or am I just going about this entirely wrong.

       

       

      TIA

       

      Daniel