Java sql中插入命令时出错 [英] error in insert into command in java sql

问题描述

朋友，我在插入到java.sql.SQLException的命令中遇到错误:[Microsoft] [ODBC Microsoft Access驱动程序] INSERT INTO语句中的语法错误.
我的琴弦是

hi friend i am getting an error in insert into command that is java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
my string is

insert into Unique_ASR_Errors(SLNO,ERR_DATE,Time,ASR,ICSC,TYPE_EVC_UNI,ERR_CODE,ERR_MSSG,COMPLETED,COMPLETED_DATE,CANCELLED,CANCELLED_DATE,FOC,FOC_DATE,EIPOC_INVOLVED,CNO,PON,ACNA,MOBILITY,PENDING,PENDING_START_DATE) values('18964.0','06/09/2011','10:34:57','1.015410003E9','SW30','PORT','INTEX181','(22/VLXP/400130/SB)UNI Circuit ID Uniqueness Validation in New UNI Order failed same UNI Circuit ID exist in Inventory','X','05/08/2012 00:00:00','N','-','N','-','N','1-8B3SR0','A5C0010A-2','WCG','N','N','-')

请帮我，如果语法错误，我将无法找出错误

please help me i am not able to find out error wha is error in syntax

推荐答案

Try:

Try:

INSERT INTO
     Unique_ASR_Errors
         (SLNO, 
          ERR_DATE, 
          Time, 
          ASR,
          ICSC,
          TYPE_EVC_UNI,
          ERR_CODE,
          ERR_MSSG,
          COMPLETED,
          COMPLETED_DATE,
          CANCELLED,
          CANCELLED_DATE,
          FOC,
          FOC_DATE,
          EIPOC_INVOLVED,
          CNO,
          PON,
          ACNA,
          MOBILITY,
          PENDING,
          PENDING_START_DATE) 
      VALUES 
          ('18964.0',
          '{06/09/2011}',
          '{10:34:57}',
          '1.015410003E9',
          'SW30',
          'PORT',
          'INTEX181',
          '{(22/VLXP/400130/SB)UNI Circuit ID Uniqueness Validation in New UNI Order failed same UNI Circuit ID exist in Inventory}',
          'X',
          '{05/08/2012 00:00:00}',
          'N',
          '-',
          'N',
          '-',
          'N',
          '1-8B3SR0',
          'A5C0010A-2',
          'WCG',
          'N',
          'N',
          '-')

请参阅: http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htm [ ^ ]

Refer: http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htm[^]

这篇关于Java sql中插入命令时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！