hi
i have a big problem.
task: i need to execute multiple queries form some files. each file contains at about 50-100 query. the queries are from create table to create function ... almost everything. this batches should run on more than 600 databases.
my problem is:
i used the Statement.addBatch() to add the batch to the statement, and i execute batch with the Statement.executeBatch() method. the execution failes with the following error:
org.postgresql.util.PSQLException: Too many update results were returned.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleCommandStatus(AbstractJdbc2Statement.java:2468)
at org.postgresql.core.v3.QueryExecutorImpl.interpretCommandStatus(QueryExecutorImpl.java:1559)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1274)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2559)
at com.xxx.db.Database.executeUpdater(Database.java:xy)
at com.taylor.zeus.patcher.db.DatabaseSelector.upgradeDatabases(DatabaseSelector.java:xy)
at com.xxx.Patcher.start(Patcher.java:xy)
at com.xxx.Application.start(Application.java:xy)
at com.xxx.Application.main(Application.java:xy)
i goggled all over the web to find out what is the source of this exception, but i don't find anything.
can someone explain to me what should i do. or at least what is the problem with this.
platform: linux with 2.6.20-16-generic kernel
db: PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
jdbc: 8.1 jdbc3 (i don't know what build number is)
regards
Laszlo-Robert, Albert
Building a website is a piece of cake.
Yahoo! Small Business gives you
all the tools to get online.