Hi, sorry it's pretty unreadeable. You should check if any ) is missing somewhere.
Lvc@ On 18 February 2014 14:32, prabhat <[email protected]> wrote: > This query works fine in console, but fails in bulk > > INSERT INTO US_simplified_data (patent_id, national_class, title, status, > time_stamp, kind, iso_date, ipc_version, inventors, international_class, > further_national_class, further_international_class, date, country, > citations, assignees, applicants, abstract) VALUES ('06428505','604 > 80','In-line IV drug delivery pack with controllable dilution','not > found','1028592000','B1','2002-08-06T00:00:00Z','7','[ { \"city\" : > \"Napa\", \"first_name\" : \"Michael A.\", \"last_name\" : \"Taylor\", > \"name\" : \"Michael A. Taylor\", \"country\" : \"not found\", \"pincode\" > : \"not found\", \"state\" : \"CA\" } ]','A61M 514','[ \"604 83\", \"604 > 85\" ]','[]','20020806','US','[ { \"kind\" : \"A\", \"country\" : \"not > found\", \"inventor_name\" : \"Iversen et al.\", \"patent_id\" : > \"3276458\", \"date\" : \"19661000\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Huppen\", \"patent_id\" : \"3517816\", \"date\" : \"19700600\", \"class\" > : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Herrmann\", \"patent_id\" : \"3730349\", \"date\" : > \"19730500\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" > : \"not found\", \"inventor_name\" : \"Akcasu\", \"patent_id\" : > \"4070289\", \"date\" : \"19780100\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Harris, Jr.\", \"patent_id\" : \"4160727\", \"date\" : \"19790700\", > \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not > found\", \"inventor_name\" : \"Keil\", \"patent_id\" : \"4231872\", > \"date\" : \"19801100\", \"class\" : \"not found\" }, { \"kind\" : \"A\", > \"country\" : \"not found\", \"inventor_name\" : \"Berry, III et al.\", > \"patent_id\" : \"4280912\", \"date\" : \"19810700\", \"class\" : \"not > found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Hart\", \"patent_id\" : \"4396383\", \"date\" : > \"19830800\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" > : \"not found\", \"inventor_name\" : \"Lyons\", \"patent_id\" : > \"4458733\", \"date\" : \"19840700\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Kaufman\", \"patent_id\" : \"4484920\", \"date\" : \"19841100\", > \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not > found\", \"inventor_name\" : \"Bohman et al.\", \"patent_id\" : > \"4507114\", \"date\" : \"19850300\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Theeuwes\", \"patent_id\" : \"4511351\", \"date\" : \"19850400\", > \"class\" : \"604246\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Wolfe et al.\", \"patent_id\" : \"4533348\", \"date\" > : \"19850800\", \"class\" : \"137268\" }, { \"kind\" : \"A\", \"country\" : > \"not found\", \"inventor_name\" : \"Geller\", \"patent_id\" : \"4534757\", > \"date\" : \"19850800\", \"class\" : \"604126\" }, { \"kind\" : \"A\", > \"country\" : \"not found\", \"inventor_name\" : \"Moss\", \"patent_id\" : > \"4576603\", \"date\" : \"19860300\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Makinen et al.\", \"patent_id\" : \"4648978\", \"date\" : \"19870300\", > \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not > found\", \"inventor_name\" : \"Berglund et al.\", \"patent_id\" : > \"4695272\", \"date\" : \"19870900\", \"class\" : \"604252\" }, { \"kind\" > : \"A\", \"country\" : \"not found\", \"inventor_name\" : \"Matsuzaki et > al.\", \"patent_id\" : \"4698153\", \"date\" : \"19871000\", \"class\" : > \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Hambleton et al.\", \"patent_id\" : \"4784763\", > \"date\" : \"19881100\", \"class\" : \"not found\" }, { \"kind\" : \"A\", > \"country\" : \"not found\", \"inventor_name\" : \"Trasen\", \"patent_id\" > : \"4810388\", \"date\" : \"19890300\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : \"Taylor > et al.\", \"patent_id\" : \"4871463\", \"date\" : \"19891000\", \"class\" : > \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Sumnitsch\", \"patent_id\" : \"4903717\", \"date\" : > \"19900200\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" > : \"not found\", \"inventor_name\" : \"Ikeda\", \"patent_id\" : > \"4994056\", \"date\" : \"19910200\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : \"Bosko > et al.\", \"patent_id\" : \"5004535\", \"date\" : \"19910400\", \"class\" : > \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Jha et al.\", \"patent_id\" : \"5032265\", \"date\" : > \"19910700\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" > : \"not found\", \"inventor_name\" : \"Marius et al.\", \"patent_id\" : > \"5059317\", \"date\" : \"19911000\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"McElveen, Jr. et al.\", \"patent_id\" : \"5163922\", \"date\" : > \"19921100\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" > : \"not found\", \"inventor_name\" : \"Taylor\", \"patent_id\" : > \"5259954\", \"date\" : \"19931100\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Berglund\", \"patent_id\" : \"5395323\", \"date\" : \"19950300\", > \"class\" : \"604 84\" }, { \"kind\" : \"A\", \"country\" : \"not found\", > \"inventor_name\" : \"Morris\", \"patent_id\" : \"5429603\", \"date\" : > \"19950700\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" > : \"not found\", \"inventor_name\" : \"O\'Neil et al.\", \"patent_id\" : > \"5637087\", \"date\" : \"19970600\", \"class\" : \"not found\" }, { > \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : > \"Michaels, Jr.\", \"patent_id\" : \"5685846\", \"date\" : \"19971100\", > \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not > found\", \"inventor_name\" : \"Taylor\", \"patent_id\" : \"5725777\", > \"date\" : \"19980300\", \"class\" : \"210232\" } ]','[ { \"city\" : > \"Napa\", \"name\" : \"PrisMedical Corporation\", \"country\" : \"not > found\" } ]','[]','An in-line drug delivery pack that connects in-line with > an intravenous line and allows for the mixing of diluent with a drug > reagent to be delivered to the patient. An internal drug bed bypass > mechanism is tailored to apportion diluent flow between the bypass and the > drug bed. The apportionment is selected to achieve a solution concentration > suitable for IV administration as the dried reagent is dissolved. Thus, > both dissolution and precisely tailored dilution are performed in the same > simple device.' ) > > Prabhat Kumar Singh > > > > On Tue, Feb 18, 2014 at 6:59 PM, Luca Garulli <[email protected]> wrote: > >> What query? >> >> Lvc@ >> >> >> On 18 February 2014 14:25, Shishya <[email protected]> wrote: >> >>> Luca, >>> >>> even though I add a space after the ), I get the same error. >>> Any workarounds please >>> >>> regards >>> >>> >>> On Thursday, October 11, 2012 5:00:59 PM UTC+5:30, Meerkatzenwildschwein >>> wrote: >>>> >>>> I've changed this as you described. Now it works. Thanks! >>>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OrientDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> -- >> >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "OrientDB" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/orient-database/N33PMS9uzAc/unsubscribe >> . >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
