You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jcs-dev@jakarta.apache.org by "Alistair Forbes (JIRA)" <ji...@apache.org> on 2007/03/12 12:57:09 UTC
[jira] Created: (JCS-20) Clear JDBC region cache
Clear JDBC region cache
-----------------------
Key: JCS-20
URL: https://issues.apache.org/jira/browse/JCS-20
Project: JCS
Issue Type: Bug
Components: JDBC Disk Cache
Reporter: Alistair Forbes
Assigned To: Aaron Smuts
Priority: Minor
Incorrect SQL generated in JDBCDiskCache.java when clear a region.
When clearing a cache with a key ending with a colon, the SQL has the syntax "where xxx = like 'key:'". The = causes an SQL syntax error.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jcs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jcs-dev-help@jakarta.apache.org
[jira] Closed: (JCS-20) Clear JDBC region cache
Posted by "Aaron Smuts (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCS-20?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aaron Smuts closed JCS-20.
--------------------------
> Clear JDBC region cache
> -----------------------
>
> Key: JCS-20
> URL: https://issues.apache.org/jira/browse/JCS-20
> Project: JCS
> Issue Type: Bug
> Components: JDBC Disk Cache
> Reporter: Alistair Forbes
> Assignee: Aaron Smuts
> Priority: Minor
> Attachments: JDBCDiskCache.diff
>
>
> Incorrect SQL generated in JDBCDiskCache.java when clear a region.
> When clearing a cache with a key ending with a colon, the SQL has the syntax "where xxx = like 'key:'". The = causes an SQL syntax error.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jcs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jcs-dev-help@jakarta.apache.org
[jira] Updated: (JCS-20) Clear JDBC region cache
Posted by "Alistair Forbes (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCS-20?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alistair Forbes updated JCS-20:
-------------------------------
Attachment: JDBCDiskCache.diff
> Clear JDBC region cache
> -----------------------
>
> Key: JCS-20
> URL: https://issues.apache.org/jira/browse/JCS-20
> Project: JCS
> Issue Type: Bug
> Components: JDBC Disk Cache
> Reporter: Alistair Forbes
> Assigned To: Aaron Smuts
> Priority: Minor
> Attachments: JDBCDiskCache.diff
>
>
> Incorrect SQL generated in JDBCDiskCache.java when clear a region.
> When clearing a cache with a key ending with a colon, the SQL has the syntax "where xxx = like 'key:'". The = causes an SQL syntax error.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jcs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jcs-dev-help@jakarta.apache.org
[jira] Commented: (JCS-20) Clear JDBC region cache
Posted by "Aaron Smuts (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCS-20?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481389 ]
Aaron Smuts commented on JCS-20:
--------------------------------
I'll apply the patch. Thanks.
> Clear JDBC region cache
> -----------------------
>
> Key: JCS-20
> URL: https://issues.apache.org/jira/browse/JCS-20
> Project: JCS
> Issue Type: Bug
> Components: JDBC Disk Cache
> Reporter: Alistair Forbes
> Assigned To: Aaron Smuts
> Priority: Minor
> Attachments: JDBCDiskCache.diff
>
>
> Incorrect SQL generated in JDBCDiskCache.java when clear a region.
> When clearing a cache with a key ending with a colon, the SQL has the syntax "where xxx = like 'key:'". The = causes an SQL syntax error.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jcs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jcs-dev-help@jakarta.apache.org
[jira] Resolved: (JCS-20) Clear JDBC region cache
Posted by "Aaron Smuts (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCS-20?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aaron Smuts resolved JCS-20.
----------------------------
Resolution: Fixed
I added the patch and a unit test to verify the fix. In SVN.
> Clear JDBC region cache
> -----------------------
>
> Key: JCS-20
> URL: https://issues.apache.org/jira/browse/JCS-20
> Project: JCS
> Issue Type: Bug
> Components: JDBC Disk Cache
> Reporter: Alistair Forbes
> Assigned To: Aaron Smuts
> Priority: Minor
> Attachments: JDBCDiskCache.diff
>
>
> Incorrect SQL generated in JDBCDiskCache.java when clear a region.
> When clearing a cache with a key ending with a colon, the SQL has the syntax "where xxx = like 'key:'". The = causes an SQL syntax error.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jcs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jcs-dev-help@jakarta.apache.org