Once you have that bundle in an active state and you Java JDBC code references your MySQL, this code works:
 

<%@include file="/libs/foundation/global.jsp"%>
<%@taglib prefix="cq" uri="http://www.day.com/taglibs/cq/1.0" %>
<%@ page import="com.adobe.test.DataService"  %>
<h1><%= properties.get("title", currentPage.getTitle()) %></h1>
<%
DataService ds = new DataService();
 
%>
<h2>About to write the first name</h2>
 
<h3>The first name in the list is: <%=  ds.getUser()%></h3>

I just executed it with AEM 5.6 and got:

[img]ASCott.png[/img]

Notice it queries the custFirst field from the first record in the Customer table.

In this example -- it queried Scot. 

Here is my Customer table viewed in MySQL workbench:

[img]ASCott2.png[/img]

This is what you should see in the Felix console:

[img]ADataBaseBundle.png[/img]

This article does not use CRXDE to create an OSGi bundle - it uses Eclipse Plug-in project. Therefore does not use the .bnd file. 

First off - do you have your OSGi bundle in an active state -- can you submit a screen shot that shows this please. 

Also be sure to wrap your JDBC Driver file in the OSGi bundle:

4. In the JAR selection dialog, click the Add external button, and browse to the CQJDBC.jar file that you created in the previous step. Also include the MySQL database driver JAR file (for example, mysql-connector-java-5.1.22).

Hi Scott,

 Thank for your prompt reply. Really appreciate it. When I try to create the OSGI Bundle I got an error with some of the packages "-Can not be resolved". Hence I removed them. I tried few other things, like adding a class with the ConnectionHelper ..etc But before that I'm am attaching the screenshots of my code.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@include file="/libs/foundation/global.jsp"%> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.Statement" %> <%@ page import="org.training.test.HelloWorld" %> <%@ page import="com.adobe.test.DataService" %> <%@ page import="java.sql.ResultSet"%> <% DataService ds = new DataService(); %> <h3> Member:<%=ds.getUser()%> end</h3> <h1>hello raju</h1>

Here's mysql result set.

Ok here's what I tried as plan B. Added Connection helper * DataService class in the CRXDE

Created a bundle and consumed the bundle.

package org.training.test; import java.sql.*; import org.slf4j.Logger; import org.slf4j.LoggerFactory; public class DataService { private static final Logger LOG = LoggerFactory.getLogger(DataService.class); public String getUser(){ Connection c = null; String firstName =""; try { // Create a Connection object c =  ConnectionHelper.getConnection(); System.out.println("got connection"); LOG.debug("Connection @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"); Statement s = c.createStatement(); ResultSet rs = s.executeQuery("Select * from dental.member where idMember=2"); System.out.println("Executed"); rs.next(); firstName = rs.getString("memName"); } catch (Exception e) { e.printStackTrace(); } finally { ConnectionHelper.close(c); } System.out.println("first name:" + firstName); return firstName; } public String getMember(){ Connection c = null; String firstName =""; try { // Create a Connection object c =  ConnectionHelper.getConnection(); System.out.println("got connection"); Statement s = c.createStatement(); ResultSet rs = s.executeQuery("Select * from dental.member where idMember=2"); System.out.println("Executed"); rs.next(); firstName = rs.getString("memName"); } catch (Exception e) { System.out.println("***************In catch***********"); e.printStackTrace(); } finally { ConnectionHelper.close(c); } System.out.println("first name:" + firstName); return firstName; } }

======================================================================

ConnectionHelper.java

package org.training.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class ConnectionHelper { private String url; private static ConnectionHelper instance; public ConnectionHelper() { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); url = "jdbc:mysql://localhost:3306/dental"; } catch (Exception e) { e.printStackTrace(); } } public static Connection getConnection() throws SQLException { if (instance == null) { instance = new ConnectionHelper(); } try { return DriverManager.getConnection(instance.url, "root", "admin"); } catch (SQLException e) { throw e; } } public static void close(Connection connection) { try { if (connection != null) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } }

================================

myjdbc.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="org.training.test.HelloWorld" %> <%@ page import="org.training.test.DataService" %> <%@ page import="javax.sql.DataSource" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>DENTAL</title> </head> <body> <% DataService ds = new DataService(); %> <h3> DENTAL HOME PAGE</h3> <h3> Member:<%=ds.getUser()%> end</h3> <input type="text" id="memId"> </body> </html>

Can you paste all of your Java code here too. Need to see it.

There is something wrong with your Java packages -- you should not need  to dropped any. In this article -- the ConnectionHelp class established a connection to your MySQL.

Thanks Scott for your help. I think that was the step I was missing to remove the version next to the import packages in the Manifest file.

arrrgghhh it was driving me NUTS. thx again & you're doing a great job.

Regards,

Sudhin