oracle - Java.sql.SQLException: ORA-00604 -
oracle - Java.sql.SQLException: ORA-00604 -
i developed website using jsp , servlet gives exception java.sql.sqlexception: ora-00604.after restarting server working fine. below code
public class logincheck extends httpservlet { private static final long serialversionuid = 1l; /** * @see httpservlet#httpservlet() */ public logincheck() { super(); // todo auto-generated constructor stub } /** * @see httpservlet#doget(httpservletrequest request, httpservletresponse response) */ protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { // todo auto-generated method stub } /** * @see httpservlet#dopost(httpservletrequest request, httpservletresponse response) */ protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { // todo auto-generated method stub arraylist<string> appaddlist = new arraylist<string>(); arraylist<string> appnamelist = new arraylist<string>(); printwriter out = response.getwriter(); calendar objcal1=calendar.getinstance(); calendar objcal2=calendar.getinstance(); objcal2.set(1970,0,1,0,0,0); response.setdateheader("last-modified",objcal1.gettime().gettime()); response.setdateheader("expires",objcal2.gettime().gettime()); response.setheader( "pragma" , "no-cache" ); response.setheader( "cache-control" , "no-cache" ); response.addheader("cache-control","no-store"); cookie cookies[] = request.getcookies(); if(cookies != null) { for(int = 0; < cookies.length; i++) { cookies[i].setmaxage(0); response.addcookie(cookies[i]); } } httpsession session = request.getsession(); session.setattribute( "user" , request.getparameter( "username" ) ); session.setattribute( "pass" , request.getparameter( "pass" ) ); string user = (string)session.getattribute( "user" ); string pass = (string)session.getattribute( "pass" ); session.setmaxinactiveinterval(120); java.sql.connection con = tsm.intf.common.com.common.connection.getconnection(); statement stmtemptable = null; statement stmtapptable = null; preparedstatement stmtdesigid = null; preparedstatement stmtemptableappacc = null; seek { stmtemptable = con.createstatement(); stmtapptable = con.createstatement(); stmtemptableappacc = con.preparestatement( "select appaccess employee empid = ?" ); stmtdesigid = con.preparestatement( "select desigid employee empid = ?" ); resultset rsemp = stmtemptable.executequery( "select empid , username , userpassword , employeename employee" ); resultset rsappname = stmtapptable.executequery( "select appname application" ); boolean correctid = false; boolean mach = false; int indexnum = integer.parseint( request.getparameter("index") ); string[] appaccess = null; string path = response.encodeurl(request.getcontextpath() ); appaddlist.add( 0 , path + "\\jsp\\login\\index.jsp"); appnamelist.add( 0 , "index" ); while( rsemp.next() ) { if( user.equals( rsemp.getstring("username") ) && pass.equals( rsemp.getstring("userpassword") ) ) { correctid = true; string name = rsemp.getstring("employeename"); string[] empname = name.split(" "); string emp = ""; for(string str : empname) { if( str.length() != 0 ) { str = str.substring(0, 1).touppercase() + str.substring(1).tolowercase() + " "; emp += str; } } session.setattribute( "empname" , emp ); session.setattribute( "empid" , rsemp.getint("empid") ); stmtemptableappacc.setint( 1 , (integer)session.getattribute("empid") ); resultset rs = stmtemptableappacc.executequery(); rs.next(); appaccess = rs.getstring("appaccess").split("#~##~#"); while( rsappname.next() ) { appaddlist.add( path + "\\jsp\\login\\" + rsappname.getstring("appname") + "home.jsp" ); appnamelist.add( rsappname.getstring("appname") ); } stmtdesigid.setint( 1 , (integer)session.getattribute("empid") ); resultset rsdesgid = stmtdesigid.executequery(); rsdesgid.next(); if( rsdesgid.getint(1) == 1) { appaddlist.set( 1 , path + "\\jsp\\login\\timemanagerhome.jsp" ); } for( string str : appaccess ) { if( indexnum == 0) { mach = true; out.println("<html><head><meta http-equiv=\"refresh\" content=\"0;url=" + appaddlist.get(indexnum) + "\"></head>"); out.println("<body></body></html>"); } if( str.equals( appnamelist.get(indexnum) ) ) { mach = true; out.println("<html><head><meta http-equiv=\"refresh\" content=\"0;url=" + appaddlist.get(indexnum) + "\"></head>"); out.println("<body></body></html>"); } } rs.close(); rsdesgid.close(); } } string url = response.encodeurl(request.getcontextpath() + "\\jsp\\login\\login.jsp"); if( !correctid ) { out.print( "<script>alert(\"please come in right userid & password.\")</script>" ); out.println("<html><head><meta http-equiv=\"refresh\" content=\"0;url=" + url + "\"></head>"); out.println("<body></body></html>"); } if( !mach && correctid) { out.print( "<script>alert(\"do not utilize application.\")</script>" ); out.println("<html><head><meta http-equiv=\"refresh\" content=\"0;url=" + url + "\"></head>"); out.println("<body></body></html>"); } rsemp.close(); rsappname.close(); } catch( sqlexception e ) { e.printstacktrace(); } } }
you have not closed connection object established sql connection. advisable close statements , resultsets , connection objects .
finally{ resultset.close(); statement.close(); connection.close(); } finally block executes on conditions on errors. closes database related objects avoids errors caused .
closing database connections in java
java oracle servlets jdbc
Comments
Post a Comment