------------------------------------------------------------
revno: 173
committer: Lars Helge Oeverland [email protected]
branch nick: trunk
timestamp: Tue 2009-04-14 18:28:23 +0200
message:
dhis-service-jdbc: Fixed bug related to H2 sql syntax
modified:
dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java
=== modified file
'dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java'
---
dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java
2009-04-07 18:32:17 +0000
+++
dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java
2009-04-14 16:28:23 +0000
@@ -229,9 +229,10 @@
{
return
"DELETE FROM period " +
- "USING periodtype " +
- "WHERE period.periodtypeid = periodtype.periodtypeid " +
- "AND periodtype.name = '" + RelativePeriodType.NAME + "';";
+ "WHERE periodtypeid IN ( " +
+ "SELECT periodtypeid " +
+ "FROM periodtype " +
+ "WHERE periodtype.name = '" + RelativePeriodType.NAME + "' );";
}
public String getDeleteZeroDataValues()
--
Trunk
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription.
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
