• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Incorrect Syntax near 'Contribution'

 
Mahendra Kariya
Greenhorn
Posts: 26
Firefox Browser Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I am using MS SQL Server 2008 as database. I downloaded the JDBC drivers from Microsoft's website.

I am running a query in my program.



This query is working fine sometimes. But when the user load increases, this query is failing. It is generating an exception:


I am not using the word 'Contribution' anywhere. I don't understand why this error is occurring? This doesn't occur every time. ONLY WHEN THERE IS LOAD ON THE SERVER.
How to solve this error?
 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know the answer but a first thing you must do is in sert the columns into the insert statement
so


this is just much safer code, and may make your problem go away.
Going to discover how to write a FAQ, "the column order isn't reliable".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic