I tried with postgress as well but same error. I dont think this is a dialect issue. It happens when hibernate is trying to close the querystatement. Here is the trace java.sql.SQLException: Method not supported, sorry! at nl.cwi.monetdb.jdbc.MonetStatement.getQueryTimeout(MonetStatement.java:538) at org.apache.commons.dbcp.DelegatingStatement.getQueryTimeout(DelegatingStatement.java:243) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:273) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:209) at org.hibernate.loader.Loader.doQuery(Loader.java:714) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:888) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:839) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:830) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:822) Can you return a negative value instead of throwing an exception? Thanks for the quick response. MonetDB is really giving my 10x boost but i wish i can get it working with hibernate. Thanks Bharani Fabian Groffen wrote:
On 18-07-2007 04:27:39 -0700, Bharani wrote:
Hi
I am trying to make monetdb work with hibernate using existing mysql dialect. When i do a simple select it actually returns the value but i get an exception saying
I think you better start with the postgresql dialect, as we're more close to that one.
Method not supported,Sorry!
for nl.cwi.monetdb.jdbc.MonetStatement.getQueryTimeout
any reason why it is being thrown
Uhm... yeah, because I don't know how to implement that function. To make sure that users of it will know that it won't work I decided to throw an SQLException. Is hibernate configurable in this regard?
Thanks for the feedback!
------------------------------------------------------------------------- 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-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- View this message in context: http://www.nabble.com/Query-Timeout-tf4102673.html#a11667934 Sent from the monetdb-developers mailing list archive at Nabble.com.