Passing database result set from server to client

[Swastik Dey]

This is how you convert an object to json format using Gson library.

public class ModelClass {
	private String name;
	private int age;
	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;
	}
}

import com.google.gson.Gson;


public class TestClass {
	public static void main(String...arg){
		ModelClass md=new ModelClass();
		md.setName("A");
		md.setAge(20);
		Gson gson=new Gson();
		String jsonData=gson.toJson(md);
		System.out.println(jsonData);
	}
}

[Priti Mehta]

List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
			while(rs.next())
			{
				UAVSearch uavsearch = new UAVSearch();
				uavsearch.setUAVname(rs.getString(uavname));
				uavsearch.setUAVBand(rs.getString(uavband));
				uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
				uavsearch.setDFreqTo(rs.getString(dfreqto));
				uavsearch.setDBWFrom(rs.getString(dbwfrom));
				uavsearch.setDBWTo(rs.getString(dbwto));
				uavsearch.setDetectionTime(rs.getString(detectiontime));
				searchlist.add(uavsearch);
				
			}

I want to convert this List searchlist to json object without using gson..help please...

[Swastik Dey]

Does that mean you won't use any extra library to convert it to json?

[Priti Mehta]

yes true...uavsearch is my model class and rs is resultant set obtained from database.

[Swastik Dey]

Not a very correct approach, but you can use StringBuilder and append data in correct json format.

[Priti Mehta]

Ok if I use the Gson also but i dont want to add variables values like

md.setName("A");
md.setAge(20);

Then how will i use it.

[Swastik Dey]

You are already doing this

uavsearch.setUAVname(rs.getString(uavname));

the same thing I am also doing, and what's wrong in doing this?

[Partheban Udayakumar]

Priti Mehta wrote:i dont want to add variables values like

I have given the alternate to you in my answer itself

[Priti Mehta]

ok done!!!

string jsondata = Gson.tojson(uavsearch) is not working. throwing error as

"Cannot make a static reference to the non-static method toJson(Object) from the type Gson"

[Swastik Dey]

toJson is not a static method. Look at the error, point 2 as per my understanding it should be a json array

List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
    while(rs.next())
    {
        UAVSearch uavsearch = new UAVSearch();
        uavsearch.setUAVname(rs.getString(uavname));
        uavsearch.setUAVBand(rs.getString(uavband));
        uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
        uavsearch.setDFreqTo(rs.getString(dfreqto));
        uavsearch.setDBWFrom(rs.getString(dbwfrom));
        uavsearch.setDBWTo(rs.getString(dbwto));
        uavsearch.setDetectionTime(rs.getString(detectiontime));
        searchlist.add(uavsearch);
         
    }

JsonObject obj = new JsonObject(); //Json Object
	Gson gson=new Gson();
	obj.add("UAVSearch", gson.toJsonTree(searchlist));
	String jsonData=gson.toJson(obj);
System.out.println("printing json array:"+jsonData);

[Priti Mehta]

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
		
		System.out.println("In DB Class " );
		
		try{
			// registering driver
			conn = GetConnection();
			stmt = conn.createStatement();
			System.out.println("Fetching records with condition...");
			System.out.println(uavname);
			String sql = "Select * from UAVTypeTable Where UAVName = '" + uavname + "'";
			ResultSet rs = stmt.executeQuery(sql);
			
			//List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
			while(rs.next())
			{
				
				UAVSearch uavsearch = new UAVSearch();
				uavsearch.setUAVname(rs.getString(uavname));
				uavsearch.setUAVBand(rs.getString(uavband));
				uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
				uavsearch.setDFreqTo(rs.getString(dfreqto));
				uavsearch.setDBWFrom(rs.getString(dbwfrom));
				uavsearch.setDBWTo(rs.getString(dbwto));
				uavsearch.setDetectionTime(rs.getString(detectiontime));
				searchlist.add(uavsearch);
			}
			
			// process result set
			/*while(rs.next()){
				String uname = rs.getString("UAVName");
				
				System.out.println("UAVName = " + uname);
			}*/
			//rs.close();
		}

How can rs be json array..?

[Priti Mehta]

Sorry List part is not commented.
//List<UAVSearch> searchlist = new ArrayList<UAVSearch>();

[Swastik Dey]

rs is not a jsonarray. searchlist is a list that is getting converted to a json array.

[Priti Mehta]

java.sql.SQLException: [Sybase][JDBC Driver]Syntax error or access violation
at sybase.jdbc4.sqlanywhere.IIStatement.executeQuery(Native Method)
at sybase.jdbc4.sqlanywhere.IStatement.executeQuery(IStatement.java:299)
at UAV.DBClass.processUAVBandRequest(DBClass.java:51)
at UAV.UAVSearchHandler.ValidateUAV(UAVSearchHandler.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)


getting exception on running code and jsondata is not being printed.

[Swastik Dey]

The error has got nothing to do with json. The error is related to database probably your syntax of any query is wrong. Comment out the conversion to json part, and just try to print the searchlist, you are likely to get the same error.

[Swastik Dey]

Do you see the following line

System.out.println("Fetching records with condition...");

getting printed?

[Priti Mehta]

I commented the following code it is working...

// List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
// while(rs.next())
// {
//
// UAVSearch uavsearch = new UAVSearch();
// uavsearch.setUAVname(rs.getString(uavname));
// uavsearch.setUAVBand(rs.getString(uavband));
// uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
// uavsearch.setDFreqTo(rs.getString(dfreqto));
// uavsearch.setDBWFrom(rs.getString(dbwfrom));
// uavsearch.setDBWTo(rs.getString(dbwto));
// uavsearch.setDetectionTime(rs.getString(detectiontime));
// searchlist.add(uavsearch);
// }
// rs.close();
//
// JsonObject obj = new JsonObject(); //Json Object
// Gson gson=new Gson();
// obj.add("UAVSearch", gson.toJsonTree(searchlist));
// String jsonData=gson.toJson(obj);
// System.out.println("printing json array:"+jsonData);


output is


In DB Class
Inside GetConnection Try Block
Connection 1 successful
Fetching records with condition...
Priti
Goodbye!
Return From Web Service 2
Get Ing Response

[Swastik Dey]

If the method is getting called it should at least print the following

System.out.println("In DB Class " );

[Priti Mehta]

Its printing "In DB class". Not related to query i think..

[Swastik Dey]

Show the complete method block once again, with the lines you have commented.

[Priti Mehta]

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
		
		System.out.println("In DB Class " );
		
		try{
			// registering driver
			conn = GetConnection();
			stmt = conn.createStatement();
			System.out.println("Fetching records with condition...");
			System.out.println(uavname);
			String sql = "Select * from UAVTypeTable Where UAVName = '" + uavname + "'";
			ResultSet rs = stmt.executeQuery(sql);
			
//			List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
//			while(rs.next())
//			{
//				
//				UAVSearch uavsearch = new UAVSearch();
//				uavsearch.setUAVname(rs.getString(uavname));
//				uavsearch.setUAVBand(rs.getString(uavband));
//				uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
//				uavsearch.setDFreqTo(rs.getString(dfreqto));
//				uavsearch.setDBWFrom(rs.getString(dbwfrom));
//				uavsearch.setDBWTo(rs.getString(dbwto));
//				uavsearch.setDetectionTime(rs.getString(detectiontime));
//				searchlist.add(uavsearch);
//			}
//			rs.close();
//			
//			JsonObject obj = new JsonObject(); //Json Object
//		    Gson gson=new Gson();
//		    obj.add("UAVSearch", gson.toJsonTree(searchlist));
//		    String jsonData=gson.toJson(obj);
//		    System.out.println("printing json array:"+jsonData);
		}
		catch(SQLException se)
		{
		      //Handle errors for JDBC
		      se.printStackTrace();
	    }
		catch(Exception e)
		{
		     //Handle errors for Class.forName
		     e.printStackTrace();
		}
		finally
		{
		      //finally block used to close resources
		    try
		    {
		    	if(stmt!=null)
		        conn.close();
		    }
		    catch(SQLException se)
		    {
		    }// do nothing
		    try{
		         if(conn!=null)
		            conn.close();
		      }catch(SQLException se){
		         se.printStackTrace();
		      }//end finally try
		}//end try
		System.out.println("Goodbye!");
	}
}

[Swastik Dey]

try this

ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
  System.out.println("inside record set loop");
}

and see do you get the same errro

[Priti Mehta]

When I commented only this

// JsonObject obj = new JsonObject(); //Json Object
// Gson gson=new Gson();
// obj.add("UAVSearch", gson.toJsonTree(searchlist));
// String jsonData=gson.toJson(obj);
// System.out.println("printing json array:"+jsonData);

it showed exception..as

In DB Class
Inside GetConnection Try Block
Connection 1 successful
Fetching records with condition...
UAVAlpha's
java.sql.SQLException: [Sybase][JDBC Driver]Syntax error or access violation
at sybase.jdbc4.sqlanywhere.IIStatement.executeQuery(Native Method)
at sybase.jdbc4.sqlanywhere.IStatement.executeQuery(IStatement.java:299)
at UAV.DBClass.processUAVBandRequest(DBClass.java:51)
at UAV.UAVSearchHandler.ValidateUAV(UAVSearchHandler.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Goodbye!
Return From Web Service 2
Get Ing Response

[Swastik Dey]

Just try what I said, let the commented parts be as it is, json has got nothing to do with this. just try executing the loop and see do you get the same error.

[Swastik Dey]

What I am trying to say is this

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
         
        System.out.println("In DB Class " );
         
        try{
            // registering driver
            conn = GetConnection();
            stmt = conn.createStatement();
            System.out.println("Fetching records with condition...");
            System.out.println(uavname);
            String sql = "Select * from UAVTypeTable Where UAVName = '" + uavname + "'";
            ResultSet rs = stmt.executeQuery(sql);
             while(rs.next())
          {
                System.out.println("inside recordset loop"):
          }
//          List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
//          while(rs.next())
//          {
//              
//              UAVSearch uavsearch = new UAVSearch();
//              uavsearch.setUAVname(rs.getString(uavname));
//              uavsearch.setUAVBand(rs.getString(uavband));
//              uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
//              uavsearch.setDFreqTo(rs.getString(dfreqto));
//              uavsearch.setDBWFrom(rs.getString(dbwfrom));
//              uavsearch.setDBWTo(rs.getString(dbwto));
//              uavsearch.setDetectionTime(rs.getString(detectiontime));
//              searchlist.add(uavsearch);
//          }
//          rs.close();
//          
//          JsonObject obj = new JsonObject(); //Json Object
//          Gson gson=new Gson();
//          obj.add("UAVSearch", gson.toJsonTree(searchlist));
//          String jsonData=gson.toJson(obj);
//          System.out.println("printing json array:"+jsonData);
        }
        catch(SQLException se)
        {
              //Handle errors for JDBC
              se.printStackTrace();
        }
        catch(Exception e)
        {
             //Handle errors for Class.forName
             e.printStackTrace();
        }
        finally
        {
              //finally block used to close resources
            try
            {
                if(stmt!=null)
                conn.close();
            }
            catch(SQLException se)
            {
            }// do nothing
            try{
                 if(conn!=null)
                    conn.close();
              }catch(SQLException se){
                 se.printStackTrace();
              }//end finally try
        }//end try
        System.out.println("Goodbye!");
    }
}

[Priti Mehta]

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
		
		System.out.println("In DB Class " );
		
		try{
			// registering driver
			conn = GetConnection();
			stmt = conn.createStatement();
			System.out.println("Fetching records with condition...");
			System.out.println(uavname);
			String sql = "Select * from UAVTypeTable Where UAVName = '" + uavname + "'";
			ResultSet rs = stmt.executeQuery(sql);
			
			List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
			while(rs.next())
			{
				System.out.println("inside record set loop");
//				UAVSearch uavsearch = new UAVSearch();
//				uavsearch.setUAVname(rs.getString(uavname));
//				uavsearch.setUAVBand(rs.getString(uavband));
//				uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
//				uavsearch.setDFreqTo(rs.getString(dfreqto));
//				uavsearch.setDBWFrom(rs.getString(dbwfrom));
//				uavsearch.setDBWTo(rs.getString(dbwto));
//				uavsearch.setDetectionTime(rs.getString(detectiontime));
//				searchlist.add(uavsearch);
			}
			
//			
//			JsonObject obj = new JsonObject(); //Json Object
//		    Gson gson=new Gson();
//		    obj.add("UAVSearch", gson.toJsonTree(searchlist));
//		    String jsonData=gson.toJson(obj);
//		    System.out.println("printing json array:"+jsonData);
		}
		catch(SQLException se)
		{
		      //Handle errors for JDBC
		      se.printStackTrace();
	    }
		catch(Exception e)
		{
		     //Handle errors for Class.forName
		     e.printStackTrace();
		}
		finally
		{
		      //finally block used to close resources
		    try
		    {
		    	if(stmt!=null)
		        conn.close();
		    }
		    catch(SQLException se)
		    {
		    }// do nothing
		    try{
		         if(conn!=null)
		            conn.close();
		      }catch(SQLException se){
		         se.printStackTrace();
		      }//end finally try
		}//end try
		System.out.println("Goodbye!");
	}
}

output is 
In DB Class 
Inside GetConnection Try Block
Connection 1 successful
Fetching records with condition...
Priti
inside record set loop
Goodbye!
Return From Web Service 2
Get Ing Response 

[Swastik Dey]

try this once more

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
         
        System.out.println("In DB Class " );
         
        try{
            // registering driver
            conn = GetConnection();
            stmt = conn.createStatement();
            System.out.println("Fetching records with condition...");
            System.out.println(uavname);
            String sql = "Select * from UAVTypeTable Where UAVName = '" + uavname + "'";
            ResultSet rs = stmt.executeQuery(sql);
             
          List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
          while(rs.next())
          {
             
              UAVSearch uavsearch = new UAVSearch();
              uavsearch.setUAVname(rs.getString("uavname"));
              uavsearch.setUAVBand(rs.getString("uavband"));
              uavsearch.setDFreqFrom(rs.getString("dfreqfrom"));
              uavsearch.setDFreqTo(rs.getString("dfreqto"));
              uavsearch.setDBWFrom(rs.getString("dbwfrom"));
              uavsearch.setDBWTo(rs.getString("dbwto"));
              uavsearch.setDetectionTime(rs.getString("detectiontime"));
              searchlist.add(uavsearch);
          }
          rs.close();
          
          JsonObject obj = new JsonObject(); //Json Object
          Gson gson=new Gson();
          obj.add("UAVSearch", gson.toJsonTree(searchlist));
          String jsonData=gson.toJson(obj);
          System.out.println("printing json array:"+jsonData);
        }
        catch(SQLException se)
        {
              //Handle errors for JDBC
              se.printStackTrace();
        }
        catch(Exception e)
        {
             //Handle errors for Class.forName
             e.printStackTrace();
        }
        finally
        {
              //finally block used to close resources
            try
            {
                if(stmt!=null)
                conn.close();
            }
            catch(SQLException se)
            {
            }// do nothing
            try{
                 if(conn!=null)
                    conn.close();
              }catch(SQLException se){
                 se.printStackTrace();
              }//end finally try
        }//end try
        System.out.println("Goodbye!");
    }
}

[Priti Mehta]

In DB Class
Inside GetConnection Try Block
Connection 1 successful
Fetching records with condition...
Priti
inside record set loop
java.sql.SQLException: Cannot find column "Priti" in the resultset
at sybase.jdbc4.sqlanywhere.IIResultSet.getString(Native Method)
at sybase.jdbc4.sqlanywhere.IResultSet.getString(IResultSet.java:536)
at UAV.DBClass.processUAVBandRequest(DBClass.java:58)
at UAV.UAVSearchHandler.ValidateUAV(UAVSearchHandler.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Goodbye!
Return From Web Service 2
Get Ing Response

It is showing this error whereas there is Priti as UAVNAme in database table.

[Priti Mehta]

If I give Uavanme as UAVAlpha's then it is giving same exception as before..

[Swastik Dey]

show the table structure.

[Priti Mehta]

See attachment

[Swastik Dey]

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
         
        System.out.println("In DB Class " );
         
        try{
            // registering driver
            conn = GetConnection();
            stmt = conn.createStatement();
            System.out.println("Fetching records with condition...");
            System.out.println(uavname);
            String sql = "Select UAVName,UAVBand,DownLinkFreq,DownLinkBW,PriUpLinkFreq,PriUpLinkBW,DetectionTime from UAVTypeTable Where UAVName = '" + uavname + "'";
            ResultSet rs = stmt.executeQuery(sql);
             
          List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
          while(rs.next())
          {
             
              UAVSearch uavsearch = new UAVSearch();
              uavsearch.setUAVname(rs.getString(1));
              uavsearch.setUAVBand(rs.getString(2));
              uavsearch.setDFreqFrom(rs.getString(3));
              uavsearch.setDFreqTo(rs.getString(4));
              uavsearch.setDBWFrom(rs.getString(5));
              uavsearch.setDBWTo(rs.getString(6));
              uavsearch.setDetectionTime(rs.getString(7));
              searchlist.add(uavsearch);
          }
          rs.close();
          
          JsonObject obj = new JsonObject(); //Json Object
          Gson gson=new Gson();
          obj.add("UAVSearch", gson.toJsonTree(searchlist));
          String jsonData=gson.toJson(obj);
          System.out.println("printing json array:"+jsonData);
        }
        catch(SQLException se)
        {
              //Handle errors for JDBC
              se.printStackTrace();
        }
        catch(Exception e)
        {
             //Handle errors for Class.forName
             e.printStackTrace();
        }
        finally
        {
              //finally block used to close resources
            try
            {
                if(stmt!=null)
                conn.close();
            }
            catch(SQLException se)
            {
            }// do nothing
            try{
                 if(conn!=null)
                    conn.close();
              }catch(SQLException se){
                 se.printStackTrace();
              }//end finally try
        }//end try
        System.out.println("Goodbye!");
    }
}

[Swastik Dey]

It should work with the record Priti, but probably not with the other one. Let me if it is happening.

[Priti Mehta]

same error

[Swastik Dey]

try with Priti.

[Priti Mehta]

Still same error...I restarted the database server also...but no gain..

[Swastik Dey]

It can't be same error. I change the query, i used column index instead of column labels. I know it will show error with the other value that has single quote. but it should work with the record Priti.

[Swastik Dey]

What error does it show with the latest code that i sent if you enter Priti.

[Swastik Dey]

Do you clean build and restart the server again. What IDE are you using ? Netbeans/Eclipse?

[Priti Mehta]

In DB Class
Inside GetConnection Try Block
Connection 1 successful
Fetching records with condition...
Priti
inside record set loop
java.sql.SQLException: Cannot find column "Priti" in the resultset
at sybase.jdbc4.sqlanywhere.IIResultSet.getString(Native Method)
at sybase.jdbc4.sqlanywhere.IResultSet.getString(IResultSet.java:536)
at UAV.DBClass.processUAVBandRequest(DBClass.java:58)
at UAV.UAVSearchHandler.ValidateUAV(UAVSearchHandler.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Goodbye!
Return From Web Service 2
Get Ing Response

public void processUAVBandRequest(String uavname, String uavband, String dfreqfrom, String dfreqto, String dbwfrom, String dbwto, String detectiontime ){
		
		System.out.println("In DB Class " );
		
		try{
			// registering driver
			conn = GetConnection();
			stmt = conn.createStatement();
			System.out.println("Fetching records with condition...");
			System.out.println(uavname);
			String sql = "Select UAVName,UAVBand,DownLinkFreq,DownLinkBW,PriUpLinkFreq,PriUpLinkBW,DetectionTime from UAVTypeTable Where UAVName = '" + uavname + "'";;
			ResultSet rs = stmt.executeQuery(sql);
			
			List<UAVSearch> searchlist = new ArrayList<UAVSearch>();
			while(rs.next())
			{
				System.out.println("inside record set loop");
				UAVSearch uavsearch = new UAVSearch();
				uavsearch.setUAVname(rs.getString(uavname));
				uavsearch.setUAVBand(rs.getString(uavband));
				uavsearch.setDFreqFrom(rs.getString(dfreqfrom));
				uavsearch.setDFreqTo(rs.getString(dfreqto));
				uavsearch.setDBWFrom(rs.getString(dbwfrom));
				uavsearch.setDBWTo(rs.getString(dbwto));
				uavsearch.setDetectionTime(rs.getString(detectiontime));
				searchlist.add(uavsearch);
			}
			rs.close();
			
			JsonObject obj = new JsonObject(); //Json Object
		    Gson gson=new Gson();
		    obj.add("UAVSearch", gson.toJsonTree(searchlist));
		    String jsonData=gson.toJson(obj);
		    System.out.println("printing json array:"+jsonData);
		}
		catch(SQLException se)
		{
		      //Handle errors for JDBC
		      se.printStackTrace();
	    }
		catch(Exception e)
		{
		     //Handle errors for Class.forName
		     e.printStackTrace();
		}
		finally
		{
		      //finally block used to close resources
		    try
		    {
		    	if(stmt!=null)
		        conn.close();
		    }
		    catch(SQLException se)
		    {
		    }// do nothing
		    try{
		         if(conn!=null)
		            conn.close();
		      }catch(SQLException se){
		         se.printStackTrace();
		      }//end finally try
		}//end try
		System.out.println("Goodbye!");
	}