I use JBuilder to edit my code, and that pretty much tells me where to put
in my escapes in my SQL code which has come in handy. Not sure what editor
you use or if you have an editor that helps you in that area, but this
would be my guess on your problem.
Jackie
On Wednesday, May 16, 2001 3:18 PM, Mark Phelps [SMTP:[EMAIL PROTECTED]]
wrote:
> When you create an SQL statement in JDBC you should not include the
> semicolon at the end of the line. Also the apostrophe in "Natasha's" may
be
> giving you problems. You may need to remove it or use \' or something
like
> that.
>
> -----Original Message-----
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 12:42 PM
> To: JRun-Talk
> Subject: Going crazy w/ something the should work, SQL + Java problem
>
>
> I've been playing with Java and ODBC for a few days now and I've run into
a
> brickwall with something. I have an app that reads in a text file, parses
> it, and creates a SQL statement out it. I've hard coded the columns and I
> know the line format, so it's really just a "one time deal" type script,
but
> something is going wrong. For some reason this string is giving me a SQL
> error.
>
> java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Unclosed quotation mark before the character string 'eng'.
> insert into
>
tblMp3s(Filename,Version,Title,Artist,Album,YearReleased,Comment,Track,G
enre
> ) values('f:\music\sleeping_jesus.mp3','2','Sleeping Jesus','Natasha''s
> ghost','Everything Under The Moon',1999,'eng
> http://mp3.com/NatashasGhost',0,'');
>
> As far as I can tell this is valid SQL. I even cut and pasted into CF and
it
> worked fine. Any clues as to why this would work in CF but fail in Java?
>
> (Here is a snippet of the code running the statement: (statements is a
> Vector of insert statements)
>
> try {
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection con =
> DriverManager.getConnection("jdbc:odbc:MP3Music;UID=sa;PWD=");
> Statement stmt = con.createStatement();
> for(int i = 0; i < statements.size(); i++) {
> String statement = (String)statements.get(i);
> try {
> int x = stmt.executeUpdate(statement);
> } catch (Exception e) {
> System.out.println(e);
> System.out.println(statement);
> }
> }
> con.close();
> } catch (Exception e) {
> System.out.println(e);
> System.out.println(temp);
> }
>
>
> =======================================================================
> Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>
> Email : [EMAIL PROTECTED]
> ICQ UIN : 3679482
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
