wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes sun app server and mysql configuration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "sun app server and mysql configuration" Watch "sun app server and mysql configuration" New topic
Author

sun app server and mysql configuration

Giju George
Ranch Hand

Joined: Jun 08, 2004
Posts: 333
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 !!!


SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCEA
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sun app server and mysql configuration