The ERPrototypes and FrontBasePlugin libraries are correctly set up in the class path. The FrontBase related JARS and frameworks are set up in the system class path. In the model file the FrontBase prototypes were selected.
Trying to isolate the problem to study a solution, I stripped down the migrations file generated, leaving only one entity and only the string-based attributes. After this I got the following error:
Dez 17 12:45:04 AdministraAgencias1.0[60001] INFO er.transaction.adaptor.ConnectionAnalyzer - JDBC connection successful!
Dez 17 12:45:04 AdministraAgencias1.0[60001] ERROR er.extensions.appserver.ERXApplication - AdministraAgencias1.0 failed to start.
JDBCAdaptorException: Unable to find type information for external type 'INT' in attribute 'updateLock' of entity '_dbupdater'. Check spelling and capitalization.
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression.columnTypeStringForAttribute(_FrontBasePlugIn.java:1187)
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression.addCreateClauseForAttribute(_FrontBasePlugIn.java:1095)
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseSynchronizationFactory.addCreateClauseForAttribute(_FrontBasePlugIn.java:905)
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseSynchronizationFactory.createTableStatementsForEntityGroup(_FrontBasePlugIn.java:845)
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseSynchronizationFactory.createTableStatementsForEntityGroups(_FrontBasePlugIn.java:809)
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseSynchronizationFactory.schemaCreationStatementsForEntities(_FrontBasePlugIn.java:640)
at com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseSynchronizationFactory.schemaCreationScriptForEntities(_FrontBasePlugIn.java:606)
at er.extensions.jdbc.ERXSQLHelper.createSchemaSQLForEntitiesWithOptions(ERXSQLHelper.java:286)
at er.extensions.migration.ERXJDBCMigrationLock.dbUpdaterCreateStatement(ERXJDBCMigrationLock.java:370)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:148)
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:1502)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1294)
... skipped 13 stack elements
Any clues? Adding a little more information, the migrations and application worked well with MySQL, but a problem with a circular relationship convinced me to switch to FrontBase, when I faced the error above for the first time. Well, to say the truth, I had a problem with the connection dictionary password, but was able to solve it specifying the dbpasswd and upasswd properties.