dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Ouch. Fixed in 2.12 and 2.11 now.

Lars



On Thu, Jul 25, 2013 at 9:10 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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
>
>