ok, the thing is like this. i've installed this JRun in my machine. everything go smooth as silk. the thing is, i would like to install back my apache + php + mysql into my machine (since i'm actually crazy about PHP/Mysql! ), without uninstalling my JRun (i need this for my JSPs, for the sake of my job! ).

the question is, will this interupt my JRun, since supposedly it would not, because JRun using port 8000 and 8100 and on the other hand, apache is using port 80, and mysql is 3306. so, how is it?

and one more thing, can i used the mysql that i've installed with my jsp and how does actually i set that JDBC thingy? or is there another way to interact with the database using this JSP?

Hi,

There shouldn't be any problems reinstalling Apache without uninstalling JRun.

To interface MySQL with JSP try:

<%@ page import="java.sql.*" %>
Connection connection = null;
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
connection = DriverManager.getConnection("jdbc:mysql://localhost/<DB NAME>?user=<USER NAME>&password=<PASSWORD>");

ok, i got that. so, how's about if i want to connect to a oracle server. is it still the same? if could, please include examples.

and another thing, will all of the sql still the same, i mean the sql query object, not the sql statement. an example here also is really appreciated.

one more thing, how to use that JRun Management Console. which is better anyway, should i stay using JRun or change to that jakarta-tomcat, since it seems that i got this one tutorial from www.visualbuilder.com where it shows that handling jakarta-tomcat is easier than JRun. opinion please...