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

Problem while inserting data into MS SQL Server 2005.

 
Kannan Raman
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
 
Kannan Raman
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry all,
Before mentioning the problem,the connection was lost.I am extremely sorry for that.

I have developed a portal for a Quiz application.I am using JSP as front end and MS SQL Server as backend.

I am encrypting both the question and correct answer.While I am trying to store these details into the database I am getting a SQL exception.

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near '_vm'.

I fixed the issue.The reason for the problem is,While encrypting the text it will insert the ' & " .While trying to insert that into DB,the SQL server is trigerring this exception.

The data type of the field in the database is varchar2(1000).

Please help me to resolve this.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can we see your code?
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic