You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Thomas-W Hofmann <th...@db.com> on 2006/11/28 18:00:06 UTC

Database Problem (Oracle related ?)

Hi, 

One other issue with my corporate  setup.
Fact 1 : Roller is running and working fine !
Fact 2 : During startup I get 700 lines of error messages related to the 
Database Connection :

Fact 3 : Logfile seems to indicate it cannot read Connection Metadata.
Fact 4 : Roller is still running fine and has working Database connection 
???????????????

Running Roller 31.RC1 on Oracle 9.2x

First error :

INFO  2006-11-28 16:43:31,817 HbmBinder:bindCollectionSecondPass - Mapping 
collection: 
org.apache.roller.pojos.PlanetSubscriptionData.groupSubscriptionAssocs -> 
rag_group_subscription
INFO  2006-11-28 16:43:31,819 HbmBinder:bindCollectionSecondPass - Mapping 
collection: org.apache.roller.pojos.PlanetSubscriptionData.entries -> 
rag_entry
INFO  2006-11-28 16:43:31,862 NamingHelper:getInitialContext - JNDI 
InitialContext properties:{}
INFO  2006-11-28 16:43:31,865 DatasourceConnectionProvider:configure - 
Using datasource: java:comp/env/jdbc/rollerdb
WARN  2006-11-28 16:43:31,877 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)
...
Followed by :

INFO  2006-11-28 16:43:31,991 Dialect:<init> - Using dialect: 
org.hibernate.dialect.Oracle9Dialect
INFO  2006-11-28 16:43:32,033 
TransactionFactoryFactory:buildTransactionFactory - Using default 
transaction strategy (direct JDBC transactions)

Second error :
NFO  2006-11-28 16:43:33,769 SessionFactoryObjectFactory:addInstance - Not 
binding factory to JNDI, no JNDI name configured
INFO  2006-11-28 16:43:33,784 RollerFactory:setRoller - Using Roller Impl: 
org.apache.roller.business.hibernate.HibernateRollerImpl
WARN  2006-11-28 16:43:34,003 JDBCExceptionReporter:logExceptions - SQL 
Error: 0, SQLState: null
ERROR 2006-11-28 16:43:34,005 JDBCExceptionReporter:logExceptions - Cannot 
create JDBC driver of class '' for connect URL 'null'
FATAL 2006-11-28 16:43:34,009 HibernatePropertiesManagerImpl:init - Failed 
to initialize runtime configuration properties.Please check that the 
database has been upgraded!
org.apache.roller.RollerException
                 at 
org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(HibernatePropertiesManagerImpl.java:115)
 
.... and 2 more of this kind.


Any idea appreciated

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
Thomas Hofmann




--

Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Antwort: Re: Database Problem (Oracle related ?)

Posted by Thomas-W Hofmann <th...@db.com>.
Anil,

thank you for the hint.

It was caused by the jdbc resource definition in the Roller WEB.XML file - 
I dont think it should be in there.
IMHO the resources should be defined Global and referenced to in the 
CONTEXT.XML file. (at least for Tomcat)

However, thank you again.

Thomas




"Anil Gangolli" <an...@busybuddha.org> 
28/11/2006 18:19
Bitte antworten an
roller-user@incubator.apache.org


An
<ro...@incubator.apache.org>
Kopie

Thema
Re: Database Problem (Oracle related ?) 







You appear to have a duplicate (failing) auto-deployment of the webapp.

See:  http://rollerweblogger.org/wiki/Wiki.jsp?page=TomcatJDBCEmptyNull

You're most likely in the case of the second bullet in the top section.

--a.


----- Original Message ----- 
From: "Thomas-W Hofmann" <th...@db.com>
To: <ro...@incubator.apache.org>
Sent: Tuesday, November 28, 2006 9:00 AM
Subject: Database Problem (Oracle related ?)


> Hi,
>
> One other issue with my corporate  setup.
> Fact 1 : Roller is running and working fine !
> Fact 2 : During startup I get 700 lines of error messages related to the
> Database Connection :
>
> Fact 3 : Logfile seems to indicate it cannot read Connection Metadata.
> Fact 4 : Roller is still running fine and has working Database 
connection
> ???????????????
>
> Running Roller 31.RC1 on Oracle 9.2x
>
> First error :
>
> INFO  2006-11-28 16:43:31,817 HbmBinder:bindCollectionSecondPass - 
Mapping
> collection:
> org.apache.roller.pojos.PlanetSubscriptionData.groupSubscriptionAssocs 
->
> rag_group_subscription
> INFO  2006-11-28 16:43:31,819 HbmBinder:bindCollectionSecondPass - 
Mapping
> collection: org.apache.roller.pojos.PlanetSubscriptionData.entries ->
> rag_entry
> INFO  2006-11-28 16:43:31,862 NamingHelper:getInitialContext - JNDI
> InitialContext properties:{}
> INFO  2006-11-28 16:43:31,865 DatasourceConnectionProvider:configure -
> Using datasource: java:comp/env/jdbc/rollerdb
> WARN  2006-11-28 16:43:31,877 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)
> ...
> Followed by :
>
> INFO  2006-11-28 16:43:31,991 Dialect:<init> - Using dialect:
> org.hibernate.dialect.Oracle9Dialect
> INFO  2006-11-28 16:43:32,033
> TransactionFactoryFactory:buildTransactionFactory - Using default
> transaction strategy (direct JDBC transactions)
>
> Second error :
> NFO  2006-11-28 16:43:33,769 SessionFactoryObjectFactory:addInstance - 
Not
> binding factory to JNDI, no JNDI name configured
> INFO  2006-11-28 16:43:33,784 RollerFactory:setRoller - Using Roller 
Impl:
> org.apache.roller.business.hibernate.HibernateRollerImpl
> WARN  2006-11-28 16:43:34,003 JDBCExceptionReporter:logExceptions - SQL
> Error: 0, SQLState: null
> ERROR 2006-11-28 16:43:34,005 JDBCExceptionReporter:logExceptions - 
Cannot
> create JDBC driver of class '' for connect URL 'null'
> FATAL 2006-11-28 16:43:34,009 HibernatePropertiesManagerImpl:init - 
Failed
> to initialize runtime configuration properties.Please check that the
> database has been upgraded!
> org.apache.roller.RollerException
>                 at
> 
org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(HibernatePropertiesManagerImpl.java:115)
>
> .... and 2 more of this kind.
>
>
> Any idea appreciated
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
> Thomas Hofmann
>
>
>
>
> --
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte 
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese 
E-Mail 
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender 
und 
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte 
> Weitergabe dieser Mail ist nicht gestattet.
>
> This e-mail may contain confidential and/or privileged information. If 
you 
> are not the intended recipient (or have received this e-mail in error) 
> please notify the sender immediately and destroy this e-mail. Any 
> unauthorized copying, disclosure or distribution of the material in this 

> e-mail is strictly forbidden. 






--

Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Re: Database Problem (Oracle related ?)

Posted by Anil Gangolli <an...@busybuddha.org>.
You appear to have a duplicate (failing) auto-deployment of the webapp.

See:  http://rollerweblogger.org/wiki/Wiki.jsp?page=TomcatJDBCEmptyNull

You're most likely in the case of the second bullet in the top section.

--a.


----- Original Message ----- 
From: "Thomas-W Hofmann" <th...@db.com>
To: <ro...@incubator.apache.org>
Sent: Tuesday, November 28, 2006 9:00 AM
Subject: Database Problem (Oracle related ?)


> Hi,
>
> One other issue with my corporate  setup.
> Fact 1 : Roller is running and working fine !
> Fact 2 : During startup I get 700 lines of error messages related to the
> Database Connection :
>
> Fact 3 : Logfile seems to indicate it cannot read Connection Metadata.
> Fact 4 : Roller is still running fine and has working Database connection
> ???????????????
>
> Running Roller 31.RC1 on Oracle 9.2x
>
> First error :
>
> INFO  2006-11-28 16:43:31,817 HbmBinder:bindCollectionSecondPass - Mapping
> collection:
> org.apache.roller.pojos.PlanetSubscriptionData.groupSubscriptionAssocs ->
> rag_group_subscription
> INFO  2006-11-28 16:43:31,819 HbmBinder:bindCollectionSecondPass - Mapping
> collection: org.apache.roller.pojos.PlanetSubscriptionData.entries ->
> rag_entry
> INFO  2006-11-28 16:43:31,862 NamingHelper:getInitialContext - JNDI
> InitialContext properties:{}
> INFO  2006-11-28 16:43:31,865 DatasourceConnectionProvider:configure -
> Using datasource: java:comp/env/jdbc/rollerdb
> WARN  2006-11-28 16:43:31,877 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)
> ...
> Followed by :
>
> INFO  2006-11-28 16:43:31,991 Dialect:<init> - Using dialect:
> org.hibernate.dialect.Oracle9Dialect
> INFO  2006-11-28 16:43:32,033
> TransactionFactoryFactory:buildTransactionFactory - Using default
> transaction strategy (direct JDBC transactions)
>
> Second error :
> NFO  2006-11-28 16:43:33,769 SessionFactoryObjectFactory:addInstance - Not
> binding factory to JNDI, no JNDI name configured
> INFO  2006-11-28 16:43:33,784 RollerFactory:setRoller - Using Roller Impl:
> org.apache.roller.business.hibernate.HibernateRollerImpl
> WARN  2006-11-28 16:43:34,003 JDBCExceptionReporter:logExceptions - SQL
> Error: 0, SQLState: null
> ERROR 2006-11-28 16:43:34,005 JDBCExceptionReporter:logExceptions - Cannot
> create JDBC driver of class '' for connect URL 'null'
> FATAL 2006-11-28 16:43:34,009 HibernatePropertiesManagerImpl:init - Failed
> to initialize runtime configuration properties.Please check that the
> database has been upgraded!
> org.apache.roller.RollerException
>                 at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(HibernatePropertiesManagerImpl.java:115)
>
> .... and 2 more of this kind.
>
>
> Any idea appreciated
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
> Thomas Hofmann
>
>
>
>
> --
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte 
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail 
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und 
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte 
> Weitergabe dieser Mail ist nicht gestattet.
>
> This e-mail may contain confidential and/or privileged information. If you 
> are not the intended recipient (or have received this e-mail in error) 
> please notify the sender immediately and destroy this e-mail. Any 
> unauthorized copying, disclosure or distribution of the material in this 
> e-mail is strictly forbidden.