Doubt in JDBC

[ChakraPani Margani]

Hai to all members,
First of all thanks to Mr.Krishna Moorthy for sending the clarification to me.

while I running the program I got a RUN TIME Error.

The line at which I face problem is


rs=st.executeQuery("select * from uin where NUM="+UIN);


Here UIN is a string value.

NUM in the database is varchar2 type.

The exception is:Invalid column name..

please clarify my doubt.

Regards,
ChakraPani.M

[Alice Corman]

Literal string values must be enclosed in single quotes. Otherwise, the database may assume the string is a column name. Try

Edit: added code tags

rs=st.executeQuery("select * from uin where NUM = '"+ UIN +"'");

[ August 25, 2007: Message edited by: Alice Corman ]