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