yupadhyay

Manifest-Version: 1.0
Bundle-ManifestVersion: 2
Bundle-Name: Mysql-Osgi
Bundle-SymbolicName: com.osgi.mysql
Bundle-Version: 1.0.0
Bundle-RequiredExecutionEnvironment: JavaSE-1.7
Import-Package: javax.management,
 javax.naming,
 javax.naming.spi,
 javax.net,

yupadhyay

<%@page session="false"%><%
%><%@ page import="com.day.commons.datasource.poolservice.DataSourcePool" %><%
%><%@ page import="javax.sql.DataSource" %><%
%><%@ page import="java.sql.Connection" %><%
%><%@ page import="java.sql.SQLException" %><%
%><%@ page import="java.sql.Statement" %><%
%><%@ page import="java.sql.ResultSet"%><%
%><%@ page import="java.sql.PreparedStatement"%>
%><%@ page import="java.sql.DriverManager"%>
DataSourcePool dspService = sling.getService(DataSourcePool.class);

yupadhyay

Manifest-Version: 1.0
Bundle-ManifestVersion: 2
Bundle-Name: Taradatajdbc
Bundle-SymbolicName: taradatajdbc
Bundle-Version: 1.0.0
Bundle-ClassPath: .
Export-Package: com.ncr.teradata,
 com.teradata.jdbc,
 com.teradata.jdbc.client,
 com.teradata.jdbc.encode,

yupadhyay

@Service
@Component(immediate=true)
public class WriteServiceImpl implements WriteService {

 private final Logger log = LoggerFactory.getLogger(getClass());

 @Reference
 private ResourceResolverFactory resolverFactory;
        
        //If you are planning to use repository session

yupadhyay

@Service
@Component(immediate=true)
public class ReadServiceImpl implements ReadService{

 private final Logger log = LoggerFactory.getLogger(getClass());

    @Reference
 private ResourceResolverFactory resolverFactory;
   
        //If you are planning to use repository session

yupadhyay

<?xml version="1.0" encoding="UTF-8"?>
<jcr:root xmlns:sling="http://sling.apache.org/jcr/sling/1.0" xmlns:jcr="http://www.jcp.org/jcr/1.0"
    jcr:primaryType="sling:OsgiConfig"
    user.mapping="[com.adobe.granite.oauth.server=oauthservice,com.adobe.granite.oauth.server:authentication-handler=admin,com.day.cq.cq-search-suggest=suggestionservice,blog.wemblog.com:writeService=bob, blog.wemblog.com:readService=alice]"/>

yupadhyay

<dependency>
    <groupid>com.adobe.aem</groupid>
    <artifactid>aem-api</artifactid>
    <version>6.0.0.1</version>
    <scope>provided</scope>
</dependency>

yupadhyay

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MySQLConnectionHelper {
  private static volatile MySQLConnectionHelper mySQLConnectionHelper;

  private MySQLConnectionHelper() {

    try {

yupadhyay

import javax.jcr.Node;
import org.apache.felix.scr.annotations.Component;
import org.apache.felix.scr.annotations.Property;
import org.apache.felix.scr.annotations.Reference;
import org.apache.felix.scr.annotations.Service;
import org.apache.sling.api.adapter.AdapterFactory;
import org.apache.sling.api.resource.Resource;
import org.apache.sling.api.resource.ResourceResolverFactory;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

yupadhyay

import javax.jcr.Node;
import javax.jcr.RepositoryException;
import org.apache.sling.api.resource.LoginException;
import org.apache.sling.api.resource.Resource;
import org.apache.sling.api.resource.ResourceResolver;
import org.apache.sling.api.resource.ResourceResolverFactory;
import org.apache.sling.api.resource.ValueMap;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;