SODA 1.1.27\n\n Support for 23ai JSON collection table (new default collection on 23ai with compatible 23 or higher)\n Support for Duality Views\n Indexing and orderbys on JSON type\n New item methods\n Changed required dependencies from javax.json to jakarta.json (new JSONP API and its Parsson implementation)\n Bug fixes\n<\/code><\/pre>\n\n\n\nUsing the old version<\/p>\n\n\n\n![\"\"](\"https:\/\/adrianotanaka.com.br\/wp-content\/uploads\/2024\/11\/image-2.png\")
<\/figure>\n\n\n\nUsing orajsoda > 1.1.27<\/p>\n\n\n\n![\"\"](\"https:\/\/adrianotanaka.com.br\/wp-content\/uploads\/2024\/11\/image-1.png\")
<\/figure>\n\n\n\npom.xml to work with orajsoda 1.127, you must use the jakarta.json <\/p>\n\n\n\n
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\"\n xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n <modelVersion>4.0.0<\/modelVersion>\n <artifactId>soda-parent<\/artifactId>\n <groupId>com.oracle.database.soda<\/groupId>\n <version>${revision}<\/version>\n <packaging>pom<\/packaging>\n <name>parent<\/name>\n\n <modules>\n <module>orajsoda<\/module>\n <\/modules>\n\n <properties>\n <outputDirectory>..\/lib<\/outputDirectory>\n <excludes>**\/*.ade_path\/**<\/excludes>\n <label>github<\/label>\n <revision>1.1.27<\/revision>\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n <maven.compiler.source>1.8<\/maven.compiler.source>\n <maven.compiler.target>1.8<\/maven.compiler.target>\n <\/properties>\n\n <build>\n <finalName>${project.artifactId}<\/finalName>\n <plugins>\n <plugin>\n <artifactId>maven-compiler-plugin<\/artifactId>\n <version>3.8.0<\/version>\n <configuration>\n <excludes>\n <exclude>${excludes}<\/exclude>\n <\/excludes>\n <testExcludes>\n <exclude>${excludes}<\/exclude>\n <\/testExcludes>\n <\/configuration>\n <\/plugin>\n <plugin>\n <artifactId>maven-clean-plugin<\/artifactId>\n <version>3.1.0<\/version>\n <configuration>\n <filesets>\n <fileset>\n <directory>lib<\/directory>\n <includes>\n <include>*.jar<\/include>\n <\/includes>\n <followSymlinks>false<\/followSymlinks>\n <\/fileset>\n <\/filesets>\n <\/configuration>\n <\/plugin>\n <plugin>\n <groupId>org.apache.maven.plugins<\/groupId>\n <artifactId>maven-dependency-plugin<\/artifactId>\n <version>3.2.0<\/version>\n <executions>\n <execution>\n <id>copy-dependencies<\/id>\n <phase>package<\/phase>\n <goals>\n <goal>copy<\/goal>\n <\/goals>\n <inherited>false<\/inherited>\n <configuration>\n <artifactItems>\n <artifactItem>\n <groupId>jakarta.json<\/groupId>\n <artifactId>jakarta.json-api<\/artifactId>\n <version>2.1.3<\/version>\n <outputDirectory>lib<\/outputDirectory>\n <\/artifactItem>\n <artifactItem>\n <groupId>org.eclipse.parsson<\/groupId>\n <artifactId>jakarta.json<\/artifactId>\n <version>1.1.5<\/version>\n <outputDirectory>lib<\/outputDirectory>\n <\/artifactItem>\n <artifactItem>\n <groupId>javax.json<\/groupId>\n <artifactId>javax.json-api<\/artifactId>\n <version>1.1.4<\/version>\n <outputDirectory>lib<\/outputDirectory>\n <\/artifactItem>\n <artifactItem>\n <groupId>com.oracle.database.jdbc<\/groupId>\n <artifactId>ojdbc8<\/artifactId>\n <version>23.3.0.23.09<\/version>\n <outputDirectory>lib<\/outputDirectory>\n <\/artifactItem>\n <artifactItem>\n <groupId>junit<\/groupId>\n <artifactId>junit<\/artifactId>\n <version>3.8.1<\/version>\n <outputDirectory>lib<\/outputDirectory>\n <\/artifactItem>\n <\/artifactItems>\n <\/configuration>\n <\/execution>\n <\/executions>\n <\/plugin>\n <\/plugins>\n <\/build>\n\n\n <dependencies>\n\n <dependency>\n <groupId>org.eclipse.parsson<\/groupId>\n <artifactId>parsson<\/artifactId>\n <version>1.1.7<\/version>\n <\/dependency>\n\n\n <dependency>\n <groupId>jakarta.json<\/groupId>\n <artifactId>jakarta.json-api<\/artifactId>\n <version>2.1.3<\/version>\n <\/dependency>\n\n\n <dependency>\n <groupId>jakarta.json<\/groupId>\n <artifactId>jakarta.json-tck<\/artifactId>\n <version>2.1.1<\/version>\n <type>pom<\/type>\n <\/dependency>\n\n \n\n <dependency>\n <groupId>com.oracle.database.jdbc<\/groupId>\n <artifactId>ojdbc11-production<\/artifactId>\n <version>23.5.0.24.07<\/version>\n <type>pom<\/type>\n <\/dependency>\n\n <\/dependencies>\n<\/project><\/code><\/pre>\n\n\n\nAll the MongoDB API commands are working with this collection:<\/p>\n\n\n\n![\"\"](\"https:\/\/adrianotanaka.com.br\/wp-content\/uploads\/2024\/11\/image006-1024x197.png\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n![\"\"](\"https:\/\/adrianotanaka.com.br\/wp-content\/uploads\/2024\/11\/image007-1024x298.png\")
<\/figure>\n\n\n\nKeeping your application updated to the latest version is crucial for several reasons,updates often introduce new features and enhancements that can provide a better user experience and increase your productivity. By ensuring your application is always up-to-date, you can avoid compatibility issues with other software and benefit from the latest innovations and improvements.<\/p>\n\n\n\n
In short, regularly updating your application ensures it remains secure, efficient, and equipped with the latest features to meet your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"
I was assisting a customer with an issue related to the SODA\/MongoDB API. They were encountering the ORA-40842 error in Autonomous Database – Shared (19c). After several troubleshooting sessions, we determined that updating the application driver to the latest version resolves the problem. For Java, specifically, you need orajsoda-1.1.27(or newer) to accommodate some internal changes […]<\/p>\n","protected":false},"author":1,"featured_media":1414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"material-hide-sections":[],"footnotes":""},"categories":[55,56,45,54,6,57],"tags":[],"class_list":["post-1410","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-api","category-atp","category-database","category-mongo","category-oracle","category-soda"],"_links":{"self":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1410"}],"version-history":[{"count":4,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1410\/revisions"}],"predecessor-version":[{"id":1421,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1410\/revisions\/1421"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/media\/1414"}],"wp:attachment":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}