Forums Register Login

Too few paramters

+Pie Number of slices to send: Send
Hi,
When I parse this code:
Select name frome employees where name="smith"; in MS-access, the result is, obviously, a field with the name smith (if it exists)
However, when I use former mentioned query in the following line
ResultSet rs = stmt.executeQuery(query);
I get a 'too few parameters, expected 1" error. DSN and other stuff is good because query 'select name from employees;' works fine.
I try'd PreparedStatement as was told somewhere else in this group, but then I'll get 'Driver does not support this function'.
Using Visual Age for Java 3.5 on W2K and trying to access MS-access2k, standard sun's jdbc-odbc driver.
any help is welcome,
grtz,
Lex
+Pie Number of slices to send: Send
How are you building the statement?
What does the Query statement look like before you send it?
+Pie Number of slices to send: Send
I finally got it working using PreparedStatement.
Now I know, ms-access probably needs prepared statements.
This is working:
String query = "Select name From Employees Where name=?;";
PreparedStatement pst = con.prepareStatement(query);
pst.setString(1,request.getParameter("name"));
Building the string direct (" ....where name=\"" + name + " \";"; ) and passing it to a normal statement doesn't work.
Now I need to know how I can make the ResultSet updateable;
creation of the resultset via PreparedStatement doesn't give the possibillity to give params UPDATABLE etc. like creation via Statement does.
L.

Too many men are afraid of being fools - Henry Ford. Foolish tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 803 times.
Similar Threads
an SQLException
Problem with Like statement Using JDBC:ODBC
How to Insert data into MS Access?
java sqlexception
Java sqlexception definition
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 10:44:29.