Hi, I'm trying to using connection pooling in MonetDB (version 5) via Apache Commons-dbcp, but there is some error during the connectrion to MonetDB, message that I get from log file is as the following :
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted ...... Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: writable mode not supported ... 64 more
Can anyone show me the correct way to implement connection pooling with MonetDB ? Or it is not supported in the current release of MonetDB ?
Beside, I also found that the aliased columns not recognized after "group by... order by", my SQL statement could as the following...
SELECT name AS n FROM students ORDER BY name;
And the error message I get was ORDER BY: no such column "name".
Im very new to MonetDB, and wants to used it with Modrian OLAP for reporting purposes, I really appreciate any help in this. Thanks
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 5/22/2007 3:49 PM