Connecting to MySQL DataSourcePool is null
Hi,
I've been following the tutorial to create a mySQL connection from AEM on AEM 6.2
I've created the mySQL bundle that exports com.mysql.jdbc this includes the com.mysql.jdbc.Driver for the connection
The Database in MySQL workbench is called staff_directory
my Day Commons JDBC Connections Pool config is
JDBC driver class = com.mysql.jdbc.Driver
JDBC connection URI = jdbc:mysql://localhost:3306/staff_directory
Datasource name = Staff
the username and password are both correct
All im trying to do is log out connected to see if the database connection is working. The DataSourcePool variable is always null
@Component
@Service
public class EmployeeServiceImp implements EmployeeService {
protected final Logger log = LoggerFactory.getLogger(this.getClass());
@Reference
private DataSourcePool source;
@Override
public Connection getConnection()
{
DataSource dataSource = null;
Connection con = null;
try
{
dataSource = (DataSource) source.getDataSource("Staff");
con = dataSource.getConnection();
return con;
log.debug("Connected");
}
catch (Exception e)
{
log.debug("log error ", e);
}
return null;
}
Thanks for your Help