[Monetdb-developers] Query Timeout
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 Method not supported,Sorry! for nl.cwi.monetdb.jdbc.MonetStatement.getQueryTimeout any reason why it is being thrown Thanks Bharani -- View this message in context: http://www.nabble.com/Query-Timeout-tf4102673.html#a11666902 Sent from the monetdb-developers mailing list archive at Nabble.com.
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!
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.
On 18-07-2007 05:47:41 -0700, Bharani wrote:
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)
[snip]
Can you return a negative value instead of throwing an exception?
I could, but getQueryTimeout() I can have working, because that's always zero in our case. Returning an negative number would violate the interface.
Thanks for the quick response. MonetDB is really giving my 10x boost but i wish i can get it working with hibernate.
I'll fix getQueryTimeout in CVS current (HEAD). In 10 minutes it should be done. Do you work with the CVS sources?
Currently i work with the stable release not cvs. But i can try. I will find out how to check out and work with the cvs directly. Thanks a ton for the help. Really appreciate it Bharani Fabian Groffen wrote:
On 18-07-2007 05:47:41 -0700, Bharani wrote:
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)
[snip]
Can you return a negative value instead of throwing an exception?
I could, but getQueryTimeout() I can have working, because that's always zero in our case. Returning an negative number would violate the interface.
Thanks for the quick response. MonetDB is really giving my 10x boost but i wish i can get it working with hibernate.
I'll fix getQueryTimeout in CVS current (HEAD). In 10 minutes it should be done. Do you work with the CVS sources?
------------------------------------------------------------------------- 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#a11668170 Sent from the monetdb-developers mailing list archive at Nabble.com.
On 18-07-2007 05:57:49 -0700, Bharani wrote:
Currently i work with the stable release not cvs. But i can try. I will find out how to check out and work with the cvs directly.
You can reduce your efforts by only checking out the clients module from current CVS and running `ant jar_jdbc` in the src/java/ directory. That will build the JDBC driver in the jars/ subdirectory. The current JDBC driver should work with stable MonetDB 5.
Thanks a ton for the help. Really appreciate it
We would appreciate it if you could share your efforts to make MonetDB work with Hibernate. Do you think that's possible?
Sure , i dont see any problems with that Fabian Groffen wrote:
On 18-07-2007 05:57:49 -0700, Bharani wrote:
Currently i work with the stable release not cvs. But i can try. I will find out how to check out and work with the cvs directly.
You can reduce your efforts by only checking out the clients module from current CVS and running `ant jar_jdbc` in the src/java/ directory. That will build the JDBC driver in the jars/ subdirectory. The current JDBC driver should work with stable MonetDB 5.
Thanks a ton for the help. Really appreciate it
We would appreciate it if you could share your efforts to make MonetDB work with Hibernate. Do you think that's possible?
------------------------------------------------------------------------- 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#a11668358 Sent from the monetdb-developers mailing list archive at Nabble.com.
participants (2)
-
Bharani -
Fabian Groffen