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

<<attachment: winmail.dat>>

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply via email to