Hello. I've been monitoring this list for several weeks and this is my first post. I'm a seasoned systems programmer, but new to the Apple platform, so please forgive my ignorance.
I've decided to use WebObjects to develop a web app. I have the following configuration on my server:
Tiger 10.4.1 Server running DNS and a verified working installation of MySQL. I've created a database called MORC and created a MySQL user called webuser with full access to that DB. I've also installed the 5.2 WO Deployment package on the server. This is the staging server which is running on a 1Ghz 17" G4 iMac. My web server is a DP 2.3 xServe.
My development platform is running Tiger 10,4 on a 1.67ghz G4 w/2gb RAM. I've installed the 5.2 WO Developer on the PB, along with the latest xCode tools. I'm now at the point where I need to create my ERD and I'm trying to use EOModeler, but cannot get it to connect to the MORC mySQL DB running on the server.
I select Model->New and then jdbc for the connection and enter the following:
Username: webuser Password: ********* URL: jdbc.MySQL://192.168.0.112/MORC.
and get the following response: Connection Failure No Suitable Driver
The WO install guide says it installs jdbc support for mysql, but I tried putting mysql-connector-java-3.1.8-bin.jar and mysql-connector-java-3.1.8-bin-g.jar in my /Library/Java/Extensions folder, but get the same results.
If I specify the Driver as mysql-connector-java-3.1.8-bin.jar, it tells me the driver isn't in my classpath and displays the current classpath, which very clearly included /Library/Java.
If I specify com.mysql.jdbc.Driver, and get the Connection Failure/No Suitable Driver...
Thanks in advance for your assistance.
Sam Loy
|