Hello
I tried a few approaches. I made the query to the server with
NamedQuery and something like :
Map map = new HashMap();
map.put( "entityName", "Apple" );
map.put( "fieldName", "numberOfWormsInTheApple" );
if (finalExpression != null ) {
map.put("whereClause", "WHERE "+finalExpression.toString());
} else {
map.put("whereClause", "");
}
NamedQuery namedQuery = new NamedQuery("SumQuery", map);
and the sql on the other end looking like :
SELECT sum($fieldName) FROM $entityName $whereClause
The query gets to the server, but an exception is thrown, what I get
suggest that there is a limit on query length in derby. I tried to
execute the long expression in squirrel, getting StackOveflowError too.
Can someone confirm that there is a limit on sql query length in
derby ? There is nothing in google about that.
Marcin
Ps: I get this from server :
java.lang.IllegalStateException: Serialized class
org.apache.derby.client.net.NetSqlca does not implement
java.io.Serializable
at com.caucho.hessian.io.JavaSerializer.<init>
(JavaSerializer.java)
at
com.caucho.hessian.io.SerializerFactory.getDefaultSerializer
(SerializerFactory.java:200)
at com.caucho.hessian.io.SerializerFactory.getSerializer
(SerializerFactory.java)
at com.caucho.hessian.io.HessianOutput.writeObject
(HessianOutput.java:315)
at com.caucho.hessian.io.JavaSerializer
$FieldSerializer.serialize(JavaSerializer.java:242)
at com.caucho.hessian.io.JavaSerializer.writeObject10
(JavaSerializer.java:175)
at com.caucho.hessian.io.JavaSerializer.writeObject
(JavaSerializer.java:157)
at com.caucho.hessian.io.ThrowableSerializer.writeObject
(ThrowableSerializer.java:71)
at com.caucho.hessian.io.HessianOutput.writeObject
(HessianOutput.java:317)
at com.caucho.hessian.io.JavaSerializer
$FieldSerializer.serialize(JavaSerializer.java:242)
at com.caucho.hessian.io.JavaSerializer.writeObject10
(JavaSerializer.java:175)
at com.caucho.hessian.io.JavaSerializer.writeObject
(JavaSerializer.java:157)
at com.caucho.hessian.io.ThrowableSerializer.writeObject
(ThrowableSerializer.java:71)
at com.caucho.hessian.io.HessianOutput.writeObject
(HessianOutput.java:317)
at com.caucho.hessian.io.HessianOutput.writeFault
(HessianOutput.java:297)
at com.caucho.hessian.server.HessianSkeleton.invoke
(HessianSkeleton.java:165)
at com.caucho.hessian.server.HessianServlet.service
(HessianServlet.java:365)
at ish.oncourse.server.CayenneServlet.service
(CayenneServlet.java:104)
at org.mortbay.jetty.servlet.ServletHolder.handle
(ServletHolder.java:428)
at org.mortbay.jetty.servlet.ServletHandler.dispatch
(ServletHandler.java:666)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service
(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext
(HttpConnection.java:982)
at org.mortbay.http.HttpConnection.handle
(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection
(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle
(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run
(ThreadPool.java:534)
On 06/12/2006, at 11:56 AM, Marcin Skladaniec wrote:
> Hi
> I create a really long org.cayenne.exp.Expression. The longest I
> created so far, had 63000 characters as string. The problem is that
> after reaching certain (not sure what size, need to test more) size
> I get:
>
> Exception in thread "Thread-8"
> org.apache.cayenne.CayenneRuntimeException: [v.3.0-incubating-
> SNAPSHOT ] Remote error. URL - http://localhost:8181/angel-server-
> cayenne
> at
> org.apache.cayenne.remote.hessian.HessianConnection.doSendMessage
> (HessianConnection.java:145)
> at org.apache.cayenne.remote.BaseConnection.sendMessage
> (BaseConnection.java:73)
> at org.apache.cayenne.remote.ClientChannel.send
> (ClientChannel.java:276)
> at org.apache.cayenne.remote.ClientChannel.onQuery
> (ClientChannel.java:110)
> at org.apache.cayenne.util.ObjectContextQueryAction.runQuery
> (ObjectContextQueryAction.java:282)
> at org.apache.cayenne.CayenneContextQueryAction.execute
> (CayenneContextQueryAction.java:51)
> at org.apache.cayenne.CayenneContext.onQuery
> (CayenneContext.java:347)
> at org.apache.cayenne.CayenneContext.performQuery
> (CayenneContext.java:336)
> at ish.oncourse.cayenne.CayenneContext.performQuery
> (CayenneContext.java:152)
> at
> ish.oncourse.print.ProfitLossPrintableObject.getTransactionsFromRecord
> s(ProfitLossPrintableObject.java:180)
> at ish.oncourse.controller.PrintController$1.construct
> (PrintController.java:263)
> at ish.oncourse.view.SwingWorker$2.run(SwingWorker.java:117)
> at java.lang.Thread.run(Thread.java:613)
> Caused by: java.lang.StackOverflowError
> at java.util.IdentityHashMap.hash(IdentityHashMap.java:283)
> at java.util.IdentityHashMap.get(IdentityHashMap.java:313)
> at com.caucho.hessian.io.HessianOutput.addRef
> (HessianOutput.java:799)
> at com.caucho.hessian.io.JavaSerializer.writeObject
> (JavaSerializer.java:134)
> at com.caucho.hessian.io.HessianOutput.writeObject
> (HessianOutput.java:317)
> at com.caucho.hessian.io.JavaSerializer
> $FieldSerializer.serialize(JavaSerializer.java:242)
> at com.caucho.hessian.io.JavaSerializer.writeObject10
> (JavaSerializer.java:175)
> at com.caucho.hessian.io.JavaSerializer.writeObject
> (JavaSerializer.java:157)
> at com.caucho.hessian.io.HessianOutput.writeObject
> (HessianOutput.java:317)
> at com.caucho.hessian.io.JavaSerializer
> $FieldSerializer.serialize(JavaSerializer.java:242)
> at com.caucho.hessian.io.JavaSerializer.writeObject10
> (JavaSerializer.java:175)
> at com.caucho.hessian.io.JavaSerializer.writeObject
> (JavaSerializer.java:157)
>
> It looks like hessian is failing to serialise the Expression. I'm I
> right ? If so I'll post them a bug report.
>
> Marcin
-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001 fax +61 2 9550 4001
This archive was generated by hypermail 2.0.0 : Tue Dec 05 2006 - 23:13:09 EST