Help! Newbie needs help with simple JDBC calls

From: Gora Sudindranath <gora73175_at_yahoo.com>
Date: 5 May 2003 20:24:25 -0700
Message-ID: <91ce6f4f.0305051924.40b53d37@posting.google.com>

Hi,

I'm having problems with the following code:

		Question question = new Question();
		Connection con = null;
		Statement stmt = null;		
        try
        {
	    con = getConnection();
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT TEXT FROM
QUESTION WHERE QUESTION_ID = '" + id + "'");
            if(rs.next())
            {
            	question.setId(id);
                question.setText(rs.getString(1));
                loadAnswers(question);
            }
        }

My result set always returns empty, even though I can execute the query from toad and it returns one record. Any idea what is going on? I'm using the following config:

Tomcat 4.1
Oracle 8.1.7
Oracle Thin JDBC Driver

The SQL DDL for the table I am trying to select from is as follows:

CREATE TABLE QUESTION (

  QUESTION_ID  VARCHAR2 (10)  NOT NULL, 
  CATEGORY_ID  VARCHAR2 (10)  NOT NULL, 
  TEXT         VARCHAR2 (2000)  NOT NULL, 
  IS_ACTIVE    VARCHAR2 (1)  NOT NULL, 

  CREATE_DATE DATE,
   CONSTRAINT CK01_QUESTION
          CHECK (IS_ACTIVE IN ('Y', 'N')),   CONSTRAINT PK_QUESTION
  PRIMARY KEY ( QUESTION_ID )
    USING INDEX

     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 4096K NEXT 1024K PCTINCREASE 0 ))

   TABLESPACE USERS NOLOGGING
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE (
   INITIAL 4194304
   NEXT 1048576
   MINEXTENTS 1
   MAXEXTENTS 4096
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; ALTER TABLE QUESTION ADD CONSTRAINT FK01_QUESTION  FOREIGN KEY (CATEGORY_ID)
  REFERENCES NIKE_BEAUTIFUL.CATEGORY (CATEGORY_ID) ; Any help would be much appreciated!

Gora
gora73175_at_yahoo.com Received on Mon May 05 2003 - 22:24:25 CDT