[jetty-user] Jetty Clustering via the Database Overrides Web Application Specified Data Source Pool
Steve Wall <[email protected]> Tue, 19 Feb 2013 16:34:44 +0000
| Newsgroups | gmane.comp.java.jetty.support |
|---|---|
| Message-ID | <C3D6602A037E324BB07052B944F0D6E4010083D5@SRVWUDEN0402.hqintl1.com> |
--_000_C3D6602A037E324BB07052B944F0D6E4010083D5SRVWUDEN0402hqi_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello,
The goal is to create a clustered environment for a web application that is=
currently running in a single Jetty instance. When clustering configuratio=
n is added, it appears to prevent the applications data source pool from in=
itializing. Attaching a remote debugging session and stepping through the c=
ode shows the application hanging on startup while waiting for a connection=
to free up from the pool. Inspecting the details of the pool shows no conn=
ections have been created. c3p0 is used for the pooling implementation. Whe=
n the server starts without the clustering configuration, c3p0 generates a =
log message showing it is initializing. When started with clustering config=
ured, the log message is not seen. Leading me to believe the application da=
ta source pool is never initialized because the clustering data source pool=
is usurping it in some way.
To get the clustering behavior I added the following to %JETTY_HOME%/etc/je=
tty.xml.
<New id=3D"DSClustering" class=3D"org.eclipse.jetty.plus.jndi.Resource">
<Arg></Arg>
<Arg>jdbc/DSClustering</Arg>
<Arg>
<New class=3D"com.mchange.v2.c3p0.ComboPooledDataSource">
<Set name=3D"driverClass">oracle.jdbc.OracleDriver</Set>
<Set name=3D"jdbcUrl">jdbc:oracle:thin:@xxxxx:1521:xe</Set>
<Set name=3D"User">xxxx</Set>
<Set name=3D"Password">xxxx</Set>
</New>
</Arg>
</New>
<Set name=3D"sessionIdManager">
<New id=3D"jdbcidmgr" class=3D"org.eclipse.jetty.server.session.JDBCSes=
sionIdManager">
<Arg><Ref id=3D"Server"/></Arg>
<Set name=3D"workerName">jetty1</Set>
<Set name=3D"DatasourceName">jdbc/DSClustering</Set>
<Set name=3D"scavengeInterval">60</Set>
</New>
</Set>
<Call name=3D"setAttribute">
<Arg>jdbcIdMgr</Arg>
<Arg><Ref id=3D"jdbcidmgr"/></Arg>
</Call>
And added the following to the applications jetty-web.xml
<Set name=3D"sessionHandler">
<New class=3D"org.eclipse.jetty.server.session.SessionHandler">
<Arg>
<New class=3D"org.eclipse.jetty.server.session.JDBCSessionManag=
er">
<Set name=3D"idManager">
<Ref id=3D"jdbcidmgr"/>
</Set>
</New>
</Arg>
</New>
</Set>
The applications data source pool is configured as a Spring bean -
<bean id=3D"sysContextAwareDataSource" class=3D"com.mycompany.datasource.Sy=
sContextAwareDataSource">
<property name=3D"targetDataSource" ref=3D"myPoolDataSource"/>
<property name=3D"connectionWaitLoggingThreshold" value=3D"1000"/>
</bean>
<bean id=3D"myPoolDataSource" class=3D"com.mchange.v2.c3p0.ComboPooledDataS=
ource" destroy-method=3D"close">
<property name=3D"driverClass" value=3D"${jdbc.driverClassName}"/>
<property name=3D"jdbcUrl" value=3D"${jdbc.url}"/>
<property name=3D"user" value=3D"${jdbc.username}"/>
<property name=3D"password" value=3D"${jdbc.password}"/>
<property name=3D"acquireIncrement" value=3D"${jdbc.pool.acquireIncreme=
nt}"/>
<property name=3D"minPoolSize" value=3D"${jdbc.pool.minPoolSize}"/>
<property name=3D"maxPoolSize" value=3D"${jdbc.pool.maxPoolSize}"/>
<property name=3D"initialPoolSize" value=3D"${jdbc.pool.initialPoolSize=
}"/>
<property name=3D"acquireRetryAttempts" value=3D"${jdbc.pool.acquireRet=
ryAttempts}"/>
<property name=3D"testConnectionOnCheckin" value=3D"${jdbc.pool.testCon=
nectionOnCheckin}"/>
<property name=3D"idleConnectionTestPeriod" value=3D"${jdbc.pool.idleCo=
nnectionTestPeriod}"/>
<property name=3D"preferredTestQuery" value=3D"${jdbc.pool.preferredTes=
tQuery}"/>
<property name=3D"maxIdleTime" value=3D"${jdbc.pool.maxIdleTime}"/>
<property name=3D"acquireRetryDelay" value=3D"${jdbc.pool.acquireRetryD=
elay}"/>
<property name=3D"maxStatements" value=3D"${jdbc.pool.maxStatements}"/>=
<property name=3D"maxStatementsPerConnection" value=3D"${jdbc.pool.maxS=
tatementsPerConnection}"/>
</bean>
<bean id=3D"userDAO" class=3D"com.mycompany.dataaccess.UserDAOImpl">
<property name=3D"sessionFactory" ref=3D"sessionFactory"/>
<property name=3D"dataSource" ref=3D"transactionAwareDataSourceProxy"/>=
</bean>
Environment: jetty 8.1.9, Oracle 11g, Windows 7 Enterprise, JDK 1.6.0_38
Any ideas my appreciated!
-Steve
The information transmitted, including any content in this communication is=
confidential, is intended only for the use of the intended recipient and i=
s the property of The Western Union Company or its affiliates and subsidiar=
ies. If you are not the intended recipient, you are hereby notified that an=
y use of the information contained in or transmitted with the communication=
or dissemination, distribution, or copying of this communication is strict=
ly prohibited. If you have received this communication in error, please not=
ify the Western Union sender immediately by replying to this message and de=
lete the original message
--_000_C3D6602A037E324BB07052B944F0D6E4010083D5SRVWUDEN0402hqi_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Consolas}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello,</p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt; line-height:13.5pt; b=
ackground:white; vertical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:"Arial","sans-s=
erif"; color:black">The goal is to create a clustered environment for =
a web application that is currently running in a single Jetty instance. Whe=
n clustering configuration is added, it appears to prevent
the applications data source pool from initializing. Attaching a remote de=
bugging session and stepping through the code shows the application hanging=
on startup while waiting for a connection to free up from the pool. Inspec=
ting the details of the pool shows
no connections have been created. c3p0 is used for the pooling implementat=
ion. When the server starts without the clustering configuration, c3p0 gene=
rates a log message showing it is initializing. When started with clusterin=
g configured, the log message is
not seen. Leading me to believe the application data source pool is never =
initialized because the clustering data source pool is usurping it in some =
way.</span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt; line-height:13.5pt; b=
ackground:white; vertical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:"Arial","sans-s=
erif"; color:black">To get the clustering behavior I added the followi=
ng to %JETTY_HOME%/etc/jetty.xml.</span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><New id=3D"=
DSClustering" class=3D"org.eclipse.jetty.plus.jndi.Resource"=
></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<Arg></Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
lt;Arg>jdbc/DSClustering</Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <New class=3D"com.mchange.v2.c3p0.ComboPool=
edDataSource">  =
;
</span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"d=
riverClass">oracle.jdbc.OracleDriver</Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"jdbcUr=
l">jdbc:oracle:thin:@xxxxx:1521:xe</Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"User&qu=
ot;>xxxx</Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"Passwo=
rd">xxxx</Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> </span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; </New></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
</Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></New></span>=
</p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> </span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> </span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><Set name=3D&quo=
t;sessionIdManager"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<New id=3D"jdbcidmgr" class=3D"org.eclipse.jetty.server.s=
ession.JDBCSessionIdManager"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Arg><Ref id=3D"Server"/><=
/Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"workerName">jetty1<=
/Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"DatasourceName">jdbc/D=
SClustering</Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Set name=3D"scavengeInterval">60&l=
t;/Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
</New></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></Set></span>=
</p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><Call name=3D&qu=
ot;setAttribute"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<Arg>jdbcIdMgr</Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<Arg><Ref id=3D"jdbcidmgr"/></Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></Call></span=
></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt; line-height:13.5pt; b=
ackground:white; vertical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:"Arial","sans-s=
erif"; color:black"><br>
<br>
And added the following to the applications jetty-web.xml</span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><Set name=3D&quo=
t;sessionHandler"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<New class=3D"org.eclipse.jetty.server.session.SessionHandler"=
></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <New class=3D"org.e=
clipse.jetty.server.session.JDBCSessionManager"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <=
;Set name=3D"idManager"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; &nbs=
p; <Ref id=3D"jdbcidmgr"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; <=
;/Set></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; </New></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> &=
nbsp; </Arg></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
</New></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></Set></span>=
</p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt; line-height:13.5pt; b=
ackground:white; vertical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:"Arial","sans-s=
erif"; color:black"><br>
<br>
The applications data source pool is configured as a Spring bean -</span></=
p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><bean id=3D"=
;sysContextAwareDataSource" class=3D"com.mycompany.datasource.Sys=
ContextAwareDataSource"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"targetDataSource" ref=3D"myPoolDataSour=
ce"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"connectionWaitLoggingThreshold" value=3D&quo=
t;1000"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></bean></span=
></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> </span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><bean id=3D"=
;myPoolDataSource" class=3D"com.mchange.v2.c3p0.ComboPooledDataSo=
urce" destroy-method=3D"close"></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"driverClass" value=3D"${jdbc.driverClas=
sName}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"jdbcUrl" value=3D"${jdbc.url}"/>=
;</span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"user" value=3D"${jdbc.username}"/&=
gt;</span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"password" value=3D"${jdbc.password}&quo=
t;/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"acquireIncrement" value=3D"${jdbc.pool.=
acquireIncrement}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"minPoolSize" value=3D"${jdbc.pool.minPo=
olSize}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"maxPoolSize" value=3D"${jdbc.pool.maxPo=
olSize}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"initialPoolSize" value=3D"${jdbc.pool.i=
nitialPoolSize}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"acquireRetryAttempts" value=3D"${jdbc.p=
ool.acquireRetryAttempts}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"testConnectionOnCheckin" value=3D"${jdb=
c.pool.testConnectionOnCheckin}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"idleConnectionTestPeriod" value=3D"${jd=
bc.pool.idleConnectionTestPeriod}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"preferredTestQuery" value=3D"${jdbc.poo=
l.preferredTestQuery}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"maxIdleTime" value=3D"${jdbc.pool.maxId=
leTime}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"acquireRetryDelay" value=3D"${jdbc.pool=
.acquireRetryDelay}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"maxStatements" value=3D"${jdbc.pool.max=
Statements}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"maxStatementsPerConnection" value=3D"${=
jdbc.pool.maxStatementsPerConnection}"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></bean></span=
></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> </span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> </span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"><bean id=3D"=
;userDAO" class=3D"com.mycompany.dataaccess.UserDAOImpl">=
</span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"sessionFactory" ref=3D"sessionFactory&q=
uot;/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"> =
<property name=3D"dataSource" ref=3D"transactionAwareData=
SourceProxy"/></span></p>
<p class=3D"MsoNormal" style=3D"line-height:13.5pt; background:#EEEEEE; ver=
tical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:Consolas; color:black; border:=
none windowtext 1.0pt; padding:0in; background:#EEEEEE"></bean></span=
></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt; line-height:13.5pt; b=
ackground:white; vertical-align:baseline">
<span style=3D"font-size:10.5pt; font-family:"Arial","sans-s=
erif"; color:black">Environment: jetty 8.1.9, Oracle 11g, Windows 7 En=
terprise, JDK 1.6.0_38</span></p>
<p class=3D"MsoNormal">Any ideas my appreciated!</p>
<p class=3D"MsoNormal">-Steve</p>
<p class=3D"MsoNormal"> </p>
</div>
<p>The information transmitted, including any content in this communication=
is confidential, is intended only for the use of the intended recipient an=
d is the property of The Western Union Company or its affiliates and subsid=
iaries. If you are not the intended
recipient, you are hereby notified that any use of the information contain=
ed in or transmitted with the communication or dissemination, distribution,=
or copying of this communication is strictly prohibited. If you have recei=
ved this communication in error,
please notify the Western Union sender immediately by replying to this mes=
sage and delete the original message
</p>
<p></p>
<br clear=3Dall> =
</body>
</html>
--_000_C3D6602A037E324BB07052B944F0D6E4010083D5SRVWUDEN0402hqi_--