I have some doubts regarding preparedstatement.
1. Who will do the pre compilation for this kind of statement.
2. below is some code snippet:
PreparedStatement ps=conn.preparedStatement("insert into tableA values(?,?)");
some java code
PreparedStatement ps1=conn.preparedStatement("insert into tableA values(?,?)");
Now as both ps and ps1 contain the same SQL query so is there any compilation for ps1?
3. if we call close() method of preparedStatement then will that precompile statement also wipeout from Database.
Please clarify and also thanks in advance!!