Bug 888764 - JDBCCacheStore tests fail with Oracle DB in case the table name prefix contains "/" symbol
Summary: JDBCCacheStore tests fail with Oracle DB in case the table name prefix contai...
Keywords:
Status: VERIFIED
Alias: None
Product: JBoss Data Grid 6
Classification: JBoss
Component: Infinispan
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: ER10
: 6.1.0
Assignee: Tristan Tarrant
QA Contact: Martin Gencur
URL:
Whiteboard:
: 893006 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-12-19 12:48 UTC by Anna Manukyan
Modified: 2023-04-01 08:00 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker ISPN-2660 0 Minor Resolved JDBCCacheStore tests fail with Oracle DB in case the table name prefix contains "/" symbol 2014-01-08 21:47:18 UTC
Red Hat Issue Tracker ISPN-2755 0 Major Resolved Make sure tableprefix does not contain "non-allowed" characters 2014-01-08 21:47:18 UTC

Description Anna Manukyan 2012-12-19 12:48:27 UTC 
https://svn.devel.redhat.com/repos/jboss-qa/jdg/jdg-functional-tests/trunk/invm/jdbc-cache-store/src/test/java/com/jboss/datagrid/test/jdbcstore/BinaryCacheStoreTest.java test is failing for Oracle DB while the table name prefix contains / sign.

You can find the failure errors here:

http://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/edg-60-jdbc-cache-stores-eap6/DATABASE=oracle11gR2,jdk=java16_default,label=RHEL6_x86_64/161/testReport/com.jboss.datagrid.test.jdbcstore/BinaryCacheStoreTest/testPutGetRemoveWithoutPassivationWithPreload/
Comment 2 JBoss JIRA Server 2012-12-19 15:04:15 UTC 
Mircea Markus <mmarkus> made a comment on jira ISPN-2660

I think a simple workaround would be for the user not to use '/' in the table name.
Comment 3 Martin Gencur 2013-01-09 08:59:18 UTC 
*** Bug 893006 has been marked as a duplicate of this bug. ***
Comment 4 JBoss JIRA Server 2013-01-10 09:33:13 UTC 
Adrian Nistor <anistor> made a comment on jira ISPN-2660

Integrated. Thanks!
Comment 5 JBoss JIRA Server 2013-01-22 14:31:54 UTC 
Anna Manukyan <amanukya> updated the status of jira ISPN-2660 to Reopened
Comment 6 JBoss JIRA Server 2013-01-22 14:31:54 UTC 
Anna Manukyan <amanukya> made a comment on jira ISPN-2660

The issue still appears with 5.2.0.CR2.

I've looked through the fix, and found out the reason why this happens: 

the fix replaces all special symbols with _ in cachename. But the bug is regarding the table name prefix. So as the table name prefix still contains "/" and is not replaced, the general table name anyway contains "/" symbol, which leads to error for Oracle.
Comment 7 JBoss JIRA Server 2013-01-25 08:57:46 UTC 
Tristan Tarrant <ttarrant> updated the status of jira ISPN-2660 to Resolved
Comment 8 JBoss JIRA Server 2013-01-25 10:16:36 UTC 
Adrian Nistor <anistor> made a comment on jira ISPN-2755

Integrated. Thanks!
Comment 9 Anna Manukyan 2013-01-31 09:00:45 UTC 
Verified, Thanks!
Note You need to log in before you can comment on or make changes to this bug.