his is my sample server.xml look for glvn key word
Good luck -Dan <?xml version='1.0' encoding='utf-8'?> <Server className="org.apache.catalina.core.StandardServer" debug="0" port="8005" shutdown="SHUTDOWN"> <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" debug="0"/> <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" debug="0"/> <GlobalNamingResources> <Environment name="simpleValue" override="true" type="java.lang.Integer" value="30"/> <Resource auth="Container" description="User database that can be updated and saved" name="UserDatabase" scope="Shareable" type="org.apache.catalina.UserDatabase"/> <Resource name="jdbc/glvn" scope="Shareable" type="javax.sql.DataSource"/> <ResourceParams name="UserDatabase"> <parameter> <name>factory</name> <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> </parameter> <parameter> <name>pathname</name> <value>conf/tomcat-users.xml</value> </parameter> </ResourceParams> <ResourceParams name="jdbc/glvn"> <parameter> <name>validationQuery</name> <value>select ping from ping </value> </parameter> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>maxActive</name> <value>4</value> </parameter> <parameter> <name>username</name> <value>sa</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>url</name> <value>jdbc:microsoft:sqlserver://localhost:1433;databaseName=glvn;selectMet hod=cursor</value> </parameter> <parameter> <name>driverClassName</name> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>2</value> </parameter> </ResourceParams> </GlobalNamingResources> <Service className="org.apache.catalina.core.StandardService" debug="0" name="Tomcat-Standalone"> <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" acceptCount="10" bufferSize="2048" connectionTimeout="20000" debug="0" enableLookups="true" maxProcessors="75" minProcessors="5" port="8080" protocolHandlerClassName="org.apache.coyote.http11.Http11Protocol" proxyPort="0" redirectPort="8443" scheme="http" secure="false" tcpNoDelay="true" useURIValidationHack="false"> <Factory className="org.apache.catalina.net.DefaultServerSocketFactory"/> </Connector> <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" acceptCount="10" bufferSize="2048" connectionTimeout="20000" debug="0" enableLookups="true" maxProcessors="75" minProcessors="5" port="8009" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" proxyPort="0" redirectPort="8443" scheme="http" secure="false" tcpNoDelay="true" useURIValidationHack="false"> <Factory className="org.apache.catalina.net.DefaultServerSocketFactory"/> </Connector> <Engine className="org.apache.catalina.core.StandardEngine" debug="0" defaultHost="localhost" mapperClass="org.apache.catalina.core.StandardEngineMapper" name="Standalone"> <DefaultContext className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> </DefaultContext> <Host className="org.apache.catalina.core.StandardHost" appBase="webapps" autoDeploy="true" configClass="org.apache.catalina.startup.ContextConfig" contextClass="org.apache.catalina.core.StandardContext" debug="0" deployXML="true" errorReportValveClass="org.apache.catalina.valves.ErrorReportValve" liveDeploy="true" mapperClass="org.apache.catalina.core.StandardHostMapper" name="localhost" unpackWARs="true"> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Administration Application" docBase="../server/webapps/admin" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/admin" privileged="true" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_admin_log." suffix=".txt" timestamp="true" verbosity="1"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Webdav Content Management" docBase="C:\JBuilder8\thirdparty\jakarta-tomcat-4.1.12-LE-jdk14\webapps\webd av" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/webdav" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Examples" docBase="examples" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/examples" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_examples_log." suffix=".txt" timestamp="true" verbosity="1"/> <Parameter name="context.param.name" override="false" value="context.param.value"/> <Ejb home="com.wombat.empl.EmployeeRecordHome" name="ejb/EmplRecord" remote="com.wombat.empl.EmployeeRecord" type="Entity"/> <Ejb description="Example EJB Reference" home="com.mycompany.mypackage.AccountHome" name="ejb/Account" remote="com.mycompany.mypackage.Account" type="Entity"/> <Environment name="foo/name4" override="true" type="java.lang.Integer" value="10"/> <Environment name="maxExemptions" override="true" type="java.lang.Integer" value="15"/> <Environment name="minExemptions" override="true" type="java.lang.Integer" value="1"/> <Environment name="foo/bar/name2" override="true" type="java.lang.Boolean" value="true"/> <Environment name="name3" override="true" type="java.lang.Integer" value="1"/> <Environment name="foo/name1" override="true" type="java.lang.String" value="value1"/> <LocalEjb description="Example Local EJB Reference" home="com.mycompany.mypackage.ProcessOrderHome" local="com.mycompany.mypackage.ProcessOrder" name="ejb/ProcessOrder" type="Session"/> <Resource auth="SERVLET" name="jdbc/EmployeeAppDb" scope="Shareable" type="javax.sql.DataSource"/> <Resource auth="Container" name="mail/Session" scope="Shareable" type="javax.mail.Session"/> <ResourceParams name="jdbc/EmployeeAppDb"> <parameter> <name>url</name> <value>jdbc:HypersonicSQL:database</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>driverClassName</name> <value>org.hsql.jdbcDriver</value> </parameter> <parameter> <name>username</name> <value>sa</value> </parameter> </ResourceParams> <ResourceParams name="mail/Session"> <parameter> <name>mail.smtp.host</name> <value>localhost</value> </parameter> </ResourceParams> <ResourceLink global="simpleValue" name="linkToGlobalResource" type="java.lang.Integer"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Giaoly Vietngu Databbase" docBase="c:\dev\glvn\approot" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/glvn" privileged="true" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_glvn_log." suffix=".txt" timestamp="true" verbosity="1"/> <ResourceLink global="jdbc/glvn" name="jdbc/glvn" type="javax.sql.DataSource"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Documentation" docBase="C:\JBuilder8\thirdparty\jakarta-tomcat-4.1.12-LE-jdk14\webapps\tomc at-docs" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/tomcat-docs" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Welcome to Tomcat" docBase="C:\JBuilder8\thirdparty\jakarta-tomcat-4.1.12-LE-jdk14\webapps\ROOT " mapperClass="org.apache.catalina.core.StandardContextMapper" path="" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Manager Application" docBase="../server/webapps/manager" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/manager" privileged="true" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Listener className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"/> <ResourceLink global="UserDatabase" name="users" type="org.apache.catalina.UserDatabase"/> </Context> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_log." suffix=".txt" timestamp="true" verbosity="1"/> </Host> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="catalina_log." suffix=".txt" timestamp="true" verbosity="1"/> <Realm className="org.apache.catalina.realm.UserDatabaseRealm" debug="0" resourceName="UserDatabase" validate="true"/> </Engine> </Service> </Server> ----- Original Message ----- From: "White, Joshua A (CASD, IT)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 6:24 PM Subject: RE: JNDI datasource frustrations... > It looks like this is a common problem. I have found several posts on > several boards about this problem. Unfortunately, no solution. > > Does it matter whether I declare the resource in the server.xml under the > global naming resources or do I need to define one specific to my > applications path? > > Has anyone successfully connected with MSSQL Server 2k? > > -Joshua > > -----Original Message----- > From: White, Joshua A (CASD, IT) > Sent: Thursday, February 13, 2003 5:17 PM > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: JNDI datasource frustrations... > > > Here is my entry in my web.xml: > > <resource-ref> > <description>Sql Server Database Connection</description> > <res-ref-name>jdbc/joshsDB</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > I am still at a loss. Any other ideas? > > -Joshua > > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 3:43 PM > To: [EMAIL PROTECTED] > Subject: RE: JNDI datasource frustrations... > > > What about your app's web.xml? This is a classic question, You many search > through this list or struts/commons lists for answer. There is also a > documentation on Jakarta.apache.org's. > > Regards, > > > PQ > > "This Guy Thinks He Knows Everything" > "This Guy Thinks He Knows What He Is Doing" > > -----Original Message----- > From: White, Joshua A (CASD, IT) [mailto:[EMAIL PROTECTED]] > Sent: February 13, 2003 3:36 PM > To: '[EMAIL PROTECTED]' > Subject: JNDI datasource frustrations... > > All, > > It seems that I may be having a problem instantiating the Sql server jdbc > driver. I have copied the following jars into my $CATALINA_HOME/common/lib > directory: > msbase.jar > mssqlserver.jar > msutil.jar > > > I have the following in my server.xml file: > > <Resource name="jdbc/joshsDB" > auth="Container" > type="javax.sql.DataSource"/> > > > <ResourceParams name="jdbc/joshsDB"> > <parameter> > <name>username</name> > <value>someuser</value> > </parameter> > <parameter> > <name>password</name> > <value>password</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:microsoft:sqlserver://localhost:1433</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>100</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>10000</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > </ResourceParams> > > > In the Tomcat console, I see the following: > > java.sql.SqlException: Cannot load JDBC driver class 'null' > > What am I doing wrong here? > > Joshua > > > > > This communication, including attachments, is for the exclusive use of > addressee and may contain proprietary, confidential or privileged > information. If you are not the intended recipient, any use, copying, > disclosure, dissemination or distribution is strictly prohibited. If > you are not the intended recipient, please notify the sender > immediately by return email and delete this communication and destroy all > copies. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
