sách gpt4 ăn đã đi

java - ORA-00932 : inconsistent datatypes: expected SYS. AQ$_JMS_TEXT_MESSAGE 得到 SYS.AQ$_JMS_TEXT_MESSAGE

In lại Tác giả: Walker 123 更新时间:2023-11-30 10:09:35 25 4
mua khóa gpt4 giày nike

使用较新版本的 Oracle DB (12.2.0.1),我们开始收到 ORA-00932,因为代码可以很好地与旧的 DB 服务器配合使用。此外,驱动程序报告异常的奇怪细节:

ORA-00932: inconsistent datatypes: expected SYS.AQ$_JMS_TEXT_MESSAGE got SYS.AQ$_JMS_TEXT_MESSAGE

你可以看到预期的和得到的类型名称是相同的。

Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-00932: inconsistent datatypes: expected SYS.AQ$_JMS_TEXT_MESSAGE got SYS.AQ$_JMS_TEXT_MESSAGE
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4Caqe.doOAQEQ(T4Caqe.java:355)
at oracle.jdbc.driver.T4CConnection.doEnqueue(T4CConnection.java:3938)
at oracle.jdbc.driver.PhysicalConnection.enqueue(PhysicalConnection.java:10076)
at oracle.jms.AQjmsProducer.jdbcEnqueue(AQjmsProducer.java:1096)
... 13 more

问题是由使用以下 AQ 驱动程序库的独立 Java 应用程序引起的:

aqapi.jar;javax.jms_1.1.4.jar;jta-1.1.jar

使用的ojdbc驱动版本:

Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.5
Created-By: 1.5.0_30-b03 (Sun Microsystems Inc.)
Implementation-Vendor: Oracle Corporation
Implementation-Title: JDBC
Implementation-Version: 11.2.0.3.0
Repository-Id: JAVAVM_11.2.0.3.0_LINUX_110823
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Specification-Version: 4.0
Main-Class: oracle.jdbc.OracleDriver
sealed: true

câu trả lời hay nhất

当我们开始使用与 Oracle DB 服务器相同的 jdbc 驱动程序版本时:

Manifest-Version: 1.0
Ant-Version: Apache Ant 1.7.1
Implementation-Title: JDBC
Implementation-Version: 12.2.0.1.0
sealed: true
Repository-Id: JAVAVM_12.2.0.1.0_LINUX.X64_161213
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Created-By: 25.91-b14 (Oracle Corporation)
Specification-Version: 4.0
Implementation-Vendor: Oracle Corporation
Main-Class: oracle.jdbc.OracleDriver

AQ JMS 驱动程序开始运行良好。我找不到任何 Oracle 文档说明,即 11.2 jdbc 驱动程序与 12.2 ORA DB 服务器不兼容,甚至对于 AQ JMS 实现 (aqapi.jar) 也不兼容。

关于java - ORA-00932 : inconsistent datatypes: expected SYS. AQ$_JMS_TEXT_MESSAGE 得到 SYS.AQ$_JMS_TEXT_MESSAGE,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/53192574/

25 4 0
Walker 123
Hồ sơ

Tôi là một lập trình viên xuất sắc, rất giỏi!

Nhận phiếu giảm giá taxi Didi miễn phí
Phiếu giảm giá taxi Didi
Chứng chỉ ICP Bắc Kinh số 000000
Hợp tác quảng cáo: 1813099741@qq.com 6ren.com
Xem sitemap của VNExpress