I am using the trial version of Servoy devleoper for Mac OS X.
The install went ok but I cannot seem to setup the connection to a MySQL server. I am trying to add a server connection under Preferences → DB Server → then Auto Setup drop down menu and choose “MySQL”
I have tried both a remote mysql server and a connection to localhost-- a mysql server running on my local machine.
I have selected Auto setup for a Mysql conncetion but I am getting this error every time:
JDBC Driver ‘org.gjt.mm.mysql.Driver’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver org.gjt.mm.mysql.Driver
jdbc:mysql://mysql.dwchost.com/jfbuser_DWCsystem
Is the localhost required for developer? I have also tried it iwth localhost (installed MySQL 5 on my laptop for this), but I got the same error.
Please advise… I am very new to this and am excited by the possibility of editing a database I have already created the structure of in MySQL. Alas, I cannot even connect to it using Servoy! Any assistance is greatly appreciated.
Please advise… I am very new to this and am excited by the possibility of editing a database I have already created the structure of in MySQL. Alas, I cannot even connect to it using Servoy! Any assistance is greatly appreciated.
Great to see you are keen to use Servoy and ANOTHER mac user Before Servoy will let you create the datasource you need to have actually created the db in mySQL ie it has to exist before Servoy can link to it!. I found a couple of tools that make this a easy they are:
Cocoa MySQL - Its shareware and great little app for managing MySQL at a basic level
MySQL themselves have the MySQL admin tool, but I found this a bit unreliable ie it crashes a lot! On My G4Dual with loads of RAM, so it may be better on a G5
Navicat - It costs about 200, but its excellent and if you are committed to MySQL then this is well worth the $$$ etc
If you are interested in hosting your creation check out Lee McNeil at Shouri.com he has various hosting packages and it saves you a lot of hassle running your own server!! I hasten to add I have a vested interest here, so consider this a definate plug!!
Good luck! Servoy is very powerful, can be frustrating for newbies and well worth the effort in the long run! IF you have used Filemaker in the past Servoy, once you know it is definately quicker to develop in, BUT it takes some commitment to learn it and does not lend its self to lashups!
In fact I am something of a hybrid FileMaker-MySQL developer, which is what attracts me to Servoy (having used relational databases in other contents, Servoy’s GUI is quite enticing).
I have & use CocoaMySQL. I also have an existing database structure-- one that is already written in MySQL, but with a limited front-end in PHP.
PHP as everyone know is great but can be painstaking to program a database in (just takes more time than a rapid-deployment app like Servoy).
I intend to keep my existing PHP site but also develop a corollary Servoy app that will enable me to administer the MYSQL data from the ‘back-end’.
Thanks again for the tips-- when I’m ready for hosting I will certainly keep this in mind-- definitely a believer in out-sourcing one’s hosting to competent professionals so as not to be called back from vacation on emergency when there’s problems with the servers. (I am a reseller of web/email/mysql hosting through a big provider which is a relationship I am happy with).