Stack Overflow
Stack Overflow

Questions tagged [sqljet]

SQLJet is an independent pure Java implementation of a popular SQLite database management system. SQLJet is a software library that provides API that enables Java application to read and modify SQLite databases.

10 questions
4
votes
1 answer

Create SQLite inmemory database from bytearray

I need to process data from a SQLite database using some Java code. The problem is that the database is retrieved from an external service and thus it is only available as an InputStream. I would really like to avoid saving the db to the file system…
Andrew
  • 2,663
  • 6
  • 28
  • 50
3
votes
1 answer

SqlJet Transactions misuse error

I'm trying to access my database while using SqlJet Transactions, but I get this error all the time org.tmatesoft.sqljet.core.SqlJetException: MISUSE: error code is MISUSE Here is my code: SqlJetDb db = null; try { …
Nathaniele Eldritch
  • 101
  • 1
  • 4
2
votes
1 answer

How to stream sqlite from memory?

I have data in a postgres database, I'm currently creating a sqlite db on disk, and then streaming it for clients. I'd prefer to skip the write to file step, and just stream from memory. I haven't seen any Java sqlite options that allows this.…
Joel
  • 2,601
  • 4
  • 33
  • 44
1
vote
0 answers

How do I do an upsert operation in SQLJet?

Given a list of items that need to either update or add records to the database, how can I do/replicate an UPSERT operation using SQLJet? Below I have a minor solution, but the problem is if the order of games in the list changes, then I might skip…
Greenstack
  • 11
  • 1
  • 3
1
vote
1 answer

Is there a Java in-process database, wich allows access from multible VMs?

I am looking for a library which allows to run an in-process database like SQLJet, but it has to be accessible from multiple vms (on the same machine) simultaneously like an independent database server. At best something like this: You create a new…
ObiWanBennobi
  • 118
  • 8
1
vote
0 answers

Using sqlite virtual tables with SqlJet

I'm using the SqlJet Java SqlLite library. I've created a virtual table and now would like to insert rows into it. However, the only insert method I can find applies to a table ojbect, not a virtual table. When I attempt to access the virtual table…
stlingin
  • 11
  • 1
1
vote
1 answer

Porting Android-SQLite code to non-Android SQLite

There is a great Android library that I would like to reuse for a desktop application. The only Android-specific part in this library is the use of android.database.sqlite. What is the best practice in such cases? Replace all calls to use a…
Nicolas Raoul
  • 58,567
  • 58
  • 222
  • 373
0
votes
0 answers

What is this NullPointerException?

I'm writing a small web app using a SQlite database to store users information. But I cannot figure out why I get a NullPointerException if the password entered is wrong only once the first time. Here is my method checkPasssword() : private boolean…
didil
  • 693
  • 8
  • 22
0
votes
1 answer

Query SqlJet at Low level

I got the following problem and no idea on how to solve it. I am using SqlJet to access and manage a small Sqlite DB. It's amazing the simplicity of this library! But now, I have to execute a complex query which cannot be expressed using the…
user1384636
  • 481
  • 6
  • 17
0
votes
1 answer

Can't find created index

Using SQLJet as an SQLite library for a Java project, I create an index for my table and use that to get something from the Database and I keep getting the error, and I have no idea what I'm doing wrong. Paraphrased my code a bit (I create more than…
user1810737
  • 234
  • 4
  • 14