Hi All,
maybe my question is stupid, but i don't have much experience with servlets...
Inside my servlet, i want connect to Microsoft Access datasource via JDBC:ODBC driver. But on startup of my servlet i received this error message....can somebody explain me what does it mean? What is wrong?
Here is my init method:
public void init()
throws ServletException
{
try {
Context env = (Context) new InitialContext().lookup("java:comp/env");
pool = (DataSource) env.lookup("jdbc/testik");
if (pool == null)
throw new ServletException("`testik' is an unknown DataSource");
} catch (NamingException e) {
throw new ServletException(e);
}
}
Here is my web.xml config (tomcat-directory)/Webapps/Root/WebInf:
<resource-ref>
<description>
My first DB pool Servlet...
</description>
<res-ref-name>
jdbc/testik
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
Here is my server.xml config from $CATALINA_HOME/conf
<Resource name="jdbc/testik" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/testik">
<parameter>
<name>user</name>
<value>""</value>
</parameter>
<parameter>
<name>password</name>
<value>""</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>
jdbc:odbc:testik
</value>
</parameter>
</ResourceParams>
</Engine> // my TAG is inside of Engine tag.....