hi,
When i am trying to connect database using datasource it throws exception:
javax.servlet.ServletException: Cannot create
JDBC driver of class '' for connect URL 'null'
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
i added context to the server.xml in tomcat/ conf folder.
<Context path="/JDBCProj" docBase="JDBCProj" debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/dbconn" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dbconn">
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:orcl</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
</ResourceParams>
</Context>
and i added reference names to web.xml as
resource name: jdbc/dbconn
resource type: javax.sql.DataSource
auth: Container
code in my
JSP is:
InitialContext ctx = new InitialContext();
DataSource ds =(javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/dbconn");
Connection conn = ds.getConnection();
why it throws exception?
thanks,
chaitanya.