Results 1 to 3 of 3
  1. 09-27-2011, 12:14 PM #1
    nandhinianand's Avatar
    nandhinianand
    nandhinianand is offline Member
    Join Date
    Jul 2011
    Location
    India,Tamil Nadu
    Posts
    32
    Rep Power
    0

    Smile java.sql.SQLException:

    Java Code: 
    String g="FUP1UN";
sql[1]=" select Confidence from cpm1 where Combinedrule= "+g;
    java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'FUP1UN'
    i am Sql using 2000.
    But,

    Java Code: 
    sql[1]=" select Confidence from cpm1 where Combinedrule='FUP1UN'";
    This code executed successfully.
    Last edited by nandhinianand; 09-27-2011 at 12:19 PM.
    Reply With Quote Reply With Quote
  2. 09-27-2011, 03:50 PM #2
    doWhile
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,606
    Rep Power
    5

    Default Re: java.sql.SQLException:

    Note the difference between the two Strings...in particular the single quotes. Avoid this necessity by using PreparedStatement.
    Reply With Quote Reply With Quote
  3. 09-28-2011, 07:15 AM #3
    nandhinianand's Avatar
    nandhinianand
    nandhinianand is offline Member
    Join Date
    Jul 2011
    Location
    India,Tamil Nadu
    Posts
    32
    Rep Power
    0

    Default Re: java.sql.SQLException:

    Respected senior member,
    Thank you .
    Reply With Quote Reply With Quote
« noob question. plz help tho! | Sub class and super class »

Similar Threads

  1. java.sql.sqlException
    By harsimran05 in forum JDBC
    Replies: 1
    Last Post: 09-06-2011, 12:14 PM
  2. java.sql.SQLException: Invalid column name
    By agangaia in forum JDBC
    Replies: 7
    Last Post: 04-14-2011, 01:06 PM
  3. java.sql.SQLException: System or internal error java.io.IOException: Stream closed
    By ashok bhagat in forum Advanced Java
    Replies: 0
    Last Post: 01-21-2011, 12:43 PM
  4. java.sql.SQLException: Exhausted Resultset
    By boy22 in forum JDBC
    Replies: 2
    Last Post: 06-07-2010, 08:45 AM
  5. Unreported exception java.sql.SQLException
    By javamula in forum AWT / Swing
    Replies: 4
    Last Post: 09-29-2009, 02:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules