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 simple error 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 "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
I agree. Here's the link:
subject: simple error
It's not a secret anymore!