tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ron McNulty <>
Subject Re: DB Connection error
Date Tue, 10 Jan 2012 07:38:55 GMT
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 

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

Hope that helps.



----- Original Message ----- 
From: "Anjib Mulepati" <>
To: "Tomcat Users List" <>
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<>:
>>> 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:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message