This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes enter special characters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "enter special characters" Watch "enter special characters" New topic
Author

enter special characters

apurv suthar
Ranch Hand

Joined: Feb 05, 2012
Posts: 35
When I use query- "INSERT INTO tab_name VALUES(param1,param2)" and passes email as parameter it shows syntax error at char "@"... why? I know that this can be solved by using PreparedStatement... but if I wants to use same query..how to do it?
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1660
    
  14



No more Blub for me, thank you, Vicar.
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

chris webster wrote:


oh you think he had missed the quotes and it was trying to use them as column names, ahhh that makes sense
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

Wendy Gibbons wrote:oh you think he had missed the quotes and it was trying to use them as column names


Yeah, this commonly happens when people don't use PreparedStatement and try to build their SQL via string concatenation. Which is why you should always use PreparedStatement unless there's an extremely good reason why you can't.
apurv suthar
Ranch Hand

Joined: Feb 05, 2012
Posts: 35
Oh yah..I got it...sorry for my stupidity...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: enter special characters