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

brant.felix8 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 Tananaev8 years ago

What database are you using?

brant.felix8 years ago

I am using SQL Express 2014 with latest service pack.

Anton Tananaev8 years ago

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

brant.felix8 years ago

Is this something that I can fix?

Anton Tananaev8 years ago

I need to see the query first.

brant.felix8 years ago

Is there anything I can send or post?

Anton Tananaev8 years ago

Your config.

brant.felix8 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 Tananaev8 years ago

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

brant.felix8 years ago

Yes, this is definitely the running config.

Anton Tananaev8 years ago

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

brant.felix8 years ago

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

Anton Tananaev8 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.felix8 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.