Re: Installation issues : Cannot create JDBC driver of class '' f or connect URL 'null'

Anil Gangolli Thu, 26 Apr 2007 08:37:28 -0700

With that server.xml setup (if it works at all, I haven't reviewed it thatcarefully), I think you would get an extra autodeployment in the enginelooking at conf/Catalina/localhost and finding no roller.xml; you might justbe seeing that. If you want to run that way, you should put the rollerwebapp outside your appbase and refer to it with an absolute path in theroller.xml, or separate the two appbase dirs for the engines. I'drecommend that you try a simpler standalone setup following the installationguide as closely as possible with the standard server.xml configurationfirst, then add more complexity once you have that working.

Also, from earlier messages, you really shouldn't put all of the requiredjars in the common/lib; all but the jdbc, mail and activation jars shouldbe in the webapp's own WEB-INF/lib

----- Original Message -----From: "mohamed felfel" <[EMAIL PROTECTED]>

To: <[email protected]>
Sent: Wednesday, April 25, 2007 7:55 AM

Subject: Re: Installation issues : Cannot create JDBC driver of class '' for connect URL 'null'

Any input on the issue guys? i'm still having a rough time with it.

On 4/24/07, mohamed felfel <[EMAIL PROTECTED]> wrote:


We have reffered to the roller installation wiki, i believe quetion #12,
the one that addresses
       Cannot create JDBC driver of class '' for connect URL 'null'
and it was'nt of much help unfourtounatly.

ALSO:

I know that roller can only connect to a DB vai TCP, and we're good this
way.

$ netstat -an | grep 3306
tcp        0      0 127.0.0.1:3306              0.0.0.0:*
LISTEN



On 4/24/07, mohamed felfel <[EMAIL PROTECTED]> wrote:
>
> Hello guys, i'm new to J2EE applications. So i will appreciate any help
> i can get. I'm having issues installing roller. Here is my log as i

> stop/start tomcat. And after that, i have outlined all steps which i> did to

> install it.
>
> ========================================================================
> $ sudo ./doit.sh
> Using CATALINA_BASE:   /usr/java/tomcat-5.5
> Using CATALINA_HOME:   /usr/java/tomcat-5.5
> Using CATALINA_TMPDIR: /usr/java/tomcat- 5.5/temp
> Using JRE_HOME:       /usr/java/jdk/jre
> Using CATALINA_BASE:   /usr/java/tomcat-5.5
> Using CATALINA_HOME:   /usr/java/tomcat-5.5
> Using CATALINA_TMPDIR: /usr/java/tomcat-5.5/temp
> Using JRE_HOME:       /usr/java/jdk/jre
> WARN  2007-04-24 11:09:34,933 RollerContext:upgradeDatabaseIfNeeded -
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
> driver of class '' f or connect URL 'null'
> ERROR 2007-04-24 11:09:35,386 RollerFactory:getRoller - Error
> instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
> ERROR 2007-04-24 11:09:35,450 RollerFactory:getRoller - Error
> instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
> ERROR 2007-04-24 11:09:35,467 StandardContext:filterStart - Exception
> starting filter securityFilter
> ERROR 2007-04-24 11:09:35,646 RollerFactory:getRoller - Error
> instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
> ERROR 2007-04-24 11:09:35,648 StandardContext:listenerStop - Exception
> sending context destroyed event to listener instance of class
> org.apache.roller.ui.cor e.RollerContext
> WARN  2007-04-24 11:09:36,228 RollerContext:upgradeDatabaseIfNeeded -
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
> driver of class '' f or connect URL 'null'
> ERROR 2007-04-24 11:09:36,350 RollerFactory:getRoller - Error
> instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
> ERROR 2007-04-24 11:09:36,364 RollerFactory:getRoller - Error
> instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
> ERROR 2007-04-24 11:09:36,377 StandardContext:filterStart - Exception
> starting filter securityFilter
> ERROR 2007-04-24 11:09:36,423 RollerFactory:getRoller - Error
> instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
> ERROR 2007-04-24 11:09:36,426 StandardContext:listenerStop - Exception
> sending context destroyed event to listener instance of class
> org.apache.roller.ui.cor e.RollerContext
> ========================================================================
>
>
> Where doit.sh is my restart/tail roller.log file script.
>
> Now, here is how i installed roller, I have
> 1: Downloaded the latest roller 3.1.
> 2: Created my database as well as the schema.
> 3: Coppied the appropriate jars to common/lin, (see below).
> 4: Created roller-custom.properties (see below), and created the
> uploads, seach-index dirs.
> 5: Roller.xml (check it out below)
> 6: Edited hibernate.cfg.xml, i know you dont need to do that!, but
> before and after editing this yeild to the same error. (See below).
> 7: Edited security.xml accordingly.
> 8: Placed web.xml in WEB-INF/web.xml
> 9: added the appropriate <service> to server.xml (see below), <--- not
> too confident about
>
>
> $ ls common/lib/
> activation.jar    commons-el.jar   jasper-compiler.jar      jsp-api.jar
> mysql-connector-java-3.0.17-ga-bin.jar  readme.txt
> asm-attrs.jar    dom4j-1.6.1.jar  jasper-compiler-jdt.jar  jta.jar
> naming-factory-dbcp.jar                 servlet-api.jar
> asm.jar          ehcache-1.1.jar  jasper-runtime.jar
> jta-spec1_0_1.jar  naming-factory.jar
> cglib-2.1.3.jar  hibernate3.jar   jdbc2_0-stdext.jar       mail.jar
> naming-resources.jar
>
> $ cat common/classes/roller-custom.properties
> # this is how you might do it for tomcat
> JAVA_OPTS="-
> 
Droller.custom.config=/usr/java/tomcat-5.5/common/classes/roller-custom.properties
> "
> export $JAVA_OPTS
> $TOMCAT_HOME/bin/startup.sh
> uploads.dir=$ROLLER/roller-files/uploads
> search.index.dir=$ROLLER/roller-files/search-index
> passwds.encryption.enabled=true
>
> $ cat conf/Catalina/EXAMPLE.COM/roller.xml
> <?xml version=" 1.0" encoding="UTF-8"?>
> <Context
>         path="/roller"
>         docBase="roller"
>         debug="1"
>         workdir="/usr/java/tomcat-5.5/webapps/roller">
>   <Resource
>         name="jdbc/rollerdb"
>         auth="Container"
>         type="javax.sql.DataSource"
>         driverClassName="com.mysql.jdbc.Driver"
> 
url="jdbc:mysql://localhost:3306/ROLLERDB?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"
>
>         username="ROLLERUSERNAME"
>         password="ROLLERPASSWORD"
>         maxActive="20"
>         maxIdle="3"
>         removeAbandoned="true"
>         maxWait="3000"
>   />
> </Context>
>
>
> $ cat webapps/roller/WEB-INF/classes/hibernate.cfg.xml
> <?xml version='1.0' encoding='utf-8'?>
> <!DOCTYPE hibernate-configuration PUBLIC
>         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"

>> "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd

> ">
> <hibernate-configuration>
>     <session-factory>
>         <property name="connection.datasource
> ">java:comp/env/jdbc/rollerdb</property>

> <property> name="dialect">org.hibernate.dialect.MySQLDialect</property>

>         <property name="show_sql">false</property>
>         <property name="hibernate.current_session_context_class
> ">thread</property>
>         <property name=" hibernate.cache.provider_class">
> org.hibernate.cache.EhCacheProvider</property>
>         <property name="hibernate.generate_statistics">true</property>
>         <property name=" hibernate.cache.use_structured_entries
> ">true</property>
>         <mapping
> resource="org/apache/roller/pojos/RollerPropertyData.hbm.xml" />
>         <mapping resource="org/apache/roller/pojos/UserData.hbm.xml" />
>         <mapping resource="org/apache/roller/pojos/RoleData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/pojos/RollerConfigData.hbm.xml" />
>         <mapping resource="org/apache/roller/pojos/WebsiteData.hbm.xml"
> />
>         <mapping
> resource="org/apache/roller/pojos/PermissionsData.hbm.xml" />

> <mapping> resource="org/apache/roller/pojos/BookmarkData.hbm.xml"

> />
>         <mapping resource="org/apache/roller/pojos/CommentData.hbm.xml"
> />
>         <mapping resource="org/apache/roller/pojos/FolderAssoc.hbm.xml"
> />
>         <mapping resource="org/apache/roller/pojos/FolderData.hbm.xml"
> />
>         <mapping
> resource="org/apache/roller/pojos/WeblogTemplate.hbm.xml" />
>         <mapping

> resource="org/apache/roller/pojos/PingCategoryRestrictionData.hbm.xml"> />> <mapping> resource="org/apache/roller/pojos/AutoPingData.hbm.xml"

> />
>         <mapping
> resource="org/apache/roller/pojos/PingQueueEntryData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/pojos/PingTargetData.hbm.xml" />
>         <mapping resource="org/apache/roller/pojos/RefererData.hbm.xml"
> />

> <mapping> resource="org/apache/roller/pojos/TaskLockData.hbm.xml"

> />

> <mapping> resource="org/apache/roller/pojos/HitCountData.hbm.xml"

> />
>         <mapping
> resource="org/apache/roller/pojos/WeblogEntryData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/pojos/WeblogEntryTagData.hbm.xml" />
>         <mapping

> resource="org/apache/roller/pojos/WeblogEntryTagAggregateData.hbm.xml"> />

>         <mapping
> resource="org/apache/roller/pojos/EntryAttributeData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/pojos/WeblogCategoryData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/pojos/WeblogCategoryAssoc.hbm.xml" />
>         <mapping
> resource="org/apache/roller/planet/pojos/PlanetConfigData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/planet/pojos/PlanetGroupData.hbm.xml" />
>         <mapping
> resource="org/apache/roller/planet/pojos/PlanetEntryData.hbm.xml" />
>         <mapping

> resource="org/apache/roller/planet/pojos/PlanetSubscriptionData.hbm.xml"> />

>     </session-factory>
> </hibernate-configuration>
>
>
> $ cat conf/server.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <Server>

> <Listener className="org.apache.catalina.core.AprLifecycleListener> "/>

>   <Listener className="
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
>   <Listener className="
> org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>
>   <Listener className="
> org.apache.catalina.mbeans.ServerLifecycleListener"/>
>   <GlobalNamingResources>
>     <Environment
>       name="simpleValue"
>       type="java.lang.Integer "
>       value="30"/>
>     <Resource
>       auth="Container"
>       description="User database that can be updated and saved"
>       name="UserDatabase"
>       type=" org.apache.catalina.UserDatabase"
>       pathname="conf/tomcat-users.xml"
>       factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
>   </GlobalNamingResources>
>   <Service
>       name="Catalina">
>     <Connector
>         port="9080"
>         redirectPort="9443"
>         minSpareThreads="25"
>         connectionTimeout="20000"
>         maxThreads="150"
>         maxSpareThreads="75">
>     </Connector>
>     <Connector
>         port="8009"
>         protocol="AJP/1.3">
>     </Connector>
>     <Engine
>         defaultHost="localhost"
>         name="Catalina">
>       <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
>       <Host
>           appBase="webapps"
>           name="localhost">
>       </Host>
>     </Engine>
>   </Service>
>   <Service
>       name=" EXAMPLE.COM">
>     <Connector
>         enableLookups="true"
>         port="8666"
>         redirectPort="9443"
>         URIEncoding="UTF-8"
>         debug="1"
>         acceptCount="10">
>     </Connector>
>     <Engine
>         defaultHost="EXAMPLE.COM"
>         name=" EXAMPLE.COM">
>       <Realm className=" org.apache.catalina.realm.JAASRealm"
>         appName="gigs.fm"/>
>       <Host
>           appBase="webapps"
>           name=" gigs.fm">
>       </Host>
>     </Engine>
>   </Service>
> </Server>
>
> --
> MoZey
>



--
MoZey





--
MoZey

Re: Installation issues : Cannot create JDBC driver of class '' f or connect URL 'null'

Reply via email to