Subject Re: Connection invalid error
Author krelwyn
--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...>

Daniel,

> Which middle-tier framework are you using?

I am using the RemObjects.com Data Abstract framework.

> Can you show us the code surrounding the error?

I'm not sure about this. The error occurs pretty much randomly when a
dataset is opened on the middle tier. The queries are all
straightforward, simple selects with no joins, and simple where
clauses. No stored procs. And the framework code is 3rd party, and I'm
sure I'm not allowed to post the source for that :)


> Is the statement prepared properly?

Yes, I have stepped through the framework code and have seen that it
does set the Prepared property of the query to true before the query
is executed.

> Do you know which statement that is being opened, when this happens?

Again, it's fairly random, but the vast majority of the time I see
this one fail (probably because it is called the most):

SELECT
SESSION_ID, CREATED_AT, LAST_ACCESSED, SESSION_DATA
FROM
SESSIONS
WHERE
SESSION_ID = :SESSION_ID


Jason