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
|