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(BasicDataSourc 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;DatabaseNam 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]