This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes EJB und MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB und MySQL" Watch "EJB und MySQL" New topic
Author

EJB und MySQL

Georg Joo
Ranch Hand

Joined: Feb 24, 2004
Posts: 49
Hi
I am using J2EE Sun Server, Mysql with its MySQL Connector/J 3.0.
Everything goes ok (deploying,..)
Statement :
Aussteller aussteller = home.create(args[1], args[2]);
But I get the following exception message :
RemoteException occurred in server thread; nested exception is: java.rmi.RemoteException: nested exception is: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"AusstellerBeanTable" WHERE "ausstellername" = 'ich'' at line 1"; nested exception is: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"AusstellerBeanTable" WHERE "ausstellername" = 'zob'' at line 1"
Where can I change the syntax for MySQL Statements (ejbCreate,..)
I have changed the finders, the are ok.
thanks
Georg


SCJP, SCWCD, SCBCD<br /> <br />Vienna, Austria
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: EJB und MySQL
 
Similar Threads
preapareStatement with condition
Problems with creating table in mysql through JSP
Can't execute prepared statements using mySQL
MySQL error
Configuring the Datasource forJBOSS