IBM Support

PI18502: ERROR "INCORRECT SYNTAX NEAR KEYWORD <RESERVED WORD>" WHEN ADDING TABLE TO DATABASE STUB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you attempt to add a table to a stub database and that table
    contains a reserved word such as "table" it fails with the error
    "incorrect syntax near keyword  <reserved word>"
    
    The JVM console shows the following:
    
    com.ghc.ghTester.gui.dbstub.AbstractEditAction handleException
                              WARNING: Action handing exception
    
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect
    syntax near the keyword 'table'.
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabase
    Error(SQLServerException.java:216)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQ
    LServerStatement.java:1515)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStateme
    nt(SQLServerStatement.java:792)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doEx
    ecute(SQLServerStatement.java:689)
                                    at
    com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:56
    96)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(
    SQLServerConnection.java:1715)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(S
    QLServerStatement.java:180)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement
    (SQLServerStatement.java:155)
                                    at
    com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServe
    rStatement.java:662)
                                    at
    com.ghc.ghTester.gui.dbstub.AddTableWizardPanel.processCopyTable
    (AddTableWizardPanel.java:280)
                                    at
    com.ghc.ghTester.gui.dbstub.AddTableWizardPanel.process(AddTable
    WizardPanel.java:206)
                                    at
    com.ghc.ghTester.gui.dbstub.AbstractWizardPanel.processFinish(Ab
    stractWizardPanel.java:120)
                                    at
    com.ghc.wizard.Wizard$2.run(Wizard.java:580)
                                    at
    org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester who are using JDBC  *
    * (database) stubs.                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If a user attempts to add a database table to a JDBC         *
    * (database) stub and that table contains columns whose names  *
    * are reserved database words (such as "table" or "column")    *
    * then an error will occur.                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • This problem was caused because Rational Integration Tester was
    not recognizing the reserved words and didn't escape them
    correctly. This problem has been resolved in version 8.6.0.1 of
    RIT and tables containing reserved words as columns can now be
    added to JDBC stub.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI18502

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    851

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-22

  • Closed date

    2014-09-01

  • Last modified date

    2014-09-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    RATL INTEGRA TE

  • Fixed component ID

    5725G79IT

Applicable component levels

  • R800 PSN

       UP

  • R801 PSN

       UP

  • R850 PSN

       UP

  • R851 PSN

       UP

  • R860 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBLQQ","label":"Rational Test Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 October 2021