Hello,

Anybody had any luck with Cloudscape?

Most things seem to work fine, but I couldn't do an order by, for example (field not present in result, it says... it looks like in the version I have of Cloudscape the order by is based on what the result looks like, not the table, so it can only see the internally assigned aliases).

Anyway, if anybody has any comments at all about working with Cloudscape or, better yet, has written a dialect, I would appreciate it a lot.

Thanks,

Luis

I have written a cloudscapeDialect, but it is very basic. I am also having the problem with order by. Another problem I am having is getting "Invalid Cursor State" exceptions when I run a query:

Query q = sess.createQuery("from Partner");
List list = q.list();

This results in an exception. Seems to only happen on larger tables. If the table is small, I don't seem to get the error.

Can you post it in the wiki area (with warnings), please ?