From 82e095b443ca60603cf7261e73f41d5bfdb0ae56 Mon Sep 17 00:00:00 2001 From: Peter Wu Date: Sat, 10 May 2014 19:47:27 +0200 Subject: Move SQLException processing in processTweet to Main Huge diff comes from whitespace diff. Now the tweet is printed with its line number in error cases, and all further insertions are aborted. --- src/main/Main.java | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'src/main/Main.java') diff --git a/src/main/Main.java b/src/main/Main.java index b5df23f..bd4055f 100644 --- a/src/main/Main.java +++ b/src/main/Main.java @@ -63,14 +63,19 @@ public class Main { } private void tweetsToDb(ITweetReader reader) throws IOException { - Tweet tweet; + Tweet tweet = null; + int tweetNo = 1; try (Connection connection = cb.create()) { /* create the object that fills the database */ DataFiller filler = new DataFiller(connection); while ((tweet = reader.getTweet()) != null) { filler.processTweet(tweet); + ++tweetNo; } } catch (SQLException ex) { + if (tweet != null) { + System.err.println("Faulty tweet: " + tweet); + } Logger.getLogger(Main.class.getName()).log(Level.SEVERE, "DB error", ex); } -- cgit v1.2.1