Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
MIME-Version: 1.0
In-Reply-To: <0e2a3615f212108c8e1868671dc3a7d0@mail.gmail.com>
References: <7a56a9c89de8fd69dfc02d9fd13a3fc7@mail.gmail.com>
 <OF37255DF3.81A82C94-ONC1258003.002A43FF-C1258003.002A7EC1@lex-com.net> <0e2a3615f212108c8e1868671dc3a7d0@mail.gmail.com>
From: =?UTF-8?Q?Jose_Mar=C3=ADa_Zaragoza?= <demablogia@gmail.com>
Date: Tue, 9 Aug 2016 11:38:43 +0200
Message-ID: <CABOBwRhjWMDDF1+bLjQq7o9VDAKsF3O63eVynBqSwAA-wriebg@mail.gmail.com>
Subject: Re: jdbc check available database
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
archived-at: Tue, 09 Aug 2016 09:39:09 -0000

2016-08-09 10:52 GMT+02:00 Andrea Galli <andrea.galli@tp-italia.com>:
> Thank you Christoph , but in this how-to there isn't any example for SQL
> Server.

This is my configuration (context.xml) for a SQL Server connection pool

<Resource auth=3D"Container" type=3D"javax.sql.DataSource"
 factory=3D"org.apache.tomcat.jdbc.pool.DataSourceFactory"
 driverClassName=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver"
 initialSize=3D"0"  maxActive=3D"100" maxIdle=3D"20" maxWait=3D"10000" mind=
Idle=3D"0"
 name=3D"datasource/test" password=3D"xxxxxx" removeAbandoned=3D"true"
 url=3D"jdbc:sqlserver://x.x.x.x;databaseName=3DTest;LoginTimeout=3D3"
 username=3D"xxxxxx" validationQuery=3D"SELECT 1" testOnBorrow=3D"true" />

You need a SQL Server JDBC driver


>
> -----Messaggio originale-----
> Da: Christoph Nenning [mailto:Christoph.Nenning@lex-com.net]
> Inviato: marted=C3=AC 2 agosto 2016 09:44
> A: Tomcat Users List <users@tomcat.apache.org>
> Oggetto: Re: jdbc check available database
>
>> Hello guys,
>>
>> I=E2=80=99ve SQL Server database with Tomcat 7 and, when I restart only
> database,
>>  webapps on Tomcat didn=E2=80=99t works , it show me error to connect to
> database ..
>>
>> In webapp context I use jdbc driver for connect, so there is a kind of
>> method for retry to connect to database when it return available?
>>
>>
>>
>
> Hi,
>
> I suggest to use a DataSource instead of dealing with jdbc connections on
> your own.
>
> see:
> http://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.ht=
ml
>
>
> Regards,
> Christoph
>
>
> This Email was scanned by Sophos Anti Virus
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>

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