RE: DataSource error (DBCP)
i've already done that somehow i compiled :) DBTest.java and where should i place the DBTest.class file. EVERYWHERE I TRIED :(. anyone can answer ? regards and thanks sunil Galbayar Dorjgotov To: Tomcat Users List [EMAIL PROTECTED] galbayar@mobi cc: net.mn Subject: RE: DataSource error (DBCP) 12/23/2002 01:49 AM Please respond to Tomcat Users List copy mysql jdbc driver to tomcat/common/lib directory -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 3:09 AM To: [EMAIL PROTECTED] Subject: DataSource error (DBCP) hi all, i'm new to tomcat... if my queries are foolish...pl forgive. :) my configuration is RH Linux 8/MYSQL 3.../TOMCAT 4.1.8 all the examples provided are working correctly... i tried JNDI Datasource HOW-TO (more details in the URL) http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations 4 i tried with MYSQL DBCP Example 1. i've created mysql username,password,database,tables,records 2. i've changed the server.xml configuration by inserting the codes given under no.2 3. i've created a web.xml as in no.3 4. i've written the same test.jsp and DBTest.java and i created a directory DBTest and placed test.jsp and DBTest.java there and another subdirectory called WEB-INF and placed the web.xml there. I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error - please help! THANKS IN ADVANCE best regards sunil -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
Could you post your source code for the java code? Sounds like you are missing javax.sql.* , but can't be sure until someone has a look at it. [EMAIL PROTECTED] wrote: i've already done that somehow i compiled :) DBTest.java and where should i place the DBTest.class file. EVERYWHERE I TRIED :(. anyone can answer ? regards and thanks sunil Galbayar Dorjgotov To: Tomcat Users List [EMAIL PROTECTED] galbayar@mobi cc: net.mn Subject: RE: DataSource error (DBCP) 12/23/2002 01:49 AM Please respond to Tomcat Users List copy mysql jdbc driver to tomcat/common/lib directory -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 3:09 AM To: [EMAIL PROTECTED] Subject: DataSource error (DBCP) hi all, i'm new to tomcat... if my queries are foolish...pl forgive. :) my configuration is RH Linux 8/MYSQL 3.../TOMCAT 4.1.8 all the examples provided are working correctly... i tried JNDI Datasource HOW-TO (more details in the URL) http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations 4 i tried with MYSQL DBCP Example 1. i've created mysql username,password,database,tables,records 2. i've changed the server.xml configuration by inserting the codes given under no.2 3. i've created a web.xml as in no.3 4. i've written the same test.jsp and DBTest.java and i created a directory DBTest and placed test.jsp and DBTest.java there and another subdirectory called WEB-INF and placed the web.xml there. I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error - please help! THANKS IN ADVANCE best regards sunil -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how i cut and paste the source codes for MYSQL Example... u r right... first error was javax.sql.* missing... but i included all the directories in classpath that error cleared.. this is the jsp file... DBTest is the class file.. (that i compiled inside my oracle directory and moved to Tomcat and tried placing everywhere) -- html head titleDB Test/title /head body % foo.DBTest tst = new foo.DBTest(); tst.init(); % h2Results/h2 Foo %= tst.getFoo() %br/ Bar %= tst.getBar() % /body /html -- Peng Tuck Kwok pengtuck@makm To: Tomcat Users List [EMAIL PROTECTED] al.net cc: Subject: Re: DataSource error (DBCP) 12/23/2002 08:23 AM Please respond to Tomcat Users List Could you post your source code for the java code? Sounds like you are missing javax.sql.* , but can't be sure until someone has a look at it. [EMAIL PROTECTED] wrote: i've already done that somehow i compiled :) DBTest.java and where should i place the DBTest.class file. EVERYWHERE I TRIED :(. anyone can answer ? regards and thanks sunil Galbayar Dorjgotov To: Tomcat Users List [EMAIL PROTECTED] galbayar@mobi cc: net.mn Subject: RE: DataSource error (DBCP) 12/23/2002 01:49 AM Please respond to Tomcat Users List copy mysql jdbc driver to tomcat/common/lib directory -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 3:09 AM To: [EMAIL PROTECTED] Subject: DataSource error (DBCP) hi all, i'm new to tomcat... if my queries are foolish...pl forgive. :) my configuration is RH Linux 8/MYSQL 3.../TOMCAT 4.1.8 all the examples provided are working correctly... i tried JNDI Datasource HOW-TO (more details in the URL) http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations 4 i tried with MYSQL DBCP Example 1. i've created mysql username,password,database,tables,records 2. i've changed the server.xml configuration by inserting the codes given under no.2 3. i've created a web.xml as in no.3 4. i've written the same test.jsp and DBTest.java and i created a directory DBTest and placed test.jsp and DBTest.java there and another subdirectory called WEB-INF and placed the web.xml there. I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error - please help! THANKS IN ADVANCE best regards sunil -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
Hmm, does it work yet or are you still experiencing some problems ? [EMAIL PROTECTED] wrote: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how i cut and paste the source codes for MYSQL Example... u r right... first error was javax.sql.* missing... but i included all the directories in classpath that error cleared.. this is the jsp file... DBTest is the class file.. (that i compiled inside my oracle directory and moved to Tomcat and tried placing everywhere) -- html head titleDB Test/title /head body % foo.DBTest tst = new foo.DBTest(); tst.init(); % h2Results/h2 Foo %= tst.getFoo() %br/ Bar %= tst.getBar() % /body /html -- Peng Tuck Kwok pengtuck@makm To: Tomcat Users List [EMAIL PROTECTED] al.net cc: Subject: Re: DataSource error (DBCP) 12/23/2002 08:23 AM Please respond to Tomcat Users List Could you post your source code for the java code? Sounds like you are missing javax.sql.* , but can't be sure until someone has a look at it. [EMAIL PROTECTED] wrote: i've already done that somehow i compiled :) DBTest.java and where should i place the DBTest.class file. EVERYWHERE I TRIED :(. anyone can answer ? regards and thanks sunil Galbayar Dorjgotov To: Tomcat Users List [EMAIL PROTECTED] galbayar@mobi cc: net.mn Subject: RE: DataSource error (DBCP) 12/23/2002 01:49 AM Please respond to Tomcat Users List copy mysql jdbc driver to tomcat/common/lib directory -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 3:09 AM To: [EMAIL PROTECTED] Subject: DataSource error (DBCP) hi all, i'm new to tomcat... if my queries are foolish...pl forgive. :) my configuration is RH Linux 8/MYSQL 3.../TOMCAT 4.1.8 all the examples provided are working correctly... i tried JNDI Datasource HOW-TO (more details in the URL) http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations 4 i tried with MYSQL DBCP Example 1. i've created mysql username,password,database,tables,records 2. i've changeXXX XX : mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL
Re: DataSource error (DBCP)
while executing ... http://195.54.247.110:8080/DBTest/test.jsp getting the error message org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 6 in the jsp file: /test.jsp Generated servlet error: [javac] Compiling 1 source file /home/sunil/jakarta-tomcat-4.1.18/work/Standalone/localhost/DBTest/test_jsp.java:48: cannot resolve symbol symbol : class DBTest location: class org.apache.jsp.test_jsp DBTest tst = new DBTest(); ^ An error occurred at line: 6 in the jsp file: /test.jsp Generated servlet error: /home/sunil/jakarta-tomcat-4.1.18/work/Standalone/localhost/DBTest/test_jsp.java:48: cannot resolve symbol symbol : class DBTest location: class org.apache.jsp.test_jsp DBTest tst = new DBTest(); ^ 2 errors anyone can help a. on this. b. see the first posting (compile error..) T I A -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
tomcat 4.x doesn't like classes in the root directory - place that class into a package and then try again. - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, December 23, 2002 12:42 AM Subject: Re: DataSource error (DBCP) while executing ... http://195.54.247.110:8080/DBTest/test.jsp getting the error message org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 6 in the jsp file: /test.jsp Generated servlet error: [javac] Compiling 1 source file /home/sunil/jakarta-tomcat-4.1.18/work/Standalone/localhost/DBTest/test_jsp. java:48: cannot resolve symbol symbol : class DBTest location: class org.apache.jsp.test_jsp DBTest tst = new DBTest(); ^ An error occurred at line: 6 in the jsp file: /test.jsp Generated servlet error: /home/sunil/jakarta-tomcat-4.1.18/work/Standalone/localhost/DBTest/test_jsp. java:48: cannot resolve symbol symbol : class DBTest location: class org.apache.jsp.test_jsp DBTest tst = new DBTest(); ^ 2 errors anyone can help a. on this. b. see the first posting (compile error..) T I A -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
Put your .class files in $CATALINA_HOME/webapps/$YOUR_APP/WEB-INF/classes (preferably in packages under this directory) Use an import statement to include a class in the top of your jsp: %@ page language=java import=some.package.DBTest % Rgrds. Klaas From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: DataSource error (DBCP) Date: Mon, 23 Dec 2002 08:42:05 + while executing ... http://195.54.247.110:8080/DBTest/test.jsp getting the error message org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 6 in the jsp file: /test.jsp Generated servlet error: [javac] Compiling 1 source file /home/sunil/jakarta-tomcat-4.1.18/work/Standalone/localhost/DBTest/test_jsp.java:48: cannot resolve symbol symbol : class DBTest location: class org.apache.jsp.test_jsp DBTest tst = new DBTest(); ^ An error occurred at line: 6 in the jsp file: /test.jsp Generated servlet error: /home/sunil/jakarta-tomcat-4.1.18/work/Standalone/localhost/DBTest/test_jsp.java:48: cannot resolve symbol symbol : class DBTest location: class org.apache.jsp.test_jsp DBTest tst = new DBTest(); ^ 2 errors anyone can help a. on this. b. see the first posting (compile error..) T I A -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] _ Add photos to your e-mail with MSN 8. Get 3 months FREE*. http://join.msn.com/?page=features/featuredemailxAPID=42PS=47575PI=7324DI=7474SU= http://www.hotmail.msn.com/cgi-bin/getmsgHL=1216hotmailtaglines_addphotos_3mf -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
that's cool!!! worked. bringing attention to my old problem like i'm unable to compile DBTest.java (i compiled the same in another machine where oracle 9i is running, and copied to the machine where tomcat is running :)) I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error --- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DataSource error (DBCP)
sorry for replicating the same query!!! anyone can help TIA bringing attention to my old problem like i'm unable to compile DBTest.java (i compiled the same in another machine where oracle 9i is running, and copied to the machine where tomcat is running :)) I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error --- sunil.kumar@imasst elecom.com To: Tomcat Users List [EMAIL PROTECTED] cc: 12/23/2002 02:53 Subject: Re: DataSource error (DBCP) PM Please respond to Tomcat Users List that's cool!!! worked. bringing attention to my old problem like i'm unable to compile DBTest.java (i compiled the same in another machine where oracle 9i is running, and copied to the machine where tomcat is running :)) I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error --- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: DataSource error (DBCP)
Did you import javax.sql.*; ?? DataSource is part of the J2EE package. Just an extension to the normal java.sql package -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 24 December 2002 2:20 AM To: Tomcat Users List Subject: Re: DataSource error (DBCP) sorry for replicating the same query!!! anyone can help TIA bringing attention to my old problem like i'm unable to compile DBTest.java (i compiled the same in another machine where oracle 9i is running, and copied to the machine where tomcat is running :)) I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error --- sunil.kumar@imasst elecom.com To: Tomcat Users List [EMAIL PROTECTED] cc: 12/23/2002 02:53 Subject: Re: DataSource error (DBCP) PM Please respond to Tomcat Users List that's cool!!! worked. bringing attention to my old problem like i'm unable to compile DBTest.java (i compiled the same in another machine where oracle 9i is running, and copied to the machine where tomcat is running :)) I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error --- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] ** The information contained in this e-mail is confidential and is intended only for the use of the addressee(s). If you receive this e-mail in error, any use, distribution or copying of this e-mail is not permitted. You are requested to forward unwanted e-mail and address any problems to the MIM Holdings Limited Support Centre. For general enquires: ++61 7 3833 8000 Support Centre e-mail: [EMAIL PROTECTED] Support Centre phone: Australia 1800500646 International ++61 7 38338042 ** -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DataSource error (DBCP)
hi all, i'm new to tomcat... if my queries are foolish...pl forgive. :) my configuration is RH Linux 8/MYSQL 3.../TOMCAT 4.1.8 all the examples provided are working correctly... i tried JNDI Datasource HOW-TO (more details in the URL) http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations 4 i tried with MYSQL DBCP Example 1. i've created mysql username,password,database,tables,records 2. i've changed the server.xml configuration by inserting the codes given under no.2 3. i've created a web.xml as in no.3 4. i've written the same test.jsp and DBTest.java and i created a directory DBTest and placed test.jsp and DBTest.java there and another subdirectory called WEB-INF and placed the web.xml there. I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error - please help! THANKS IN ADVANCE best regards sunil -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: DataSource error (DBCP)
copy mysql jdbc driver to tomcat/common/lib directory -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 3:09 AM To: [EMAIL PROTECTED] Subject: DataSource error (DBCP) hi all, i'm new to tomcat... if my queries are foolish...pl forgive. :) my configuration is RH Linux 8/MYSQL 3.../TOMCAT 4.1.8 all the examples provided are working correctly... i tried JNDI Datasource HOW-TO (more details in the URL) http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations 4 i tried with MYSQL DBCP Example 1. i've created mysql username,password,database,tables,records 2. i've changed the server.xml configuration by inserting the codes given under no.2 3. i've created a web.xml as in no.3 4. i've written the same test.jsp and DBTest.java and i created a directory DBTest and placed test.jsp and DBTest.java there and another subdirectory called WEB-INF and placed the web.xml there. I tried to compile DBTest.java and ended up an error Type 'Datasource' not found in the declaration of table 'ds' DataSource ds= ^ 1 error - please help! THANKS IN ADVANCE best regards sunil -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
