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" <anji...@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<anji...@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-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
