tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joao Silva <joao.si...@vilt-group.com>
Subject Re: Shared data source (Bug 49543)
Date Wed, 23 May 2012 21:26:38 GMT
Hi

The ResourceLink element will use the parameters name, global and type.
Everything else is being ignored, as the resource link is but reference 
to the global shared data source.
See http://tomcat.apache.org/tomcat-7.0-doc/config/context.html, 
searching for ResourceLink.

Best regards

On 5/23/2012 9:31 PM, Robert Anderson wrote:
> Hi,
>
> I'm testing this functionality (versions 6.0.35 and 7.0.27) but it's not
> working for me (https://issues.apache.org/bugzilla/show_bug.cgi?id=49543 ,
> http://tomcat.apache.org/tomcat-7.0-doc/config/context.html#Resource_Links).
>
>
> -->server.xml
>
>
>    <GlobalNamingResources>
>
>      <Resource name="jdbc/globalpg" auth="Container"
> type="javax.sql.DataSource" removeAbandoned="true"
> removeAbandonedTimeout="300"
>                                     maxActive="400" maxIdle="30"
> maxWait="10000"
>                                     validationQuery="select 1"
>                                     testOnBorrow="true"
>
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>                                     driverClassName="org.postgresql.Driver"
>                                     url="jdbc:postgresql://
> 172.17.1.5:5432/tjse"
>                                     username="user1"
>                                     password="validpassword"
>                                     />
>
>    </GlobalNamingResources>
>
>
> -->conf/Catalina/localhost/app1.xml
>
>
> <Context>
>
>      <ResourceLink name="jdbc/localpg"
>      global="jdbc/globalpg"
>      type="javax.sql.DataSource"
>      factory="org.apache.naming.factory.DataSourceLinkFactory"
>      username="user2"
>      password="invalidpassword"
>      />
>
> </Context>
>
>
> -->webapps/app1/index.jsp
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
>     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
> <%@ page session="false" import="javax.naming.*, java.sql.*, javax.sql.*" %>
> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
>      <head>
>      <title>Test shared data source</title>
> </head>
> <body>
> <%
>      Context ctx = new InitialContext();
>      DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/localpg");
>      Connection c = ds.getConnection();
>      Statement stm = c.createStatement();
>
>      ResultSet rs = stm.executeQuery("select 'this should fail because the
> password of localpg is invalid but it is working.'");
>
>      rs.next();
>
> %>
>      <%= rs.getString(1) %><br/>
> <%
>
>      c.close();
> %>
> </body>
> </html>
>
>
> Am I doing some wrong?
>
>
> Thanks in advance,
>
>
> Robert
>

-- 
*João Silva
* *
VILT Group
* *_http://www.vilt-group.com
_
Rua Ivone Silva, 6 - 7º Esq
1050-124 Lisboa - Portugal

Mobile  +351 926 531 097
Phone   +351 210 34 33 00
Fax       +351 210 34 33 99
Email _joao.silva@vilt-group.com <mailto:joao.silva@vilt-group.com>_*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message