用透明网关同步mysql数据库,现在有个棘手的问题,一般字段integer,varchar,char可以搞定,大字段如
text,blob,clob等)不能用dblink返回,我想用java source来搞定,但有个问题,oracle的java source里不能导入访问mysql的包
C:>loadjava -user byf/1234 -resolve *.jar
errors : class com/mysql/jdbc/Blob
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSet
errors : class com/mysql/jdbc/BlobFromLocator$LocatorInputStream
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/BlobFromLocator
errors : class com/mysql/jdbc/BlobFromLocator
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSet
errors : class com/mysql/jdbc/Buffer
ORA-29521: 引用名称java/nio/ByteBuffer无法找到
errors : class com/mysql/jdbc/CallableStatement$CallableStatementParam
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement
errors : class com/mysql/jdbc/CallableStatement$CallableStatementParamInfo
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement$CallableStat
ementParam
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SQLError
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSetMetaData
errors : class com/mysql/jdbc/CallableStatement$CallableStatementParamInfoJDBC
3
ORA-29521: 引用名称java/sql/ParameterMetaData无法找到
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement
errors : class com/mysql/jdbc/CallableStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Field
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSet
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/PreparedStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SQLError
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/DatabaseMetaData
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SingleByteCharsetConverter
ORA-29521: 引用名称java/sql/ParameterMetaData无法找到
errors : class com/mysql/jdbc/CharsetMapping
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
errors : class com/mysql/jdbc/Clob
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SQLError
errors : class com/mysql/jdbc/CommunicationsException
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
errors : class com/mysql/jdbc/CompressedInputStream
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
errors : class com/mysql/jdbc/Connection$1
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ServerPreparedStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/util/LRUCache
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
不知道个位有没有碰到类似的问题,有什么好办法?
或者oracle里有什么好的package能处理这个问题,我试过dbms_java.set_system_class_loading(1)---通过引用系统环境变量的包,但会出错!

C:>loadjava -user byf/1234 -resolve *.jar
errors : class com/mysql/jdbc/Blob
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSet
errors : class com/mysql/jdbc/BlobFromLocator$LocatorInputStream
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/BlobFromLocator
errors : class com/mysql/jdbc/BlobFromLocator
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSet
errors : class com/mysql/jdbc/Buffer
ORA-29521: 引用名称java/nio/ByteBuffer无法找到
errors : class com/mysql/jdbc/CallableStatement$CallableStatementParam
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement
errors : class com/mysql/jdbc/CallableStatement$CallableStatementParamInfo
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement$CallableStat
ementParam
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SQLError
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSetMetaData
errors : class com/mysql/jdbc/CallableStatement$CallableStatementParamInfoJDBC
3
ORA-29521: 引用名称java/sql/ParameterMetaData无法找到
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/CallableStatement
errors : class com/mysql/jdbc/CallableStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Field
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ResultSet
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/PreparedStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SQLError
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/DatabaseMetaData
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SingleByteCharsetConverter
ORA-29521: 引用名称java/sql/ParameterMetaData无法找到
errors : class com/mysql/jdbc/CharsetMapping
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
errors : class com/mysql/jdbc/Clob
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/SQLError
errors : class com/mysql/jdbc/CommunicationsException
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
errors : class com/mysql/jdbc/CompressedInputStream
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
errors : class com/mysql/jdbc/Connection$1
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/ServerPreparedStatement
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/util/LRUCache
ORA-29534: 无法解析引用对象BYF.com/mysql/jdbc/Connection
不知道个位有没有碰到类似的问题,有什么好办法?
或者oracle里有什么好的package能处理这个问题,我试过dbms_java.set_system_class_loading(1)---通过引用系统环境变量的包,但会出错!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751051/viewspace-731732/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751051/viewspace-731732/