Howdy, http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples -howto.html
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Jim Kennedy [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 26, 2003 12:47 PM >To: Tomcat Users List >Subject: Re: Datasource problem upgrading from 4.06 > >How do I define host and database name with this version? > >Need a good example to look at. Thanks > >Jim Kennedy >IT Consultant >Mobile Phone: 813-503-1484 >----------------------------------------------------- > > >----- Original Message ----- >From: "Shapira, Yoav" <[EMAIL PROTECTED]> >To: "Tomcat Users List" <[EMAIL PROTECTED]> >Sent: Wednesday, November 26, 2003 12:41 PM >Subject: RE: Datasource problem upgrading from 4.06 > > > >Howdy, >You need a ResourceParam for the DB URL. It looks like your driver name >me be the URL? > >Yoav Shapira >Millennium ChemInformatics > > >>-----Original Message----- >>From: Jim Kennedy [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, November 26, 2003 12:30 PM >>To: Tomcat Users List >>Subject: Datasource problem upgrading from 4.06 >> >>Below is a little bit of the trace I'm seeing. >> >> >>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver >of >>class 'com. >>microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL 'null', >cause: >>java.lang.NullPointerException >> at java.lang.String.regionMatches(String.java:967) >> at com.microsoft.jdbc.base.BaseURLParser.parse(Unknown Source) >> at com.microsoft.jdbc.base.BaseDriver.acceptsURL(Unknown >Source) >> at java.sql.DriverManager.getDriver(DriverManager.java:232) >> at >>org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSour c >e. >>java:743) >> at >>org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource. j >av >>a:518) >>..... >> >> >>I just upgraded from Tomcat 4.06 to 4.1.29. I've made no changes to >code >>or web.xml. Just a straight copy of my app over to the new server. >Here's >>a snippet of my server.xml. The below config for the context is the >same >>(which worked on 4.06). I'm having problems with the jdbc/eaglepro >>datasource. >> >><Context path="/cds" docBase="D:\serverapps\Tomcat >4.1\webapps-noauto\cds" >>reloadable="true" debug="0" crossContext="true"> >> <Logger className="org.apache.catalina.logger.FileLogger" >>prefix="localhost_cds_log." suffix=".log" timestamp="true"/> >> <Environment name="maxExemptions" type="java.lang.Integer" >value="15"/> >> <Parameter name="context.param.name" value="context.param.value" >>override="false"/> >> <Resource name="jdbc/eaglepro" auth="SERVLET" >>type="javax.sql.DataSource"/> >> <ResourceParams name="jdbc/eaglepro"> >> <parameter><name>user</name> >> <value>eflowuser_t</value> >> </parameter> >> <parameter><name>password</name> >> <value>#$%^&*</value> >> </parameter> >> <parameter><name>driverClassName</name> >> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> >> </parameter> >> <parameter><name>driverName</name> >> >><value>jdbc:microsoft:sqlserver://192.168.2.14:1433;DatabaseName=jtest ; >Sele >>ctMethod=cursor</value> >> </parameter> >> </ResourceParams> >> >> <Resource name="mail/bay4" auth="Container" >type="javax.mail.Session"/> >> <ResourceParams name="mail/bay4"> >> <parameter> <name>mail.smtp.host</name> >> <value>smtp.algx.net</value> >> </parameter> >> </ResourceParams> >> >><Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" >>driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" >>connectionURL="jdbc:microsoft:sqlserver://192.168.2.14:1433;DatabaseNa m >e=ef >>low_dev;User=eflowadmin;Password=#$%^&*;SelectMethod=cursor" >>userTable="ef_users" userNameCol="user_name" >userCredCol="user_password" >>userRoleTable="j2ee_user_roles" roleNameCol="role_name"/> >> >></Context> > > > >This e-mail, including any attachments, is a confidential business >communication, and may contain information that is confidential, >proprietary >and/or privileged. This e-mail is intended only for the individual(s) to >whom it is addressed, and may not be saved, copied, printed, disclosed or >used by anyone else. If you are not the(an) intended recipient, please >immediately delete this e-mail from your computer system and notify the >sender. Thank you. > > >--------------------------------------------------------------------- >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] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
