NullPointer exception on prepared Insert

[Vivienne Lambe]

Hi
Hope someone can help. I have been working on this for hours and cant find the problem. I have an Insert statement, but when I try to actually prepare it, I receive a null pointer exception.
I would appreciate any help with this, i have tried everything.

try {
PreparedStatement pstmt = null;
StringBuffer sbSqlUpdateServer = new StringBuffer("INSERT INTO EventLog (EVENT_DATE, EVENT_URL, DOWNLOAD_SIZE) VALUES (?,?,?)");
pstmt = connection.prepareStatement(sbSqlUpdateServer.toString());

---
Exception in thread "main" java.lang.NullPointerException
at com.quickplay.parser.CreateEventLogEntries.insertEventRow(Compiled Code)
at com.quickplay.parser.CreateEventLogEntries.getTokens(Compiled Code)
at com.quickplay.parser.CreateEventLogEntries.readLogFile(Compiled Code)

[David O'Meara]

I'm assuming your connection is not null?

[Vivienne Lambe]

I verified the Connection is valid.
I think the problem is with the date field. I have tried using to_date(?, 'dd/mm/yyyy') but still the same. Column defined as "Date" in table so i'm not sure if it needs a specific type when inserting.
Thanks for your reply.

[Vivienne Lambe]

Found problem, unstable connection

[Mike Rainville]

See if this helps ...


PreparedStatement pstmt = null; // moved before try block

try {
/* PreparedStatement pstmt = null; moved */