pool not open error while trying to access DB AEM 6.5 | Community
Skip to main content
B
bhavya1724
Level 2
January 20, 2023
Solved

pool not open error while trying to access DB AEM 6.5

  • January 20, 2023
  • 3 replies
  • 4233 views

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.
Best answer by SantoshSai

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

3 replies

SantoshSai
Community Advisor
SantoshSaiCommunity AdvisorAccepted solution
Community Advisor
January 20, 2023

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
    B
    bhavya1724Author
    Level 2
    January 21, 2023

    Thank you @santoshsai i will have a look once again

      ChitraMadan
      Community Advisor
      ChitraMadanCommunity Advisor
      Community Advisor
      January 20, 2023

      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.

        B
        bhavya1724Author
        Level 2
        January 21, 2023

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

         

          Vijayalakshmi_S
          Vijayalakshmi_S
          Level 10
          January 22, 2023

          Hi @bhavya1724 

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

            Nitin_laad
            Community Advisor
            Nitin_laadCommunity Advisor
            Community Advisor
            January 20, 2023

            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. 

             

              B
              bhavya1724Author
              Level 2
              January 21, 2023

              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

                Terms & ConditionsAccessibility statement

                Loading footer...