File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Doubt in JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Doubt in JDBC" Watch "Doubt in JDBC" New topic

Doubt in JDBC

ChakraPani Margani

Joined: Aug 19, 2007
Posts: 19
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.

Alice Corman

Joined: Jun 21, 2006
Posts: 19
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

[ August 25, 2007: Message edited by: Alice Corman ]
I agree. Here's the link:
subject: Doubt in JDBC
It's not a secret anymore!