Skip to Main Content

NoSQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error: create tables and insert into oracle nosql db

2924628Apr 6 2015 — edited Apr 21 2015

Hi! i'm Tin, can i ask you some questions?

I using oracle nosql db 12cR1 on oracle linux 6.4, it run really stable, but i have some problem when i create tables(datatype Date) and insert data into nosql db. I have fixed many way but not effective. please help me! Thanks!

The Error below:

Error 1:

kv-> table create -name customers

customers-> add-field -name userId -type string

customers-> add-field -name fullname -type string

customers-> add-field -name birthday -type DATE

Invalid argument: DATE

  Usage: add-field -type <type> -name <name> [-not-nullable]

  [-default <value>] [-max <value>] [-min <value>]

  [-max-exclusive] [-min-exclusive] [-desc <description>]

  [-size <size>] [-enum-values <value[,value[,...]]>]

  <type>: INTEGER, LONG, DOUBLE, FLOAT, STRING, BOOLEAN, BINARY,

  FIXED_BINARY, ENUM.

Error 2: I have User table, and cerate extra child table is User.Folder table.....but i cannot insert into data this table

kv-> put table -name User.Folder

User.Folder-> add-value -field folderId -value F1

User.Folder-> add-value -field name -value Report.rar

User.Folder-> show

{

  "folderId" : "F1",

  "name" : "Report.rar"

}

User.Folder-> exit

Error handling command exit: Primary key fields are specified out of order

User.Folder->

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2015
Added on Apr 6 2015
22 comments
5,630 views