[Dspace-tech] Dspace 1.6.2 src Solaris 10, Oracle10, ant fails.
0 views
Skip to first unread message
Marvin Weaver
Aug 25, 2015, 2:09:10 PM8/25/15
to dspac...@lists.sourceforge.net
I have cleared the oracle database of everything I know of.
No tables in tabs, No user_constraints, No views, No sequences, No user_objects, purged recyclebin. I did this by modifying the clean_database.sql that came with 1.5.2, adding elements that were not in it. I changed all the DROP TABLE statements to be DROP TABLE tablename CASCADE CONSTRAINTS PURGE; and added a PURGE RECYCLEBIN; at the end. I checked them all with appropriate queries.
Oracle 10.2.0.3, Solaris 10, ojdbc14 10.2.0.2, and ant 1.8.1
So now ant fresh_install fails with:
-bash-3.00$ ant fresh_install
Buildfile: /dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml
init_installation:
init_configs:
test_database:
[java] 2010-08-31 12:41:21,199 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:21,238 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java]
[java] Attempting to connect to database:
[java] - URL: jdbc:oracle:thin:@//dumbbell:1521/dspace
[java] - Driver: oracle.jdbc.OracleDriver
[java] - Username: dspace
[java] - Password: dspace2009
[java] - Schema: dspace
[java]
[java] Testing connection...
[java] Connected succesfully!
[java]
setup_database:
[java] 2010-08-31 12:41:23,281 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:23,323 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-31 12:41:23,323 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2010-08-31 12:41:24,933 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
[java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-31 12:41:24,942 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
[java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-31 12:41:30,946 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:30,998 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-31 12:41:33,249 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:33,263 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:35,512 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:35,520 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,160 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,168 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,522 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,531 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
load_registries:
[java] 2010-08-31 12:41:40,025 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:40,093 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] Error:
[java] - null
[java] 2010-08-31 12:41:41,972 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] java.lang.NullPointerException
[java] at
org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:674)
[java] at
org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:110)
[java] at
org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:507)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:713)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:419)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:202)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:168)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:105)
BUILD FAILED
/dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml:663:
Java returned: 1
Total time: 24 seconds
Any suggestions welcomed.
Marvin Weaver
Previous problem:
I finally found the problem! Solaris 10 comes with Sun's own screwed up
version of tar. It was truncating filenames at 21 characters. (I
thought they had abandoned it back with 5.8 and embraced gtar).
I updated jdk to 1.60_21, installed gtar from sunfreeware, ran mvn
-Udb.name=oracle package, and it built. Only one very strange thing I
noticed, gtar ended with "tar: A lone zero block at 44151" rather than a
clean exit.
Now, when trying ant fresh_install, I'm getting "index already
exists"...I'll wipe the database and try again.
No tables in tabs, No user_constraints, No views, No sequences, No user_objects, purged recyclebin. I did this by modifying the clean_database.sql that came with 1.5.2, adding elements that were not in it. I changed all the DROP TABLE statements to be DROP TABLE tablename CASCADE CONSTRAINTS PURGE; and added a PURGE RECYCLEBIN; at the end. I checked them all with appropriate queries.
Oracle 10.2.0.3, Solaris 10, ojdbc14 10.2.0.2, and ant 1.8.1
So now ant fresh_install fails with:
-bash-3.00$ ant fresh_install
Buildfile: /dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml
init_installation:
init_configs:
test_database:
[java] 2010-08-31 12:41:21,199 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:21,238 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java]
[java] Attempting to connect to database:
[java] - URL: jdbc:oracle:thin:@//dumbbell:1521/dspace
[java] - Driver: oracle.jdbc.OracleDriver
[java] - Username: dspace
[java] - Password: dspace2009
[java] - Schema: dspace
[java]
[java] Testing connection...
[java] Connected succesfully!
[java]
setup_database:
[java] 2010-08-31 12:41:23,281 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:23,323 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-31 12:41:23,323 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2010-08-31 12:41:24,933 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
[java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-31 12:41:24,942 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
[java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-31 12:41:30,946 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:30,998 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-31 12:41:33,249 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:33,263 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:35,512 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:35,520 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,160 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,168 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,522 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,531 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
load_registries:
[java] 2010-08-31 12:41:40,025 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:40,093 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] Error:
[java] - null
[java] 2010-08-31 12:41:41,972 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] java.lang.NullPointerException
[java] at
org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:674)
[java] at
org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:110)
[java] at
org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:507)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:713)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:419)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:202)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:168)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:105)
BUILD FAILED
/dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml:663:
Java returned: 1
Total time: 24 seconds
Any suggestions welcomed.
Marvin Weaver
Previous problem:
I finally found the problem! Solaris 10 comes with Sun's own screwed up
version of tar. It was truncating filenames at 21 characters. (I
thought they had abandoned it back with 5.8 and embraced gtar).
I updated jdk to 1.60_21, installed gtar from sunfreeware, ran mvn
-Udb.name=oracle package, and it built. Only one very strange thing I
noticed, gtar ended with "tar: A lone zero block at 44151" rather than a
clean exit.
Now, when trying ant fresh_install, I'm getting "index already
exists"...I'll wipe the database and try again.
Pottinger, Hardy J.
Aug 25, 2015, 2:09:11 PM8/25/15
to mwe...@sju.edu, dspac...@lists.sourceforge.net
Hi, Marvin, here are my notes for when I cleared out our old development site based on 1.5.1, in preparation for testing an upgrade of our live site to 1.6.2. I'm no DBA, but this procedure worked for me.
I used Oracle's free SQL Developer tool, which is really handy for this kind of thing, and is cross-platform.
First, this thread provided the inspiration: http://www.dbapool.com/forumthread/topic_14101.html
But after some experimentation, I discovered that I don't have access to the "DBA" prefixed tables. But I do have access to "USER" prefixed tables. So, here are my revisions to the suggested code:
-- DISABLE CONSTRAINTS
-- results in a list of SQL statements, which you can copy/paste into a
-- new SQL script and run (disabling constraints required in order to truncate
-- certain tables
select 'Alter Table'||' '||table_name||' '||'Disable Constraint'||' '||constraint_name||';' from user_constraints ORDER BY TABLE_NAME;
Run that, copy the results, paste, run the results. Same drill for the next two:
-- ENABLE CONSTRAINTS
-- results in a list of SQL statements, which you can copy/paste into a
-- new SQL script and run (enabling constraints)
select 'Alter Table'||' '||table_name||' '||'Enable Constraint'||' '||index_name||';' from user_indexes ORDER BY TABLE_NAME;
-- TRUNCATE TABLES
-- results in a list of SQL statements, which you can copy/paste into a
-- new SQL script and run (truncating all tables)
select 'truncate'||' '||'table'||' '||table_name|| ';' from user_tables;
You'll likely have to run this multiple times (disable constraints, truncate and drop tables, disable more constraints, truncate and drop tables, etc.) until all tables are gone.
Finally, you'll need to drop all your sequences:
select 'drop'||' '||'sequence'||' '||sequence_name|| ';' from user_sequences;
It's not pretty, I bet it could be improved, but this will definitely zero out your database.
Hope that helps.
--Hardy
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ------------------------------------------------------------------------
> ------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
I used Oracle's free SQL Developer tool, which is really handy for this kind of thing, and is cross-platform.
First, this thread provided the inspiration: http://www.dbapool.com/forumthread/topic_14101.html
But after some experimentation, I discovered that I don't have access to the "DBA" prefixed tables. But I do have access to "USER" prefixed tables. So, here are my revisions to the suggested code:
-- DISABLE CONSTRAINTS
-- results in a list of SQL statements, which you can copy/paste into a
-- new SQL script and run (disabling constraints required in order to truncate
-- certain tables
select 'Alter Table'||' '||table_name||' '||'Disable Constraint'||' '||constraint_name||';' from user_constraints ORDER BY TABLE_NAME;
Run that, copy the results, paste, run the results. Same drill for the next two:
-- ENABLE CONSTRAINTS
-- results in a list of SQL statements, which you can copy/paste into a
-- new SQL script and run (enabling constraints)
select 'Alter Table'||' '||table_name||' '||'Enable Constraint'||' '||index_name||';' from user_indexes ORDER BY TABLE_NAME;
-- TRUNCATE TABLES
-- results in a list of SQL statements, which you can copy/paste into a
-- new SQL script and run (truncating all tables)
select 'truncate'||' '||'table'||' '||table_name|| ';' from user_tables;
You'll likely have to run this multiple times (disable constraints, truncate and drop tables, disable more constraints, truncate and drop tables, etc.) until all tables are gone.
Finally, you'll need to drop all your sequences:
select 'drop'||' '||'sequence'||' '||sequence_name|| ';' from user_sequences;
It's not pretty, I bet it could be improved, but this will definitely zero out your database.
Hope that helps.
--Hardy
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java
> :100)
> [java] 2010-08-31 12:41:30,946 INFO
> org.dspace.core.ConfigurationManager @ Loading system provided config
> property (-Ddspace.configuration): config/dspace.cfg
> [java] 2010-08-31 12:41:30,998 INFO
> org.dspace.core.ConfigurationManager @ Using default log4j provided
> log configuration,if uninitended, check your dspace.cfg for
> (log.init.config)
> [java] 2010-08-31 12:41:33,249 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java
> :100)
> [java] 2010-08-31 12:41:30,946 INFO
> org.dspace.core.ConfigurationManager @ Loading system provided config
> property (-Ddspace.configuration): config/dspace.cfg
> [java] 2010-08-31 12:41:30,998 INFO
> org.dspace.core.ConfigurationManager @ Using default log4j provided
> log configuration,if uninitended, check your dspace.cfg for
> (log.init.config)
> [java] 2010-08-31 12:41:33,249 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:33,263 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:33,263 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:35,512 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:35,512 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:35,520 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:35,520 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,160 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,160 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,168 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,168 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,522 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,522 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ava:491)
> [java] at
> org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,531 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
> [java] at
> org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
> [java] at
> org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
> [java] at
> org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
> [java] 2010-08-31 12:41:36,531 ERROR
> org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
> [java] java.sql.SQLException: ORA-00942: table or view does not
> exist
> [java]
> [java] at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> [java] at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> [java] at
> oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> [java] at
> a:216)
> [java] at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:955)
> [java] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1168)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3316)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3400)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:102)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav
> a:460)
> [java] at
> org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j
> ------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
Reply all
Reply to author
Forward
0 new messages