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

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

What database are you using?

brant.felix 10 years ago

I am using SQL Express 2014 with latest service pack.

Anton Tananaev 10 years ago

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

brant.felix 10 years ago

Is this something that I can fix?

Anton Tananaev 10 years ago

I need to see the query first.

brant.felix 10 years ago

Is there anything I can send or post?

Anton Tananaev 10 years ago

Your config.

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

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

brant.felix 10 years ago

Yes, this is definitely the running config.

Anton Tananaev 10 years ago

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

brant.felix 10 years ago

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

Anton Tananaev 10 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 10 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.