java.jdbc

Add sqlite3 support

Details

  • Type: Enhancement Enhancement
  • Status: Resolved Resolved
  • 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 -
Resolution Completed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Sean Corfield made changes -
Status Resolved [ 5 ] Reopened [ 4 ]
Resolution Completed [ 1 ]
Nelson Morris made changes -
Attachment sqlite_transaction_test.patch [ 10975 ]
Sean Corfield made changes -
Resolution Completed [ 1 ]
Status Reopened [ 4 ] Resolved [ 5 ]

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: