Dear All,
While connecting to Database i am getting following error
'Cannot load JDBC driver class 'null'' in TOMACT server.
I have a bean called UpdateRegDB, in this bean i am connecting to the database,
following is code for connection and i m creating instance of this bean in
ActionServlet called UpdateAction..
------------------------------------code connection in
bean---------------------------------
public Connection getConnection(){
Connection con = null;
try{
Context initctx = new InitialContext();
DataSource ds = (DataSource)initctx.lookup("java:comp/env/jdbc/TestDB");
con = ds.getConnection();
}
catch(Exception e){
System.out.println("Class : UpdateRegDB, Method :
getConnection()"+e.getMessage());
}
return con;
}
}
--------------------------------------------------------------------------------
---------------------------------------------
following is code for JNDI configuration in server.xml from TOMCAT server
------------------------------------------------------------------------------------------------------------------------------------
<Context path="/DBTest" docBase="DBTest" debug="5" reloadable="true"
crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no
limit.-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>admin</value>
</parameter>
<parameter>
<name>password</name>
<value>admin</value>
</parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://191.100.10.248:3306/db_slcs?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
------------------------------------------------------------------------------------------------------------------
Resource ref in WEB-INF/web.xml(In my struts framework web.xml)
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
---------------------------------------------------------------------------------------------------------------
Can any one please tell me where i am doing mistake...
wating for ur help.........
Regards,
viru
