i think it's an error in wonder-mysql-plugin 25 апреля 2012 г. 9:22 пользователь Ron X <[email protected]> написал:
> i think i use MySQL-plugin checkouted from WONDER-repo. > > 25 апреля 2012 г. 1:33 пользователь Pascal Robert <[email protected]>написал: > > You have to use the MySQL plugin from Wonder, the bundled plugin coming >> with WO 5.4 have problems. >> >> > i use MySQL and do migration by the migration java class (not sql-file): >> > .... >> > >> > @Override >> > public void upgrade(EOEditingContext editingContext, >> ERXMigrationDatabase database) throws Throwable { >> > ERXMigrationTable albumTable = >> database.existingTableNamed("Album"); >> > albumTable.newStringColumn("oldName", true); >> > >> > .... >> > >> > and i get: >> > >> > INFO 32.41 MB used/48.65 MB free [ProcessChangesQueue] >> (ERXJDBCUtilities.java:653) - Executing alter table Album null oldName >> longtext >> > DEBUG 34.08 MB used/46.99 MB free [ProcessChangesQueue] >> (ERXEOAccessUtilities.java:1221) - "_dbupdater"@999692932 expression took >> 5 ms: UPDATE _dbupdater SET lockowner = NULL, updatelock = ? WHERE >> modelname = ? withBindings: 1:0[updateLock], 2:sounds[modelName] >> > ERROR 34.41 MB used/46.65 MB free [ProcessChangesQueue] >> (ERXApplication.java:1307) - SoundsAdmin failed to start. >> > MySQLSyntaxErrorException: You have an error in your SQL syntax; check >> the manual that corresponds to your MySQL server version for the right >> syntax to use near 'null oldName longtext' at line 1 >> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >> > at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >> > at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >> > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) >> > at com.mysql.jdbc.Util.getInstance(Util.java:384) >> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) >> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) >> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) >> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) >> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) >> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562) >> > at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1664) >> > at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1583) >> > at >> er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:656) >> > at >> er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:614) >> > at >> er.extensions.migration.ERXMigrationColumn.create(ERXMigrationColumn.java:390) >> > at >> er.extensions.migration.ERXMigrationTable._newColumn(ERXMigrationTable.java:237) >> > at >> er.extensions.migration.ERXMigrationTable.newColumn(ERXMigrationTable.java:282) >> > at >> er.extensions.migration.ERXMigrationTable.newLargeStringColumn(ERXMigrationTable.java:334) >> > at >> er.extensions.migration.ERXMigrationTable.newStringColumn(ERXMigrationTable.java:321) >> > at >> dm.legalsounds.migrations.LegalSounds147.upgrade(LegalSounds147.java:20) >> > at >> er.extensions.migration.ERXMigrationDatabase$Migration.upgrade(ERXMigrationDatabase.java:444) >> > at >> er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:473) >> > at >> er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1489) >> > at >> er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201) >> > at >> er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1186) >> > ... skipped 13 stack elements >> > WARN 38.74 MB used/42.32 MB free [ProcessChangesQueue] >> (ERXNSLogLog4jBridge.java:43) - A fatal exception occurred: Migration >> failed. >> > [2012-4-21 15:59:31 EEST] <ProcessChangesQueue> >> er.extensions.migration.ERXMigrationFailedException: Migration failed. >> > at >> er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:490) >> > at >> er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1489) >> > at >> er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201) >> > at >> er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1186) >> > 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:597) >> > 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:1303) >> > at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) >> > at er.extensions.appserver.ERXApplication.main(ERXApplication.java:783) >> > at dm.legalsounds.Application.main(Application.java:45) >> > Caused by: java.lang.RuntimeException: Failed to execute 'alter table >> Album null oldName longtext'. >> > at >> er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:660) >> > at >> er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:614) >> > at >> er.extensions.migration.ERXMigrationColumn.create(ERXMigrationColumn.java:390) >> > at >> er.extensions.migration.ERXMigrationTable._newColumn(ERXMigrationTable.java:237) >> > at >> er.extensions.migration.ERXMigrationTable.newColumn(ERXMigrationTable.java:282) >> > at >> er.extensions.migration.ERXMigrationTable.newLargeStringColumn(ERXMigrationTable.java:334) >> > at >> er.extensions.migration.ERXMigrationTable.newStringColumn(ERXMigrationTable.java:321) >> > at >> dm.legalsounds.migrations.LegalSounds147.upgrade(LegalSounds147.java:20) >> > at >> er.extensions.migration.ERXMigrationDatabase$Migration.upgrade(ERXMigrationDatabase.java:444) >> > at >> er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:473) >> > ... 16 more >> > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> You have an error in your SQL syntax; check the manual that corresponds to >> your MySQL server version for the right syntax to use near 'null oldName >> longtext' at line 1 >> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >> > >> > ================= >> > >> > why EOF generate >> > alter table Album null oldName longtext >> > ? >> > well-written code is: >> > alter table Album ADD oldName longtext >> > >> > thanx. >> > >> > 17 апреля 2012 г. 18:43 пользователь Henrique Prange <[email protected]> >> написал: >> > Hi Ron, >> > >> > The m2e plug-in usually respects the order of your dependencies. Always >> add ERExtensions as your first dependency to avoid problems. >> > >> > Cheers, >> > >> > Henrique >> > >> > On 17/04/2012, at 12:30, Ron X wrote: >> > >> >> i use maven >> >> >> >> 17 апреля 2012 г. 17:17 пользователь Johann Werner <[email protected]> >> написал: >> >> >> >> Am 17.04.2012 um 15:52 schrieb Ron X: >> >> >> >>> compilation error: >> >>> The constructor NSArray<String>(String, String) is undefined >> >> >> >> Then something with your class path is wrong, the Wonder version of >> NSArray has the constructor NSArray(E, E...). >> >> Check if ERExtensions comes before the Java* frameworks. >> >> >> >> >> >>> >> >>> 17 апреля 2012 г. 11:53 пользователь Johann Werner <[email protected]> >> написал: >> >>> >> >>> Am 17.04.2012 um 09:22 schrieb Ron X: >> >>> >> >>>> NSArray<String> keys = new NSArray<String>(new >> String[]{"chart_count", "chart_size_sum"}); >> >>> >> >>> don't make it more complicated than necessary: >> >>> >> >>> keys = new NSArray<String>("chart_count", "chart_size_sum"); >> >>> >> >>> >> >>> >> >>>> NSArray<NSDictionary> result = >> EOUtilities.rawRowsForSQL(editingContext, >> >>>> "legalsounds", >> >>>> "SELECT count(*), sum(songFileSize) FROM `Song`", >> keys); >> >>>> >> >>>> works fine >> >>>> >> >>>> 17 апреля 2012 г. 10:20 пользователь Ron X <[email protected]> >> написал: >> >>>> Error! >> >>>> The method rawRowsForSQL(EOEditingContext, String, String, NSArray) >> in the type EOUtilities is not applicable for the arguments >> (EOEditingContext, String, String, String[]) >> >>>> >> >>>> 13 апреля 2012 г. 21:47 пользователь Larry Mills-Gahl < >> [email protected]> написал: >> >>>> >> >>>> >> >>>> >> >>>> On Apr 13, 2012, at 7:07 AM, Ron X wrote: >> >>>> >> >>>>> thank you very much! very good! >> >>>>> this method considered deprecated - is there non-deprecated method? >> >>>> >> >>>> EOUtilities.rawRowsForSQL(EOEditingContext ec, String modelName, >> String sqlString, NSArray keys) >> >>>> >> >>>> >> >>>> rawRowsForSQL >> >>>> >> >>>> public static NSArray rawRowsForSQL(EOEditingContext >> >>>> ec, >> >>>> >> >>>> String >> >>>> modelName, >> >>>> >> >>>> String >> >>>> sqlString, >> >>>> >> >>>> NSArray keys) >> >>>> Evaluates the specified SQL and returns the resulting raw rows. >> >>>> >> >>>> >> >>>> Parameters: >> >>>> ec - an EOEditingContext >> >>>> modelName - name of the EOModel to use >> >>>> sqlString - the query string in SQL syntax >> >>>> keys - array of Strings corresponding to the SELECT list; these will >> be used as the keys in the result dictionaries; use null for default naming >> >>>> Returns: >> >>>> matching raw rows (an NSArray of NSDictionaries) >> >>>> Since: >> >>>> 5.2.2 >> >>>> >> >>>> >> >>> >> >>> >> >> >> >> >> >> _______________________________________________ >> >> Do not post admin requests to the list. They will be ignored. >> >> Webobjects-dev mailing list ([email protected]) >> >> Help/Unsubscribe/Update your Subscription: >> >> >> https://lists.apple.com/mailman/options/webobjects-dev/hprange%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: >> > >> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >> > >> > 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
