Bookmark Topic Watch Topic
  • New Topic

saving messages

 
hon eb
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Report post to moderator
hi every one i hve tried alot but cant save the incoming messages through java mail API into database ACCESS here is my code plz do do respond. It is not giving any errors at compile time of any kind but still not saving
//FOR DATABASE

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String sourceURL = "jdbc dbc:junk";
Connection databaseConnection=DriverManager.getConnection(sourceURL);
Statement statement=databaseConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

Subject=message[i].getSubject().toString();
Message=message[i].getContent().toString();
From=message[i].getFrom()[0].toString();
String Date="none";
PreparedStatement stat = databaseConnection.prepareStatement("INSERT INTO MINFO (From,Subject,Message,Date) VALUES(?,?,?,?)");
stat.setString(1,From);
stat.setString(2,Subject);
stat.setString(3,Message);
stat.setString(4,Date);
stat.executeUpdate();
stat.close();
}
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64721
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
hon, please do not cross-post the same question in multiple forums -- it is against JavaRanch policy. Please continue any discussion here.
I am requesting that this topic be closed.
bear
 
Michael Ernest
High Plains Drifter
Sheriff
Posts: 7292
Netbeans IDE VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Done.
 
    Bookmark Topic Watch Topic
  • New Topic