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
> [email protected]
> 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.
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
