Log warning: "WARN: The statement must be executed ..."

brant.felix9 years ago

What does this warning mean? I see it constantly in the log files.

WARN: The statement must be executed before any results can be obtained. - SQLServerException (... < QueryBuilder:445 < DataManager:292 < DefaultDataHandler:27 < ...)
Anton Tananaev9 years ago

What database are you using?

brant.felix9 years ago

I am using SQL Express 2014 with latest service pack.

Anton Tananaev9 years ago

Looks like there is some problem with "database.insertPosition" query.

brant.felix9 years ago

Is this something that I can fix?

Anton Tananaev9 years ago

I need to see the query first.

brant.felix9 years ago

Is there anything I can send or post?

Anton Tananaev9 years ago

Your config.

brant.felix9 years ago
...

    <entry key='database.insertPosition'>
        INSERT INTO positions (deviceId, protocol, serverTime, deviceTime, fixTime, valid, latitude, longitude, altitude, speed, course, address, attributes)
        VALUES (:deviceId, :protocol, :now, :deviceTime, :fixTime, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :attributes);
    </entry>

...
Anton Tananaev9 years ago

It looks fine to me. Are you absolutely sure that's the config that you are using?

brant.felix9 years ago

Yes, this is definitely the running config.

Anton Tananaev9 years ago

I did some research and it looks like you have to update the JDBC driver that you are using.

brant.felix9 years ago

I loaded the latest sqljdbc42.jar driver (sept 30, 2016 release) and no difference.

Anton Tananaev9 years ago

I would recommend to use JDBC version 4.1. I don't have any other ideas at the moment. I can take a look at your server if you provide connection details.

brant.felix9 years ago

I will try this version out at the end of the day here and let know you what my results are.

Thanks again.