Problems running Servoy 4.1 and Mysql on a Mac

[popdizzle]

I'm helping someone try to get Servoy 4.1 running on their Mac (10.5) with Mysql 5.0.x. They installed MAMP, which is a mac app to help manage Apache and Mysql. Mamp installed mysql and put it at port 8889. It also put the mysql.sock file in a non-standard place so we created a symbolic link between the directories. Not sure if that matters.

I can add a database server that points to our database in mysql. It connects okay and saves the info. If I click on the db server name, it shows the tables in the window below. However, if I click on a table name, I get an error that says the mysql table editor cannot be opened. If I click "Details", I get the following errors. I have tried several mysql drivers, including the one I use regularly on 3.5 and 4.0 on my own Windows XP machine. The database does exist, as do the tables, so the driver seems to be having trouble talking to the mysql server.

Has anyone seen this or have any ideas on the cause?

--------------------------------
java.lang.RuntimeException: Could not initialize table editor: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'tmwm2.cpus' doesn't exist Table 'tmwm2.cpus' doesn't exist
at com.servoy.eclipse.ui.editors.TableEditor.setInput(TableEditor.java)
at org.eclipse.ui.part.MultiPageEditorPart.init(MultiPageEditorPart.java:537)
at com.servoy.eclipse.ui.editors.TableEditor.init(TableEditor.java)
at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:794)
....<many more lines omitted>
--------------------------------

[IT2Be]

Mamp installed mysql and put it at port 8889. It also put the mysql.sock file in a non-standard place so we created a symbolic link between the directories. Not sure if that matters.

Remove it. I think it will only screw things up.

Use the latest jdbc driver. I think that is the best thing you can do.

I have mamp installed as well but only for testing purposes. Disadvantage is that you have to fire up mamp each time you use it including apache and php.
When they are going to use Servoy on a daily basis and use MySQL as their main db I would install a 'normal' MySQL distro.

I can't do much with the error message though. Sorry...
- Does the user have sufficient rights?
- Can you create/open a table with other tools?
- etc...

[lvostinar]

In the other log ( servoy_log.txt) should be the complete error (with stack). This is only the runtime error we throw and message from actual error. So , can you post that as well ?

[popdizzle]

We can access the tables fine via phpMyAdmin.

Here's the log:

2008-11-06 21:43:36,527 ERROR [main] com.servoy.j2db.persistence.Server - com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'tmwm2.dummy' doesn't exist
2008-11-06 21:43:36,529 WARN [main] com.servoy.j2db.util.Debug - Failed on getting colums using catalog 'tmwm2' and schema 'null' for table 'dummy' -- continuing using server-defined catalog and schema
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'tmwm2.dummy' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2471)
at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2345)
at com.servoy.j2db.persistence.Server.askTableForColumns(Server.java)
at com.servoy.j2db.persistence.Server.initTable(Server.java)
at com.servoy.j2db.persistence.Server.getTable(Server.java)
at com.servoy.j2db.persistence.Form.getTable(Form.java)
at com.servoy.eclipse.ui.property.PersistProperties.Za(PersistProperties.java)
at com.servoy.eclipse.ui.property.PersistProperties.Zb(PersistProperties.java)
at com.servoy.eclipse.ui.property.PersistProperties.Za(PersistProperties.java)
at com.servoy.eclipse.ui.property.PersistProperties.Zb(PersistProperties.java)
at com.servoy.eclipse.ui.property.PersistProperties.Za(PersistProperties.java)
at com.servoy.eclipse.designer.editor.commands.Zv.isChecked(Zv.java)
at org.eclipse.jface.action.ActionContributionItem.update(ActionContributionItem.java:890)
at org.eclipse.jface.action.ActionContributionItem.fill(ActionContributionItem.java:281)
at org.eclipse.jface.action.MenuManager.update(MenuManager.java:666)
at org.eclipse.jface.action.MenuManager.handleAboutToShow(MenuManager.java:396)
at org.eclipse.jface.action.MenuManager.access$1(MenuManager.java:391)
at org.eclipse.jface.action.MenuManager$2.menuShown(MenuManager.java:417)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1495)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1519)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1500)
at org.eclipse.swt.widgets.Menu.kEventMenuOpening(Menu.java:761)
at org.eclipse.swt.widgets.Widget.menuProc(Widget.java:1253)
at org.eclipse.swt.widgets.Display.menuProc(Display.java:2752)
at org.eclipse.swt.internal.carbon.OS.ContextualMenuSelect(Native Method)
at org.eclipse.swt.widgets.Menu._setVisible(Menu.java:203)
at org.eclipse.swt.widgets.Display.runPopups(Display.java:3402)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2929)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
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 org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)

[agiletortoise]

Is 'tmwm2.dummy' a valid table in your setup? Can you browse and execute SQL statements against that table in phpMyAdmin?

greg.

[popdizzle]

Yes, that is a real table and it works fine from phpMyAdmin.

We ended up turning off Mamp and installed Mysql using the Mysql .dmg file and everything worked fine after that.

Thanks everyone.