Help with Error

**Atia of the julii** · 12-02-2011, 05:39 PM

When I run the following code I am getting this error... please can someone advise. (I have a similar question in the database section of the forum but there are significantly fewer users looking there!)

Thanks

ERROR

Java Code:

SQL StatementSELECT English FROM smsdb1 WHERE SMS = ?
Prepared Statementorg.sqlite.PrepStmt@199a0c7c
Prepared Statementorg.sqlite.PrepStmt@199a0c7c
java.sql.SQLException: no such column: 'id'
	at org.sqlite.RS.findColumn(RS.java:116)
	at org.sqlite.RS.getString(RS.java:247)
	at PreparedStatementParameter.main(PreparedStatementParameter.java:26)

My database setup is as follows

Java Code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
public class PreparedStatementParameter {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement prepStmt = null;
        ResultSet rs = null;
        try {
            Class.forName("org.sqlite.JDBC");
            conn = DriverManager.getConnection("jdbc:sqlite:C:\\smsdb1.sqlite");  
            String sqlStmt = "SELECT English FROM smsdb1 WHERE SMS = ?";
            System.out.println("SQL Statement" + sqlStmt);
            prepStmt = conn.prepareStatement(sqlStmt);
            System.out.println("Prepared Statement" + prepStmt.toString());
 
            prepStmt.setString (1, "2nite");  
            System.out.println("Prepared Statement" + prepStmt.toString());
            rs = prepStmt.executeQuery();
            while (rs.next()) {
                String id = rs.getString("id");
                String English = rs.getString("English");
                System.out.println("Translation: " + id + ", Proper English: " + English );
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null)
                    rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                if (prepStmt != null)
                    prepStmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                if (conn != null)
                    conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

**KevinWorkman** · 12-02-2011, 05:41 PM

Please don't post multiple copies of the same question.

But the error message seems pretty self-explanatory. Where is your "id" column?

**Atia of the julii** · 12-02-2011, 05:51 PM

I know, I apologise, it's just because of the frustration when I've been working on it all day and there are hardly any members in the other forum.

I have created an 'id' column though haven't I? It shows it in the image? Have I done this wrong?

Thanks