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.
