DB2 exception: Cannot create PoolableConnectionFactory SQLCODE=-142

简介: DB2 exception: Cannot create PoolableConnectionFactory SQLCODE=-142

While you say that this is a “simple query”, the exception error code mentions the following:

-142

THE SQL STATEMENT IS NOT SUPPORTED

Explanation

An SQL statement was detected that is not supported by the database. The statement might be valid for other IBM® relational database products or it might be valid in another context. For example, statements such as VALUES and SIGNAL or RESIGNAL SQLSTATE can be used only in certain contexts, such as in a trigger body or in an SQL Procedure.



System action

The statement cannot be processed.



Programmer response

Change the syntax of the SQL statement or remove the statement from the program.

You should review the DB2 SQL guidelines for how to achieve what you want to achieve, and also explain that in the question if you’d like further assistance. For example, are you sure “WSDIWC.WBPTRR1” is actually available?

检测到数据库不支持的SQL语句。 该语句可能对其他IBM®关系数据库产品有效,也可能在其他上下文中有效。例如,诸如VALUES和SIGNAL或RESIGNAL SQLSTATE之类的语句只能在某些上下文中使用,例如在触发器主体或SQL过程中


相关文章
|
4月前
|
SQL 关系型数据库 数据库
postgresql报:ERROR: column “i“ of relation “test“ does not exist LINE 1: UPDATE怎么解决?
解决“ERROR: column "i" of relation "test" does not exist”错误的关键在于核实列名的准确性,修正更新语句,确保列名的引用正确无误,并考虑到任何可能影响列名引用的表别名、大小写、特殊字符或动态SQL生成等因素。通过上述步骤,你应该能有效定位并解决问题,保证SQL语句的正确执行。
518 0
|
6月前
|
数据库连接 网络安全 数据库
Could not create connection to database server.Attempted reconnect 3 times. Giving up.
这篇文章提供了解决数据库连接问题的方法,建议在连接字符串后添加`?serverTimezone=UTC`来指定时区,并检查网络设置、连接属性、驱动版本以及是否需要SSH或SSL连接。
Could not create connection to database server.Attempted reconnect 3 times. Giving up.
|
8月前
|
SQL 监控 NoSQL
db.oplog.rs.find({"ns": "your_database_name.your_collection_name", "o": {$exists: true}}).sort({$natural: -1}).limit(1) 这个SQL什么意思
【6月更文挑战第29天】db.oplog.rs.find({"ns": "your_database_name.your_collection_name", "o": {$exists: true}}).sort({$natural: -1}).limit(1) 这个SQL什么意思
76 8
|
9月前
|
SQL NoSQL MongoDB
db.oplog.rs.find({"ns": "your_database_name.your_collection_name", "o": {$exists: true}}).sort({$natural: -1}).limit(1)
【5月更文挑战第22天】db.oplog.rs.find({"ns": "your_database_name.your_collection_name", "o": {$exists: true}}).sort({$natural: -1}).limit(1) 的作用
66 6
|
关系型数据库
DB2报错:SQLCODE=-419, SQLSTATE=42911
DB2报错:SQLCODE=-419, SQLSTATE=42911
207 0
|
SQL 关系型数据库 数据库
DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null
DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null
455 0
|
SQL 存储 关系型数据库
DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016
DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016
247 0
|
关系型数据库
DB2 SQLCODE=-803,SQLSTATE=23505,SQLERROR=1
DB2 SQLCODE=-803,SQLSTATE=23505,SQLERROR=1
226 0
|
关系型数据库
DB2 sqlcode:-117 sqlstate:42802
DB2 sqlcode:-117 sqlstate:42802
515 0
|
关系型数据库 数据库
DB2 SQLCODE: -407, SQLSTATE: 23502
DB2 SQLCODE: -407, SQLSTATE: 23502
463 0