Need urgent help with loadjava
From: leo <schumacherfan2003_at_yahoo.com>
Date: 22 Apr 2003 02:27:17 -0700
Message-ID: <79d24144.0304220127.779364eb_at_posting.google.com>
Hi,
DRVR DBG1 SQL: "ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'" DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 SQL: "ALTER SESSION SET NLS_TERRITORY = 'AMERICA'" DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 SQL: "SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'"
parseExecuteDescribe
fetch
DRVR DBG1 After execute: valid_rows=1
DBAccess.closeQuery
DBAccess.close
getConnection returning
driver[className=oracle.jdbc.driver.OracleDriver,context=null,oracle.jdbc.dr iver.OracleDriver_at_162cee]
DBAccess.setAutoCommit
DBAccess.open
DRVR DBG1 SQL: "create table CREATE$JAVA$LOB$TABLE (name varchar2(200) unique, lob blob, loadtime da
te)"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
ginload (classfile varchar2) return varchar2; procedure appendpiece (piece raw, len binary_integer
); function endload (classfile varchar2) return varchar2; function beginread (classfile varchar2
, len out binary_integer) return varchar2; function getpiece (piece out raw, len in out b
inary_integer) return varchar2; function endread (classfile varchar2) return varchar2; en
d loadlobs;"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
DRVR DBG1 SQL: "create table JAVA$CLASS$MD5$TABLE (name varchar2(200) unique, md5 raw(16))"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
DBAccess.close
initialization complete
DBAccess.open
DRVR DBG1 SQL: "SELECT MD5 FROM JAVA$CLASS$MD5$TABLE WHERE NAME =
'mine'"
parseExecuteDescribe
fetch
DRVR DBG1 After execute: valid_rows=0
DBAccess.closeQuery
DBAccess.close
loading : mine
DBAccess.open
DRVR DBG1 SQL: " delete from CREATE$JAVA$LOB$TABLE where name =
'mine'"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0
DRVR DBG1 First row: noOfArgs=1, noOfOutParams=0, m_currentRank=0 DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.close
DBAccess.open
DRVR DBG1 First row: noOfArgs=1, noOfOutParams=0, m_currentRank=0
parseExecuteDescribe
fetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 Send batch: batch=1, m_currentRank=0
creating : mine
DBAccess.open
DRVR DBG1 SQL: "create or replace java class using 'mine'" DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DBAccess.open
DRVR DBG1 SQL: "select text from user_errors where name = dbms_java.shortname('mine')"
parseExecuteDescribe
SQLException: SQLState(42000) vendor code(904) java.sql.SQLException: ORA-00904: invalid column name
Error while retrieving errors for mine
DBAccess.close
DBAccess.open
DRVR DBG1 SQL: " delete from CREATE$JAVA$LOB$TABLE where name =
'mine'"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0
DRVR DBG1 First row: noOfArgs=1, noOfOutParams=0, m_currentRank=0 DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.close
DBAccess.open
DRVR DBG1 First row: noOfArgs=2, noOfOutParams=0, m_currentRank=0 DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.commit
DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.close
loadjava: 1 errors Received on Tue Apr 22 2003 - 11:27:17 CEST
Date: 22 Apr 2003 02:27:17 -0700
Message-ID: <79d24144.0304220127.779364eb_at_posting.google.com>
Hi,
I am getting the following problem with loadjava :-
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
I switched on the debug mode on my command prompt, and found that there was some problem concerning the table CREATE$JAVA$LOB$TABLE. It gives me an error saying the table already exists. I dropped this table but i still get the above listed error.
Here is how i am trying to use loadjava utility :- loadjava -user admin/password_at_mybd -verbose -debug mine.class
Waiting for helpful feedback..
Thanks and regards,
Leo.
PS: I am attaching the full stderr dump. Sorry this will make the mail rather longish but i am attaching to provide the full picture.
C:\>loadjava -user admin/password_at_mydb -verbose -debug mine.class
DRVR OPER Enabled logging (moduleMask 0x0fffffff, categoryMask
0x0fffffff)
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,context=null,oracle.jdbc.driver.Ora
cleDriver_at_162cee]
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,context=null,oracle.jdbc.driver.Ora
cleDriver_at_162d14]
DriverManager.getConnection("jdbc:oracle:oci8:_at_mydb")
trying driver[className=oracle.jdbc.driver.OracleDriver,context=null,oracle.jdbc.driver.OracleDr iver_at_162cee]
DBAccess.logon DBAccess.setAutoCommit DBAccess.open
DRVR DBG1 SQL: "ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'" DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 SQL: "ALTER SESSION SET NLS_TERRITORY = 'AMERICA'" DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 SQL: "SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'"
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true, need_to_prepare_define_buff er=true, columns_defined_by_user=false
parseExecuteDescribe
fetch
DRVR DBG1 After execute: valid_rows=1
DBAccess.closeQuery
DBAccess.close
getConnection returning
driver[className=oracle.jdbc.driver.OracleDriver,context=null,oracle.jdbc.dr iver.OracleDriver_at_162cee]
DBAccess.setAutoCommit
DBAccess.open
DRVR DBG1 SQL: "create table CREATE$JAVA$LOB$TABLE (name varchar2(200) unique, lob blob, loadtime da
te)"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java)
at oracle.aurora.server.tools.loadjava.LoadJava.init(LoadJava.java:887)
at oracle.aurora.server.tools.loadjava.LoadJava.getConnection(LoadJava.java:589)
at oracle.aurora.server.tools.loadjava.LoadJava.fileIsDifferent(LoadJava.java:492)
at oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(LoadJava.java:1217)
at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1135)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:266)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:57)
DRVR DBG1 SQL: "create package loadlobs is column blob; end_of_lob
binary_integer; function be
ginload (classfile varchar2) return varchar2; procedure appendpiece (piece raw, len binary_integer
); function endload (classfile varchar2) return varchar2; function beginread (classfile varchar2
, len out binary_integer) return varchar2; function getpiece (piece out raw, len in out b
inary_integer) return varchar2; function endread (classfile varchar2) return varchar2; en
d loadlobs;"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java)
at oracle.aurora.server.tools.loadjava.LoadJava.init(LoadJava.java:890)
at oracle.aurora.server.tools.loadjava.LoadJava.getConnection(LoadJava.java:589)
at oracle.aurora.server.tools.loadjava.LoadJava.fileIsDifferent(LoadJava.java:492)
at oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(LoadJava.java:1217)
at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1135)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:266)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:57)
DBAccess.open
DRVR DBG1 SQL: "create table JAVA$CLASS$MD5$TABLE (name varchar2(200) unique, md5 raw(16))"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
SQLException: SQLState(42000) vendor code(955) java.sql.SQLException: ORA-00955: name is already used by an existing object
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java)
at oracle.aurora.server.tools.loadjava.LoadJava.createMD5Table(LoadJava.java:439)
at oracle.aurora.server.tools.loadjava.LoadJava.init(LoadJava.java:901)
at oracle.aurora.server.tools.loadjava.LoadJava.getConnection(LoadJava.java:589)
at oracle.aurora.server.tools.loadjava.LoadJava.fileIsDifferent(LoadJava.java:492)
at oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(LoadJava.java:1217)
at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1135)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:266)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:57)
DBAccess.close
DBAccess.close
initialization complete
DBAccess.open
DRVR DBG1 SQL: "SELECT MD5 FROM JAVA$CLASS$MD5$TABLE WHERE NAME =
'mine'"
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true, need_to_prepare_define_buff er=true, columns_defined_by_user=false
parseExecuteDescribe
fetch
DRVR DBG1 After execute: valid_rows=0
DBAccess.closeQuery
DBAccess.close
loading : mine
DBAccess.open
DRVR DBG1 SQL: " delete from CREATE$JAVA$LOB$TABLE where name =
'mine'"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0
DBAccess.commit DBAccess.close DBAccess.open
DRVR DBG1 First row: noOfArgs=1, noOfOutParams=0, m_currentRank=0 DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.close
DBAccess.open
DRVR DBG1 First row: noOfArgs=1, noOfOutParams=0, m_currentRank=0
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true, need_to_prepare_define_buff er=true, columns_defined_by_user=false
parseExecuteDescribe
fetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 Send batch: batch=1, m_currentRank=0
DBAccess.closeQuery DBAccess.close DBAccess.commit
creating : mine
DBAccess.open
DRVR DBG1 SQL: "create or replace java class using 'mine'" DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DBAccess.open
DRVR DBG1 SQL: "select text from user_errors where name = dbms_java.shortname('mine')"
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true, need_to_prepare_define_buff er=true, columns_defined_by_user=false
parseExecuteDescribe
SQLException: SQLState(42000) vendor code(904) java.sql.SQLException: ORA-00904: invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)
at oracle.aurora.server.tools.loadjava.LoadJava.getErrors(LoadJava.java:614)
at oracle.aurora.server.tools.loadjava.LoadJava.createClass(LoadJava.java:319)
at oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(LoadJava.java:1223)
at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1135)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:266)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:57)
DBAccess.close
Error while retrieving errors for mine
ORA-00904: invalid column name
java.sql.SQLException: ORA-00904: invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)
at oracle.aurora.server.tools.loadjava.LoadJava.getErrors(LoadJava.java:614)
at oracle.aurora.server.tools.loadjava.LoadJava.createClass(LoadJava.java:319)
at oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(LoadJava.java:1223)
at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1135)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:266)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:57)
DBAccess.commit
DBAccess.close
DBAccess.open
DRVR DBG1 SQL: " delete from CREATE$JAVA$LOB$TABLE where name =
'mine'"
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0
DBAccess.commit DBAccess.close DBAccess.open
DRVR DBG1 First row: noOfArgs=1, noOfOutParams=0, m_currentRank=0 DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=0
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.close
DBAccess.open
DRVR DBG1 First row: noOfArgs=2, noOfOutParams=0, m_currentRank=0 DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
parseExecuteFetch
executeFetch
DRVR DBG1 After execute: valid_rows=1
DRVR DBG1 End of doExecuteWithBatch(): m_currentRank=0 DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.commit
DRVR DBG1 Send batch: batch=1, m_currentRank=0 DBAccess.close
loadjava: 1 errors Received on Tue Apr 22 2003 - 11:27:17 CEST