request error when trying to get own task using the explorer

[livingst]

Hi,

I start the h2 server
I start the tomcat server.

I have launched the demo.setup ant script.

I connect to activiti-explorer using the "fozzie" user.
I got a lot of sql error in the error log of tomcat windows like this:


### The error may exist in org/activiti/db/ibatis/task.mapping.xml
### The error may involve org.activiti.persistence.dynamicSelectTask
### The error occurred while executing a query
### SQL: ┬á ┬áselect distinct(T.*)  ┬á ┬á        from ACT_TASK T            WHERE  T.ASSIGNEE_ = ?       ┬á ┬áorder
D_  ┬á
### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "┬

á ┬áSELECT DISTINCT(T.*)

   
    FROM ACT_TASK T

     WHERE  T.ASSIGNEE_ = ?

   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
   
    from ACT_TASK T

     WHERE  T.ASSIGNEE_ = ?

   order by ID_
  [42000-132]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.message.DbException.getSyntaxError(DbException.java:179)

any idea ?

Thanks.

[livingst]

We are blocked. any one for help ? Many thanks.

[jcosano]

This error was in alpha 2…. and solution:

——————————————————————
You can explicitly set the encoding in the tomcat startup.bat file.
Insert as first line:
set JAVA_OPTS=-Dfile.encoding=UTF-8

[livingst]

It works now ! Thanks.

[jbarrez]

The bug should be removed in alpha 3? Can you confirm that you were using alpha 2?

[livingst]

I confirm : I'm using activiti-5.0.alpha2