Re: [Sqlrelay-discussion] Oracle error (ORA-01036)

[Jason M. <jmc...@gm...>]

I figured this out. The prepared statement only works on the same connection
daemon that it was initially prepared on.

That lead me to think that I could create a prepared statement per
connection cache and try to get the prepared statement from there if it
existed. In order to do that, I would need some way to uniquely identify
each connection.

I looked at sqlrcon_getConnectionPort and sqlrcon_getConnectionSocket, but
the documentation suggests that they are only valid after a
sqlrcon_suspendSession. It would seem wasteful to suspend a connection just
to resume it again.

Has anyone else implemented a prepared statement cache, or does anyone know
how to uniquely identify a connection?

Thanks,
Jason