On 09/05/2003 02:31 PM Angus Mezick wrote:
I did an I got BasicDataSource. --Angus
-----Original Message-----
From: Adam Hardy [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 4:19 AM
To: Tomcat Users List
Subject: Re: Using jndi to get a DBCP BasicDataSource give ClassCastException
Hi Angus,
looked at your first mail and couldn't see anything wrong with it. I can only suggest that you do some debugging, like output the .getClass().getName() from the datasource, to see what it really thinks it is.
Adam
On 09/04/2003 10:27 PM Angus Mezick wrote:
Anyone have a clue as to whether or not this is a Real bug,
or am I just
screwing something up?
-----Original Message-----
From: Angus Mezick Sent: Wednesday, September 03, 2003 4:32 PM
To: [EMAIL PROTECTED]
Subject: Using jndi to get a DBCP BasicDataSource give ClassCastException
I am having problems with the GlobalNamingResources. If I put my two DB
resource entries into the GlobalNamingResources section and just use
Resource-Links to access them I cannot cast from DataSource to
BasicDataSource.. I need to do this to use this line in my
monitoring
app: (I can still use the Datasources to get talk to the
DB, just not
recast it from the interface to the concrete class)
pageContext.getOut().println(" jdbc/CommerceDB: Active: " + ((BasicDataSource)ds).getNumActive() + " Idle: " + ((BasicDataSource)ds).getNumIdle() + "<br>");
If I define the resources directly in the Context everything works fine.
ARGH! Here is my server.xml snippets:
<GlobalNamingResources> <Resource name="jdbc/SessionDBGlobal" auth="Container" type="javax.sql.DataSource"/> <Resource name="jdbc/CommerceDBGlobal" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/SessionDBGlobal"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value></value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>driverClassName</name> <value>com.inet.tds.TdsDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:inetdae7a:IPADDR</value> </parameter> <parameter> <name>validationQuery</name> <value>select top 1 name from syscolumns</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>300</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>60000</value> </parameter> <parameter> <name>testOnBorrow</name> <value>true</value> </parameter> <parameter> <name>testWhileIdle</name> <value>true</value> </parameter> </ResourceParams> <ResourceParams name="jdbc/CommerceDBGlobal"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value></value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>driverClassName</name> <value>com.inet.tds.TdsDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:inetdae7a:IPADDR</value> </parameter> <parameter> <name>validationQuery</name> <value>select top 1 name from syscolumns</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>300</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>60000</value> </parameter> <parameter> <name>testOnBorrow</name> <value>true</value> </parameter> <parameter> <name>testWhileIdle</name> <value>true</value> </parameter> </ResourceParams> </GlobalNamingResources>
---- 8< ---- 8< ---- <Host name="wwwHOST_NAME.guidestar.net" debug="1" appBase="/Guidestar/" unpackWARs="true" autoDeploy="true"> <Logger className="org.apache.catalina.logger.FileLogger" directory="logs" prefix="wwwHOST_NAME_log." suffix=".txt" timestamp="true"/> <Context path="" reloadable="true" docBase="C:\GuideStar\GsMain\web" workDir="C:\GuideStar\GsMain\web\work\org\apache\jsp" debug="1"> <Manager className="org.apache.catalina.session.JdbcSessionManager" debug="1" maxInactiveInterval="1800" maxIdleSwap="-1" maxIdleBackup="-1" checkInterval="60" useDirtyFlag="true" reaper="yes"> </Manager> <InstanceListener> org.apache.catalina.session.JdbcSessionInstanceListener</Insta nceListene r> <Loader className="org.apache.catalina.loader.DevLoader" reloadable="true" debug="1"/> <ResourceLink name="jdbc/SessionDB" global="jdbc/SessionDBGlobal" type="javax.sql.DataSource"/> <ResourceLink name="jdbc/CommerceDB" global="jdbc/CommerceDBGlobal" type="javax.sql.DataSource"/> </Context> </Host> </Engine> </Service> </Server>
------------------------------------------------------------
---------
---------------------------------------------------------------------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]
-- struts 1.1 + tomcat 4.1.27 + java 1.4.2 Linux 2.4.20 RH9
--------------------------------------------------------------------- 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]
-- struts 1.1 + tomcat 4.1.27 + java 1.4.2 Linux 2.4.20 RH9
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
