I’m trying to run a simple QueryRequest but I keep seeing the following error:
{“Unexpected character encountered while parsing value: <. Path ‘’, line 0, position 0.”}
Here is the code I’m using to produce this:
// create my bucket using a helper
var bucket = CouchbaseManager.Instance.GetBucket("MyBucket");
// simple test to verify my connection is working
var test = bucket.GetDocument<string>("1");
// create query request
var queryRequest = new QueryRequest().Statement("SELECT * FROM 'MyBucket' LIMIT 10");
var results = bucket.Query<dynamic>(queryRequest);
Interestingly, results.Status is Success and both errors and warnings collection are empty. However, if I look at Success property; it reports false. Also the exception reads as above.
The one unique angle is that I’m using my own Json serializer. So whenever data goes into couchbase, it looks uses this:
public static string Serialize<TValue>(TValue value) where TValue : class
{
var ms = new MemoryStream();
var serializer = new DataContractJsonSerializer(typeof(TValue));
serializer.WriteObject(ms, value);
var json = Encoding.Default.GetString(ms.ToArray());
ms.Dispose();
return json;
}
I’m guessing query request may be trying to use its own deserializer and not respecting my DataContractJsonSerializer. I tried to use bucket.Query<string>
and bucket.Query<object>
to see if I could work around this.
Anyone have any suggestions?
Thanks.