INFO: Loading XML bean definitions from file
[/home/pimenov_pa/sql/scheme2ddl.config.xml]
08.11.2012 9:48:53
org.springframework.beans.factory.support.DefaultListableBeanFactory
preInstantiateSingletons
INFO: Pre-instantiating singletons in
org.springframework.beans.factory.support.DefaultListableBeanFactory@4e044e04:
defining beans [dataSource,dao,ty
pes_for_getting_DDL,exclude_map_prefixes,exclude_map_pattern,fileWorker,transfor
mParams_for_dbms_metadata,ddlFormatter,worker]; root of factory hierar
chy
start getting of user object list for processing
list.size() before filter = 60
get 60 objects
08.11.2012 9:48:54
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
08.11.2012 9:48:54 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL,
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException:
CallableStatementCallback; uncategorized SQLException for SQL [DECLARE
callstr VARCHAR2(4000);
BEGIN
dbms_job.user_export(101, callstr);
:done := callstr; END;]; SQL state [99999]; error code [23421]; ORA-23421:
íîìåð çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â
î÷åðåäè çàäàíèé
ORA-06512: íà "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà "SYS.DBMS_IJOB", line 529
ORA-06512: íà "SYS.DBMS_JOB", line 284
ORA-06512: íà line 4
; nested exception is java.sql.SQLException: ORA-23421: íîìåð
çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â
î÷åðåäè çàäàíèé
ORA-06512: íà "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà "SYS.DBMS_IJOB", line 529
ORA-06512: íà "SYS.DBMS_JOB", line 284
ORA-06512: íà line 4
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:944)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:956)
at ru.qwazer.scheme2ddl.Dao.findDbmsJobDDL(Unknown Source)
at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Unknown Source)
at ru.qwazer.scheme2ddl.Dao.fillDDL(Unknown Source)
at ru.qwazer.scheme2ddl.Worker.work(Unknown Source)
at ru.qwazer.scheme2ddl.Main.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-23421: íîìåð çàäàíèÿ 101 íå
ñîîòâåòñòâóåò çàäàíèþ â î÷åðåäè çàäàíèé
ORA-06512: íà "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà "SYS.DBMS_IJOB", line 529
ORA-06512: íà "SYS.DBMS_JOB", line 284
ORA-06512: íà line 4
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4719)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
at ru.qwazer.scheme2ddl.Dao$CallableStatementCallbackImpl.doInCallableStatement(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:928)
... 6 more