Hi Frank,

To determine which statement is causing this error you could turn on OJB 
logging:

- enable Commons Logging in jetspeed/WEB-INF/classes/OJB-logging.properties 
like this:

  # Commons-logging
  LoggerClass=org.apache.ojb.broker.util.logging.CommonsLoggerImpl
  # log4j based logging
  #LoggerClass=org.apache.ojb.broker.util.logging.Log4jLoggerImpl
  # OJB's own simple looging support
  #LoggerClass=org.apache.ojb.broker.util.logging.PoorMansLoggerImpl
  #LoggerConfigFile=log4j.properties

- configure specific OJB logging in jetspeed/WEB-INF/conf/Log4j.properties by 
adding something like this:

  log4j.category.org.apache.ojb.broker.accesslayer.JdbcAccessImpl=DEBUG,ojb
  log4j.additivity.org.apache.ojb.broker.accesslayer.JdbcAccessImpl=false
  
log4j.category.org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl=DEBUG,ojb
  
log4j.additivity.org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl=false

That will log all generated SQL and jdbc calls by OJB to jetspeed/logs/ojb.log
(make sure to have the log4j.appender.ojb configured as well as is provided by 
default with Jetspeed)

Ate

Frank Otto wrote:
thanks, that works.

But now, I have another error by deploying j2-admin:

Completing transaction for [org.apache.jetspeed.components.portletregistry.PortletRegistry.registerPortletApplication] after exception: org.apache.jetspeed.components.portletregistry.PortletRegistry.registerPortletApplication org.springframework.jdbc.UncategorizedSQLException: OJB operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; 00324 EXE IBV Invalid program bind variable; nested exception is java.sql.SQLException: 00324 EXE IBV Invalid program bind variable


I think, there is a problem with column data types on sqlbase database. Which tables where used on register a portlet?



David Sean Taylor schrieb:

On Feb 4, 2009, at 6:31 AM, Frank Otto wrote:

Thanks for the hint. But how can I disable the statistic component? I don't need it.

In the trunk, there are properties. This will turn it off in override.properties:

portal.statistics.logToLogger = false
portal.statistics.logToDatabase = false

as well as audit logging:

portal.audit.enable = false

For version 2.1.3:

edit the WEB-INF/assembly/statistics.xml:

change constructor arg 1 for Portal Statistics to false:

<constructor-arg index='1' type="boolean"><value>false</value></constructor-arg>



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]




---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to