On Jan 29, 2013, at 12:18 PM, alan.farr...@renfrewshire.gov.uk wrote: > 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" />
These three are using a custom "factory", so you'll want to check with the author of "org.moss.jdj.dbcp.EncryptedDataSourceFactory" to determine exactly what properties it supports. I'm assuming that because the first two take a "validationQuery", the third should work with it as well. You just need to adjust the query so that it works on MSSQL. I think "SELECT 1" should work, but you'll want to double-check that. > > <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" /> This doesn't have a factory, so it'll use the default DBCP connection pool. See Chris' email for a link to the docs for DBCP. Dan > > > 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. > > ********************************************************************** > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
