Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic