2 Replies Latest reply on Mar 4, 2002 3:54 AM by Rajarshi

    Pool Size and SQLServer License

    Rajarshi Newbie

      Hello,
      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)