sun app server and mysql configuration

[Giju George]

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.

Pls help !!!