• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error while executing the jdbc code

 
ujwwala tem
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,


I am calling simalateDb.java from action

public boolean saveToDb(CustomerAction c) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException


{

String url= "jdbc:mysql://localhost:3306/";
String dbName="mysql";
String driver="com.mysql.jdbc.Driver";
String userName="uj";
String password="uj";
Connection conn=null;
PreparedStatement pstmt=null;
boolean isAdded = false;
int i=0;



try {

Class.forName(driver).newInstance();
conn= DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Connected to the database");



pstmt=conn.prepareStatement(INSERT_CUSTOMER);


pstmt.setString(i++,c.getName());
pstmt.setInt(i++,c.getAge());
pstmt.setString(i++,c.getEmail());
pstmt.setInt(i++,c.getTelephone());
pstmt.execute();
//conn.commit();
isAdded=true;
System.out.println("successfully Added");


}
catch (SQLException e) {
System.out.println("Error inserting the customer data");
try {
if (!(conn == null)) {
conn.rollback();
}



}

catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}


}
return isAdded;
}
public static final String INSERT_CUSTOMER =
" insert into customer (name, age, email,phone "+")values(?,?,?,?)";

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true

I haven't set any autocommit to true if by default its trute so what should I do here?

Please reply
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ujwwala,

Please use code tags.

Regards, Jan
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use: Connection.setAutocommit()
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#setAutoCommit(boolean)

The javdocs are your friend! You should have them bookmarked.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic