Re: help? JNDI Datasource HOW-TO
I found out that the mysql-connector-java-3.0.10-stable-bin.jar needs to be in the \common\lib directory. that was all that i over looked :( thanks eveybody - Original Message - From: "Kumar Abhay-CAK203C" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Tuesday, February 03, 2004 3:21 PM Subject: RE: help? JNDI Datasource HOW-TO > Hello, > > I am having the same problem since last 3 days and no final solution yet I hv posted the msg 2 time to this gr but all in vain > Pls share it with me if u hv any solution.. > > Abhay > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 03, 2004 1:48 PM > To: Tomcat Users List > Subject: help? JNDI Datasource HOW-TO > > > i have followed the example but changed the location of the database to another machine. Tomcat 5.0.18 > > the test.jsp returns > > Results > Foo Not Connected > Bar -1 > > checking the DBTest log i get : > > > 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: Resource parameters for jdbc/TestDB = ResourceParams[name=jdbc/TestDB, parameters={factory=org.apache.commons.dbcp.BasicDataSourceFactory, url=jdbc:mysql://:3306/javatest?autoReconnect=true, password=, maxWait=1, maxActive=100, driverClassName=org.gjt.mm.mysql.Driver, username=Daniel, maxIdle=30}] > 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: Adding resource ref jdbc/TestDB > 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: ResourceRef[className=javax.sql.DataSource,factoryClassLocation=null,factory ClassName=org.apache.naming.factory.ResourceFactory,{type=scope,content=Shar eable},{type=auth,content=Container},{type=factory,content=org.apache.common s.dbcp.BasicDataSourceFactory},{type=url,content=jdbc:mysql://:3306/javatest?autoReconnect=true},{type=password,content= },{type=maxWait,content=1},{type=maxActive,content=100},{type=driverClas sName,content=org.gjt.mm.mysql.Driver},{type=username,content=Daniel},{type= maxIdle,content=30}] > 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: Resource parameters for UserTransaction = null > > at this point im stumped. > > server.xml is ::: > > > factory org.apache.catalina.users.MemoryUserDatabaseFactory > > > pathname > conf/tomcat-users.xml > > > > > prefix="localhost_DBTest_log." suffix=".txt" > timestamp="true"/> > auth="Container" > type="javax.sql.DataSource"/> > > > factory org.apache.commons.dbcp.BasicDataSourceFactory > > > maxActive > 100 > > > maxIdle > 30 > > > maxWait > 1 > > > username > Daniel > > > password > > > > driverClassName org.gjt.mm.mysql.Driver > > > url jdbc:mysql://:3306/javatest?autoReconnect=true > > > > > > > > > > /DBTest/WEB-INF/web.xml::: > > > PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd";> > > dbtest > > Welcome to dbtest > > MySQL Test App > > DB Connection jdbc/TestDB > javax.sql.DataSource > Container > > > > > /DBTest/test.jsp > > > > DB Test > > > <% > foo.DBTest tst = new foo.DBTest(); > tst.init(); > %> > Results > Foo <%= tst.getFoo() %> > Bar <%= tst.getBar() %> > > > > > /DBTest/WEB-INF/foo/DBTest.class > > package foo; > > import javax.naming.*; > import javax.sql.*; > import java.sql.*; > > public class DBTest { > > String foo = "Not Connected"; > int bar = -1; > > public void init() { > try{ > Context ctx = new InitialContext(); > if(ctx == null ) > throw new Exception("Boom - No Context"); > > DataSource ds = > (DataSource)ctx.lookup( >"java:comp/env/jdbc/TestDB"); > > if (ds != null) { > Connection conn = ds.getConnection(); > > if(conn != null) { > foo = "Got Connection "+conn.toString(); > Statement stmt = conn.createStatement(); > ResultSet rst = > stmt.executeQuery( > "select id, foo, bar from testdata"); > if(rst.next()) { >foo=rst.getString(2); >bar=rst.getInt(3); > } > conn.close(); > } > } > }catch(Exception e) {
Re: help? JNDI Datasource HOW-TO
oh oops. Thats where i have it otherwise i would never have goten the jsp to display info. thanks, Daniel Schulken - Original Message - From: "Liem Do" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Tuesday, February 03, 2004 3:52 PM Subject: Re: help? JNDI Datasource HOW-TO > > I am having the same problem since last 3 days and no final solution yet I > hv posted the msg 2 time to this gr but all in vain > > Pls share it with me if u hv any solution.. > > > > > > /DBTest/WEB-INF/foo/DBTest.class > > > > Not sure if this is the problem but your class file should be under: > /DBTest/WEB-INF/classes/foo/DBTest.class > > Everything else looks ok. > > > HTH, > Liem > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: help? JNDI Datasource HOW-TO
> I am having the same problem since last 3 days and no final solution yet I hv posted the msg 2 time to this gr but all in vain > Pls share it with me if u hv any solution.. > > > /DBTest/WEB-INF/foo/DBTest.class > Not sure if this is the problem but your class file should be under: /DBTest/WEB-INF/classes/foo/DBTest.class Everything else looks ok. HTH, Liem - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: help? JNDI Datasource HOW-TO
Hello, I am having the same problem since last 3 days and no final solution yet I hv posted the msg 2 time to this gr but all in vain Pls share it with me if u hv any solution.. Abhay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 1:48 PM To: Tomcat Users List Subject: help? JNDI Datasource HOW-TO i have followed the example but changed the location of the database to another machine. Tomcat 5.0.18 the test.jsp returns Results Foo Not Connected Bar -1 checking the DBTest log i get : 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: Resource parameters for jdbc/TestDB = ResourceParams[name=jdbc/TestDB, parameters={factory=org.apache.commons.dbcp.BasicDataSourceFactory, url=jdbc:mysql://:3306/javatest?autoReconnect=true, password=, maxWait=1, maxActive=100, driverClassName=org.gjt.mm.mysql.Driver, username=Daniel, maxIdle=30}] 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: Adding resource ref jdbc/TestDB 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: ResourceRef[className=javax.sql.DataSource,factoryClassLocation=null,factoryClassName=org.apache.naming.factory.ResourceFactory,{type=scope,content=Shareable},{type=auth,content=Container},{type=factory,content=org.apache.commons.dbcp.BasicDataSourceFactory},{type=url,content=jdbc:mysql://:3306/javatest?autoReconnect=true},{type=password,content=},{type=maxWait,content=1},{type=maxActive,content=100},{type=driverClassName,content=org.gjt.mm.mysql.Driver},{type=username,content=Daniel},{type=maxIdle,content=30}] 2004-02-03 14:19:36 NamingContextListener[/Catalina/localhost/DBTest]: Resource parameters for UserTransaction = null at this point im stumped. server.xml is ::: factory org.apache.catalina.users.MemoryUserDatabaseFactory pathname conf/tomcat-users.xml factory org.apache.commons.dbcp.BasicDataSourceFactory maxActive 100 maxIdle 30 maxWait 1 username Daniel password driverClassName org.gjt.mm.mysql.Driver url jdbc:mysql://:3306/javatest?autoReconnect=true /DBTest/WEB-INF/web.xml::: http://java.sun.com/dtd/web-app_2_3.dtd";> dbtest Welcome to dbtest MySQL Test App DB Connection jdbc/TestDB javax.sql.DataSource Container /DBTest/test.jsp DB Test <% foo.DBTest tst = new foo.DBTest(); tst.init(); %> Results Foo <%= tst.getFoo() %> Bar <%= tst.getBar() %> /DBTest/WEB-INF/foo/DBTest.class package foo; import javax.naming.*; import javax.sql.*; import java.sql.*; public class DBTest { String foo = "Not Connected"; int bar = -1; public void init() { try{ Context ctx = new InitialContext(); if(ctx == null ) throw new Exception("Boom - No Context"); DataSource ds = (DataSource)ctx.lookup( "java:comp/env/jdbc/TestDB"); if (ds != null) { Connection conn = ds.getConnection(); if(conn != null) { foo = "Got Connection "+conn.toString(); Statement stmt = conn.createStatement(); ResultSet rst = stmt.executeQuery( "select id, foo, bar from testdata"); if(rst.next()) { foo=rst.getString(2); bar=rst.getInt(3); } conn.close(); } } }catch(Exception e) { e.printStackTrace(); } } public String getFoo() { return foo; } public int getBar() { return bar;} } What am i missing?thanks,Daniel Schulken---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]