Hi,
I am having a hard time pinning down which function creates a prepared statement. Say in some language I create a Prepared Statement and send it off. Before the first time I execute the prepared statement, which function is the one that 'creates' the prepared statement. In other words, which function stores it. I know that StorePreparedStatement will cache it, but is there anything else.
e.g.
In your favorite language:
String statement = "Insert into table_one values 10";
PreparedStatement insert = con.prepareStatement(statement);
insert.execute()
The very first time, does it store this just in the plancache or does it do something different to 'know' it has stored a Prepared Statement, so next time it will invoke it.
Thanks,
Patrick