Connect AEM with MySQL - AEM 6.4
Hi All,
I am trying to connect with MYSQL. I have given JDBC configuration and used below code. But in below code i am getting datasource pool as null. Can you please help me to find where i am doing mistake?
@Reference
private DataSourcePool ds;
//Returns a connection using the configured DataSourcePool
private Connection getConnection()
{
LOGGER.info("************Inside get connection*********" + ds);
DataSource dspService = null;
Connection con = null;
try
{
dspService = (DataSource) ds.getDataSource("hsqldbds");
LOGGER.info("************Inside IF*********");
if(dspService != null) {
LOGGER.info("************Inside IF*********");
final Connection connection = ((DataSource) dspService).getConnection();
final Statement statement = connection.createStatement();
final ResultSet resultSet = statement.executeQuery("SELECT * from pet");
int r=0;
LOGGER.info("************Working*********");
while(resultSet.next()){
r=r+1;
}
resultSet.close();
}
}
catch (Exception e)
{
LOGGER.info("************ERROR*********" + e.getMessage());
e.printStackTrace();
}
return con;
}
Also, Can you share me driver need to be used for SQL DB in AEM 6.4.
