error executing SQL statement from file

[Chadwiki]

I have upgraded to ES 1.0.1 and river-jdbc 1.0.0.1, from ES 0.90.1 river-jdbc 2.3.1.2 (running on windows)
I have been unable to get the old configuration working.

First, I see that the old statements that I pulled from /bin/analyticsmonthly.sql are not executing. Is there a change in providing SQL file?

Column 1 : [2014-03-17 12:19:52,932][DEBUG][org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource] executing SQL without params: statement=analyticsmonthly.sql parameter=[] callable=false Column 1 : [2014-03-17 12:19:52,923][DEBUG][org.xbib.elasticsearch.river.jdbc.RiverState] load state={"name":"jdbc","started":"2014-03-17T19:13:48.633Z","timestamp":"2014-03-17T19:13:48.648Z","counter":1,"active":true,"custom":{"riverName":"jdbc_river_analyticsmonthly","settings":{"type":"jdbc","jdbc":{"max_bulk_requests":30,"bulk_size":100,"index":"analytics","poll":"1h","poolsize":2,"sql":["analyticsmonthly.sql"],"strategy":"simple","driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver","autocommit":true,"type":"analyticsmonthly","bulk_flush_interval":"10s","password":"data","user":"data_services","url":"jdbc:sqlserver://qa.company.org:2080;databaseName=QA_Analytics;"}},"locale":"en_","job":null,"schedule":null,"interval":"-1","sql":["statement=analyticsmonthly.sql parameter=[] callable=false"],"autocommit":true,"fetchsize":10,"maxrows":0,"retries":3,"maxretrywait":"30s","columnCreatedAt":"created_at","columnUpdatedAt":"updated_at","columnDeletedAt":null,"columnEscape":true}}

This previously worked on the old version:
curl -XPUT 'http://elastictoad:9200/_river/jdbc_river_analyticsmonthly/_meta'
{
"type" : "jdbc",
"jdbc" : {
"driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",
"url":"jdbc:sqlserver://qa.company.org:2080;databaseName=QA_Analytics;",
"user" : "data_services",
"password" : "password",
"sql" : "analyticsmonthly.sql",
"index" : "analytics",
"type" : "analyticsmonthly",
"poolsize" : 2,
"bulk_size" : 100,
"max_bulk_requests" : 30,
"bulk_flush_interval" : "10s",
"poll" : "1h",
"strategy" : "simple",
"autocommit" : true
}
}'

[jprante]

Thanks, this is still open, I have to fix the statements from file.