Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

sun app server and mysql configuration  RSS feed

Giju George
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 !!!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!