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

brant.felix 9 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 Tananaev 9 years ago

What database are you using?

brant.felix 9 years ago

I am using SQL Express 2014 with latest service pack.

Anton Tananaev 9 years ago

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

brant.felix 9 years ago

Is this something that I can fix?

Anton Tananaev 9 years ago

I need to see the query first.

brant.felix 9 years ago

Is there anything I can send or post?

Anton Tananaev 9 years ago

Your config.

brant.felix 9 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 Tananaev 9 years ago

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

brant.felix 9 years ago

Yes, this is definitely the running config.

Anton Tananaev 9 years ago

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

brant.felix 9 years ago

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

Anton Tananaev 9 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.felix 9 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.