java.jdbc

Add sqlite3 support

Details

  • Type: Enhancement Enhancement
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Completed
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: None
  • Labels:
    None
  • Patch:
    Code and Test

Description

sqlite3 has some problems:

1) PreparedStatements.addBatch does not do anything without some parameters, so executeBatch doesn't do anything.
2) Transaction support appears to require closing the ResultSet object from generatedKeys.

I've only tested the included patch with the default test dbs and sqlite3.

  1. mssql-error.log
    17/Feb/12 10:06 PM
    42 kB
    Nelson Morris
  2. sqlite_transaction_test.patch
    01/Mar/12 1:15 AM
    1 kB
    Nelson Morris
  3. sqlite3-support.patch
    13/Feb/12 11:46 PM
    6 kB
    Nelson Morris

Activity

Nelson Morris made changes -
Field Original Value New Value
Attachment mssql-error.log [ 10923 ]
Sean Corfield made changes -
Status Open [ 1 ] Resolved [ 5 ]
Resolution Completed [ 1 ]
Sean Corfield made changes -
Resolution Completed [ 1 ]
Status Resolved [ 5 ] Reopened [ 4 ]
Nelson Morris made changes -
Attachment sqlite_transaction_test.patch [ 10975 ]
Sean Corfield made changes -
Status Reopened [ 4 ] Resolved [ 5 ]
Resolution Completed [ 1 ]
Sean Corfield made changes -
Status Resolved [ 5 ] Closed [ 6 ]

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: