Pool Size and SQLServer License
raj_skromis Feb 25, 2002 6:57 AMHello,
My problem is something like this.
In design part I am having one JSP(client to Session Bean),one Session and one EntityBean.
I have given the MaxSize in the Pool(Connection) is 1 and MinSize=0.
I have set the SQLServer License to 2.
Now if after running the JBoss I start to use the Application with 2 users concurrently then
it gives me "Pool is full". Now I know that this is very much expected behaviour as the MaxSize is set to 1.
Now when this is happening I want to give the second USER a meaningfule message for eg. say "Server is Busy..".But I am facing a problem to do this.I could see the message that the Entity BEan is throwing the user defined FinderException "Server Busy"..but I am not getting it inside my Session Bean so that I can indicate the JSP to give the Porper message.Could anyone give any idea how to do this.
I am also giving the detail of Exception as well as configuration:
Server: Windows2000 Server
Database: MSSQL 7.0
Driver: ConnectJDBC2.1
Pool Name: LearningmateDS
Entity Bean: CourseInfoEJB
Also I want to know what is the Maximum value I can give to PoolSize with 5 user SQLServer License
Error:
Inside Entity Bean Method
Before DataBase Connection
mateDS] Pool LearningmateDS is full (1/1)!
mateDS] Pool LearningmateDS [1/1/1] couldn't find an object to return!
caught Exception that UserName & SchoolID is not validjavax.ejb.Finder
: java.lang.NullPointerException
[Default] !!!!ERROR!!!!....java.lang.NullPointerException
[Default] Error null in CourseInfo..
[EntitySynchronizationInterceptor] Store failed
java.rmi.RemoteException: Server Busy
at lmate.EJB.Entity.CourseInfoEJB.ejbStore(CourseInfoEJB.java:264)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.plugins.BMPPersistenceManager.storeEntity(BMPPersistenc
eManager.java:347)
at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:252)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchr
onization.beforeCompletion(EntitySynchronizationInterceptor.java:400)
at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1210)
at org.jboss.tm.TxCapsule.commit(TxCapsule.java:304)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
torCMT.java:364)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:9
9)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContaine
r.java:341)
at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPCon
tainerInvoker.java:395)
at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPCon
tainerInvoker.java:476)
at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(Ge
nericProxy.java:335)
at org.jboss.ejb.plugins.jrmp.interfaces.StatefulSessionProxy.invoke(Sta
tefulSessionProxy.java:136)
at $Proxy55.getCourseDetails(Unknown Source)
at lmate.Util.NavigatorHandler.getCourseDetails(NavigatorHandler.java:96
)
at _0002fContent_0002ejspContent_jsp_0._jspService(_0002fContent_0002ejs
pContent_jsp_0.java:416)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspSer
vlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer
vlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:4
29)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:4
05)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372
)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.
java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758
)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnectio
n(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
416)