dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Lars,
I think you introduced a new bug here as the UNION statement is now
incomplete and throws this.

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/routineDataValue.sqlmap.xml.
--- The error occurred while executing query.
--- Check the           SELECT COUNT(*) FROM RoutineData WHERE EntryNumber
> 2147483647 UNION   .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Syntax error in query.  Incomplete query clause.
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Syntax error in query.  Incomplete query clause.

Best regards,
Jason




On Fri, Jul 19, 2013 at 7:47 PM, <noreply@xxxxxxxxxxxxx> wrote:

> ------------------------------------------------------------
> revno: 11453
> committer: Lars Helge Øverland <larshelge@xxxxxxxxx>
> branch nick: dhis2
> timestamp: Fri 2013-07-19 19:47:03 +0200
> message:
>   1.4 file import, fixed bug related to checking for routine data values
> out of range.
> modified:
>
> dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml
>
>
> --
> lp:dhis2
> 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
>
> === modified file
> 'dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml'
> ---
> dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml
>        2013-02-04 17:48:14 +0000
> +++
> dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml
>        2013-07-19 17:47:03 +0000
> @@ -40,7 +40,6 @@
>
>         <select id="getRoutineDataValuesOutOfRange"
> resultClass="java.lang.Integer">
>                 SELECT COUNT(*) FROM RoutineData WHERE EntryNumber >
> 2147483647 UNION
> -               SELECT COUNT(*) FROM RoutineDataArchive WHERE EntryNumber
> > 2147483647
>         </select>
>
>  </sqlMap>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>