Re: MYSQL and TOMCAT

[Ramiro Gonzalez]

What  I see

your are losing the real message of the error:

  catch (SQLException sqle) {
 error = "Update failed, possible duplicate entry";
 throw new SQLException( error );
  }
Better you should do:

  catch (SQLException sqle) {
   System.out.println(sqle.getMessage()); //get the message from 
the exception
 // do something here to return the error upside
  }


jsp wrote:

Here is another beginner question of sorts I imagine.
I receive this error.
java.sql.SQLException: Update failed, possible duplicate entry


I've got this code in a .jsp page.

<% String ref=request.getHeader("Referer");%>

<% 
	count.addInfo( ref );
%>

count is calling the method addInfo
in a java bean...
public void addInfo( String Referer )
 throws SQLException, Exception {
if (con != null) {
   try{
   
  PreparedStatement updateInfo;
  updateInfo = con.prepareStatement(
   "insert into info(?);");
  updateInfo.setString(1,Referer);
  updateInfo.execute();
   
   }
  catch (SQLException sqle) {
 error = "Update failed, possible duplicate entry";
 throw new SQLException( error );
  }
} 
else {
   error = "Connection with database was lost.";
   throw new Exception( error );
}
 }

Can anyone see the mistake I am making here. My database has one table
now called info with one String field which is the primary key also.
Thanks if anyone can help or point me to a webpage or something.

-wiley



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: MYSQL and TOMCAT

[Ralph Einfeldt]

First of all you shouldn't rethrow the exception.
That hides the true nature of the problem.

> -Original Message-
> From: jsp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 25, 2003 4:17 AM
> To: 'Tomcat Users List'
> Subject: MYSQL and TOMCAT
> 
>PreparedStatement updateInfo;
>updateInfo = con.prepareStatement(
> "insert into info(?);");
>updateInfo.setString(1,Referer);
>updateInfo.execute();
> 
> }
>catch (SQLException sqle) {
>   error = "Update failed, possible duplicate entry";
>   throw new SQLException( error );
>}
>  } 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: MYSQL and TOMCAT

[Kwok Peng Tuck]

java.sql.SQLException: Update failed, possible duplicate entry

Let's see you have a table info with one field and that field is a primary key right? 
If I remember correctly, primary keys in a table have to be unique, so maybe you are calling
your method with the same data again and again ? 



 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Mysql and Tomcat

[Andy Eastham]

Gareth,

What are the errors?

We're running mysql under Tomcat and our corresponding code is:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
this.connection = DriverManager.getConnection("jdbc:mysql://" +
this.databaseHost +":" + this.databasePort + "/" + this.databaseName +
"?user=" + this.databaseUsername + "&password=" + this.databasePassword);

This works fine, but I guess it's more likely a class loading problem you're
having.  I'd check that mysql.jar is under Tomcat/common/lib.  We've also
got jdbc2_0-stdext.jar there, although I'm not sure this is required any
more.

Andy

> -Original Message-
> From: Lawrence, Gareth [mailto:[EMAIL PROTECTED]]
> Sent: 15 April 2002 05:53
> To: 'Tomcat Users List'
> Subject: Mysql and Tomcat
>
>
> Greetings All,
>
> Just when I though everything was sweet I'm having a nasty
> problem.  I'm running:
> Debian Linux, Tomcat 4.0.3, Mysql, Ant, MM JDBC driver.
>
> Basically I've set everything up sweet and when I run a test file
> from the command line (java test.class) I get a connection to the
> database no problems.  Unfortunately when I try and do the same
> thing through a servlet loaded onto Tomcat I get grief!!!  See below
> I get two errors outputted in the browser window, the second one
> could be caused by the first :-)
>
> If anyway has any ideas about this, please let me know this is a
> desperate one :-(((
>
> Thanks heaps and heaps,
>
> Gareth
>
> Code:
>
> try {
> //Registering the MySQL JDBC Driver
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> }
> catch (Exception E) {
> out.println("Exception: Created Driver");
> System.err.println("Unable to load driver.");
> E.printStackTrace();
> }
>
> try {
> //create variable url containing connecting value
> String url="jdbc:mysql://localhost/weblearn";
> //Create Connection Object from java.sql.*
> Connection Conn = DriverManager.getConnection(url, "root", "");
> }
> //Exceptions if something went wrong
> catch (SQLException E) {
> out.println("SQL Exception");
> }
>
>
>



--
To unsubscribe:   
For additional commands: 
Troubles with the list: