0 Replies Latest reply on Sep 6, 2013 1:52 PM by Daniel Trieu

    JdbcStringBasedCacheStore and ORA-000972 identifier too long

    Daniel Trieu Newbie



      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.