*META-INF/context.xml*:
<?xml version='1.0' encoding='utf-8'?>
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/isDS" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@172.16.4.4:1523:kiptest"
username="test" password="test"
maxActive="20" maxIdle="10" maxWait="-1" />
<Resource name="jdbc/TestDB" auth="Container"
type="javax.sql.DataSource" maxActive="100" maxIdle="30"
maxWait="10000" username="root" password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mysql?autoReconnect=true" />
</Context>
*WEB-INF/web.xml, modified a bit to hide private data:*
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application
2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app id="WebAppUM">
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/isDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<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>
<context-param >
<param-name>contextConfigLocation</param-name>
<param-value>
/WEB-INF/applicationContext-security.xml
/WEB-INF/schedulers-context.xml
</param-value>
</context-param>
<context-param >
<param-name>log4jConfigLocation</param-name>
<param-value>/WEB-INF/classes/log4j.properties</param-value>
</context-param>
<filter >
<filter-name>springSecurityFilterChain</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>
<filter-mapping >
<filter-name>springSecurityFilterChain</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener >
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<listener >
<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
</listener>
<listener >
<listener-class>org.springframework.security.ui.session.HttpSessionEventPublisher</listener-class>
</listener>
<servlet id="com.company.application" >
<servlet-name>com.company.application</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping >
<servlet-name>com.company.application</servlet-name>
<url-pattern>*.form</url-pattern>
</servlet-mapping>
</web-app>
*catalina.2009-03-30.log:*
Mar 30, 2009 11:09:11 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: E:\Program Files\Apache Software Foundation\Tomcat
6.0\bin;.;E:\WINDOWS\Sun\Java\bin;E:\WINDOWS\system32;E:\WINDOWS;E:\Program
Files\Windows Resource Kits\Tools\;E:\Program
Files\PHP\;F:\home3\bin;F:\OraHome_1\bin;E:\WINDOWS\system32;E:\WINDOWS;E:\WINDOWS\System32\Wbem;E:\Program
Files\Intel\DMIX;E:\Program Files\Diskeeper
Corporation\Diskeeper\;E:\Program Files\7-Zip;E:\Program Files\WinRAR;
Mar 30, 2009 11:09:11 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-9080
Mar 30, 2009 11:09:11 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 274 ms
Mar 30, 2009 11:09:11 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Mar 30, 2009 11:09:11 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.16
Mar 30, 2009 11:09:12 AM org.apache.catalina.core.StandardContext
addApplicationListener
INFO: The listener "org.springframework.web.context.ContextLoaderListener"
is already configured for this context. The duplicate definition has been
ignored.
Mar 30, 2009 11:09:12 AM org.apache.catalina.core.StandardContext
addApplicationListener
INFO: The listener "org.springframework.web.util.Log4jConfigListener" is
already configured for this context. The duplicate definition has been
ignored.
Mar 30, 2009 11:09:12 AM org.apache.catalina.core.StandardContext
addApplicationListener
INFO: The listener
"org.springframework.security.ui.session.HttpSessionEventPublisher" is
already configured for this context. The duplicate definition has been
ignored.
Mar 30, 2009 11:09:12 AM org.apache.tomcat.util.modeler.Registry
registerComponent
SEVERE: Null component
Catalina:type=DataSource,path=/com.company.application,host=localhost,class=javax.sql.DataSource,name="jdbc/isDS"
Mar 30, 2009 11:09:12 AM org.apache.tomcat.util.modeler.Registry
registerComponent
SEVERE: Null component
Catalina:type=DataSource,path=/com.company.application,host=localhost,class=javax.sql.DataSource,name="jdbc/TestDB"
Mar 30, 2009 11:09:16 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-9080
Mar 30, 2009 11:09:16 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Mar 30, 2009 11:09:16 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/32 config=null
Mar 30, 2009 11:09:16 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4910 ms
Mar 30, 2009 11:11:11 AM org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-9080
Mar 30, 2009 11:11:12 AM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Mar 30, 2009 11:11:12 AM org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-9080
*localhost.2009-03-30.log *
Mar 30, 2009 11:09:12 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Mar 30, 2009 11:09:15 AM org.apache.catalina.core.ApplicationContext log
INFO: Set web app root system property: 'webapp.root' = [E:\Program
Files\Apache Software Foundation\Tomcat
6.0\webapps\com.company.application\]
Mar 30, 2009 11:09:15 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Log4J from [E:\Program Files\Apache Software
Foundation\Tomcat
6.0\webapps\com.company.application\WEB-INF\classes\log4j.properties]
Mar 30, 2009 11:09:15 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'com.company.application'
Mar 30, 2009 11:11:12 AM org.apache.catalina.core.ApplicationContext log
INFO: Destroying Spring FrameworkServlet 'com.company.application'
Mar 30, 2009 11:11:12 AM org.apache.catalina.core.ApplicationContext log
INFO: Shutting down Log4J
Mar 30, 2009 11:11:12 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
That is all :).
Waiting your solutions.
On Fri, Mar 27, 2009 at 6:21 PM, Gregor Schneider <[email protected]>wrote:
> 1st: I Agree to Yassine that it would be helpful if you could provide some
> logs.
>
> 2nd: If I'm not mistaken, you're using the Tomcat5-syntax which has
> changed since Tomcat 6.
>
> Have l look here:
> http://tomcat.apache.org/tomcat-6.0-doc/config/realm.html
>
> I.e., the username-attribute becomes connectionName-attribute etc.
>
> Please look it up, change your settings and let us know if it works now.
>
> If not, please provide
>
> - your complete context-definition
> - your complete deplyment-descriptor
> - the logs
>
> Rgds
>
> Gregor
> --
> just because your paranoid, doesn't mean they're not after you...
> gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2
> gpgp-key available
> @ http://pgpkeys.pca.dfn.de:11371
> @ http://pgp.mit.edu:11371/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
--
________________________
Best regards,
Alexandr Khlystov
