search

strongloop / strong-oracle

Deprecated: Node.js Driver for Oracle databases (Use https://github.com/oracle/node-oracledb instead)
Other
45 stars 18 forks source link

Full CLOB not being saved #56

Open tnrich opened 8 years ago

tnrich commented 8 years ago

Hey there,

I'm trying to insert a large CLOB into my oracle database via bookshelf. It's just a big string with well over 100,000 characters. Unfortunately when I save it to the DB, only 40K characters make it into the DB. No warnings are thrown. A coworker looked into this issue and said:

I looked at the strong-oracle driver code for clob's and it looks like it's auto detecting the clob type if it's sent as buffer type instead of a string type. You might try sending it in as a stream or buffer. Not exactly sure how to do that in Knex / Bookshelf though.

I'm wondering if anyone else has faced this sort of issue, and if anyone knows of a solution to it at the db driver level.

Thanks!

rpavez commented 8 years ago

+1

mcfa77y commented 8 years ago

+1