Hello List,
Been a long time. I am looking to migrate my small collection of WO
apps over to Snow Leopard servers (older hardware is off lease and
going away) and I'm stuck getting access to my databases.
Where I am coming from:
WO is hosted on a couple of G5 Xserves running 10.5.8
Apple provide MySQL is the database
I've been using the Connector/J JDBC plugin version 3.1.12 for ages
with good success
WO Apps have been running for years with no modification of note
Where I am going:
A new Xserve running 10.6.x
Planned on using Apple provided MySQL database
What have I done so far:
WO 5.4.3 is installed and wotaskd and womonitor are up and running.
Connector/J 5.1.10 JDBC plugin is installed in /Library/Java/Extensions
MySQL is up and running
I simply copied my .woa packages from the old machine to this one (I
did not attempt to recompile)
Used WOMonitor to deploy
Both apps are working in that they display initial content (no
fetches for either app on main page)
One of the applications is working all the way in that it linked to a
MySQL server on another Xserve (running 10.4.x)
Hand edited the index.eomodeld files to update the plugin information
and server address for the app that is referencing the local MySQL
What is not working:
The application that is not working is the one that references MySQL
on itself (meaning the 10.6 server). I am throwing an exception when
I try to write to the database server on the host server:
_obtainOpenChannel. Now, if I go over to my development machine,
running 10.4.11, I can open up EOModeler and browse the content of the
new server's MySQL database. This was initially accomplished using
the original 3.1.12 Connector J plugin but I also tried the 5.1.10
version on 10.4.11 to some success (although eomodeler will
occasionally crash which I can accept). I realize I am referencing
the connection process from the development box but at least I know
the data is accessible based on the user, password, and plugin
configuration.
With WO support in Snow in its current state, am I trying to
accomplish something that can not be accomplished? Is MySQL + Snow
Leopard + Connector/J + traditional WO development something I should
not be pursuing? Obviously, I have the option of moving my database
to the 10.4 server mentioned above. Then my app would, in theory,
work again since I am not trying to access the local MySQL server.
Anyone have success building a Snow Leopard server with Apple's MySQL
and a JDBC plugin that works with traditional .woa deployments? I
know, I have actually become a dinosaur. The truth is that I
developed the apps so well that I really never need to touch them. I
just need to keep them working.
As always, thanks in advance
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com
This email sent to [email protected]
