File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Cattle Drive and the fly likes jdbc and apostrophes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » This Site » Cattle Drive
Bookmark "jdbc and apostrophes " Watch "jdbc and apostrophes " New topic

jdbc and apostrophes

Pauline McNamara

Joined: Jan 19, 2001
Posts: 4012
For the jdbc assignments is it considered overkill to deal with titles, stars or descriptions with ' in the text? For example, a title like My Best Friend's Dog or a star like Rosie O'Donnell breaks the SQL. Should those ' be escaped first or does one KISS it off?

Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9043
I think it is a good thing if your code can handle that situation, but it's not required to pass the assignment.

"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
I agree. Here's the link:
subject: jdbc and apostrophes
Similar Threads
Loading file data into a DB2 table using java
Need guidance for SCJD exam preparation
java sql parser
"Invalid Packet length" Error
Need help to write a bot to collect data from internet.