Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Java
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
Posted 25-Sep-12 5:54am
Edited 25-Sep-12 7:03am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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',
          '-')
Refer: http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htm[^]
  Permalink  
Comments
maheshpardeshi at 26-Sep-12 3:59am
   
hi sandeep there is problem with colon in time data like '{14:15:60}'
maheshpardeshi at 26-Sep-12 3:59am
   
synax erreor is there
Sandeep Mewara at 26-Sep-12 4:07am
   
I shared a link with you on how to escape special characters. Did you go through it? It explains all.
 
Try:
'10\:34\:57' for time, escaping specific character.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Dnyaneshwar@Pune 604
1 thatraja 370
2 OriginalGriff 319
3 Sergey Alexandrovich Kryukov 241
4 Gihan Liyanage 194
0 OriginalGriff 737
1 Dnyaneshwar@Pune 604
2 Kornfeld Eliyahu Peter 505
3 Sergey Alexandrovich Kryukov 372
4 thatraja 370


Advertise | Privacy | Mobile
Web02 | 2.8.140902.1 | Last Updated 25 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100