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.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via teradata.com by Unknown author, 1 year ago
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.
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(JdbcDAO.java:178)
at com.teradata.datatools.util.dao.JdbcDAO.parametizedListMapQuery(JdbcDAO.java:679)
at com.teradata.datatools.util.dao.JdbcDAO.runQuery(JdbcDAO.java:652)
at com.teradata.datatools.dao.TeradataCatalogDAO.loadTables(TeradataCatalogDAO.java:437)
at com.teradata.datatools.dtp.catalog.TeradataCatalogSchema.loadTables(TeradataCatalogSchema.java:1552)
at com.teradata.datatools.dtp.catalog.TeradataCatalogSchema.getTables(TeradataCatalogSchema.java:757)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.