Unable to Access mysql database through JNDI.

[Vishal Srivastav]

Dear Friends,

I am trying to access mysql database through JNDI but I am not able to access it. I am not much familiar to JNDI. I am sending you the coding part of my programs. Kindly help me and tell where am I making a mistake -

DatabaseCheck.java

//jdbc packages import
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.sql.DataSource;
//jndi packages import
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
//io packages import
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.IOException;

class DatabaseCheck {

	private Context ctx;
	private DataSource ds;
	private Connection con;
	private PreparedStatement pstmt;
	private int row;

	private BufferedReader br;
	private InputStreamReader is;

	public boolean connect(String dsn) {

		try {
			
			ctx = new InitialContext();

			if(ctx == null)
				throw new RuntimeException("Unable to find JNDI context.");

			ds = (DataSource)ctx.lookup(dsn);

			if(ds == null)
				throw new RuntimeException("DataSource \"studentDB\" not found.");

			con = ds.getConnection();
			pstmt = con.prepareStatement("insert into studentTB values(?,?,?)");

			//taking input from the user
			is = new InputStreamReader(System.in);
			br = new BufferedReader(is);

			System.out.println("Enter information regarding student you want to save: ");
			System.out.print("Name :: ");
			Student s = new Student();

			s.setName(br.readLine());

			System.out.print("Age :: ");
			s.setAge(Integer.parseInt(br.readLine()));

			System.out.print("Phone :: ");
			s.setPhone(br.readLine());

			pstmt.setString(1, s.getName());
			pstmt.setInt(2, s.getAge());
			pstmt.setString(3, s.getPhone());

			row = pstmt.executeUpdate();
		} catch(NamingException ne) {
			System.err.println("Error in lookup: " + ne);
		} catch(SQLException sqle) {
			System.err.println("Error in database: " + sqle);
		} catch(IOException ioe) {
			System.err.println("Error in input stream: " + ioe);
		} catch(NumberFormatException nfe) {
			System.err.println("Invalid Age: " + nfe);
		}
		
		if(row == 0) 
			return false;
		else	
			return true;
	}

	public static void main(String[] args) {
		DatabaseCheck dc = new DatabaseCheck();

		boolean isStored = dc.connect("java:comp/env/jdbc/studentDB");

		if(isStored)
			System.out.println("Record saved successfully.");
		else
			System.err.println("Error in saving data to database.");
	}
}

Student.java

public class Student {

	private String name;
	private int age;
	private String phone;

	public Student() {
	}

	public Student(String name, int age, String phone) {

		this.name = name;
		this.age = age;
		this.phone = phone;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}
}

When I used simple statement

java DatabaseCheck

to run the code, following error message flashed -

Error in lookup: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
Error in saving data to database.

I later used the following command for running the application -

java -Djava.naming.factory.initial=com.mysql.jdbc.Driver -Djava.naming.provider.url=jdbc:mysql://localhost:3306/studentDB DatabaseCheck

Then following error msg flashed -

Error in lookup: javax.naming.NoInitialContextException: Cannot instantiate class: com.mysql.jdbc.Driver [Root exception is java.lang.ClassCastException: com.mysql.jdbc.Driver cannot be cast to javax.naming.spi.InitialContextFactory]
Error in saving data to database. Please contact your service provider.

The user of mysql is root and password is mysql@123. Is there something extra needed to be done.

Please tell where I am commiting mistake? Suggestions are welcomed.

Waiting for your response friends.

Regards,
VIshal.

[Deepak Bala]

-Djava.naming.factory.initial=com.mysql.jdbc.Driver -Djava.naming.provider.url=jdbc:mysql://localhost:3306/studentDB

These are supposed to be JNDI related implementation details. They do not have anything to do with JDBC, thus the class cast exception.

Change the factory and procider URL to reflect the right values

[Syed Saifuddin]

Check your config file also. config file of server.