tomcat连接oracle报 ora-17002错误

但重启tomcat就没问题了,原因是tomcat连接oracle的jdbc问题

参考:http://618119.com/archives/2007/11/20/27.html


偶尔会出现错误:

An error occurred while establishing the connection:Type: java.sql.SQLException Error Code: 17002Message:Io 异常: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169869568)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=RAC02)(PORT=1521))’))(ERROR=(CODE=305)(EMFI=1))))

试了将驱动替换为10g的ojdbc14.jar.

然后再在DbVisualizer中试了很多次断开连接和重新链接,都还没出错.但是在web页面中测试,还是经常出现获取不到数据库连接的情况.

在网上查询了很多资料,仍未能解决这个问题, 不得已,只好换成oci方式连接.在jdbc客户端所在地服务器中,将TNSNAMES.ORA里本地服务名配置为mydb =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.103)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.104)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = mydb.618119.com)))

oci方式的jdbc url=”jdbc:oracle:oci:@mydb”;


ojdbc6中的错误信息(中英)

2009年09月11日 星期五 09:50

#--------------------------------------------------------------------------

#

# Messages

#

#--------------------------------------------------------------------------

ORA-17001=内部错误

ORA-17002=Io 异常

ORA-17003=无效的列索引

ORA-17004=无效的列类型

ORA-17005=不支持的列类型

ORA-17006=列名无效

ORA-17007=无效的动态列

ORA-17008=关闭的连接

      

ORA-17009=关闭的语句

      

ORA-17010=关闭的 Resultset

      

ORA-17011=结果集已耗尽

ORA-17012=参数类型冲突

ORA-17014=未调用 ResultSet.next

ORA-17015=语句被取消

ORA-17016=语句超时

ORA-17017=已初始化游标

ORA-17018=无效的游标

ORA-17019=只能描述查询

ORA-17020=无效的行预取

ORA-17021=定义丢失

ORA-17022=在索引处定义丢失

ORA-17023=不支持的特性

ORA-17024=未读取数据

ORA-17025=defines.isNull () 中出现错误

ORA-17026=数字溢出

ORA-17027=流已被关闭

ORA-17028=直到关闭当前的 ResultSet 才能进行新的定义

ORA-17029=setReadOnly: 不支持只读连接

ORA-17030=仅 READ_COMMITTED 和 SERIALIZABLE 是有效的事务处理级

ORA-17031=setAutoClose: 仅支持自动关闭模式打开的情况

ORA-17032=行预取不能设置为零

      

ORA-17033=出现格式不正确的 SQL92 串

ORA-17034=出现不支持的 SQL92 标记

ORA-17035=不支持的字符集 !!

ORA-17036=OracleNumber 中的异常

ORA-17037=不能在 UTF8 和 UCS2 之间转换

ORA-17038=字节数组不够长

ORA-17039=Char 数组不够长

ORA-17040=必须在连接 URL 中指定子协议

ORA-17041=索引中丢失 IN 或 OUT 参数:

ORA-17042=无效的批值

ORA-17043=流的最大长度无效

ORA-17044=内部错误: 未分配数据数组

ORA-17045=内部错误: 试图访问批值之外的绑定值

ORA-17046=内部错误: 数据访问的索引无效

ORA-17047=语法分析类型描述符时出错

ORA-17048=未定义的类型

ORA-17049=不一致的 java 和 sql 对象类型

      

ORA-17050=矢量中没有这样的元素

ORA-17051=此 API 不能用于非 UDT 类型

ORA-17052=此 ref 无效

ORA-17053=长度无效

ORA-17054=LOB 定位器无效

ORA-17055=遇到无效字符, 在

ORA-17056=不支持的字符集 (在类路径中添加 orai18n.jar)

ORA-17057=关闭的 LOB

      

ORA-17058=内部错误: 无效的 NLS 转换率

ORA-17059=无法转换为内部表示


ORA-17060=无法构造描述符


ORA-17061=丢失描述符


ORA-17062=Ref 游标无效

ORA-17063=不在事务处理中

ORA-17064=无效的语法或数据库名为空

ORA-17065=转换类为空

ORA-17066=访问层需要具体实施

ORA-17067=指定了无效的 Oracle URL

ORA-17068=调用中的无效参数

ORA-17069=使用明确的 XA 调用

ORA-17070=数据大小超出此类型的最大值

ORA-17071=超出 VARRAY 的最大限制

ORA-17072=对列来说插入的值太大

ORA-17074=无效的名称模式

ORA-17075=对只转发结果集的无效操作

ORA-17076=对只读结果集的无效操作

ORA-17077=无法设置 REF 值

ORA-17078=无法进行该操作, 因为连接已打开

ORA-17079=用户×××明与现有×××明不匹配

ORA-17080=无效的批处理命令

ORA-17081=批处理中出现错误

ORA-17082=没有当前行

ORA-17083=不在插入行上

ORA-17084=访问插入行

ORA-17085=出现值冲突

ORA-17086=插入行上的未定义列值

ORA-17087=可忽略的执行提示: setFetchDirection()

ORA-17088=请求的结果类型和并发级别的语法不受支持

ORA-17089=内部错误

ORA-17090=不允许的操作

ORA-17091=在所请求的类型和 (或) 并发级别无法创建结果集

ORA-17092=无法在调用处理操作结束时创建或执行 JDBC 语句

ORA-17093=OCI 操作返回 OCI_SUCCESS_WITH_INFO

ORA-17094=对象类型版本不匹配

ORA-17095=语句高速缓存大小未作设置

ORA-17096=不能为此逻辑连接启用语句高速缓存。

ORA-17097=PL/SQL 索引表的元素类型无效

ORA-17098=空二进制大对象操作无效

ORA-17099=PL/SQL 索引表数组长度无效

ORA-17100=数据库 Java 对象无效

ORA-17101=OCI 连接池对象中的属性无效

ORA-17102=Bfile 为只读

ORA-17103=通过 getConnection 返回的连接类型无效。改用 getJavaSqlConnection

ORA-17104=要执行的 SQL 语句不得为空白或空值

ORA-17105=未设置连接会话时区

ORA-17106=指定的 JDBC-OCI 驱动程序连接池配置无效

ORA-17107=指定的代理类型无效

ORA-17108=没有在 defineColumnType 中指定最大长度

ORA-17109=找不到标准 Java 字符编码

ORA-17110=执行完毕, 但带有警告

ORA-17111=指定的连接高速缓存 TTL 超时时间溢出

ORA-17112=指定的线程时间间隔无效

ORA-17113=线程时间间隔值大于高速缓存超时值

ORA-17114=无法在全局事务处理中使用本地事务处理提交

ORA-17115=无法在全局事务处理中使用本地事务处理回退

ORA-17116=无法在活动的全局事务处理中启用自动提交功能

ORA-17117=无法在活动的全局事务处理中设置保存点

ORA-17118=无法获取已命名保存点的 ID

ORA-17119=无法获取未命名保存点的名称

ORA-17120=无法设置启用了自动提交功能的保存点

ORA-17121=无法回退到启用了自动提交功能的保存点

ORA-17122=无法回退到启用了自动提交功能的保存点

ORA-17123=指定的语句高速缓存大小无效

ORA-17124=指定的连接高速缓存失活超时时间无效

ORA-17125=显式高速缓存返回了不正确的语句类型

ORA-17126=固定等待超时时间已过

ORA-17127=指定的固定等待超时时间无效

ORA-17128=SQL 字符串不是查询

ORA-17129=SQL 字符串不是 DML 语句

ORA-17132=请求的转换无效

ORA-17133=UNUSED

ORA-17134=SQL 中命名参数的长度超过 32 个字符

ORA-17135=setXXXStream 中使用的参数名在 SQL 中出现多次

ORA-17136=格式错误的 DATALINK URL, 请尝试使用 getString()

ORA-17137=连接高速缓存未启用, 或者不是启用高速缓存的有效数据源

ORA-17138=连接高速缓存名称无效。必须是有效的字符串并且是唯一的

ORA-17139=连接高速缓存属性无效

ORA-17140=具有此高速缓存名称的连接高速缓存已存在

ORA-17141=具有此高速缓存名称的连接高速缓存不存在

ORA-17142=具有此高速缓存名称的连接高速缓存已禁用

ORA-17143=在连接高速缓存中找到的连接无效或已过时

ORA-17144=未执行语句句柄

ORA-17145=接收到的 ONS 事件无效

ORA-17146=接收到的 ONS 事件版本无效

ORA-17147=试图设置未出现在 SQL 中的参数名

ORA-17148=方法仅在 Thin 中实施

ORA-17149=这已经是代理会话

ORA-17150=代码会话的参数错误

ORA-17151=Clob 太大, 无法存储在 Java 字符串中

ORA-17152=此方法仅在逻辑连接中实施

ORA-17153=此方法仅在物理连接中实施

ORA-17154=无法将 Oracle 字符映射为 Unicode

ORA-17155=无法将 Unicode 映射为 Oracle 字符

ORA-17156=数组大小对于端对端的度量值无效

ORA-17157=setString 只能处理少于 32766 个字符的字符串

ORA-17158=持续时间对该函数无效

ORA-17159=要执行端对端跟踪的度量值太长

ORA-17160=执行上下文 ID 序列号超出范围

ORA-17161=使用的交易模式无效

ORA-17162=不支持的 holdability 值

ORA-17163=无法在启用连接高速缓存时使用 getXAConnection()

ORA-17164=无法在启用了高速缓存的情况下从物理连接调用 getXAResource()

ORA-17165=服务器中不存在此连接的 PRIVATE_JDBC 包

ORA-17166=无法对 PLSQL 语句执行提取

ORA-17167=找不到 PKI 类。要使用 'connect /' 功能, oraclepki.jar 必须位于类路径中

ORA-17168=密钥存储遇到问题。请在出现打开的 Wallet (cwallet.sso) 时检查 Wallet 的位置并使用 mkstore 实用程序确保此 Wallet 包含正确的×××明

ORA-17169=无法将流绑定到 ScrollableResultSet 或 UpdatableResultSet

ORA-17170=名称空间不能为空

ORA-17171=属性长度不能超过 30 个字符

ORA-17172=属性的值不能超过 400 个字符

ORA-17173=并非所有返回参数都已注册

ORA-17174=唯一受支持的名称空间是 CLIENTCONTEXT

ORA-17175=远程 ONS 配置期间出错

ORA-17176=无法识别区域设置

ORA-17177=对象不使用请求的接口包装任何内容

ORA-17178=ANYTYPE pickler 失败

ORA-17179=KOTAD 中的幻数不匹配

ORA-17180=KOTAD 中的格式错误

ORA-17181=字符转换器一般错误

ORA-17182=字符转换器溢出错误

ORA-17183=字符转换器不可用错误 - 请与 Oracle 技术支持联系

ORA-17184=创建 NCLOB 时使用了不正确的形式

ORA-17185=连接属性的默认值缺失

ORA-17186=连接属性的访问模式缺失

ORA-17187=用于存储连接属性的实例变量的类型不受支持

ORA-17188=在连接属性的反映过程中出现 IllegalAccessException

ORA-17189=用于存储连接属性的实例变量缺失

ORA-17190=连接属性: 格式错误

ORA-17191=无效的提交选项

ORA-17192=在已释放 LOB 上的操作

ORA-17193=无效的 AQ 消息格式

ORA-17194=标记和重设不受此类的支持

ORA-17195=标记无效或未设置

ORA-17196=预读时的限制太大

ORA-17197=参数名的数目与已注册参数的数目不匹配

ORA-17198=未设置数据库会话时区

ORA-17199=不支持数据库会话时区

#

# No more error messages here

#

#############################################################

# XA error messages 

# from 17200 to 17259

#

#############################################################

ORA-17200=无法正确地将 XA 打开字符串从 Java 转换成 C

ORA-17201=无法正确地将 XA 关闭字符串从 Java 转换成 C

ORA-17202=无法正确地将 RM 名称从 Java 转换成 C

ORA-17203=无法将指针类型强制转换成 jlong

ORA-17204=输入数组过短, 无法容纳 OCI 句柄

ORA-17205=无法使用 xaoSvcCtx 从 C-XA 获取 OCISvcCtx 句柄

ORA-17206=无法使用 xaoEnv 从 C-XA 获取 OCIEnv 句柄

ORA-17207=未在数据源中设置 tnsEntry 属性

ORA-17213=C-XA 在 xa_open 期间返回 XAER_RMERR

ORA-17215=C-XA 在 xa_open 期间返回 XAER_INVAL

ORA-17216=C-XA 在 xa_open 期间返回 XAER_PROTO

ORA-17233=C-XA 在 xa_close 期间返回 XAER_RMERR

ORA-17235=C-XA 在 xa_close 期间返回 XAER_INVAL

ORA-17236=C-XA 在 xa_close 期间返回 XAER_PROTO

ORA-17240=无法检索本地主机 IP 地址。出现 UnknownHostException。

ORA-17241=无法检索本地主机 IP 地址。出现 SecurityException。

ORA-17242=对选项中指定的 TCP 端口进行语法分析时出错。

ORA-17243=对选项中指定的 TIMEOUT 值进行语法分析时出错。

ORA-17244=对选项中指定的 CHANGELAG 值进行语法分析时出错。

ORA-17245=尝试删除的注册使用的不是当前连接到的数据库实例。

ORA-17246=监听程序不能为空值。

ORA-17247=尝试将监听程序附加到在 JDBC 驱动程序之外创建的注册。

ORA-17248=监听程序已经注册。

ORA-17249=因为监听程序没有注册, 所以无法删除它。

ORA-17250=TCP 端口已经使用。

ORA-17251=注册已关闭。

ORA-17252=有效负载类型无效或未定义。

ORA-17253=名称对于 clientInfo 来说无效或不受支持。

ORA-17254=内存不足, 无法分配请求的内存大小

ORA-17255=快速连接故障转移一旦启用就无法禁用

ORA-17256=此实例属性不可用。

#############################################################

# JSR-114 RowSets (JRS) error messages

# [17300 - 17399]

#

#############################################################

ORA-17300=无法通过数据源进行连接

ORA-17301=一个或多个验证 RowSet 属性未设置

ORA-17302=RowSet 连接未打开

ORA-17303=此 JdbcRowSet 实施不允许显示已删除的行

ORA-17304=SyncProvider 实例未构造

ORA-17305=ResultSet 未打开

ORA-17306=RowSet 类型为 TYPE_SCROLL_SENSITIVE 时, 无法应用提取方向

ORA-17307=RowSet 类型为 TYPE_FORWARD_ONLY 时, 无法应用 FETCH_REVERSE

ORA-17308=提取方向非法

ORA-17309=RowSet 没有启用写入

ORA-17310=参数索引无效

ORA-17311=将列转换为流类型时出错

ORA-17312=无法将列转换为流类型

ORA-17313=行位置无效, 请先尝试调用下一行/上一行

ORA-17314=操作对于类型为 TYPE_FORWARD_ONLY 的 RowSet 无效

ORA-17315=未更改任何行

ORA-17316=toCollection() 中的映射操作失败

ORA-17317=未插入该行

ORA-17318=未删除该行

ORA-17319=未更新该行

ORA-17320=行中的列没有全部设置

ORA-17321=将读进程转换为字符串时出错

ORA-17322=无法读取流

ORA-17323=无效的参数类型

ORA-17324=无效的键列数

ORA-17325=无效的页大小

ORA-17326=尝试将已插入行标记为原始行

ORA-17327=调用 insertRow 之前对此行的操作无效

ORA-17328=基础 ResultSet 不支持此操作

ORA-17329=不预先执行分页操作就无法调用此操作

ORA-17330=指定的行参数的数目无效

ORA-17331=起始位置不应为负数

ORA-17332=提供的用于置入的 ResultSet 为空值

ORA-17333=在此位置开始置入的行太少

ORA-17334=没有设置匹配列索引

ORA-17335=没有设置匹配列名

ORA-17336=匹配列索引无效

ORA-17337=匹配列名无效

ORA-17338=无法设置匹配列索引

ORA-17339=无法设置匹配列名

ORA-17340=尚未设置要取消设置的列索引

ORA-17341=尚未设置要取消设置的列名

ORA-17342=无法获取连接

ORA-17343=无法对 SQL 字符串进行语法分析以获得表名。

ORA-17344=RowSet 滚动类型不正确

ORA-17345=该对象不满足过滤标准

ORA-17346=SerialBlob 构造器

ORA-17347=SerialClob 构造器

ORA-17348=错误, 无法复制对象的副本

ORA-17349=创建对象副本时出错

ORA-17350=空 RowSet 参数无效

ORA-17351=该参数不是 RowSet 实例

ORA-17352=联接类型不受支持

ORA-17353=行集中元素的数目不等于匹配列数

ORA-17354=尚不支持第三方 RowSet 联接

ORA-17355=读进程无效

ORA-17356=写进程无效

ORA-17357=值错误; 属性不可为空值

ORA-17358=值错误; 元数据不可为空值

ORA-17359=无效的 WebRowSet 参数

#     ^     ^     ^     ^

#     |     |     |     |        P L E A S E    R E A D

#

# Add new message above this comment.

# Before you add a new message, please read "Message Guideline" at the

# top of this file first.

#


#--------------------------------------------------------------------------

#

# TTC Messages

#

#--------------------------------------------------------------------------

ORA-17401=违反协议

     

ORA-17402=只期望得到一个 RPA 消息

ORA-17403=只期望得到一个 RXH 消息

ORA-17404=收到超过预期的 RXD

ORA-17405=UAC 长度不为零

ORA-17406=超出缓冲区的最大长度

ORA-17407=无效的类型表示 (setRep)

ORA-17408=无效的类型表示 (getRep)

ORA-17409=无效的缓冲区长度

ORA-17410=无法从套接字读取更多的数据

ORA-17411=数据类型表示不匹配

ORA-17412=类型长度大于最大值

ORA-17413=超出关键字大小

ORA-17414=缓冲区容量不足以存储列名

ORA-17415=尚未处理此类型

ORA-17416=FATAL

ORA-17417=NLS 问题, 无法对列名进行解码

ORA-17418=内部结构的字段长度错误

ORA-17419=返回的列数无效

ORA-17420=未定义 Oracle 版本

ORA-17421=未定义类型或连接

ORA-17422=工厂中的无效类

ORA-17423=在未定义 IOV 的情况下使用 PLSQL 块

ORA-17424=尝试不同的编组操作

ORA-17425=返回 PLSQL 块中的流

ORA-17426=IN 和 OUT 的绑定均为 NULL

ORA-17427=使用未初始化的 OAC

ORA-17428=连接后必须调用登录

ORA-17429=必须至少与服务器连接

ORA-17430=必须登录到服务器

ORA-17431=要分析的 SQL 语句为空

ORA-17432=all7 中的无效选项

ORA-17433=调用中无效的参数

ORA-17434=不在流模式下

ORA-17435=IOV 中无效的 in_out_binds 个数

ORA-17436=无效的 outbinds 数

ORA-17437=PLSQL 块 IN/OUT 参数中出现错误

ORA-17438=内部 - 不期望的值

ORA-17439=无效的 SQL 类型

ORA-17440=DBItem/DBType 为空

ORA-17441=不支持的 Oracle 版本。支持的最低版本为 7.2.3。

ORA-17442=Refcursor 值无效

ORA-17444=不支持从服务器接收到的 TTC 协议版本

ORA-17445=LOB 已在同一个事务处理中打开

ORA-17446=LOB 已在同一个事务处理中关闭

ORA-17447=OALL8 处于不一致状态

ORA-17448=事务处理目前正在使用中

#

# Add all error messages above here

#

# Below are MBean descriptions. They do not follow the message guidelines.

*

DiagnosibilityMBeanDescription=控制 Oracle JDBC 驱动程序的诊断功能。

DiagnosibilityMBeanConstructor()=Oracle JDBC Diagnosability MBean 的零参数构造器

DiagnosibilityMBeanLoggingEnabledDescription=所有 Oracle JDBC 事件记录代码均由此布尔型属性控制。如果该属性为“假”, 将不生成任何日志消息。如果该属性为“真”, 日志消息将由 java.util.logging 级别和过滤器控制。

DiagnosibilityMBeanStateManageableDescription=Oracle JDBC 驱动程序无法启动和停止。始终返回“假”。

DiagnosibilityMBeanStatisticsProviderDescription=Oracle JDBC 驱动程序并不通过 Diagnosability MBean 提供统计信息。

#     ^     ^     ^     ^

#     |     |     |     |        P L E A S E    R E A D

#

# Add new message above this comment.

# Before you add a new message, please read "Message Guideline" at the

# top of this file first.

#

 

----------------------------------------------------------------------------------------------------------------------------------

#

# US English Error messages for JDBC

#

# Note:

# - Error codes are defined in DatabaseError.java.

#

# Message Guidelines:

# (The existing messages are not consistent, but do follow this guideline

# when you are creating new ones, or changing old ones.)

#

# - Messages start in lower-cases (eg. "invalid data type").

# - Do not put signs in message. This is bad: "-> NULL".

# - Use past tense (eg. "failed to convert data").

#

#--------------------------------------------------------------------------

#

# Messages

#

#--------------------------------------------------------------------------

ORA-17001=Internal Error

ORA-17002=Io exception

ORA-17003=Invalid column index

ORA-17004=Invalid column type

ORA-17005=Unsupported column type

ORA-17006=Invalid column name

ORA-17007=Invalid dynamic column

ORA-17008=Closed Connection

      

ORA-17009=Closed Statement

      

ORA-17010=Closed Resultset

      

ORA-17011=Exhausted Resultset

ORA-17012=Parameter Type Conflict

ORA-17014=ResultSet.next was not called

ORA-17015=Statement was cancelled

ORA-17016=Statement timed out

ORA-17017=Cursor already initialized

ORA-17018=Invalid cursor

ORA-17019=Can only describe a query

ORA-17020=Invalid row prefetch

ORA-17021=Missing defines

ORA-17022=Missing defines at index

ORA-17023=Unsupported feature

ORA-17024=No data read

ORA-17025=Error in defines.isNull ()

ORA-17026=Numeric Overflow

ORA-17027=Stream has already been closed

ORA-17028=Can not do new defines until the current ResultSet is closed

ORA-17029=setReadOnly: Read-only connections not supported

ORA-17030=READ_COMMITTED and SERIALIZABLE are the only valid transaction levels

ORA-17031=setAutoClose: Only support auto close mode on

ORA-17032=cannot set row prefetch to zero

      

ORA-17033=Malformed SQL92 string at position

ORA-17034=Non supported SQL92 token at position

ORA-17035=Character Set Not Supported !!

ORA-17036=exception in OracleNumber

ORA-17037=Fail to convert between UTF8 and UCS2

ORA-17038=Byte array not long enough

ORA-17039=Char array not long enough

ORA-17040=Sub Protocol must be specified in connection URL

ORA-17041=Missing IN or OUT parameter at index:

ORA-17042=Invalid Batch Value

ORA-17043=Invalid stream maximum size

ORA-17044=Internal error: Data array not allocated

ORA-17045=Internal error: Attempt to access bind values beyond the batch value

ORA-17046=Internal error: Invalid index for data access

ORA-17047=Error in Type Descriptor parse

ORA-17048=Undefined type

ORA-17049=Inconsistent java and sql object types

      

ORA-17050=no such element in vector

ORA-17051=This API cannot be be used for non-UDT types

ORA-17052=This ref is not valid

ORA-17053=The size is not valid

ORA-17054=The LOB locator is not valid

ORA-17055=Invalid character encountered in

ORA-17056=Non supported character set (add orai18n.jar in your classpath)

ORA-17057=Closed LOB

      

ORA-17058=Internal error: Invalid NLS Conversion ratio

ORA-17059=Fail to convert to internal representation


ORA-17060=Fail to construct descriptor


ORA-17061=Missing descriptor


ORA-17062=Ref cursor is invalid

ORA-17063=Not in a transaction

ORA-17064=Invalid Sytnax or Database name is null

ORA-17065=Conversion class is null

ORA-17066=Access layer specific implementation needed

ORA-17067=Invalid Oracle URL specified

ORA-17068=Invalid argument(s) in call

ORA-17069=Use explicit XA call

ORA-17070=Data size bigger than max size for this type

ORA-17071=Exceeded maximum VARRAY limit

ORA-17072=Inserted value too large for column

ORA-17074=invalid name pattern

ORA-17075=Invalid operation for forward only resultset

ORA-17076=Invalid operation for read only resultset

ORA-17077=Fail to set REF value

ORA-17078=Cannot do the operation as connections are already opened

ORA-17079=User credentials doesn't match the existing ones

ORA-17080=invalid batch command

ORA-17081=error occurred during batching

ORA-17082=No current row

ORA-17083=Not on the insert row

ORA-17084=Called on the insert row

ORA-17085=Value conflicts occurs

ORA-17086=Undefined column value on the insert row

ORA-17087=Ignored performance hint: setFetchDirection()

ORA-17088=Unsupported syntax for requested resultset type and concurrency level

ORA-17089=internal error

ORA-17090=operation not allowed

ORA-17091=Unable to create resultset at the requested type and/or concurrency level

ORA-17092=JDBC statements cannot be created or executed at end of call processing

ORA-17093=OCI operation returned OCI_SUCCESS_WITH_INFO

ORA-17094=Object type version mismatched

ORA-17095=Statement cache size has not been set

ORA-17096=Statement Caching cannot be enabled for this logical connection.

ORA-17097=Invalid PL/SQL Index Table element type

ORA-17098=Invalid empty lob operation

ORA-17099=Invalid PL/SQL Index Table array length

ORA-17100=Invalid database Java Object

ORA-17101=Invalid properties in OCI Connection Pool Object

ORA-17102=Bfile is read only

ORA-17103=invalid connection type to return via getConnection. Use getJavaSqlConnection instead

ORA-17104=SQL statement to execute cannot be empty or null

ORA-17105=connection session time zone was not set

ORA-17106=invalid JDBC-OCI driver connection pool configuration specified

ORA-17107=invalid proxy type specified

ORA-17108=No max length specified in defineColumnType

ORA-17109=standard Java character encoding not found

ORA-17110=execution completed with warning

ORA-17111=Invalid connection cache TTL timeout specified

ORA-17112=Invalid thread interval specified

ORA-17113=Thread interval value is more than the cache timeout value

ORA-17114=could not use local transaction commit in a global transaction

ORA-17115=could not use local transaction rollback in a global transaction

ORA-17116=could not turn on auto-commit in an active global transaction

ORA-17117=could not set savepoint in an active global transaction

ORA-17118=could not obtain ID for a named Savepoint

ORA-17119=could not obtain name for an un-named Savepoint

ORA-17120=could not set a Savepoint with auto-commit on

ORA-17121=could not rollback to a Savepoint with auto-commit on

ORA-17122=could not rollback to a local txn Savepoint in a global transaction

ORA-17123=Invalid statement cache size specified

ORA-17124=Invalid connection cache Inactivity timeout specified

ORA-17125=Improper statement type returned by explicit cache

ORA-17126=Fixed Wait timeout elapsed

ORA-17127=Invalid Fixed Wait timeout specified

ORA-17128=SQL string is not Query

ORA-17129=SQL string is not a DML Statement

ORA-17132=Invalid conversion requested

ORA-17133=UNUSED

ORA-17134=Length of named parameter in SQL exceeded 32 characters

ORA-17135=Parameter name used in setXXXStream appears more than once in SQL

ORA-17136=Malformed DATALINK URL, try getString() instead

ORA-17137=Connection Caching Not Enabled or Not a Valid Cache Enabled DataSource

ORA-17138=Invalid Connection Cache Name. Must be a valid String and Unique

ORA-17139=Invalid Connection Cache Properties

ORA-17140=Connection Cache with this Cache Name already exists

ORA-17141=Connection Cache with this Cache Name does not exist

ORA-17142=Connection Cache with this Cache Name is Disabled

ORA-17143=Invalid or Stale Connection found in the Connection Cache

ORA-17144=statement handle not executed

ORA-17145=Invalid ONS Event received

ORA-17146=Invalid ONS Event Version received

ORA-17147=Attempt to set a parameter name that does not occur in the SQL

ORA-17148=Method only implemented in thin

ORA-17149=This is already a proxy session

ORA-17150=Wrong arguments for proxy session

ORA-17151=Clob is too large to be stored in a Java String

ORA-17152=This method is only implemented in logical connections

ORA-17153=This method is only implemented in physical connections

ORA-17154=Cannot map Oracle character to Unicode

ORA-17155=Cannot map Unicode to Oracle character

ORA-17156=Invalid array size for End-to-End metrics values

ORA-17157=setString can only process strings of less than 32766 chararacters

ORA-17158=duration is invalid for this function

ORA-17159=metric value for end-to-end tracing is too long

ORA-17160=execution context id sequence number out of range

ORA-17161=Invalid transaction mode used

ORA-17162=Unsupported holdability value

ORA-17163=Can not use getXAConnection() when connection caching is enabled

ORA-17164=Can not call getXAResource() from physical connection with caching on

ORA-17165=PRIVATE_JDBC package not present in server for this connection

ORA-17166=Cannot perform fetch on a PLSQL statement

ORA-17167=PKI classes not found. To use 'connect /' functionality, oraclepki.jar must be in the classpath

ORA-17168=encountered a problem with the Secret Store. Check the wallet location for the presence of an open wallet (cwallet.sso) and ensure that this wallet contains the correct credentials using the mkstore utility

ORA-17169=Cannot bind stream to a ScrollableResultSet or UpdatableResultSet

ORA-17170=The Namespace cannot be empty

ORA-17171=The attribute length cannot exceed 30 chars

ORA-17172=That value of the attribute cannot exceed 400 chars

ORA-17173=Not all return parameters registered

ORA-17174=The only supported namespace is CLIENTCONTEXT

ORA-17175=Error during remote ONS configuration

ORA-17176=Locale not recognized

ORA-17177=Object does not wrap anything with requested interface

ORA-17178=ANYTYPE pickler failed

ORA-17179=Magic number mismatch in KOTAD

ORA-17180=Format error in KOTAD

ORA-17181=Character converter general error

ORA-17182=Character converter overrun error

ORA-17183=Character converter impossible error -- contact Oracle Support

ORA-17184=Incorrect form of use to create NCLOB

ORA-17185=The default value of the connection property is missing

ORA-17186=The access mode of the connection property is missing

ORA-17187=The type of the instance variable used to store the connection property isn't supported

ORA-17188=Got an IllegalAccessException during reflection on the connection properties

ORA-17189=The instance variable to store the connection property is missing

ORA-17190=Connection property: format error

ORA-17191=Invalid commit options

ORA-17192=Operation on freed LOB

ORA-17193=Invalid AQ message format

ORA-17194=Mark and reset are not supported by this class

ORA-17195=Mark invalid or not set

ORA-17196=The limit on the readahead is too big

ORA-17197=The number of parameter names does not match the number of registered praremeters

ORA-17198=The database session time zone is not set

ORA-17199=The database session time zone is not supported

#

# No more error messages here

#

#############################################################

# XA error messages 

# from 17200 to 17259

#

#############################################################

ORA-17200=Unable to properly convert XA open string from Java to C

ORA-17201=Unable to properly convert XA close string from Java to C

ORA-17202=Unable to properly convert RM name from Java to C

ORA-17203=Could not casting pointer type to jlong

ORA-17204=Input array too short to hold OCI handles

ORA-17205=Failed to obtain OCISvcCtx handle from C-XA using xaoSvcCtx

ORA-17206=Failed to obtain OCIEnv handle from C-XA using xaoEnv

ORA-17207=The tnsEntry property was not set in DataSource

ORA-17213=C-XA returned XAER_RMERR during xa_open

ORA-17215=C-XA returned XAER_INVAL during xa_open

ORA-17216=C-XA returned XAER_PROTO during xa_open

ORA-17233=C-XA returned XAER_RMERR during xa_close

ORA-17235=C-XA returned XAER_INVAL during xa_close

ORA-17236=C-XA returned XAER_PROTO during xa_close

ORA-17240=couldn't retrieve localhost IP address. Got an UnknownHostException.

ORA-17241=couldn't retrieve localhost IP address. Got a SecurityException.

ORA-17242=error while parsing the TCP port specified in the options.

ORA-17243=error while parsing the TIMEOUT value specified in the options.

ORA-17244=error while parsing the CHANGELAG value specified in the options.

ORA-17245=an attempt was made to delete a registration that is using a different database instance than the one currently connected to.

ORA-17246=the listener cannot be null.

ORA-17247=an attempt was made to attach a listener to a registration that was created outside of the JDBC driver.

ORA-17248=listener is already registered.

ORA-17249=couldn't remove the listener because it is not registered.

ORA-17250=TCP PORT already is use.

ORA-17251=Closed registration.

ORA-17252=Invalid or undefined payload type.

ORA-17253=Invalid or unsupported name for clientInfo.

ORA-17254=Out Of Memory, Not able to allocate requested memory size

ORA-17255=Fast Connection Failover once enabled cannot be disabled

ORA-17256=This instance property isn't available.

#############################################################

# JSR-114 RowSets (JRS) error messages

# [17300 - 17399]

#

#############################################################

ORA-17300=Unable to connect through the DataSource

ORA-17301=One or more of the authenticating RowSet properties not set

ORA-17302=RowSet connection not open

ORA-17303=This JdbcRowSet implementation does not allow deleted rows to be visible

ORA-17304=SyncProvider instance not constructed

ORA-17305=ResultSet not open

ORA-17306=Fetch direction cannot be applied when RowSet type is TYPE_SCROLL_SENSITIVE

ORA-17307=FETCH_REVERSE cannot be applied when RowSet type is TYPE_FORWARD_ONLY

ORA-17308=Illegal fetch direction

ORA-17309=The RowSet is not write enabled

ORA-17310=Invalid parameter index

ORA-17311=Error when converting column to stream type

ORA-17312=Could not convert the column into a stream type

ORA-17313=Invalid row position, try calling next/previous first

ORA-17314=Invalid operation for RowSet type TYPE_FORWARD_ONLY

ORA-17315=None of the rows are changed

ORA-17316=Map operation failed in toCollection()

ORA-17317=The row is not inserted

ORA-17318=The row is not deleted

ORA-17319=The row is not updated

ORA-17320=Not all columns of the row are set

ORA-17321=Error converting Reader to String

ORA-17322=Could not read from the stream

ORA-17323=Invalid parameter type

ORA-17324=Invalid number of key columns

ORA-17325=Invalid page size

ORA-17326=Trying to mark an inserted row as original

ORA-17327=Invalid operation on this row before insertRow is called

ORA-17328=The underlying ResultSet does not support this operation

ORA-17329=This operation can not be called without previous paging operations

ORA-17330=Invalid number of row parameter specified

ORA-17331=The start position should not be negative

ORA-17332=Null ResultSet supplied to populate

ORA-17333=Too few rows to start populating at this position

ORA-17334=No match column indexes were set

ORA-17335=No match column names were set

ORA-17336=Invalid match column index

ORA-17337=Invalid match column name

ORA-17338=The match column index could not be set

ORA-17339=The match column name could not be set

ORA-17340=The column index being unset has not been set

ORA-17341=The column name being unset has not been set

ORA-17342=Could not obtain connection

ORA-17343=Could not parse the SQL String to get the table name.

ORA-17344=Incorrect RowSet scroll type

ORA-17345=The object does not satisfy filtering criterion

ORA-17346=SerialBlob constructor

ORA-17347=SerialClob constructor

ORA-17348=Error, could not reproduce the copy of the object

ORA-17349=Error while creating an object copy

ORA-17350=Invalid empty RowSet parameter

ORA-17351=The parameter is not a RowSet instance

ORA-17352=Join type is not supported

ORA-17353=Number of elements in rowsets is not equal to match columns

ORA-17354=Third-party RowSet Join not yet supported

ORA-17355=Invalid reader

ORA-17356=Invalid writer

ORA-17357=Bad value; non-nullable property

ORA-17358=Bad value; non-nullable metadata

ORA-17359=Invalid WebRowSet argument

#     ^     ^     ^     ^

#     |     |     |     |        P L E A S E    R E A D

#

# Add new message above this comment.

# Before you add a new message, please read "Message Guideline" at the

# top of this file first.

#


#--------------------------------------------------------------------------

#

# TTC Messages

#

#--------------------------------------------------------------------------

ORA-17401=Protocol violation

     

ORA-17402=Only one RPA message is expected

ORA-17403=Only one RXH message is expected

ORA-17404=Received more RXDs than expected

ORA-17405=UAC length is not zero

ORA-17406=Exceeding maximum buffer length

ORA-17407=invalid Type Representation(setRep)

ORA-17408=invalid Type Representation(getRep)

ORA-17409=invalid buffer length

ORA-17410=No more data to read from socket

ORA-17411=Data Type representations mismatch

ORA-17412=Bigger type length than Maximum

ORA-17413=Exceding key size

ORA-17414=Insufficient Buffer size to store Columns Names

ORA-17415=This type hasn't been handled

ORA-17416=FATAL

ORA-17417=NLS Problem, failed to decode column names

ORA-17418=Internal structure's field length error

ORA-17419=Invalid number of columns returned

ORA-17420=Oracle Version not defined

ORA-17421=Types or Connection not defined

ORA-17422=Invalid class in factory

ORA-17423=Using a PLSQL block without an IOV defined

ORA-17424=Attempting different marshaling operation

ORA-17425=Returning a stream in PLSQL block

ORA-17426=Both IN and OUT binds are NULL

ORA-17427=Using Uninitialized OAC

ORA-17428=Logon must be called after connect

ORA-17429=Must be at least connected to server

ORA-17430=Must be logged on to server

ORA-17431=SQL Statement to parse is null

ORA-17432=invalid options in all7

ORA-17433=invalid arguments in call

ORA-17434=not in streaming mode

ORA-17435=invalid number of in_out_binds in IOV

ORA-17436=invalid number of outbinds

ORA-17437=Error in PLSQL block IN/OUT argument(s)

ORA-17438=Internal - Unexpected value

ORA-17439=Invalid SQL type

ORA-17440=DBItem/DBType is null

ORA-17441=Oracle Version not supported. Minimum supported version is 7.2.3.

ORA-17442=Refcursor value is invalid

ORA-17444=TTC Protocol version received from server not supported

ORA-17445=LOB already opened in the same transaction

ORA-17446=LOB already closed in the same transaction

ORA-17447=OALL8 is in an inconsistent state

ORA-17448=transaction is currently in use

#

# Add all error messages above here

#

# Below are MBean descriptions. They do not follow the message guidelines.

*

DiagnosibilityMBeanDescription=Controls the diagnosibilty features of the Oracle JDBC drivers.

DiagnosibilityMBeanConstructor()=The zero arg constructor for the Oracle JDBC Diagnosibility MBean

DiagnosibilityMBeanLoggingEnabledDescription=All Oracle JDBC logging code is controlled by this boolean attribute. If false, no log messages will be produced. If true, log messages will be controlled by java.util.logging Levels and Filters.

DiagnosibilityMBeanStateManageableDescription=The Oracle JDBC drivers cannot be started and stopped. Always returns false.

DiagnosibilityMBeanStatisticsProviderDescription=The Oracle JDBC drivers do not provide statistics via the Diagnosibility MBean.

#     ^     ^     ^     ^

#     |     |     |     |        P L E A S E    R E A D

#

# Add new message above this comment.

# Before you add a new message, please read "Message Guideline" at the

# top of this file first.

#


来自:http://blog.csdn.net/Leolu007/article/details/4858088