• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Migrations and Pooling - Exception
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Migrations and Pooling - Exception

  • Subject: Migrations and Pooling - Exception
  • From: Farrukh Ijaz <email@hidden>
  • Date: Thu, 23 Sep 2010 09:55:47 +0300
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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: Migrations and Pooling - Exception
      • From: Stefan Klein <email@hidden>
  • Prev by Date: Antw: Re: XMLHttpRequest - call direct action using relative URL
  • Next by Date: Re: Migrations and Pooling - Exception
  • Previous by thread: Antw: Re: XMLHttpRequest - call direct action using relative URL
  • Next by thread: Re: Migrations and Pooling - Exception
  • Index(es):
    • Date
    • Thread