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 Help!!!!!******* java.sql.SQLException******** 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 "Help!!!!!******* java.sql.SQLException********" Watch "Help!!!!!******* java.sql.SQLException********" New topic

Help!!!!!******* java.sql.SQLException********

sam patel
Ranch Hand

Joined: Jun 13, 2002
Posts: 103
I using an Applet-Servlet communication. This is what i am doing...
I am searching in DB using a POLICYNUMBER; from that POLICY# i get all the information about that person.
The first time i search, i get the info but.... if i search for another POLICYNUMBER then i get this error....
java.sql.SQLException: [INTERSOLV][ODBC InterBase driver]Data type for parameter
1 has changed since first SQLExecute call.

Can someone please tell me what am i doing wrong and how can i make this disappear.
I greatly appreciate your help.....
Thanks in advance...
sam patel
Ranch Hand

Joined: Jun 13, 2002
Posts: 103
One more thing is i am using PreparedStatement.... When i used a Statement it worked fine, but i am getting error with PrepareStatement
Paul Stevens
Ranch Hand

Joined: May 17, 2001
Posts: 2823
Moving to JDBC. You might get a response there.
Piyush Daiya
Ranch Hand

Joined: Jun 13, 2002
Posts: 67
Hi sam,
It looks like datatype mismatch.Check the datatypes of your database and corresponding java types.


"A scientist is not person who gives right answers but a person who asks right questions"
sim sim
Ranch Hand

Joined: Jun 05, 2002
Posts: 55
Hi Sam
If u can paste the code, it would be more helpful.
I agree. Here's the link:
subject: Help!!!!!******* java.sql.SQLException********
It's not a secret anymore!