pool not open error while trying to access DB AEM 6.5 | Community
Skip to main content
bhavya1724
Level 2
Jan 20, 2023 3:15 PM UTC
Solved

pool not open error while trying to access DB AEM 6.5

Hello Everyone,

I am able to connect and do transactions with the JDBC connection pool, but when I am doing manual deployment through the package manager then the issue happens, I am new to AEM and not getting what to do also this is a SPA  project. below is the stack trace can anyone please help me on how to solve this or any other alternative I can use

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SantoshSai
SantoshSaiAccepted solution
New Participant
Jan 20, 2023 5:15 PM UTC

Dear @bhavya1724 ,

I suspect that's configuration issue - something is missing/miss-configured. You need to double check your configurations. Check in OSGI, check on your code every little detail for your database settings. These are the two things to look at. Then try to install the bundle/package again.

Reference: https://experienceleague.adobe.com/docs/experience-manager-64/developing/platform/jdbc.html?lang=en

Hope that helps!

Regards,

Santosh

Santosh Sai
View reply

8 replies

Nitin_laad
Nitin_laad
New Participant
Jan 20, 2023 7:42 PM UTC

Hi @bhavya1724 

some of the steps you can try to troubleshoot the issue 

  1. Can you please verify the contents of the AEM error.log and request.log files to ensure that not getting any errors related to connection pool configuration ?
  2. Additionally, You can restart the bundle after package deployment or 
  3. restart the server after package deployment

if the aforementioned steps does not resolve issue, I will go with @santoshsai's comments and validate the configuration. 

 

Translate
    bhavya1724Author
    Level 2
    Jan 21, 2023 8:07 AM UTC

    Hi @nitin_laad, thank you for your response yes if we restart the server then it is working but every time we cannot restart the server so to avoid that looking for a solution where we can correct it, and there are no errors in the log

    Translate
      ChitraMadan
      ChitraMadan
      New Participant
      Jan 20, 2023 5:50 PM UTC

      Hi @bhavya1724,

       

      Can you please check in your code if you are closing DataSourcePool anywhere, as once closed, it will have to be initialised again, before using it.

      Please share your code and configurations.

      Translate
        bhavya1724Author
        Level 2
        Jan 21, 2023 8:18 AM UTC

        Hi Chitra, Thank you for your response. we are not closing the data source anywhere here are the OSGi and other config

         

        Translate
          Vijayalakshmi_S
          Vijayalakshmi_S
          Level 10
          Jan 22, 2023 11:42 AM UTC

          Hi @bhavya1724 

          Can you share the osgi config as deployed via code (the one you shared is from Felix console)

          Translate
            SantoshSai
            SantoshSaiAccepted solution
            New Participant
            Jan 20, 2023 5:15 PM UTC

            Dear @bhavya1724 ,

            I suspect that's configuration issue - something is missing/miss-configured. You need to double check your configurations. Check in OSGI, check on your code every little detail for your database settings. These are the two things to look at. Then try to install the bundle/package again.

            Reference: https://experienceleague.adobe.com/docs/experience-manager-64/developing/platform/jdbc.html?lang=en

            Hope that helps!

            Regards,

            Santosh

            Translate
            Santosh Sai
              bhavya1724Author
              Level 2
              Jan 21, 2023 8:40 AM UTC

              Thank you @santoshsai i will have a look once again

              Translate
                Terms & ConditionsAccessibility statement

                Loading footer...