import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Collections;
import org.apache.ignite.Ignite;
import org.apache.ignite.IgniteCache;
import org.apache.ignite.Ignition;
import org.apache.ignite.cache.QueryEntity;
import org.apache.ignite.cache.query.SqlFieldsQuery;
import org.apache.ignite.configuration.CacheConfiguration;

public class JDBCQuery {
    public static void main(String[] args) {
        Ignite ignite =  Ignition.start("/opt/ignite/examples/config/query-entity.xml"); 	
        try {
            Class.forName("org.apache.ignite.IgniteJdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:ignite:cfg://cache=PERSON2:local=true:client=false@file:///opt/ignite/examples/config/query-entity.xml");

            PreparedStatement stmt = conn.prepareStatement(
                "select firstname from PERSON2");
            ResultSet rs = stmt.executeQuery();
    
            while (rs.next()) {
                String name = rs.getString("firstName");
                System.out.println(name);
            }
                conn.close();
          
    } catch (Exception e) {
        System.out.println("exception caught");
        e.printStackTrace(); 
    }
    }
}