Hi I have deployed an entity bean in sun app server and have used the sun studio for development. I have created a connection pool to mysql db in the sun server. Now, when i try to run a findByPK method.. it gives me error.
I've got a table called Product in the database. Now the sql that the container generates looks something like this :- Select t0."ID" from PRODUCT t0.
But this '"' around the fields causes a problem with the mysql db, and it gives me error saying the syntax in wrong.
I changed the conn pool to oracle and it WORKS FINE. Coz, oracle db don't have any problem with this '"'.
Now, how do I get rid of this '"' from the sql or is there a way around to get this working in MY-SQL. Will the sql be the same if I deploy in another server , say JBoss.