0 Replies Latest reply on Dec 11, 2015 9:06 AM by KRISHNA KANAKALA

    Issue in inserting records using SQL Server

    KRISHNA KANAKALA Novice

      Hello,

       

      I'm facing issue with inserting data into SQL server database where as with Oracle was working fine.

      Just want to let you know for same database (SQL Sever - bean) select statement was working fine

       

      Stack trace: -

      org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'test'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'test'.

       

      Insert query: -

       

      insert into [xxxxxx].[dbo].[esb_customer] (CUSTOMERID,CUSTOMERNAME,CUSTOMERCITY,CUSTOMERPHONE) values ('test', 'test', 'test', 'test')

       

      Appreciated for quick responses.

       

      Thanks,

      Krishna