soda-for-java
soda-for-java copied to clipboard
oracle
SODA (Simple Oracle Document Access) for Java is an Oracle library for writing Java apps that work with JSON (and not only JSON!) in the Oracle Database. SODA allows your Java app to use the Oracle Da...
OracleRDBMSMetadataBuilder support for keyColumn path field - to support Mongo collection creation
Mongo compatible collection creation on 19c using ords PUT against /ords/admin/soda/latest/< collectionname > may look similar to ... {"contentColumn":{"name":"DATA"},"keyColumn":{"name":"ID","sqlType":"VARCHAR2","maxLength":255,"assignmentMethod":"EMBEDDED_OID","path":"_id"},"versionColumn":{"name":"VERSION","method":"UUID"},"lastModifiedColumn":{"name":"LAST_MODIFIED"},"creationTimeColumn":{"name":"CREATED_ON"}} OracleRDBMSMetadataBuilder doesn't appear to support that path parameter override.
Hi, The client only support JDBC connections, and now R2DBC would be great. Regards
When trying to create a new document collection and save a new document with the 19.3 JDBC drivers, I received the following exception when calling `insertAndGet`: ``` oracle.soda.OracleException: Error occurred...
When doing `collection.find().key(key).mergeOne(documentToMerge)` where `documentToMerge.contentAsString.length` > 4000 the json_document column is set to null without any exception or error The JSON_DOCUMENT column is of type BLOB, see metadata below. Jdbc-driver...
It's not clear what combination of driver version to use for soda 1.1.7 and 21c and collection is using the new oracle "JSON" data type. Using ver ojdbc10 - 19.8.00...
In the SODA driver the batch size used in the PreparedStatement for persisting a collection of documents is hardcoded to 100. It would be a useful addition to enable the...
I am working in migrating from mongo to oracle SODA, some of the operations that are supported in mongo are not available in Oracle ,so struggling to find a workaround....
`OracleCursor` should be enabled to to be used in the Java for-each loop as well as the Java 8 forEach() streams implementation. The `.getCursor()` operation will return a cursor to...
SODA has a small dependency on java.activation: ./src/oracle/soda/rdbms/impl/OracleDocumentImpl.java: import javax.activation.MimeType; ./src/oracle/soda/rdbms/impl/OracleDocumentImpl.java: import javax.activation.MimeTypeParseException; This Java EE module is deprecated for removal in Java 9 and will be removed from the...
