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: CLOSED UPSTREAM
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: 2025-02-10 03:27 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2025-02-10 03:27:11 UTC
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!
Comment 13 Red Hat Bugzilla 2025-02-10 03:27:11 UTC 
This product has been discontinued or is no longer tracked in Red Hat Bugzilla.
Note You need to log in before you can comment on or make changes to this bug.