Hi, As requested, the resource tags from the Context file. Although I was asked by my boss to change password value to password and username value to username.
<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" factory="org.moss.jdj.dbcp.EncryptedDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/authentication" password="password" type="javax.sql.DataSource" url="jdbc:oracle:thin:@swtest:1523:TRNG" username="username" validationQuery="select 1 from dual" /> <Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" factory="org.moss.jdj.dbcp.EncryptedDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/swift" password="password" type="javax.sql.DataSource" url="jdbc:oracle:thin:@swtest:1523:TRNG" username="username" validationQuery="select 1 from dual" /> <Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" factory="org.moss.jdj.dbcp.EncryptedDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/edrms" password="password" type="javax.sql.DataSource" url="jdbc:sqlserver://hqdcsqlc2\ngedm:2369;databaseName=ImagesTrainDM" username="username" /> <Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/audit" password="password" type="javax.sql.DataSource" url="jdbc:sqlserver://egovsql2005\p40010:1433;databaseName=AuditDEV" username="username" /> Thank you Regards Alan Farroll Analyst Programmer Finance and Corporate Services Renfrewshire House Cotton Street Paisley PA1 1HY 0141 618 7961 alan.farr...@renfrewshire.gov.uk www.renfrewshire.gov.uk From: Daniel Mikusa <dmik...@vmware.com> To: "Tomcat Users List" <users@tomcat.apache.org> Date: 29/01/2013 17:06 Subject: Re: JNDI Feedback On Jan 29, 2013, at 11:54 AM, alan.farr...@renfrewshire.gov.uk wrote: > Hello, > > Running Tomcat 7.0.29 on Windows XP Professional Service Pack 3 > > I have been handed a project developed by a former colleague and I am > still learning Java and Tomcat. > > The project has 4 JNDI's set up, 2 Oracle and 2 SQL Server with validation > queries set up for the Oracle databases. Please include the configuration for your data sources. The <Resource/> tag, minus passwords should be sufficient. Dan > I want to set up validation > queries on the JNDI's for SQL server and also have the JNDI provide > feedback to the Java application if the database is down. > > Can you advise how to do this please? If not possible, then what is an > alternative? > > Thank you in advance for any assistance. > > Regards > > Alan Farroll > Analyst Programmer > Finance and Corporate Services > Renfrewshire House > Cotton Street > Paisley > PA1 1HY > > 0141 618 7961 > alan.farr...@renfrewshire.gov.uk > www.renfrewshire.gov.uk > > ********************************************************************** > > Renfrewshire Council Website - http://www.renfrewshire.gov.uk > > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. > > Renfrewshire Council may, in accordance with the Telecommunications(Lawful Business Practice) (Interception of Communications) Regulations 2000, intercept e-mail messages for the purpose of monitoring or keeping a record of communications on the Council's system. If a message contains inappropriate dialogue it will automatically be intercepted by the Council's Internal Audit section who will decide whether or not the e-mail should be onwardly transmitted to the intended recipient(s). > > This footnote also confirms that this email message has been swept by Sophos for the presence of computer viruses. > > ********************************************************************** > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org ********************************************************************** Renfrewshire Council Website - http://www.renfrewshire.gov.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Renfrewshire Council may, in accordance with the Telecommunications(Lawful Business Practice) (Interception of Communications) Regulations 2000, intercept e-mail messages for the purpose of monitoring or keeping a record of communications on the Council's system. If a message contains inappropriate dialogue it will automatically be intercepted by the Council's Internal Audit section who will decide whether or not the e-mail should be onwardly transmitted to the intended recipient(s). This footnote also confirms that this email message has been swept by Sophos for the presence of computer viruses. **********************************************************************