Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (nike.apache.org: domain of rmcnulty@clear.net.nz
 designates 203.97.33.68 as permitted sender)
Date: Tue, 10 Jan 2012 20:38:55 +1300
From: Ron McNulty <rmcnulty@clear.net.nz>
Subject: Re: DB Connection error
To: Tomcat Users List <users@tomcat.apache.org>
Message-id: <6DECD1B3AC924A2C8A39A878886DE711@Conservatory>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=iso-8859-1;
 reply-type=response
Content-transfer-encoding: 7bit
References: <BLU0-SMTP1064AB95A0344C7DCC631D0B1960@phx.gbl>
 <CABOBwRjbWhAUasokaF3S3XOjY+XbDa0TjFJ_BHfv0d1AMC2WeA@mail.gmail.com>
 <BLU0-SMTP113E51FCEA8CD6A28860E70B1960@phx.gbl>

Hi Anjib

Port 8080 looks very odd. For an Oracle XE database, this is an HTTP 
connection to the database admin console, but you need a TNS connection 
direct to the database.

Try "telnet localhost 1521" from the command line. If this connects, you 
probably have a standard Oracle database on its default port.

I would expect something like url="jdbc:oracle:thin:@localhost:1521/XE" to 
connect to a local XE installation (the only supported schema name is XE). 
This works fine on my local installation. Else 
url="jdbc:oracle:thin:@localhost:1521/MYDBS" if you have a full local Oracle 
installation and MYDBS is the schema name. Note that the double slashes have 
gone in the URL.

You will also need to put a copy of ojdb6.jar in the Tomcat shared libs 
directory.

You can easily test the connection string by using a simple SQL client like 
SQuirrel SQL.

Hope that helps.

Regards

Ron


----- Original Message ----- 
From: "Anjib Mulepati" <anjibcs@hotmail.com>
To: "Tomcat Users List" <users@tomcat.apache.org>
Sent: Wednesday, January 04, 2012 7:26 AM
Subject: Re: DB Connection error


> On 1/3/2012 1:12 PM, Chema wrote:
>> 2012/1/3 Anjib Mulepati<anjibcs@hotmail.com>:
>>> Hi All,
>>>
>>> One simple question If I have JINDI configuration in my application will 
>>> my
>>> application reconnect to the DB whenever my DB gets restart.
>>> I am having DB connection problem every Monday since our DB get 
>>> restarted on
>>> weekends which we don't have control of.
>>> I am using Tomcat 6.0.20
>> Hi:
>>
>> can you attach your<Resource/>  element in server.xml file ( except
>> sensible data )?
>
> I haven't change anythign in server.xml so i have default in it
> <GlobalNamingResources>
> <Resource name="UserDatabase" auth="Container"
>               type="org.apache.catalina.UserDatabase"
>               description="User database that can be updated and saved"
> 
> factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
>               pathname="conf/tomcat-users.xml" />
> </GlobalNamingResources>
>
> But in my application I have context.xml with following
>
> <Context antiJARLocking="true" path="/myApp">
> <Resource auth="Container"
>             driverClassName="oracle.jdbc.driver.OracleDriver"
>             maxActive="20"
>             maxIdle="10"
>             maxWait="-1"
>             name="jdbc/myName"
>             password="myPassword"
>             type="javax.sql.DataSource"
>             url="jdbc:oracle:thin:@//localhost:8080/MYDBS"
>             username="myUsername"
>              />
> </Context>
>
> ---------------------------------------------------------------------
> 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