server.xml:
<GlobalNamingResources>
<Resource name="jdbc/mydatasource"
auth="Container"
type="javax.sql.DataSource"
maxActive="16"
maxIdle="8"
maxWait="10000"
username="abc"
password="xyz"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/mydatabase?autoReconnect=true"
/>
</GlobalNamingResources>
As I said, if I move the META-INF/context.xml contents
into my server.xml, then it works fine, but then I
cannot use ant manager tasks to redeploy.
I have also tried to put the driver jar into the
application war. No luck.
--- Sameer Acharya <[EMAIL PROTECTED]> wrote:
> Where is your Resource definition ? seems like the
> Driver class name and url is not defined.
>
> -Sameer
>
> --- Charl Gerber <[EMAIL PROTECTED]> wrote:
>
> > I have 4 Tomcat environments for the same
> > application:
> > two development machines, 1 test and 1 production.
> > Development machines are Windows 2000 and Vista,
> the
> > others are linux. All 4 machines have Tomcat
> 6.0.14
> > installed.
> >
> > I really have problems getting the application
> > properly deployed and configured. I have a global
> > datasource configured in tomcat's server.xml and
> the
> > mysql driver jar is in the /lib directory of
> tomcat.
> >
> > If I deploy the application by putting it in the
> > webapps dir or using the ant manager tasks, I get
> > this
> > exception:
> >
> > Caused by:
> > org.apache.tomcat.dbcp.dbcp.SQLNestedException:
> > Cannot
> > create JDBC driver of class '' for connect URL
> > 'null'
> > at
> >
>
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
> > at
> >
>
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> > at
> >
>
org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
> > at
> >
>
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
> > ... 45 more
> >
> > If I copy the contents of the application's
> > META-INF/context.xml into the server.xml, then the
> > application and datasources loads fine, no
> problems.
> > It looks something like:
> >
> > <Context path="/myapp" docBase="path_to_war"
> > debug="0"
> > reloadable="false" antiJARLocking="true"
> > antiResourceLocking="true" crossContext="true">
> > <ResourceLink name="jdbc/mydatasource"
> > global="jdbc/mydatasource"
> > type="javax.sql.DataSource"
> > />
> > </Context>
> >
> > (I then have a context.xml and the same part in
> the
> > server.xml, but it doesn't seem to do harm)
> >
> > But then I cannot use the ant manager tasks to
> > redeploy the application:
> >
> > C:\projects\myapp\build.xml:198: FAIL - Context
> > /myapp
> > is defined in server.xml and may not be undeployed
> >
> > On the test and production (linux) servers, its
> not
> > that critical, as I do not do a lot of
> deployments.
> > So
> > there I have the app configured in server.xml and
> a
> > deployment basically means stopping stopping,
> > unzipping the war to an exploded docbase dir and
> > starting tomcat again. (The restarting is also
> > required because I use hibernate and there are
> some
> > known memory leak issues there)
> >
> > So can someone clarify where/how the application
> > must
> > be configured to be able to use the ant manager
> > tasks,
> > but also to get the datasource working?
> >
> > Thanks!
> >
> > Charl
> >
> >
> >
>
---------------------------------------------------------------------
> > To start a new topic, e-mail:
> > [email protected]
> > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> >
> >
>
>
> "All that is necessary for the triumph of evil is
> that good men do
> nothing." Edmund Burke
>
> -Sameer
> http://in.groups.yahoo.com/group/indiaenergy/join
>
>
>
>
____________________________________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
>
---------------------------------------------------------------------
> To start a new topic, e-mail:
> [email protected]
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
