Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sun app server and mysql configuration

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