com.teradata.datatools.util.dao.DAOException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.09] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WHERE' keyword.

teradata.com | 4 months ago
  1. 0

    Teradata Studio Express | Teradata Developer Exchange

    teradata.com | 4 months ago
    com.teradata.datatools.util.dao.DAOException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.09] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WHERE' keyword.

    Root Cause Analysis

    1. com.teradata.datatools.util.dao.DAOException

      java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.09] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WHERE' keyword.

      at com.teradata.datatools.util.dao.JdbcDAO.prepareStatement()
    2. com.teradata.datatools
      TeradataCatalogSchema.getTables
      1. com.teradata.datatools.util.dao.JdbcDAO.prepareStatement(JdbcDAO.java:178)
      2. com.teradata.datatools.util.dao.JdbcDAO.parametizedListMapQuery(JdbcDAO.java:679)
      3. com.teradata.datatools.util.dao.JdbcDAO.runQuery(JdbcDAO.java:652)
      4. com.teradata.datatools.dao.TeradataCatalogDAO.loadTables(TeradataCatalogDAO.java:437)
      5. com.teradata.datatools.dtp.catalog.TeradataCatalogSchema.loadTables(TeradataCatalogSchema.java:1552)
      6. com.teradata.datatools.dtp.catalog.TeradataCatalogSchema.getTables(TeradataCatalogSchema.java:757)
      6 frames
    3. org.eclipse.datatools.modelbase.sql_1.0.6.v201208230744.jar
      SchemaImpl.eGet
      1. org.eclipse.datatools.modelbase.sql.schema.impl.SchemaImpl.eGet(SchemaImpl.java:597)
      1 frame