Is there no one to help?. If there is anyone then i have an update that i am now able to successfully create the vertex but still there is a similar issue that after creating around 1500 vertex, it again generates a 500 server error. Please help me.
On Tuesday, January 5, 2016 at 12:34:49 PM UTC+5, [email protected] wrote: > > Hi, I am writing a SSIS script component for importing data into orientdb > using RestAPI but i am getting error 500. Please i am stuck here. Is there > anyone who can help me with this. > Here is my code so far. > Uri address = new Uri("http://localhost:2480//command/EQS-DB/sql/ > "); > HttpWebRequest request = WebRequest.Create(address) as > HttpWebRequest; > request.Method = "POST"; > request.Accept = "application/json; charset=UTF-8"; > request.ContentType = "application/json"; > string username = "root"; > string password = "***"; > String encoded = > System.Convert.ToBase64String(System.Text.Encoding.GetEncoding("ISO-8859-1").GetBytes(username > > + ":" + password)); > request.Headers.Add("Authorization", "Basic " + encoded); > StringBuilder data = new StringBuilder(); > // string link = "{\"statements\" : [ {\"statement\" : \"CREATE ( > company: Accounts { Name:" + Row.companyname + "} ) RETURN company\"} ]}"; > string link= "CREATE VERTEX Contacts CONTENT { 'name' : "+ > Row.fullname+", 'Email' : "+ Row.emailaddress1+", 'Phone' : "+ > Row.telephone1 + ", 'ContactId' : "+ Row.contactid+", 'City' : > "+Row.address1city+"}" ; > data.Append(HttpUtility.UrlEncode(link)); > // Create a byte array of the data we want to send > byte[] byteData = UTF8Encoding.UTF8.GetBytes(data.ToString()); > // Set the content length in the request headers > request.ContentLength = byteData.Length; > request.Headers.Add("Accept-Encoding", "gzip,deflate"); > using (Stream postStream = request.GetRequestStream()) > { > postStream.Write(byteData, 0, byteData.Length); > } > // Get response > using (HttpWebResponse response = request.GetResponse() as > HttpWebResponse) > { > // Get the response stream > StreamReader reader = new > StreamReader(response.GetResponseStream()); > // Console application output > Console.WriteLine(reader.ReadToEnd()); > } > It will be a great help if anyone can point the issue. Thank you > -- --- 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/d/optout.
