First of all you need to load the drivers. To do that you need: Class.forName(<the whole path of the drivers here>);
After that the only thing you have to do is to open a connection with the speciffic DB server Connection con = DriverManager.getConnection(<url of your database server>, "<username- optional>", "<password - optional>"); After that you can communicate with the server by just sending SQL statements. 15/01/2002 04:26:17, "Wilson E. Lozano R." <[EMAIL PROTECTED]> wrote: >Hi panos, >thanks for your help. > >Hi everybody, i'm running tomcat4.0 with jdk1.3.1_02 in win 98. >Bun now i need know how can i do to make a connection win a data base in >Microsoft acces 97 trought any web page into my web site soported with >tomcat 4.0. > >thanks in advanced. >----------------------------------- >Wilson Ernesto Lozano RolOn >Ingeniero de Sistemas >Universidad Industrial de Santander >----------------------------------- > >On Mon, 14 Jan 2002, panos periorellis wrote: > >> If you're doing this from DOS it should work.... >> >> Note that one of the directories inside the set >> catalina_home=c:\tcat\jakarta-tomcat-4.0\ should be bin lib etc.... >> >> in other words our directory should point to those >> so if there is another directory inside jakarta-tomcat-4.0 before the bin >> and lib directories then set the path to that .... >> >> the other thing i thought of is that the jakarta-tomcat-4.0 directory name >> is a bit long...I remember i had to shorten mine .... I have renamed it as >> jak.. >> >> take care >> panos >> >> ----- Original Message ----- >> From: Wilson E. Lozano R. <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Monday, January 14, 2002 09:38 >> Subject: Re: TOMCAT4.0 + win98 help!!! >> >> >> > Hi Panos, >> > Thanks but i was do it, however i don't use jrun >> > in this version of tomcat the variable isn't tomcat_home, is >> > catalina_home, and i does set catalina_home=c:\tcat\jakarta-tomcat-4.0\ >> > and i use jsdk and java_home=c:\jsdk1.3.1_02\ and my problem don't stop. >> > ?? >> > Thanks in advanced. >> > ----------------------------------- >> > Wilson Ernesto Lozano RolOn >> > Ingeniero de Sistemas >> > Universidad Industrial de Santander >> > ----------------------------------- >> > >> > On Mon, 14 Jan 2002, panos periorellis wrote: >> > >> > > you have to set the variables from DOS. >> > > >> > > i.e. >> > > >> > > set TOMCAT_HOME=c:\tomcat\jak\jak (this is on my machine ...replace with >> the >> > > direcotyr on yours. >> > > >> > > set JAVA_HOME=c:\jbuilder\jdk1.3 (if you rin jbuilder that is) >> > > >> > > >> =========================================================================== >> > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >> JSP-INTEREST". >> > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >> DIGEST". >> > > Some relevant FAQs on JSP/Servlets can be found at: >> > > >> > > http://archives.java.sun.com/jsp-interest.html >> > > http://java.sun.com/products/jsp/faq.html >> > > http://www.esperanto.org.nz/jsp/jspfaq.jsp >> > > http://www.jguru.com/faq/index.jsp >> > > http://www.jspinsider.com >> > > >> > >> > >> =========================================================================== >> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >> JSP-INTEREST". >> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >> DIGEST". >> > Some relevant FAQs on JSP/Servlets can be found at: >> > >> > http://archives.java.sun.com/jsp-interest.html >> > http://java.sun.com/products/jsp/faq.html >> > http://www.esperanto.org.nz/jsp/jspfaq.jsp >> > http://www.jguru.com/faq/index.jsp >> > http://www.jspinsider.com >> > >> >> =========================================================================== >> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". >> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". >> Some relevant FAQs on JSP/Servlets can be found at: >> >> http://archives.java.sun.com/jsp-interest.html >> http://java.sun.com/products/jsp/faq.html >> http://www.esperanto.org.nz/jsp/jspfaq.jsp >> http://www.jguru.com/faq/index.jsp >> http://www.jspinsider.com >> > >=========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > __________________________________________ "It can only be attributed to human error" 2001 A Space Odyssey =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
