tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Александър Шопов <...@contact.bg>
Subject Problems with data sources
Date Tue, 14 Jul 2009 10:45:06 GMT
Hi guys,
After reading 
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
and
http://tomcat.apache.org/tomcat-6.0-doc/config/context.html
I am still trying to configure tomcat 6.0.20 to use datasources.

I could be doing something very wrong and silly but cannot realize what.

Here are the relevant parts of my project:
=================================================
0. The web app is called test
1. web.xml in WEB-INF
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
         xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
         http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
    <resource-ref>
        <description>My postgreSQL Datasource</description>
        <res-ref-name>MyDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
</web-app>

2. context.xml in META-INF (I undeploy and redeploy the app in order to
not use previous context.xml files)

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/test">

<Resource name="MyDS"
          auth="Container"
          type="javax.sql.DataSource"
          driverClassName="org.postgresql.Driver"
          url="jdbc:postgresql://myhost:5432/mydb"
          username="myusername"
          password="mypassword"
          maxActive="20"
          maxIdle="10"
          maxWait="-1"/>
</Context>

3. index.jsp :
<%@ page  language="java" contentType="text/html;charset=UTF-8"
          import="java.util.*, java.io.*, javax.naming.*"
          %>

<HTML>
    <HEAD>
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
charset=UTF-8"/>
        <TITLE>Datasource information</TITLE>
    </HEAD>
    <BODY >
        <table >
            <tr><td>Name</td>
            <td>Exists</td>
            <td>Type</td>
            <td>toString</td>
            </tr>
            <%
            try {
                Context initCtx = new InitialContext();
                Context envCtx = (Context)
initCtx.lookup("java:comp/env");
                String[] sources = {"MyDS"};

                for (int i =0; i<sources.length; i++){
                    Object ds = envCtx.lookup(sources[i]);
                    boolean exist = (null == ds);
                    String className
=(exist)?ds.getClass().getName():"NULL";
                    String show = (exist)?ds.toString():"NULL";

            %>
            <tr>
                <td><%=sources[i]%></td>
                <td><%=exist%></td>
                <td><%=className%></td>
                <td><%=show%></td>
            </tr>
            <%
                 }
             } catch (Exception e) { %>
            <tr>
                <td>
                    <%= e.toString() %>
                </td>
            </tr>
            <%

             }
            %>

        </table>
    </BODY>
</HTML>

4. The lib dir of tomcat contains the postgres JDBC driver jar. 		
=================================================

The result that I get is when I open the index.jsp page is:
Name   Exists  Type  toString
MyDS   false   NULL  NULL	

What am I missing? How can I check what is going wrong?

Kind regards:
al_shopov

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message