Unable to retrieve tables from this connection

[arobo]

Hi,

I have been trying to set up a connection to my server. The server runs Tomcat and Apache. The database is mySQL. I have read the macromedia tech notes and it only relates to excel, which is no use to me as I am running linux. I created the tables in phpadmin but I doubt if this has much to do with it. Any ideas would be great!!

Adrian

 

[Microbe]

Are you getting a successful connection to the db?

I am using Apache/mySQL/Chili!Soft so may be able to help.
Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[arobo]

Hi,

No, I have solved the problem. I am actually using JSP with Tomcat. (Cheaper than chillisoft! How do you find it anyway? Any good?) Anyway, it was actually the setup of the mysql driver. I had correctly set everything - it was a matter of restarting tomcat again (yep, I knew it would be stupid!) I also had to copy the .jar files of the driver into the lib file on tomcat so it could find the driver. Seems to work anyway. Found another problem though - I was using Ultra dev to connect and do JSP pages but found I was getting a Callable statements error. This was because, as I found out, the prepareCall()statement that Ultradev uses in its coding is unsupported! Just great! Could have told me before I bought the darn thing. Anyway to fix you have to change prepareCall() to prepareStatement(). So more manual coding I'm affraid.

Hope this helps someone out there.

 

[Microbe]

Excellent.

Don't know TomCat...tell me more if you have the time.

Also, you don't happen to have a solution for ASP email on Linux do you?
Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[arobo]

Tomcat is the latest server from the Apache - Jakarta project. It is free and allows you to run java - hence a cheaper solution for JSP. It integrates with Apache so you can have apache doing static pages and Tomcat doing the JSP stuff. Haven't put it to full potential as yet, but hope to start on some stuff soon. You can find out more about it at

http://jakarta.apache.org/tomcat/

if your interested.

As for ASP email solution --- not much I can tell you I'm afraid .......

 

[jodwyer]

hi arobo and all,

i have tomcat installed on a linux box with apache and am having terrible trouble doing a basic connection to a MySQL server on our network. i have installed the necessary driver for MySQL (i think?) the "org.gjt.mm.mysql.Driver" one. the ultrdev help isn't really helping me. does anybody know where i can get some more support?

thanks - johnny.

 

[WND]

Johnny-

It seems that I am having the EXACT same problem that you are!

Have you found a solution yet or found any good resources???