Hello Mike,
I think Im using the FrontBasePlugIn form Wonder, but im seeingthat
the JRE has another frontbaseplugin, (lowercase) in the WebObjetcs
library I have checked the FrontBasePlugin. anyway.... here is the
whole stacktrace.
Thanks for the help
Gus
Oct 17 13:04:11 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Finished initialization after launch: ERXExtensions
Oct 17 13:04:11 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Finished initialization after launch: Ajax
Oct 17 13:04:11 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Finished initialization after launch: ERPrototypes
Oct 17 13:04:11 ControlHorarios[1250] (Application.java:17) INFO
er.extensions.appserver.ERXApplication - Welcome to ControlHorarios !
Oct 17 13:04:11 ControlHorarios[1250] (ERXModelGroup.java:125) WARN
er.extensions.eof.ERXModelGroup - Clearing previous class descriptions
Oct 17 13:04:11 ControlHorarios[1250] (ERXModelGroup.java:843) WARN
er.extensions.eof.ERXModelGroup - The EOModel 'erprototypes' has an
empty connection dictionary.
Oct 17 13:04:11 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Using JDBCPlugIn
'com.webobjects.jdbcadaptor.FrontbasePlugIn' for [EMAIL PROTECTED]
Oct 17 13:04:11 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Using JDBCPlugIn
'com.webobjects.jdbcadaptor.FrontbasePlugIn' for [EMAIL PROTECTED]
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Using JDBCPlugIn
'com.webobjects.jdbcadaptor.FrontbasePlugIn' for [EMAIL PROTECTED]
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connecting with dictionary: {password = "<password
deleted for log>"; username = "gustavpicora"; URL = "jdbc:FrontBase://
localhost/ScheduleControl"; }
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - === Begin Internal Transaction
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - === Commit Internal Transaction
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - === Begin Internal Transaction
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Using JDBCPlugIn
'com.webobjects.jdbcadaptor.FrontbasePlugIn' for [EMAIL PROTECTED]
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - fetching JDBC Info with [EMAIL PROTECTED]
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connecting with dictionary: {password = "<password
deleted for log>"; username = "gustavpicora"; URL = "jdbc:FrontBase://
localhost/ScheduleControl"; }
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connection disconnected.
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - fetching JDBC Info with [EMAIL PROTECTED]
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connecting with dictionary: {password = "<password
deleted for log>"; username = "gustavpicora"; URL = "jdbc:FrontBase://
localhost/ScheduleControl"; }
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - evaluateExpression:
<com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
"UPDATE "_dbupdater" SET "lockowner" = 'ControlHorarios--1',
"updatelock" = 1 WHERE ("modelname" = 'ScheduleControl' AND
("updatelock" = 0 OR "lockowner" = 'ControlHorarios--1'))"
withBindings: >
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - === Rollback Internal Transaction
Oct 17 13:04:12 ControlHorarios[1250] (ERXJDBCMigrationLock.java:135)
WARN er.extensions.migration.ERXJDBCMigrationLock - Locking failed,
but this might be OK if this is the first time you are running
migrations. If things keep running, it probably worked fine. The
original reason for the failure:
Semantic error 116. Referenced TABLE - _dbupdater - does not exist.at
com
.frontbase
.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:162)
at
com
.frontbase
.jdbc.FBJErrorMetaData.getExceptionChain(FBJErrorMetaData.java:194)
at com.frontbase.jdbc.FBJStatement.checkMetaData(FBJStatement.java:472)
at com.frontbase.jdbc.FBJStatement.executeUpdate(FBJStatement.java:262)
at
com
.webobjects
.jdbcadaptor
.JDBCChannel
._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:270)
at
com
.webobjects
.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at
com
.webobjects
.jdbcadaptor
.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:
176)
at
er
.extensions
.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:90)
at
er
.extensions
.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:67)
at er.extensions.migration.ERXMigrator
$ERXMigrationAction.doPerform(ERXMigrator.java:381)
at er.extensions.eof.ERXEOAccessUtilities
$ChannelAction.perform(ERXEOAccessUtilities.java:1409)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:
175)
at
er
.extensions
.appserver.ERXApplication.finishInitialization(ERXApplication.java:898)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun
.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:
122)
at com.webobjects.foundation.NSNotificationCenter
$_Entry.invokeMethod(NSNotificationCenter.java:588)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:532)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:546)
at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229)
at er.extensions.appserver.ERXApplication.run(ERXApplication.java:992)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:548)
at er.extensions.appserver.ERXApplication.main(ERXApplication.java:535)
at controlHorarios.app.Application.main(Application.java:12)
Semantic error 485. Near: UPDATE \"_dbupdater\" SET \"lockowner\" =
'ControlHorarios--1', \"updatelock\" = 1 WHERE (\"modelname
\"='ScheduleControl') AND (\"updatelock\"=0 OR \"lockowner
\"='ControlHorarios--1');.
Exception condition 363. Transaction rollback.
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
.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:90)
at
er
.extensions
.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:67)
at er.extensions.migration.ERXMigrator
$ERXMigrationAction.doPerform(ERXMigrator.java:381)
at er.extensions.eof.ERXEOAccessUtilities
$ChannelAction.perform(ERXEOAccessUtilities.java:1409)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:
175)
at
er
.extensions
.appserver.ERXApplication.finishInitialization(ERXApplication.java:898)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun
.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:
122)
at com.webobjects.foundation.NSNotificationCenter
$_Entry.invokeMethod(NSNotificationCenter.java:588)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:532)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:546)
at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229)
at er.extensions.appserver.ERXApplication.run(ERXApplication.java:992)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:548)
at er.extensions.appserver.ERXApplication.main(ERXApplication.java:535)
at controlHorarios.app.Application.main(Application.java:12)
Oct 17 13:04:12 ControlHorarios[1250] (ERXJDBCUtilities.java:588)
INFO er.extensions.jdbc.ERXJDBCUtilities - Executing CREATE TABLE
_dbupdater(lockowner VARCHAR(100), modelname VARCHAR(100) NOT NULL,
updatelock INTEGER NOT NULL, version INTEGER NOT NULL)
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - === Begin Internal Transaction
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - === Commit Internal Transaction
Oct 17 13:04:12 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:43)
WARN NSLog - A fatal exception occurred: Failed to create lock
table. Try executing:
CREATE TABLE _dbupdater(lockowner VARCHAR(100), modelname VARCHAR(100)
NOT NULL, updatelock INTEGER NOT NULL, version INTEGER NOT NULL);
.
[2008-10-17 13:4:12 COT] <main>
er.extensions.migration.ERXMigrationFailedException: Failed to create
lock table. Try executing:
CREATE TABLE _dbupdater(lockowner VARCHAR(100), modelname VARCHAR(100)
NOT NULL, updatelock INTEGER NOT NULL, version INTEGER NOT NULL);
.
at
er
.extensions
.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:141)
at
er
.extensions
.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:67)
at er.extensions.migration.ERXMigrator
$ERXMigrationAction.doPerform(ERXMigrator.java:381)
at er.extensions.eof.ERXEOAccessUtilities
$ChannelAction.perform(ERXEOAccessUtilities.java:1409)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:
175)
at
er
.extensions
.appserver.ERXApplication.finishInitialization(ERXApplication.java:898)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun
.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:
122)
at com.webobjects.foundation.NSNotificationCenter
$_Entry.invokeMethod(NSNotificationCenter.java:588)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:532)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:546)
at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229)
at er.extensions.appserver.ERXApplication.run(ERXApplication.java:992)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:548)
at er.extensions.appserver.ERXApplication.main(ERXApplication.java:535)
at controlHorarios.app.Application.main(Application.java:12)
Caused by: java.sql.SQLException: Syntax error 61. Expected Identifier
not found.
at
com
.frontbase
.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:162)
at
com
.frontbase
.jdbc.FBJErrorMetaData.getExceptionChain(FBJErrorMetaData.java:194)
at com.frontbase.jdbc.FBJStatement.checkMetaData(FBJStatement.java:472)
at com.frontbase.jdbc.FBJStatement.executeUpdate(FBJStatement.java:262)
at
er
.extensions
.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:590)
at
er
.extensions
.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:556)
at
er
.extensions
.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:136)
... 18 more
On Oct 17, 2008, at 1:16 PM, Mike Schrag wrote:
I was reading a prior post and it says about some incompatibility
with the FB plugins, but couldn't make what you were trying to say,
about a FrotBasePlugInPrincipal, is this problem Im having related
to that one mentioned before? or its completly different, if so,
then what im missing, probably some parameter in URL in the EOModel?
Update FrontBasePlugIn from the latest Wonder and see if this goes
away. I suspect there's another error or warning somewhere earlier
in your console output that is saying there's a prior problem. It
could be the bug I had in refactoring the FB plugin recently, though
you would have had to have updated in a window of one particular day
to get that, but stranger things have happened.
The problem here is the REAL frontbase plugin would have quoted
"_dbupdater" in that create statement. That you're not getting
quotes means you're not using our FrontBasePlugIn.
ms
_______________________________________________
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/webobjectspicora%40gmail.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
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]
