Re: Unknown column 'websitedat2_.handle' in 'field list' error

[Amy Roh]

Hi,

After a few changes, I was able to deploy Roller 2.1 on GlassFish.
To address the TLD error, I did the following :

Change web.xml to use version 2.4 from 2.3.

<web-app xmlns="http://java.sun.com/xml/ns/j2ee";
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
  xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";
  version="2.4">

Change taglibs.jsp to use JSTL1.1 from JSTL 1.0

<%@ taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt"; prefix="fmt" %>

Thanks,
Amy

Dave Johnson wrote:

I'm assuming you're using a recent pre-release build of Roller 2.1 
and  you're doing a fresh install, not an upgrade. So I guess this 
might be  a database configuration error. Which database are you using?

- Dave


On Dec 21, 2005, at 12:58 PM, Amy Roh wrote:

Hi,

I have deployed roller on sun application server and am getting the  
following error.

Anyone seen this?

ERROR 2005-12-20 16:06:22,031 JDBCExceptionReporter:logExceptions -  
Unknown column 'websitedat2_.handle' in 'field list'

FATAL 2005-12-20 16:06:22,046 RollerContext:contextInitialized -  
RollerContext initialization failed

org.roller.RollerException

  at  
org.roller.business.hibernate.HibernatePingTargetManagerImpl.getCommonP 
ingTargets(HibernatePingTargetManagerImpl.java:50)
.......

--- ROOT CAUSE ---

org.hibernate.exception.SQLGrammarException: could not execute query

  at  
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.j 
ava:70)
.............


  at com.sun.enterprise.server.PELaunch.main(PELaunch.java:210)

Caused by: java.sql.SQLException: Unknown column 
'websitedat2_.handle'  in 'field list'

Thanks,
Amy