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>
--------------------------------