No data source found with name '' (after asking 0 providers) | Community
Skip to main content
B
Balaram_Rudra
Level 4
September 28, 2017
Solved

No data source found with name '' (after asking 0 providers)

  • September 28, 2017
  • 6 replies
  • 2644 views

Hi,

I have to connect to an SQL server from AEM. I have a bundle created with the SQL jdbc driver and installed on OSGi. and I have the connection uri configured on the felix console with datassource name mysqlserver.

when I use the below code

    @Reference

private DataSourcePool dspService;

DataSource dataSource = (DataSource) dspService.getDataSource("mysqlserver");

I get this error:

No data source found with name '' (after asking 0 providers)

could I get some assistance in  identifying what went wrong.

Regards

    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 smacdonald2008

    There is also a video - which is hosted on the Community YouTube Channel - that you can watch that shows you everything you need to do.

    6 replies

    smacdonald2008
    smacdonald2008
    Level 10
    September 28, 2017

    Refer to this article - looks like you are missing the configuration side -- Scott's Digital Community: Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi bundle

      smacdonald2008
      smacdonald2008Accepted solution
      Level 10
      September 28, 2017

      There is also a video - which is hosted on the Community YouTube Channel - that you can watch that shows you everything you need to do.

        N
        naveens25381873
        November 20, 2018

        balarama rajur68938704   This may be old thread. But did you find the issue? I am getting the same error after setting up the configuration and installing the SQL server JDBC as OSGi bundle. Currently using AEM 6.3.

        smacdonald2008​, I went through the video and tried to do the same. Unfortunately, it is not working. Could you please provide a link for SQL Server as well. I found the link for HSQL and mySQL. Your help is appreciated.

        smacdonald2008
        smacdonald2008
        Level 10
        November 20, 2018

        We just did a new one here -- it works for MySQL - Adobe Experience Manager Help | Querying MySQL data using an Adobe Experience Manager 6.4 DataSourcePool

        N
        naveens25381873
        November 20, 2018

        Hi smacdonald2008​, Thanks for the response. However, there seems to be an issue with SQL Server JDBC. I am getting Caused by: java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 54.0), this version of the Java Runtime only recognizes class file versions up to 52.0 while saving the configuration. I have JRE 8 in my eclipse and even tried the jar from Database drivers as an OSGi bundle for Forms Data Integration, getting the same error even for this.

        Not sure how to proceed further.

        smacdonald2008
        smacdonald2008
        Level 10
        November 20, 2018

        Yeah - it certainly does look like a Data Base Driver file issue. I use MySQL Driver file for testing and there are no issues.

        I am asking internal ppl to see if this issue is known.

          Terms & ConditionsAccessibility statement

          Loading footer...