I'm trying to make my code send me email - pliz help.

[Nina Savannah]

I am trying to send an email message using the jsp code below. The message is not being sent but there is no error message either.
What could be wrong with my code?

   Statement stmtSelect;
  ResultSet rsetPasswords;
  String selectStr = "select * from country";
  stmtSelect = conn.createStatement();
  rsetPasswords = stmtSelect.executeQuery(selectStr);
  
  boolean sendEmail = false;
  while (rsetPasswords.next()) 
  {
  	if (rsetPasswords.getString("password").equals(l_password)) 
	{
		sendEmail = true;
	}
  }
  stmtSelect.close();
  
  String from="[e-mail]";
  String to="[e-mail]";
  try
  {
	 SmtpClient client = new SmtpClient("mail.magareta375a.org"); 
	 client.from(from);
	 client.to(to);
	 PrintStream message = client.startMessage();
	 message.println("To: " + to);
	 message.println("Subject:  Beneficiary data for "+country_name+" updated");
	 message.println("Beneficiary data for "+country_name+" updated");
	 message.println();
	 message.println("");
	 message.println();     
	 message.println();
	 client.closeServer();
  }
  catch (IOException e)
  {	
	out.println("ERROR SENDING EMAIL:"+e);
	e.printStackTrace();
  }
 

[Adeel Ansari]

SmtpClient class belongs to which package?

However, it looks like you closed it without sending the email.

[Nina Savannah]

I have this at the top of my page. I dont know how to packages, do I need to do that.

    <%@ page import="sun.net.smtp.SmtpClient,java.sql.*,java.io.*,java.lang.*,java.text.*,java.util.*"%>

This statement:-

 stmtSelect.close();   

closes the select statement


The error I'm getting is the one below.

ERROR SENDING EMAIL:java.net.UnknownHostException: mailhost

[Swastik Dey]

is mail.magareta375a.org a valid url, you normally get the mentioned exception when it fails to connect to the given url.

[Nina Savannah]

Yes it is valid.

I even tried using the IP address but I'm still getting the same error.

[Ulf Dittmer]

You're better off not using any sun.* classes; consider something like http://commons.apache.org/email/ instead.

[Bauke Scholtz]

Or the great JavaMail API: http://java.sun.com/products/javamail/FAQ.html

[Bear Bibeault]

Please use real words when posting to the forums. Abbreviations such as "pliz" in place of "please" only serve to make your posts more difficult to read and less likely to generate useful responses.

Please read this for more information.

thanks,
bear
JavaRanch sheriff

[Adeel Ansari]

As Ulf already mentioned, the sun.* packages are not standard Java libraries. Hence, the use is very much discourage.

[Nina Savannah]

Thank you so much for your help. I have managed to get it working!