Okay so I'm quite new...

I'm on a MacOSX machine with MySQL and PHP, running Ultradev in classic. I had problems with myJDBC driver and would get an error upon "Check" in the DSN Connection dialog. I got through that and got my JDBC stuff copied into my MRJ in extensions.

Now, when I Check, it seems fine; must see my JDBC. But when I plug everything in and hit the "Test" button, I get:

Communication link failure: Java.io.IOException

Can anyone help me with this? Is this still a JDBC thing or a MySQL thing? I could potentially still have incorrect config info in the DSN dialog in Ultradev.

Much thanks in advance for input...

Also, I did in fact read the article on:

www.udzone.com/ShowDetail.asp?NewsId=1202&offset=5

where James Martinez seems to have the same problem. And it seemed helpful at first.

In my MRJ Classes, I had both the folder (mm.mysql-2.0.8) and the bin.jar file (mm.mysql-2.0.8-bin.jar). Who knows how I botched that.

So I pulled the bin.jar file from MRJ Classes so that now I have in MRJ Classes the folder mm.mysql-2.0.8 with contents: build.xml, CHANGES, COPYING, lib, mm.mysql-2.0.8.bin.jar, org, README, testsuite.

I restarted classic (but not my whole machine yet) and launched Ultradev. Went through the same steps: Check didn't return an error, but Test gave me the IO error.



Edited by - mrnine on 07 Dec 2001 21:22:31

The IO error on a MAC seems to be a bit non-descript. I wonder if the IO error is thrown regardless of the type of error encountered.

Regardless, delete what you have in the MRJ Classes folder, and also delete the contents of the UltraDev/Configuration/JDBCDrivers folder.Then download my MySQL JDBC Driver extension from www.udzone.com/go?1190 and install it.

Then copy the contents of your UltraDev/Configuration/JDBCDrivers folder to your MRJ Classes folder.

If this now doesn't work, then the only other probable cause is a MySQL Configuration error...

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Thanks very much for the input, Tim. That makes sense. But this brings another question...and likely a large part of the problem.

Whenever I go in the Macromedia Extensions Manger to install the "MySQL_JDBC_Driver.mxp" extension, it just doesn't show. Whether I'm booted in OSX or OS9, I can't ever see the .mxp.

Originally I thought maybe all the extension did was copy the "mm.mysql-2.0.8" folder from the osx/usr/local/MySQL-3.23.46 folder to the os9/system folder/extensions/MRJ Libraries/MRJClasses folder. So I copied this folder there myself. Also copied it into my ultradev/Configuration/JDBC Drivers folder.

So...now I sort of have this mm.mysql thing all over the place. But I've kluged it up so bad, it's not doing anything. Any suggestions? I think if I could get the .mxp file to work in my extension manager, that would do it. But...hmm...

Actually, reading more closely what they suggest on the page you sent (www.udzone.com/ShowDetail.asp?NewsId=1190&offset=5) they talk about putting the actual "org" folder or the jar file itself in MRJ Classes. I have also tried this to no avail. Wish that error message were more descriptive.

I have someone coming in who can help me at least properly diagnose my mysql configuration. If it's hosed then perhaps that's the culprit.
Thanks!!

Edited by - mrnine on 08 Dec 2001 07:32:25

Like I said, Tim...I'm a little new at this.

I hadn't setup a user in MySQL with remote access privileges. So my OS9 partition with UltraDev couldn't cross that "silicon border" over my OSX partition and talk. As soon as I got that setup, everything worked fine.

Thanks so much for your input. This is a great board, and I'm sure I'll find it helpful down the road when I <b>really</b> screw this thing up! <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>

-R

Ooopsie... well never mind. At least you're up and running now <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>



Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>