jeudi 5 mars 2015

ArrayOutOfBoundsException on PreparedStatement

I'm at a loss here, can anyone see what's wrong with this code? I'm using sqlite with this driver: http://ift.tt/1fOS9gr



public void insertTweets(final List<WatchedTweet> tweets) {
try {
final PreparedStatement stmt = connection.prepareStatement(
"insert into tweets(tweet_id, user_id, campaign_id, retweet_count, date) values(?,?,?,?,?)"
);
for(WatchedTweet tweet : tweets) {
stmt.setLong(0, tweet.getID());
stmt.setLong(1, tweet.getParent().getTwitterID());
stmt.setInt(2, tweet.getParent().getCampaignID());
stmt.setInt(3, tweet.getRetweetCount());
stmt.setLong(4, tweet.getAdded().getTime());
stmt.addBatch();
stmt.clearParameters();
}
stmt.executeBatch();
stmt.close();
} catch (SQLException sqe) {
sqe.printStackTrace();
}
}


I get an exception at this line:


stmt.setLong(0, tweet.getID());


The exception:



java.lang.ArrayIndexOutOfBoundsException: -1
at org.sqlite.core.CorePreparedStatement.batch(CorePreparedStatement.java:110)
at org.sqlite.jdbc3.JDBC3PreparedStatement.setLong(JDBC3PreparedStatement.java:298)
at tweetserver.server.db.TwitterDB.insertTweets(TwitterDB.java:75)
at tweetserver.server.rest.TwitterBot.updateTimelineUntilDate(TwitterBot.java:138)
at tweetserver.server.rest.TwitterBot.process(TwitterBot.java:49)
at tweetserver.server.rest.TwitterBot.<init>(TwitterBot.java:44)
at tweetserver.server.Application.bootstrap(Application.java:25)
at tweetserver.server.Application.main(Application.java:20)


This is how I created the table



"create table if not exists tweets (" +
"id integer PRIMARY KEY AUTOINCREMENT," +
"tweet_id long NOT NULL," +
"user_id long NOT NULL," +
"campaign_id int NOT NULL, " +
"retweet_count int NOT NULL, " +
"date long NOT NULL)"`

Aucun commentaire:

Enregistrer un commentaire