Re: Tomcat5 - MySql5.0.0a - apache2.0 - XP - JNDI connection problems - Doug - Parsons Technical Services
I apologize - but I haven't been receiving any of the tomcat-user lists emails to my previous email account. I could only see responses in the mailing list archive. I have since switched to this email address and the mailing list is working fine. Anyway... Doug - Parsons Technical Services responses were: >> I am running windows XP - have apache 2.0.48 and Tomcat 5.0.19 up and >> running with j2sdk1.4.2_04. I am also running MySql5.0.0a >> >I recommend for the purpose of testing to access Tomcat directly if >possible. MySQL version may cause issues as noted by Tom. Once everything >else is fixed, we'll see. I am a newbie at configuration and Tomcat - what do you mean by "directly"? And how do I check or change this? ... >> What is wrong with my configuration? >To answer this it is much easier if we can see them. Which files do you want and do I >just attach them to the email or paste them into the email? Do you want the whole >file or just parts? (They will look like a brand new install with the following >changes as lined out on this page: >http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html ) >> Step 2. server.xml configuration says " tag of the examples >> context and the " >> My server.xml doesn't have tags should there be one? >Yes and no. >To keep things simple and to start you down the path of Tomcat knowledge, >for now create the context section as shown in the example. Later you can >move it to context.xml. Look up the context section under server >configuration for more detail. Sounds like I can leave it where it is and look into a context.xml file later on. >> Step 3. web.xml configuration - Do I make/add these changes to the web.xml >> under $CATALINA\ROOT\WEB-INF or under a subdirectory called /DBTest/?? >Under /DBTest/WEB-INF/ in the web.xml for your app. I'll make these changes tomorrow am and test. (I'm not near my machine...) >> Step 4. test code says "deploy your web app into $CATALINA_HOME/webapps >> either as a warfile called DBTest.war orinto a subdirectory called DBTest." >> So, I created a directory called DBTest and just put the test.jsp file into >> that directory - doesn't that qualify as "deploying"?? >No. IMHO You need to create the file structure and the web.xml. Not sure what else >as I use .war files. Ok - newbie question - Can you point me to what my file structure should look like or else how to create a .war file? I am guessing that it will mimic one of the "main" directories. For completeness and reference - my previous email: I am following: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html I am running windows XP - have apache 2.0.48 and Tomcat 5.0.19 up and running with j2sdk1.4.2_04. I am also running MySql5.0.0a Under $CATALINA_HOME/comon/lib mysql-connector-java-3.0.11-stable-bin commons-collections.3.0.jar commons-dbcp-1.1.jar commons-pool-1.1.jar When I run the test code - test.jsp I get the following error: Exception report: org.apache.jasper.JasperException: The absolute uri: http://java.sun.com/jsp/jstl/sql cannot be resolved in either web.xml or the jar files deployed with this application org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHand ler.java:94) org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java :404) org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java :154) org.apache.jasper.compiler.TagLibraryInfoImpl.generateTLDLocation(TagLib raryInfoImpl.java:359) org.apache.jasper.compiler.TagLibraryInfoImpl.(TagLibraryInfoImpl. java:190) org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:458) org.apache.jasper.compiler.Parser.parseDirective(Parser.java:523) org.apache.jasper.compiler.Parser.parseElements(Parser.java:1577) org.apache.jasper.compiler.Parser.parse(Parser.java:171) org.apache.jasper.compiler.ParserController.doParse(ParserController.jav a:258) org.apache.jasper.compiler.ParserController.parse(ParserController.java: 139) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237) org.apache.jasper.compiler.Compiler.compile(Compiler.java:456) org.apache.jasper.compiler.Compiler.compile(Compiler.java:439) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.ja va:553) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:291) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) What is wrong with my configuration? Step 2. server.xml configuration says " tag of the examples context and the " My server.xml doesn't have tags should there be one? Step 3. web.xml configuration - Do I make/add these changes to the web.xml under $CATALINA\RO
RE: Tomcat5 - MySql5.0.0a - apache2.0 - XP - JNDI connection problems
I apologize - but I haven't been receiving any of the tomcat-user lists emails to my previous email account. I have since switched to this one. Anyway... Tom K. - asked: Are you using jstl tags to connect to your database? Looking at your error, I noted the path http://java.sun.com/jsp/jstl/sql You are using the preview version of mySQL (Version 5), has connectorJ been tested with it...I don't know, I'm just asking. My response: I'm a newbie on the configuration so I was just following http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html I would have no idea if it has been tested - how could I find out? My previous email: I am following: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html I am running windows XP - have apache 2.0.48 and Tomcat 5.0.19 up and running with j2sdk1.4.2_04. I am also running MySql5.0.0a Under $CATALINA_HOME/comon/lib mysql-connector-java-3.0.11-stable-bin commons-collections.3.0.jar commons-dbcp-1.1.jar commons-pool-1.1.jar When I run the test code - test.jsp I get the following error: Exception report: org.apache.jasper.JasperException: The absolute uri: http://java.sun.com/jsp/jstl/sql cannot be resolved in either web.xml or the jar files deployed with this application org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHand ler.java:94) org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java :404) org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java :154) org.apache.jasper.compiler.TagLibraryInfoImpl.generateTLDLocation(TagLib raryInfoImpl.java:359) org.apache.jasper.compiler.TagLibraryInfoImpl.(TagLibraryInfoImpl. java:190) org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:458) org.apache.jasper.compiler.Parser.parseDirective(Parser.java:523) org.apache.jasper.compiler.Parser.parseElements(Parser.java:1577) org.apache.jasper.compiler.Parser.parse(Parser.java:171) org.apache.jasper.compiler.ParserController.doParse(ParserController.jav a:258) org.apache.jasper.compiler.ParserController.parse(ParserController.java: 139) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237) org.apache.jasper.compiler.Compiler.compile(Compiler.java:456) org.apache.jasper.compiler.Compiler.compile(Compiler.java:439) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.ja va:553) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:291) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) What is wrong with my configuration? Step 2. server.xml configuration says " tag of the examples context and the " My server.xml doesn't have tags should there be one? Step 3. web.xml configuration - Do I make/add these changes to the web.xml under $CATALINA\ROOT\WEB-INF or under a subdirectory called /DBTest/?? Step 4. test code says "deploy your web app into $CATALINA_HOME/webapps either as a warfile called DBTest.war orinto a subdirectory called DBTest." So, I created a directory called DBTest and just put the test.jsp file into that directory - doesn't that qualify as "deploying"?? Thanks for any help to fix my configuration. Tim - Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today
Re: Tomcat5 - MySql5.0.0a - apache2.0 - XP - JNDI connection problems
Hi, For your JSTL issue, make sure in your WEB-INF/lib directory you have jstl.jar and standard.jar ( for the apache standard implementation ). otherwise, you will not be able to use JSTL. hth, -a The Gman wrote: I am following: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html I am running windows XP - have apache 2.0.48 and Tomcat 5.0.19 up and running with j2sdk1.4.2_04. I am also running MySql5.0.0a Under $CATALINA_HOME/comon/lib mysql-connector-java-3.0.11-stable-bin commons-collections.3.0.jar commons-dbcp-1.1.jar commons-pool-1.1.jar When I run the test code - test.jsp I get the following error: Exception report: org.apache.jasper.JasperException: The absolute uri: http://java.sun.com/jsp/jstl/sql cannot be resolved in either web.xml or the jar files deployed with this application org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94) org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:404) org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:154) org.apache.jasper.compiler.TagLibraryInfoImpl.generateTLDLocation(TagLibraryInfoImpl.java:359) org.apache.jasper.compiler.TagLibraryInfoImpl.(TagLibraryInfoImpl.java:190) org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:458) org.apache.jasper.compiler.Parser.parseDirective(Parser.java:523) org.apache.jasper.compiler.Parser.parseElements(Parser.java:1577) org.apache.jasper.compiler.Parser.parse(Parser.java:171) org.apache.jasper.compiler.ParserController.doParse(ParserController.java:258) org.apache.jasper.compiler.ParserController.parse(ParserController.java:139) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237) org.apache.jasper.compiler.Compiler.compile(Compiler.java:456) org.apache.jasper.compiler.Compiler.compile(Compiler.java:439) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:553) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) What is wrong with my configuration? Step 2. server.xml configuration says " tag of the examples context and the " My server.xml doesn't have tags should there be one? Step 3. web.xml configuration - Do I make/add these changes to the web.xml under $CATALINA\ROOT\WEB-INF or under a subdirectory called /DBTest/?? Step 4. test code says "deploy your web app into $CATALINA_HOME/webapps either as a warfile called DBTest.war orinto a subdirectory called DBTest." So, I created a directory called DBTest and just put the test.jsp file into that directory - doesn't that qualify as "deploying"?? Thanks for any help to fix my configuration. Tim _ MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat5 - MySql5.0.0a - apache2.0 - XP - JNDI connection problems
Tim, > I am following: > http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html Good start. > > I am running windows XP - have apache 2.0.48 and Tomcat 5.0.19 up and > running with j2sdk1.4.2_04. I am also running MySql5.0.0a > I recommend for the purpose of testing to access Tomcat directly if possible. MySQL version may cause issues as noted by Tom. Once everything else is fixed, we'll see. > Under $CATALINA_HOME/comon/lib > mysql-connector-java-3.0.11-stable-bin > commons-collections.3.0.jar > commons-dbcp-1.1.jar > commons-pool-1.1.jar That is the correct place for the driver. > > When I run the test code - test.jsp I get the following error: > > Exception report: > org.apache.jasper.JasperException: The absolute uri: > http://java.sun.com/jsp/jstl/sql cannot be resolved in either web.xml or the > jar files deployed with this application > > org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler. java:94) snip... > javax.servlet.http.HttpServlet.service(HttpServlet.java:856) This looks odd to me. Don't have an answer at this point. Look into Tom's sugestions. > > What is wrong with my configuration? To answer this it is much easier if we can see them. > > Step 2. server.xml configuration says " tag of the examples > context and the " > My server.xml doesn't have tags should there be one? Yes and no. To keep things simple and to start you down the path of Tomcat knowledge, for now create the context section as shown in the example. Later you can move it to context.xml. Look up the context section under server configuration for more detail. > > Step 3. web.xml configuration - Do I make/add these changes to the web.xml > under $CATALINA\ROOT\WEB-INF or under a subdirectory called /DBTest/?? Under /DBTest/WEB-INF/ in the web.xml for your app. > > Step 4. test code says "deploy your web app into $CATALINA_HOME/webapps > either as a warfile called DBTest.war orinto a subdirectory called DBTest." > So, I created a directory called DBTest and just put the test.jsp file into > that directory - doesn't that qualify as "deploying"?? No. IMHO You need to create the file structure and the web.xml. Not sure what else as I use .war files. Doug - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat5 - MySql5.0.0a - apache2.0 - XP - JNDI connection problems
Are you using jstl tags to connect to your database? Looking at your error, I noted the path http://java.sun.com/jsp/jstl/sql You are using the preview version of mySQL (Version 5), has connectorJ been tested with it...I don't know, I'm just asking. Tom K. -Original Message- From: The Gman [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:16 PM To: [EMAIL PROTECTED] Subject: Tomcat5 - MySql5.0.0a - apache2.0 - XP - JNDI connection problems I am following: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples -howto.html I am running windows XP - have apache 2.0.48 and Tomcat 5.0.19 up and running with j2sdk1.4.2_04. I am also running MySql5.0.0a Under $CATALINA_HOME/comon/lib mysql-connector-java-3.0.11-stable-bin commons-collections.3.0.jar commons-dbcp-1.1.jar commons-pool-1.1.jar When I run the test code - test.jsp I get the following error: Exception report: org.apache.jasper.JasperException: The absolute uri: http://java.sun.com/jsp/jstl/sql cannot be resolved in either web.xml or the jar files deployed with this application org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHand ler.java:94) org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java :404) org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java :154) org.apache.jasper.compiler.TagLibraryInfoImpl.generateTLDLocation(TagLib raryInfoImpl.java:359) org.apache.jasper.compiler.TagLibraryInfoImpl.(TagLibraryInfoImpl. java:190) org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:458) org.apache.jasper.compiler.Parser.parseDirective(Parser.java:523) org.apache.jasper.compiler.Parser.parseElements(Parser.java:1577) org.apache.jasper.compiler.Parser.parse(Parser.java:171) org.apache.jasper.compiler.ParserController.doParse(ParserController.jav a:258) org.apache.jasper.compiler.ParserController.parse(ParserController.java: 139) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237) org.apache.jasper.compiler.Compiler.compile(Compiler.java:456) org.apache.jasper.compiler.Compiler.compile(Compiler.java:439) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.ja va:553) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:291) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) What is wrong with my configuration? Step 2. server.xml configuration says " tag of the examples context and the " My server.xml doesn't have tags should there be one? Step 3. web.xml configuration - Do I make/add these changes to the web.xml under $CATALINA\ROOT\WEB-INF or under a subdirectory called /DBTest/?? Step 4. test code says "deploy your web app into $CATALINA_HOME/webapps either as a warfile called DBTest.war orinto a subdirectory called DBTest." So, I created a directory called DBTest and just put the test.jsp file into that directory - doesn't that qualify as "deploying"?? Thanks for any help to fix my configuration. Tim _ MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]