I began by taking a stock 4.0.1 install, and then I converted the SQL script to
insert the correct data into HSQL. Here's what I get when I try to run the
portal...
2005-01-22 01:48:31,723 ERROR [org.jboss.web.localhost.Engine]
StandardWrapperValve[PortletServlet]: Servlet.service() for servlet
PortletServlet threw exception
org.jboss.portal.common.transaction.BusinessException:
java.lang.NullPointerException
at
org.jboss.portal.common.transaction.Demarcator.requiresNew(Demarcator.java:58)
at
org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:74)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:552)
Caused by: java.lang.NullPointerException
at
org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:50)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.jboss.portal.core.servlet.TransactionFilter$1.run(TransactionFilter.java:78)
at
org.jboss.portal.common.transaction.Demarcator.requiresNew(Demarcator.java:52)
... 36 more
Here's the converted HSQL script, if you find it useful....
drop table jbp_forums_watch if exists;
drop table jbp_forums_polls if exists;
drop table jbp_forums_topics if exists;
drop table jbp_forums_forums if exists;
drop table jbp_forums_categories if exists;
drop table jbp_forums_users if exists;
drop table jbp_forums_posts if exists;
drop table jbp_user_pref_prop_value if exists;
drop table jbp_user_pref if exists;
drop table jbp_role_membership if exists;
drop table jbp_roles if exists;
drop table jbp_user_prop if exists;
drop table jbp_users if exists;
drop table jbp_user_pref_set if exists;
create table jbp_user_pref_set (
jbp_id IDENTITY,
name VARCHAR(255) not null,
jbp_parent_id INTEGER,
foreign key (jbp_parent_id) references jbp_user_pref_set (jbp_id)
);
create table jbp_users (
jbp_uid IDENTITY,
jbp_root_pref_set_id INTEGER,
jbp_uname VARCHAR(255),
jbp_givenname VARCHAR(255),
jbp_familyname VARCHAR(255),
jbp_password VARCHAR(255),
jbp_realemail VARCHAR(255),
jbp_fakeemail VARCHAR(255),
jbp_regdate DATETIME,
jbp_viewrealemail BIT,
jbp_enabled BIT,
UNIQUE (jbp_uname),
foreign key (jbp_root_pref_set_id) references jbp_user_pref_set (jbp_id)
);
create table jbp_user_prop (
jbp_uid INTEGER not null,
jbp_value VARCHAR(255),
jbp_name VARCHAR(255) not null,
primary key (jbp_uid, jbp_name),
foreign key (jbp_uid) references jbp_users (jbp_uid)
);
create table jbp_roles (
jbp_rid IDENTITY,
jbp_name VARCHAR(255),
jbp_displayname VARCHAR(255),
UNIQUE (jbp_displayname),
UNIQUE (jbp_name)
);
create table jbp_role_membership (
jbp_rid INTEGER not null,
jbp_uid INTEGER not null,
primary key (jbp_uid, jbp_rid),
foreign key (jbp_rid) references jbp_roles (jbp_rid)
);
create table jbp_user_pref (
jbp_id IDENTITY,
jbp_name VARCHAR(255) not null,
jbp_type INTEGER,
jbp_set_id INTEGER,
foreign key (jbp_set_id) references jbp_user_pref_set (jbp_id)
);
create table jbp_user_pref_prop_value (
jbp_prop_id INTEGER not null,
jbp_value VARCHAR(255),
jbp_idx INTEGER not null,
primary key (jbp_prop_id, jbp_idx),
foreign key (jbp_prop_id) references jbp_user_pref (jbp_id)
);
create table jbp_forums_posts (
jbp_id IDENTITY,
jbp_topic_id INTEGER,
jbp_edit_count INTEGER,
jbp_edit_date DATETIME,
jbp_create_date DATETIME,
jbp_subject VARCHAR(255),
jbp_text VARCHAR(255),
jbp_poster INTEGER
);
create table jbp_forums_users (
jbp_id IDENTITY,
jbp_username VARCHAR(255),
jbp_nb_posts INTEGER
);
create table jbp_forums_categories (
jbp_id IDENTITY,
jbp_order INTEGER,
jbp_title VARCHAR(255)
);
create table jbp_forums_forums (
jbp_id IDENTITY,
jbp_category_id INTEGER,
jbp_description VARCHAR(255),
jbp_last_post_id INTEGER,
jbp_name VARCHAR(255),
jbp_order INTEGER,
jbp_topic_size INTEGER,
jbp_post_size INTEGER,
jbp_prune_enable BIT,
jbp_prune_next INTEGER,
jbp_status INTEGER,
jbp_type INTEGER,
foreign key (jbp_last_post_id) references jbp_forums_posts (jbp_id),
foreign key (jbp_category_id) references jbp_forums_categories (jbp_id)
);
create table jbp_forums_topics (
jbp_id IDENTITY,
jbp_forum_id INTEGER,
jbp_views INTEGER,
jbp_replies INTEGER,
jbp_first_post_id INTEGER,
jbp_last_post_id INTEGER,
jbp_last_post_date DATETIME,
jbp_poster INTEGER,
jbp_type INTEGER,
jbp_status INTEGER,
jbp_subject VARCHAR(255),
foreign key (jbp_last_post_id) references jbp_forums_posts (jbp_id),
foreign key (jbp_first_post_id) references jbp_forums_posts (jbp_id),
foreign key (jbp_poster) references jbp_forums_users (jbp_id),
foreign key (jbp_forum_id) references jbp_forums_forums (jbp_id)
);
create table jbp_forums_watch (
jbp_id IDENTITY,
jbp_forum_id INTEGER,
jbp_mode INTEGER,
jbp_user_id INTEGER,
foreign key (jbp_forum_id) references jbp_forums_forums (jbp_id),
foreign key (jbp_user_id) references jbp_forums_users (jbp_id)
);
create table jbp_forums_polls (
jbp_id IDENTITY
);
insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail,
jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('1', 'admin',
'21232f297a57a5a743894a0e4a801fc3', '[EMAIL PROTECTED]', NOW(), '1', '1');
insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail,
jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('2', 'user',
'ee11cbb19052e40b07aac0ca060c23ee', '[EMAIL PROTECTED]', NOW(), '1', '1');
insert into jbp_roles values ('1', 'Admins', 'Administrators');
insert into jbp_roles values ('2', 'Users', 'Users');
insert into jbp_role_membership values ('1', '1');
insert into jbp_role_membership values ('2', '2');
insert into jbp_forums_categories values ('1', '1', 'Dummy demo category');
insert into jbp_forums_forums values ('1', '1', 'First description', null,
'First forum', '10', '0', '0', '1', '0', '0', '0');
insert into jbp_forums_forums values ('2', '1', 'Second description', null,
'Second forum', '20', '0', '0', '1', '0', '0', '0');
Let me know if you know what's going on. If you can make available a script
that works with HSQL (perhaps based on the one I provided), that would be
excellent.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3863212#3863212
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3863212
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
