<%@ page  import="java.io.*, java.sql.*,java.util.*, java.text.*,spsjobs.*" %>
<%! Connection con=null; %>
<%! JobsOnlineConnectionPoolS insert=null; %>
<%
//-----------------------------Code for connection pool begins  ------------
	insert=new JobsOnlineConnectionPoolS();
	boolean conCheck=true;
  	try
  	{
	  	  con=insert.getConnection();
		  if (con==null)
		  {
		   	Thread.sleep(50);
			con=insert.getConnection();
			if (con==null)
			{
				Thread.sleep(50);
				con=insert.getConnection();
				if (con==null)
				{		
				     	conCheck=false;
				}
			}
		  }	      
	if(conCheck){
//--------------------------------First cut -------------------------------

		Statement statement2 = null;
			ResultSet rs1=null;
			String Sub_type="";
			String Sub_type1="";
		int count=0;
 
    try
    {	
		

	 if( true)
	{
			
			
				try{
						
						statement2 = con.createStatement();
					
	log("statement2"+statement2);
					
						rs1=statement2.executeQuery("select * from subscribe order by Id");
						log("before log");
						
log("rs1"+rs1);
					
						while(rs1.next())
						{
							 count++;
				             Sub_type="Subscribe "+count;
							 Sub_type1="Subscribe1 "+count;
								
							 session.putValue(Sub_type,rs1.getString(1));
							 session.putValue(Sub_type1,rs1.getString(2));
							 
log("statement2"+Sub_type);

						}
						statement2.close();								 
					}catch(Exception e)
						{
					 		
log("e"+e);
							 System.out.println("error in  subscribe table access"+e);
						}
					
				%>
				
				<%@ include file="jobsonline_bookcenterG.jsp" %>
				
			<%		
					
	
	}else  
	{ 	 %>
	
			<%@ include file="jobsonline_loginerror1.htm" %>
			
		
	<%		}
    	}catch(Exception ex)
    	{  log("ex"+ex);
			%>
			<%@ include file="jobsonline_loginerror.htm" %>
			<% System.out.println("Getting data error "+ex);
				  
    	 } 
//-------------------------------Second  Cut-----------------------------------------
		}//end of if block for connection boolean 
		else{
%> 
		<%@ include file="jobsonline_connection.jsp" %>
<%
		}//end of else block for connection boolean 		
	}//end of try
	catch(Exception ex){
log("ex"+ex);
	}
	finally{
    	   	try{         
			if (con!=null){
	          		insert.freeConnection(con);
			}
	   	}
        	catch(Exception e){
		}
	}
//-------------------------------close of Second  Cut---------------------------------	
%>