Re: JSP/Oracle9i: SQLException

HarryB wrote:
> I'm getting a SQLException Invalid Column Name in a JSP - but the query
> works fine if I run it from SQL*Plus. I'm new at JSP, is there something
> basic about SQL commands I'm missing?
>
> Here's the statement:
>
> Statement stmt = conn.createStatement();
> ResultSet rs = stmt.executeQuery(
> "SELECT INIT_BY, TRANS_ID, SFY," +
> "REC_TYPE, ACTION, STATUS, DATE_CREATED, DATE_CLOSED, ERR_MSG," +
> "CHAR_1, CHAR_2, CHAR_3, CHAR_4, CHAR_5, CHAR_6," +
> "CHAR_7, CHAR_8, CHAR_9, CHAR_10, CHAR_11, CHAR_12," +
> "CHAR_13, CHAR_14, CHAR_15, CHAR_16, CHAR_17, CHAR_18," +
> "CHAR_19, CHAR_20, CHAR_21, CHAR_22, CHAR_23, CHAR_24," +
> "CHAR_25, CHAR_26, CHAR_27, CHAR_28, CHAR_29, CHAR_30," +
> "CHAR_31, CHAR_32, CHAR_33, NUM_1, NUM_2, NUM_3, " +
> "NUM_4, NUM_5, DATE_1, DATE_2 " +
> "FROM BP2K_TRANSFER_DATA " +
> " order by INIT_BY, TRANS_ID desc "
> );
>
> Thanks,
> Harry

Are you connecting to the same database using the same login /password
in both cases? Sometimes schema objects may look almost the same, but
tables can have different columns

.