MS SQL with Jboss-portal-2.6-BETA1| JBoss.org Content Archive (Read Only)

1. Re: MS SQL with Jboss-portal-2.6-BETA1

prabhat.jha Apr 17, 2007 2:39 PM (in response to glarenzie)

I am not sure if you cut and pasted it worng but your ds.xml does not look right. Also, please send the error from server log.

2. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 2:48 PM (in response to glarenzie)

I restarted and now I get the log in screen. I log in as admin and I get the following error:
14:45:25,798 ERROR [PortalServlet] Unexpected exception
java.lang.NullPointerException
at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashb
oard(CustomizationManagerService.java:257)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
er.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
or.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
BeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy116.getDashboard(Unknown Source)
at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
jectDashboardNav(PageCustomizerInterceptor.java:191)
at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
voke(PageCustomizerInterceptor.java:127)
at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
lerInterceptor.java:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor
.invoke(PolicyEnforcementInterceptor.java:68)
at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
lerInterceptor.java:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.i
nvoke(PortalNodeInterceptor.java:54)
at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
lerInterceptor.java:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
157)
at org.jboss.portal.core.controller.ControllerContext.execute(Controller
Context.java:86)
at org.jboss.portal.core.controller.classic.ClassicController.handle(Cla
ssicController.java:88)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
er.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
or.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
BeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.ja
va:287)
at $Proxy230.handle(Unknown Source)
at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestCon
trollerDispatcher.java:51)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:131)
at org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(Id
entityBindingInterceptor.java:46)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(
ContentTypeInterceptor.java:67)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleI
nterceptor.java:108)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInter
ceptor.java:188)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.
invoke(SessionInvalidatorInterceptor.java:85)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss
$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterce
ptor.java:49)
at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
.java)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.j
ava:262)
at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
.java)
at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(Tr
ansactionInterceptor.java)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
157)
at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.j
ava:381)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
ctionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
kerThread.java:112)
at java.lang.Thread.run(Thread.java:534)
14:45:25,845 ERROR [[PortalServletWithPathMapping]] Servlet.service() for servle
t PortalServletWithPathMapping threw exception
java.lang.NullPointerException
at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashb
oard(CustomizationManagerService.java:257)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
er.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
or.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
BeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy116.getDashboard(Unknown Source)
at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
jectDashboardNav(PageCustomizerInterceptor.java:191)
at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
voke(PageCustomizerInterceptor.java:127)
at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
lerInterceptor.java:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor
.invoke(PolicyEnforcementInterceptor.java:68)
at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
lerInterceptor.java:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.i
nvoke(PortalNodeInterceptor.java:54)
at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
lerInterceptor.java:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
157)
at org.jboss.portal.core.controller.ControllerContext.execute(Controller
Context.java:86)
at org.jboss.portal.core.controller.classic.ClassicController.handle(Cla
ssicController.java:88)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
er.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
or.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
BeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.ja
va:287)
at $Proxy230.handle(Unknown Source)
at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestCon
trollerDispatcher.java:51)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:131)
at org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(Id
entityBindingInterceptor.java:46)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(
ContentTypeInterceptor.java:67)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleI
nterceptor.java:108)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInter
ceptor.java:188)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.
invoke(SessionInvalidatorInterceptor.java:85)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss
$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterce
ptor.java:49)
at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
.java)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.j
ava:262)
at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
.java)
at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(Tr
ansactionInterceptor.java)
at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
va:38)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
ava:115)
at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
157)
at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.j
ava:381)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
ctionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
kerThread.java:112)
at java.lang.Thread.run(Thread.java:534)

3. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 2:54 PM (in response to glarenzie)

I restarted and got no errors during startup, however when I go to the localhost:8080/portal I get the following:
java.lang.IllegalStateException: Default portal does not exist
org.jboss.portal.core.model.portal.DefaultPortalCommandFactory.doMapping(DefaultPortalCommandFactory.java:74)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
$Proxy110.doMapping(Unknown Source)
org.jboss.portal.core.controller.classic.ClassicController.handle(ClassicController.java:69)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:287)
$Proxy229.handle(Unknown Source)
org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(IdentityBindingInterceptor.java:46)
org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:67)
org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:108)
org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:188)
org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:85)
org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:381)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

4. Re: MS SQL with Jboss-portal-2.6-BETA1

prabhat.jha Apr 17, 2007 2:59 PM (in response to glarenzie)

I had tested 2.6 beta1 with mysql8 and dont remember seeing any problem. Are you using the DB instance from older portal installation? If you have not tried that already, I would suggest dropping the database and recreating it again and see if that solves the problem. Also don't forget to clean up server/default/data folder as well.

5. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 3:02 PM (in response to glarenzie)

What does this mean? clean up server/default/data folder

6. Re: MS SQL with Jboss-portal-2.6-BETA1

prabhat.jha Apr 17, 2007 3:08 PM (in response to glarenzie)

The data folder is in $JBOSS_INSTALL_DIR/server/default. Please delete data, work and tmp folders.

7. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 3:20 PM (in response to glarenzie)

Also, this is MS SQL sever 2000

8. Re: MS SQL with Jboss-portal-2.6-BETA1

prabhat.jha Apr 17, 2007 3:25 PM (in response to glarenzie)

My bad, I read MSSQL as MYSql. We run our testssuite with MS Sqlserver 2005 and use corresponding hibernate dialect. We have not run testsuite with SQL Server 2000 in a while. But I dont think it would be of much difference.

9. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 3:41 PM (in response to glarenzie)

can you post or email your ds files. I have been developing on alpha with hypersonic, however I will need this to be working with MSSQL and Oracle soon. We had Mr. Russo on site (McKesson) a couple months ago so he is familiar with what we are trying to accomplish.

10. Re: MS SQL with Jboss-portal-2.6-BETA1

prabhat.jha Apr 17, 2007 3:59 PM (in response to glarenzie)

<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://host:port/portal</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>portal</user-name>
your_password
</local-tx-datasource>

11. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 4:12 PM (in response to glarenzie)

This is a list of tables built and populated, are they all there?
jbp_cms_cmsentry
jbp_cms_perm
jbp_cms_perm_criteria
jbp_cms_perm_role
jbp_cms_perm_user
jbp_cms_repositoryentry
jbp_cms_version_binval
jbp_cms_version_node
jbp_cms_version_prop
jbp_cms_version_refs
jbp_cms_versionentry
jbp_cms_wsp_binval
jbp_cms_wsp_node
jbp_cms_wsp_prop
jbp_cms_wsp_refs
JBP_CONTEXT
JBP_INSTANCE
JBP_INSTANCE_PER_USER
JBP_INSTANCE_SECURITY
JBP_INSTANCE_SECURITY_ACTIONS
JBP_OBJECT_NODE
JBP_OBJECT_NODE_SEC
JBP_OBJECT_NODE_SEC_ACTIONS
JBP_PAGE
JBP_PORTAL
JBP_PORTAL_MODE
JBP_PORTAL_OBJECT
JBP_PORTAL_OBJECT_PROPS
JBP_PORTAL_WINDOW_STATE
JBP_PORTLET_CONSUMER
JBP_PORTLET_GROUP
JBP_PORTLET_REGISTRATION
JBP_PORTLET_STATE
JBP_PORTLET_STATE_ENTRY
JBP_PORTLET_STATE_ENTRY_VALUE
jbp_role_membership
jbp_roles
jbp_user_prop
jbp_users
JBP_WINDOW
JBPM_ACTION
JBPM_BYTEARRAY
JBPM_BYTEBLOCK
JBPM_COMMENT
JBPM_DECISIONCONDITIONS
JBPM_DELEGATION
JBPM_EVENT
JBPM_EXCEPTIONHANDLER
JBPM_ID_GROUP
JBPM_ID_MEMBERSHIP
JBPM_ID_PERMISSIONS
JBPM_ID_USER
JBPM_LOG
JBPM_MESSAGE
JBPM_MODULEDEFINITION
JBPM_MODULEINSTANCE
JBPM_NODE
JBPM_POOLEDACTOR
JBPM_PROCESSDEFINITION
JBPM_PROCESSINSTANCE
JBPM_RUNTIMEACTION
JBPM_SWIMLANE
JBPM_SWIMLANEINSTANCE
JBPM_TASK
JBPM_TASKACTORPOOL
JBPM_TASKCONTROLLER
JBPM_TASKINSTANCE
JBPM_TIMER
JBPM_TOKEN
JBPM_TOKENVARIABLEMAP
JBPM_TRANSITION
JBPM_VARIABLEACCESS
JBPM_VARIABLEINSTANCE

12. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 4:16 PM (in response to glarenzie)

These are the table built and populated. Are they all there?
jbp_cms_cmsentry
jbp_cms_perm
jbp_cms_perm_criteria
jbp_cms_perm_role
jbp_cms_perm_user
jbp_cms_repositoryentry
jbp_cms_version_binval
jbp_cms_version_node
jbp_cms_version_prop
jbp_cms_version_refs
jbp_cms_versionentry
jbp_cms_wsp_binval
jbp_cms_wsp_node
jbp_cms_wsp_prop
jbp_cms_wsp_refs
JBP_CONTEXT
JBP_INSTANCE
JBP_INSTANCE_PER_USER
JBP_INSTANCE_SECURITY
JBP_INSTANCE_SECURITY_ACTIONS
JBP_OBJECT_NODE
JBP_OBJECT_NODE_SEC
JBP_OBJECT_NODE_SEC_ACTIONS
JBP_PAGE
JBP_PORTAL
JBP_PORTAL_MODE
JBP_PORTAL_OBJECT
JBP_PORTAL_OBJECT_PROPS
JBP_PORTAL_WINDOW_STATE
JBP_PORTLET_CONSUMER
JBP_PORTLET_GROUP
JBP_PORTLET_REGISTRATION
JBP_PORTLET_STATE
JBP_PORTLET_STATE_ENTRY
JBP_PORTLET_STATE_ENTRY_VALUE
jbp_role_membership
jbp_roles
jbp_user_prop
jbp_users
JBP_WINDOW
JBPM_ACTION
JBPM_BYTEARRAY
JBPM_BYTEBLOCK
JBPM_COMMENT
JBPM_DECISIONCONDITIONS
JBPM_DELEGATION
JBPM_EVENT
JBPM_EXCEPTIONHANDLER
JBPM_ID_GROUP
JBPM_ID_MEMBERSHIP
JBPM_ID_PERMISSIONS
JBPM_ID_USER
JBPM_LOG
JBPM_MESSAGE
JBPM_MODULEDEFINITION
JBPM_MODULEINSTANCE
JBPM_NODE
JBPM_POOLEDACTOR
JBPM_PROCESSDEFINITION
JBPM_PROCESSINSTANCE
JBPM_RUNTIMEACTION
JBPM_SWIMLANE
JBPM_SWIMLANEINSTANCE
JBPM_TASK
JBPM_TASKACTORPOOL
JBPM_TASKCONTROLLER
JBPM_TASKINSTANCE
JBPM_TIMER
JBPM_TOKEN
JBPM_TOKENVARIABLEMAP
JBPM_TRANSITION
JBPM_VARIABLEACCESS
JBPM_VARIABLEINSTANCE

13. Re: MS SQL with Jboss-portal-2.6-BETA1

glarenzie Apr 17, 2007 4:49 PM (in response to glarenzie)

I switched to a different driver and it seems to work fine.

<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:inetdae7:localhost:1433?database=jbossportal</connection-url>
<driver-class>com.inet.tds.TdsDriver</driver-class>
<user-name>portal</user-name>
portal
</local-tx-datasource>

14. Re: MS SQL with Jboss-portal-2.6-BETA1

prabhat.jha Apr 17, 2007 4:57 PM (in response to glarenzie)

I am glad it's working.