JNDI connection in AEM server using spring

Avatar

Avatar

rasikawanjari

Avatar

rasikawanjari

rasikawanjari

22-04-2019

we have a requirement  to access a database through a webserver JNDI connection using spring framework

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gaurav-Behl

MVP

Avatar

Gaurav-Behl

MVP

Gaurav-Behl
MVP

23-04-2019

A solution to use JNDI in AEM. There could be other solutions as well --

Apache Sling :: DataSource Provider

While running in Application Server the DataSource instance might be managed by app server and registered with JNDI. To enable lookup of DataSource instance from JNDI you can configure JNDIDataSourceFactory

  1. Configure the DataSource from OSGi config for PID org.apache.sling.datasource.JNDIDataSourceFactory
  2. Provide the JNDI name to lookup from and other details

If Felix WebConsole is used then you can configure it via Configuration UI at http://localhost:8080/system/console/configMgr/org.apache.sling.datasource.JNDIDataSourceFactory

Once configured JNDIDataSourceFactory would lookup the DataSource instance and register it with OSGi ServiceRegistry

Answers (5)

Answers (5)

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K
smacdonald2008

22-04-2019

AEM is not a Spring-based framework. Why would you have a requirement that is based on a framework that AEM is not? AEM uses DataSourcePool API to access databases via an OSGi bundle.

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K
smacdonald2008

23-04-2019

Looks like they are attempting to connect to a database as if they are working in a SPRING MVC project. Something like - https://www.journaldev.com/2597/spring-datasource-jndi-with-tomcat-example

However - as i have pointed out, AEM is not a Spring based framework and therefore to connect to a database, one should work in the way that AEM connects to databases - which is using a DATASOURCEPOOL.

Avatar

Avatar

Jörg_Hoh

Employee

Total Posts

3.0K

Likes

953

Correct Reply

1.0K

Avatar

Jörg_Hoh

Employee

Total Posts

3.0K

Likes

953

Correct Reply

1.0K
Jörg_Hoh
Employee

23-04-2019

Can you please elaborate on bit on this? From your posts I don't get a clear understanding what you are trying to achieve.

Jörg

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K
smacdonald2008

22-04-2019

I can say it’s not best practice. I recommend following best practice which is DataSoucePool to access a database from AEM.

Avatar

Avatar

rasikawanjari

Avatar

rasikawanjari

rasikawanjari

22-04-2019

We are consuming one customized jar which is using spring framework. So, we need JNDI connection to connect with other database.is it possible ?