SourceForge.net Logo
Main Overview Wiki Issues Forum Build Fisheye
Issue Details (XML | Word | Printable)

Key: CMP-325
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Shay Banon
Reporter: Alexey Kharlamov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Compass

Bug in JdbcTable

Created: 01/Dec/06 02:57 AM   Updated: 01/Dec/06 10:41 AM
Component/s: Compass::Core
Affects Version/s: 1.1 M3
Fix Version/s: 1.1 RC1

Environment: JBoss 4.0.4, MySQL Connect/J 5.0.4


 Description  « Hide
In JdbcTable the following lines should changed:
sqlDeletaMarkDeleteByDelta = sb.append("delete from ").append(getQualifiedName())
.append(" where ").append(deletedColumn.getQuotedName()).append(" = ?")
.append("and ").append(lastModifiedColumn.getQuotedName()).append(" < ?").toString();

to:

sqlDeletaMarkDeleteByDelta = sb.append("delete from ").append(getQualifiedName())
.append(" where ").append(deletedColumn.getQuotedName()).append(" = ?")
.append(" and ").append(lastModifiedColumn.getQuotedName()).append(" < ?").toString();

NOTE: Additional space before 'and' at the last row. The MySQL JDBC driver is unable to parse request without the space correctly.



 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.