From do-not-reply at jboss.com Thu Dec 28 17:53:14 2006
Content-Type: multipart/mixed; boundary="===============3949852557023935713=="
MIME-Version: 1.0
From: torben.frojonck <do-not-reply at jboss.com>
To: jboss-user at lists.jboss.org
Subject: [jboss-user] [Installation,
 Configuration & Deployment] - Re: Starnge exception
Date: Thu, 28 Dec 2006 17:53:14 -0500
Message-ID: <13175526.1167346394357.JavaMail.jboss@colo-br-02.atl.jboss.com>

--===============3949852557023935713==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Hello Peter,

Here is the code. I have marked the call til Class.forName with bold.

	private void createPingTest(
			HttpServletRequest req,
			HttpServletResponse resp) throws ServletException, IOException {
			PrintWriter out=3Dresp.getWriter();
		    out.println("");
		    out.println("Dan test case");
		    out.println("");
		    =

	        try {
//	        	 Build up the job   =

	        	   String server=3Dreq.getParameter("server");
	        	   String emailAdress=3Dreq.getParameter("email");
	        	   if (!Configurator.isValidEmailAddress(emailAdress)){
	        		   out.println("Du skal angive en valid adresse.");
	        		   out.println("<a href=3D\"definerpingjob.jsp\">definer test" );
	        		   out.println("");
	       		       out.close();
	       		       return;
	        	   }
	        	   Integer tid=3Dnew Integer(req.getParameter("tid"));
	        	   if (tid=3D=3Dnull || tid.intValue()<=3D0){
	        		   out.println("Antal test skal v=C3=A6re st?rre end 0.");
	        		   out.println("<a href=3D\"definerpingjob.jsp\">definer test" );
	        		   out.println("");
	       		       out.close();
	       		       return;
	        	   }
	        	   Integer frekvens=3Dnew Integer(req.getParameter("frekvens"));
	        	   if (frekvens=3D=3Dnull || frekvens.intValue()<=3D0){
	        		   out.println("Tid mellem to test skal v=C3=A6re st?rre end 0."=
);
	        		   out.println("<a href=3D\"definerpingjob.jsp\">definer test" );
	        		   out.println("");
	       		       out.close();
	       		       return;
	        	   }
	        	   Integer husnr=3Dnew Integer(req.getParameter("husnr"));
	        	   if (husnr=3D=3Dnull || husnr.intValue()<=3D0){
	        		   out.println("Husnummer skal bare v=C3=A6re et tal");
	        		   out.println("<a href=3D\"definerpingjob.jsp\">definer test" );
	        		   out.println("");
	       		       out.close();
	       		       return;
	        	   }
	        	   =

	        	   StdSchedulerFactory factory=3D new StdSchedulerFactory();
	        	   Collection schedCollection=3D factory.getAllSchedulers();
	        	   Iterator iter=3DschedCollection.iterator();
	        	   Scheduler schedule=3Dnull;
	        	   while (iter.hasNext()){
	        	    schedule=3D(Scheduler) iter.next();
	        	   }
   // Her defineres jobbet
	        	   Configurator conf=3Dnew Configurator();
	        	   Connection con=3Dconf.getConnection();
	        	   PreparedStatement ps=3Dcon.prepareStatement("select nextval('j=
ob_id')");
	        	   ResultSet rs=3Dps.executeQuery();
	        	   Integer jobId=3Dnull;
	        	   while (rs.next()){
	        		   jobId=3Dnew Integer(rs.getInt(1));
	        	   }
	        	   rs.close();
	        	   ps.close();
	        	   Calendar cal=3DCalendar.getInstance(TimeZone.getTimeZone("UTC"=
));
	        	   Class detailClass=3DClass.forName("dk.frojonck.pingtest.schedu=
le.PingTest"); =

	        	   JobDetail job=3Dnew JobDetail(jobId.toString(),"pingtest",
	        			   detailClass);
	        	   JobDataMap dataMap=3Djob.getJobDataMap();
	        	   dataMap.put("server",server);
	        	   dataMap.put("email",emailAdress);
	        	   dataMap.put("antalping",Configurator.getProperty("antalping"));
	        	   dataMap.put("jobid",jobId.toString());
	        	   cal.add(Calendar.SECOND,10);
	        	   Date startTime=3Dcal.getTime();
	        	   cal.add(Calendar.HOUR_OF_DAY,tid.intValue());
//	        	   cal.add(Calendar.MINUTE,tid.intValue());
	        	   Date endTime=3Dcal.getTime();
	        	   SimpleTrigger trigger=3Dnew SimpleTrigger(jobId.toString(),"pi=
ngtest",
	        			   startTime,endTime,SimpleTrigger.REPEAT_INDEFINITELY,
	        			   	 ((long) frekvens.intValue())*1000*60);
	        	   =

	        	   =

	        	   schedule.scheduleJob(job,trigger);
	        	   =

           	       ps=3Dcon.prepareStatement("insert into pingtest "+
           	    		   	"(id, husnr, email,start_time, end_time, antal, inter=
val,pinghost,bruger_id) "+
           	    		   	"values (?,?,?,?,?,?,?,?,?)"
           	    		   );
           	       ps.setInt(1,jobId.intValue());
           	       ps.setInt(2,husnr.intValue());
           	       ps.setString(3,emailAdress);
           	       ps.setTimestamp(4,new Timestamp(startTime.getTime()),cal=
);
           	       ps.setTimestamp(5,new Timestamp(endTime.getTime()),cal);
           	       ps.setInt(6,Integer.parseInt(Configurator.getProperty("a=
ntalping")));
           	       ps.setInt(7,frekvens.intValue());
           	       ps.setString(8,server);
           	       ps.setString(9,req.getRemoteUser());
           	       ps.execute();
//           	       con.commit();
           	       ps.close();
           	       con.close();
           	       String messagetext=3D"Du har mulighed for at f=C3=B8lge =
"+
           	       " resultaterne p=C3=A5 siden "+
           	       " https://www.frojonck.dk/pingtest/resultatgraf.jsp?jobi=
d=3D"+
           	       jobId.toString();
           	       out.println(""+messagetext+"");
           	       WriteMail mail=3Dnew WriteMail(Configurator.getProperty(=
"smtphost"));
           	       mail.setFrom(Configurator.getProperty("from"));
           	       mail.addTo(emailAdress);
           	       mail.setSubject("[PINGTEST] testcase er registreret");
           	       mail.setTextPart(messagetext+
           	    		   "\n bruger er ping \n kodeord er xxx");
           	       mail.sendMessage();
           	       =

	        }
	       catch (Exception e){e.printStackTrace();}
		    =

		    out.println("");
		    out.close();

			// TODO Auto-generated method stub
		}


View the original post : http://www.jboss.com/index.html?module=3Dbb&op=3Dv=
iewtopic&p=3D3996741#3996741

Reply to the post : http://www.jboss.com/index.html?module=3Dbb&op=3Dpostin=
g&mode=3Dreply&p=3D3996741


--===============3949852557023935713==--