The moose likes JDBC and Relational Databases and the fly likes simple error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "simple error" Watch "simple error" New topic

simple error

Gopi Krrishna

Joined: Feb 15, 2006
Posts: 12
Given is the simple code to add ip address in the table named ip_table
which it creates..
but i am unable to successfully add the data into the table..
i am getting the error as
"too few parameters. expected 1"

please help

SCJP 1.4
Roy Simon
Ranch Hand

Joined: Aug 26, 2005
Posts: 62
There is a syntax error in your query
//statement.execute("insert into ip_table values(address)")

this should be
string query = "insert into ip_table values('" + address + "')";

[ March 08, 2007: Message edited by: Roy Simon ]
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

First question: why are you using the JDBC:ODBC bridge? Does your database not provide a better driver?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
jQuery in Action, 3rd edition
subject: simple error
It's not a secret anymore!