java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter

I get error
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
for the following code, what is the wrong?

conn = getConnbyDM();
String sSQL = "INSERT INTO myTable";
sSQL += "(CATEGORY_NAME)";
sSQL += " VALUES (?)";
prepStat = conn.prepareStatement(sSQL);
prepStat.setString(1,cm.getCategoryName());
prepStat = conn.prepareStatement(sSQL);
int i=prepStat.executeUpdate();
LVL 9
william007Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
suprapto45Commented:
Hi,

Are you sure that myTable only contains one field (CATEGORY_NAME)? And is it VARCHAR?

David
0
 
objectsCommented:
whats the table schema?
0
 
Siva Prasanna KumarPrincipal Solutions ArchitectCommented:

conn = getConnbyDM();
String sSQL = "INSERT INTO myTable (CATEGORY_NAME)  VALUES (?)";
prepStat = conn.prepareStatement(sSQL);
prepStat.setString(1,cm.getCategoryName());
int i=prepStat.executeUpdate();

try the above program and as such prepStat = conn.prepareStatement(sSQL); was there twice in your previous program.

also for help check out this link.

http://javaalmanac.com/egs/java.sql/InsertPs.html
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
william007Author Commented:
Yes, is that extra line giving problem, thanks:-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.