Hi,
During the conversion process for Migration, I've started facing issue for one
of our frameworks where in the Properties file following properties are defined:
er.extensions.ERXJDBCAdaptor.className=er.extensions.jdbc.ERXJDBCAdaptor
er.extensions.ERXJDBCAdaptor.useConnectionBroker = true
dbMinConnectionsGLOBAL=1
dbMaxConnectionsGLOBAL=5
dbMaxCheckoutGLOBAL=600
dbDebugLevelGLOBAL=3
However if my project use this framework, the Migrations fail with following
exception:
ERROR: relation "_dbupdater" does not existat
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
at
com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:263)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at
com.webobjects.jdbcadaptor.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:176)
at
er.extensions.jdbc.ERXJDBCAdaptor$Channel.updateValuesInRowsDescribedByQualifier(ERXJDBCAdaptor.java:278)
at
er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:93)
at
er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at
er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at
er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
at
com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel(JDBCContext.java:170)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:344)
at
com.webobjects.jdbcadaptor.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:176)
at
er.extensions.jdbc.ERXJDBCAdaptor$Channel.updateValuesInRowsDescribedByQualifier(ERXJDBCAdaptor.java:278)
at
er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:93)
at
er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at
er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at
er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
2010-09-23 09:49:08,200 ERROR QSTPTRMS[-:12345 0]
er.extensions.appserver.ERXApplication (ERXApplication.java:1301) - QSTPTRMS
failed to start.
er.extensions.migration.ERXMigrationFailedException: Failed to create lock
table. Try executing:
CREATE TABLE _dbupdater (lockowner varchar(100) , modelname varchar(100) NOT
NULL, updatelock int4 NOT NULL, version int4 NOT NULL);
.
at
er.extensions.migration.ERXMigrationFailedException.fillInStackTrace(ERXMigrationFailedException.java:50001)
at java.lang.Throwable.<init>(Throwable.java:218)
at java.lang.Exception.<init>(Exception.java:59)
at java.lang.RuntimeException.<init>(RuntimeException.java:61)
at
er.extensions.migration.ERXMigrationFailedException.<init>(ERXMigrationFailedException.java:14)
at
er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:159)
at
er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at
er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at
er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
Caused by: java.lang.NullPointerException
at
er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:646)
at
er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:597)
at
er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:579)
at
er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:152)
... 26 more
2010-09-23 09:49:08,201 WARN QSTPTRMS[-:12345 0] NSLog
(ERXNSLogLog4jBridge.java:43) - A fatal exception occurred: Failed to create
lock table. Try executing:
CREATE TABLE _dbupdater (lockowner varchar(100) , modelname varchar(100) NOT
NULL, updatelock int4 NOT NULL, version int4 NOT NULL);
.
[2010-9-23 9:49:8 AST] <main>
er.extensions.migration.ERXMigrationFailedException: Failed to create lock
table. Try executing:
CREATE TABLE _dbupdater (lockowner varchar(100) , modelname varchar(100) NOT
NULL, updatelock int4 NOT NULL, version int4 NOT NULL);
.
at
er.extensions.migration.ERXMigrationFailedException.fillInStackTrace(ERXMigrationFailedException.java:50001)
at java.lang.Throwable.<init>(Throwable.java:218)
at java.lang.Exception.<init>(Exception.java:59)
at java.lang.RuntimeException.<init>(RuntimeException.java:61)
at
er.extensions.migration.ERXMigrationFailedException.<init>(ERXMigrationFailedException.java:14)
at
er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:159)
at
er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at
er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at
er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at
er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
Caused by: java.lang.NullPointerException
at
er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:646)
at
er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:597)
at
er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:579)
at
er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:152)
... 26 more
Any ideas?
Thanks,
Farrukh _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
