tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shapira, Yoav" <Yoav.Shap...@mpi.com>
Subject RE: Datasource problem upgrading from 4.06
Date Wed, 26 Nov 2003 17:57:15 GMT

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:jimk@gigaheads.com]
>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" <Yoav.Shapira@mpi.com>
>To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>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:jimk@gigaheads.com]
>>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: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org




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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message