Replies: 2 comments 12 replies
-
|
For the record, think I found the way to use jsonb blob representation: I also tried to use a file based database. Either way, BLOB, String, file db or memory always results in SQLITE_TOOBIG at the same entry. |
Beta Was this translation helpful? Give feedback.
-
|
Sadly same for 9.4.6.0: |
Beta Was this translation helpful? Give feedback.
-
|
and also exactly same output for 9.4.7.0. List of installed gems: That is, after switching jruby version with rvm, I manually installed and I am pretty puzzled.... |
Beta Was this translation helpful? Give feedback.
-
|
Weird. I also tried on Windows and did not have problems: |
Beta Was this translation helpful? Give feedback.
-
|
Do you know if there is some way to view the jdbc sqlite driver limits at runtime? EDIT: Or how to get a complete stacktrace inside the java driver? |
Beta Was this translation helpful? Give feedback.
-
|
Unfortunately, I do not. I only use JRuby/JDBC for testing, I don't have any production experience with it. |
Beta Was this translation helpful? Give feedback.
-
|
@jeremyevans I think I got something, see: xerial/sqlite-jdbc#681 ... now trying to raise that limit at runtime to see any changes. |
Beta Was this translation helpful? Give feedback.
-
|
Can't figure out however to get to the raw |
Beta Was this translation helpful? Give feedback.
-
|
The versions of jdbc-sqlite3 I was using in the above examples are 3.7.2.1 and 3.32.3.3. To get the raw connection: DB.synchronize{|conn| ...}Since the limit is an SQL statement limit, you could try using the bound variable support: https://sequel.jeremyevans.net/rdoc/files/doc/prepared_statements_rdoc.html#label-Bound+Variables |
Beta Was this translation helpful? Give feedback.
-
|
Oh wow thanks alot! Yes, the bound variables work :-) with: seems to do the trick. And if |
Beta Was this translation helpful? Give feedback.
-
|
@jeremyevans One followup question regarding the bound variables / prepare statements (for jdbc sqlite). Is it possible (and how) to do this to insert multiple values with one call, a la: ? |
Beta Was this translation helpful? Give feedback.
-
|
You would have to use raw SQL to use bound variables in insert statements with multiple rows: DB['INSERT INTO "table" ("x", "y") VALUES (?, ?), (?, ?)', :$a, :$b, :$c, :$d].
call(:insert, :a=>1, :b=>2, :c=>3, :d=>4) |
Beta Was this translation helpful? Give feedback.
-
I am using sequel together with jruby 9.4.6.0.
Database is opened and filled like this:
Is it correct to put the string representation of the (treeish) hash object
cache_entryas argument to the insert call to get all the nice sqlite json features of the JSON column?Insert at least works up until a somewhat larger entry is inserted. I am getting:
So inserted json string was only ~1.3M Characters -> depending on encoding max. ~2.6M bytes.
That is strange, as SQLITE_TOOBIG should only occur for more than 1G bytes. Anybody got an idea why SQLITE_TOOBIG is thrown?
I also tried to insert to pass the hash object itself into the insert call, but then I get this:
already with the first insert.
How to correctly insert somewhat larger JSON objects into a memory sqlite database with sequel?
thanks alot and best
mrckzgl
Beta Was this translation helpful? Give feedback.
All reactions