Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
sam patel
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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
Posts: 103
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC. You might get a response there.
 
Piyush Daiya
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi sam,
It looks like datatype mismatch.Check the datatypes of your database and corresponding java types.

Piyush
 
sim sim
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sam
If u can paste the code, it would be more helpful.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic