[JBoss JIRA] Created: (JBPORTAL-1211) portal load test: optimize DB query
by Prabhat Jha (JIRA)
portal load test: optimize DB query
-----------------------------------
Key: JBPORTAL-1211
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1211
Project: JBoss Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Portal Core
Affects Versions: 2.4.1 SP1
Reporter: Prabhat Jha
Assigned To: Julien Viet
During portal load test, we found some bottlenecks related to call to DB. At 500 simultaneous user thread, we start seeing org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout with min pool size of 20 and max pool size of 40. I am not sure but the following query which does join of 6 tables probably also needs to be optimized
select portalobje0_.PK as PK20_0_, portalobje0_.LISTENER as LISTENER20_0_, portalobje0_4_.INSTANCE_REF as INSTANCE2_27_0_, case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2 when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when portalobje0_.PK is not null then 0 end as clazz_0_, declaredpr1_.OBJECT_KEY as OBJECT1_2_, declaredpr1_.jbp_VALUE as jbp2_2_, declaredpr1_.NAME as NAME2_, modes2_.PK as PK3_, modes2_.name as name3_, windowstat3_.PK as PK4_, windowstat3_.name as name4_ from JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on portalobje0_.PK=portalobje0_4_.PK left outer join JBP_PORTAL_OBJECT_PROPS declaredpr1_ on portalobje0_.PK=declaredpr1_.OBJECT_KEY left outer join JBP_PORTAL_MODE modes2_ on portalobje0_.PK=modes2_.PK left outer join JBP_PORTAL_WINDOW_STATE windowstat3_ on portalobje0_.PK=windowstat3_.PK where portalobje0_.PK=?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
18 years, 10 months
[JBoss JIRA] Created: (JBPORTAL-1328) Management Portlet, unable to create Window for page.
by Anders Andersen (JIRA)
Management Portlet, unable to create Window for page.
-----------------------------------------------------
Key: JBPORTAL-1328
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1328
Project: JBoss Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Portal Portlet
Affects Versions: 2.6.Beta1
Environment: OS: Mac OSX 10.4.9
Browser: Firefox 2.0.0.3 or Safari
Database: both Mysql5 and hsqldb
Reporter: Anders Andersen
Assigned To: Julien Viet
Priority: Critical
It is not possible any longer to add a window to a page. There is no data entry field any longer.
The documentation describes a Management Portlet able to add windows to a page by selecting an instance.
Unless I have misunderstood the portal this seems to be a fatal error in the portal.
In all previous versions it was possible to relate an instance to a page by creating a window.
It is still possible to remove a window, but as stated not possible to add a window :-)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
18 years, 10 months
[JBoss JIRA] Created: (JBPORTAL-1110) Portlet Deployment Directory only allows deploy
by symmetrysolutions (JIRA)
Portlet Deployment Directory only allows deploy
-----------------------------------------------
Key: JBPORTAL-1110
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1110
Project: JBoss Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Portal Server
Affects Versions: 2.4 Final
Environment: Windows XP SP1, JBoss v4.0.5.GA, Java 1.5
Reporter: symmetrysolutions
Assigned To: Julien Viet
When the portlet is not deployed from the JBoss Home/server/default/deploy directory the portlet will not deploy. The following error is produced:
2006-11-10 08:59:55,937 ERROR [org.apache.catalina.core.StandardContext] Error starting static Resources
java.lang.IllegalArgumentException: Document base C:\jboss-4.0.5.GA\server\default\.\deploy_40\helloworldjsf.war does not exist or is not a readable directory
at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:140)
at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:3848)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4019)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
The portlet is not being deployed from C:\jboss-4.0.5.GA\server\default\.\deploy_40 it is actually in C:\deploy_40 but the portal seems to assume the deployment is from the jboss server deploy directory.
I always modify my deploy URL in my JBoss service to allow deployments from another directory. The portal itself is actually in this directory and is deploying correctly allong with all of its default portals but my portlet will not deploy unless I put it in the C:\jboss-4.0.5.GA\server\default\deploy directory.
The portlet I am using is the default JSF Hello World portlet. I have not tried with other portlets.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
18 years, 10 months