That's how I have it:
jdbc:mysql:///roller?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8
I tried to get rid of domainname as db and tomcat are
on the same server.
--- Sutra Zhou <[EMAIL PROTECTED]> wrote:
> <value>
> jdbc:mysql://mydomain/roller
>
?autoReconnect=true&useUnicode=true&characterEncoding
> =utf-8&mysqlEncoding=utf8
> </value>
>
> & -> &
>
>
> 2007/3/25, Dmitriy <[EMAIL PROTECTED]>:
> >
> > it's 5.0.x
> >
> > --- Sutra Zhou <[EMAIL PROTECTED]> wrote:
> >
> > > "Cannot
> > > create JDBC driver of class '' for connect URL '
> > > null'"
> > > It looks dirver class and url are all null.
> > > Is the setting file roller.xml is not
> compatible
> > > with your tomcat.
> > >
> > > What's the version of your tomcat? 5.0.x or
> 5.5.x?
> > >
> > > 2007/3/25, Dmitriy <[EMAIL PROTECTED]>:
> > > >
> > > > Yes, I deploy it on linux server using the
> same
> > > > roller.xml context that I used on my pc, only
> > > location
> > > > has changed:
> > > >
> > > >
> > > > <Resource name="jdbc/rollerdb"
> auth="Container"
> > > > type="javax.sql.DataSource" />
> > > > <ResourceParams name="jdbc/rollerdb">
> > > > <parameter>
> > > > <name>factory</name>
> > > >
> > >
> >
>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > > > </parameter>
> > > > <parameter>
> > > > <name>driverClassName</name>
> > > > <value>com.mysql.jdbc.Driver</value>
> > > > </parameter>
> > > > <parameter>
> > > > <name>url</name>
> > > > <value>
> > > >
> > > >
> > >
> >
> >
>
jdbc:mysql://mydomain/roller?autoReconnect=true&useUnicode=true&characterEncoding
> > > > =utf-8&mysqlEncoding=utf8
> > > > </value>
> > > > </parameter>
> > > >
> > >
> >
>
<parameter><name>username</name><value>user</value></parameter>
> > > >
> > >
> >
>
<parameter><name>password</name><value>password</value></parameter>
> > > >
> > >
> >
>
<parameter><name>maxActive</name><value>20</value></parameter>
> > > >
> > >
> >
>
<parameter><name>maxIdle</name><value>3</value></parameter>
> > > >
> > >
> >
>
<parameter><name>removeAbandoned</name><value>true</value></parameter>
> > > >
> > >
> >
>
<parameter><name>maxWait</name><value>3000</value></parameter>
> > > > </ResourceParams>
> > > >
> > > > --- Sutra Zhou <[EMAIL PROTECTED]> wrote:
> > > >
> > > > > Have you setted the jndi?
> > > > >
> > > > > 2007/3/24, Dmitriy <[EMAIL PROTECTED]>:
> > > > > >
> > > > > > I am doing war. My ISP asked to use war. I
> > > have
> > > > > > redeployed and now get this error:
> > > > > >
> > > > > > INFO 2007-03-23 03:39:16,240
> > > > > > NamingHelper:getInitialContext - JNDI
> > > > > InitialContext
> > > > > > properties:{}
> > > > > > INFO 2007-03-23 03:39:16,242
> > > > > > DatasourceConnectionProvider:configure -
> Using
> > > > > > datasource: java:comp/
> > > > > > env/jdbc/rollerdb
> > > > > > WARN 2007-03-23 03:39:16,247
> > > > > > SettingsFactory:buildSettings - Could not
> > > obtain
> > > > > > connection metadata
> > > > > >
> org.apache.commons.dbcp.SQLNestedException:
> > > Cannot
> > > > > > create JDBC driver of class '' for connect
> URL
> > > '
> > > > > > null'
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.apache.commons.dbcp.BasicDataSource.createDataSource(
> > > > > > BasicDataSource.java:780)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java
> > > > > > :540)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.hibernate.connection.DatasourceConnectionProvider.getConnection
> > > > > > (DatasourceConnection
> > > > > > Provider.java:69)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java
> > > > > > :1289)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.apache.roller.business.hibernate.HibernatePersistenceStrategy
> > > > > > .<init>(HibernatePersis
> > > > > > tenceStrategy.java:65)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >
> >
>
org.apache.roller.business.hibernate.HibernateRollerImpl.<init>(
> > > > > > HibernateRollerImpl.java
> > > > > > :70)
> > > > > >
> > > > > > Again, that same war and config file
> pointing
> > > to
> > > > > the
> > > > > > same db works on my pc.
> > > > > >
> > > > > > Please let me know if this rings any bell.
> > > > > > Thanks
> > > > > >
> > > > > > --- Anil Gangolli <[EMAIL PROTECTED]>
> wrote:
> > > > > >
> > > > > > >
> > > > > > > This might happen if the you're trying
> to
> > > run
> > > > > Roller
>
=== message truncated ===
____________________________________________________________________________________
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.
http://games.yahoo.com/games/front
