Blojsom 3.2 "search" not working (Could not execute query)

Thread: Blojsom 3.2 "search" not working (Could not execute query)

Search this list only Search all lists
Blojsom 3.2 "search" not working (Could not execute query)
United States	2007-05-04 09:25:40

Hello, I have recently installed Blojsom 3.2 on a Windows 2003 server with Tomcat 5.5.17 with Microsoft SQL (MSSQL) 2000 database. Blojsom appears to work well, however, the upper right hand corner search function does not work. ; I get the following error when I attempt a search: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.hibernate.exception.GenericJDBCException: could not execute query     ; org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)       org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)     ; org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)         org.hibernate.loader.Loader.doList(Loader.java:2148)       org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)   ;   org.hibernate.loader.Loader.list(Loader.java:2024)   ;   org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) ;     org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)         org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)       org.blojsom.fetcher.database.DatabaseFetcher.findEntries(DatabaseFetcher.java:692)     ; org.blojsom.plugin.search.SimpleSearchPlugin.process(SimpleSearchPlugin.java:108)       org.blojsom.servlet.BlojsomServlet.service(BlojsomServlet.java:253) ;     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)     ; org.blojsom.filter.PermalinkFilter.doFilter(PermalinkFilter.java:207)         org.blojsom.filter.SkipEntriesFilter.doFilter(SkipEntriesFilter.java:103) ;     org.blojsom.filter.PageFilter.doFilter(PageFilter.java:167)       org.blojsom.filter.FeedFilter.doFilter(FeedFilter.java:198) Etc……R30;……... The log files do not appear to shed much light on a solution. Couple of areas I am looking into: 1) Is the search function / plugin normally enabled by default? 2) Is this the same search function as Blojsom 2? It also appears that Blojsom 3 does not have any "properties"; files and all settings are now in the database. Anyone have any suggestions? Any help is much appreciated. Blojsom appears to be a great product and I hope to integrate this software with our internal Web portal here at the Kennedy Space Center in Florida.  We are using Jetspeed (from Apache) which is a Java app running under Tomcat also. ; Blojsom appeared to be a good match with our architecture. Michael Dalton Michael.D.Daltonnasa.gov
Re: Blojsom 3.2 "search" not working (Could not execute query)
United States	2007-05-04 09:55:27

I did a fresh install of blojsom 3.2 here, but unfortunately it was on OS X, Tomcat 5.5.23, and using MySQL. I don’t have access to Win2k3 Server and MSSQL. The search plugin is enabled by default. I added two entries and was able to search for each item and have it returned from the query box on the blog page. The search is essentially the same as in blojsom 2, but I guess better since it uses better matching with Hibernate. Let me know if I can help any further. On 5/4/07 10:25 AM, "Dalton, Michael D. (KSC)"; <michael.d.daltonnasa.gov> wrote: Hello, I have recently installed Blojsom 3.2 on a Windows 2003 server with Tomcat 5.5.17 with Microsoft SQL (MSSQL) 2000 database. Blojsom appears to work well, however, the upper right hand corner search function does not work. I get the following error when I attempt a search: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.hibernate.exception.GenericJDBCException: could not execute query     ;  org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)     ; org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)     ;  org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)       ;org.hibernate.loader.Loader.doList(Loader.java:2148)        org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)       ;org.hibernate.loader.Loader.list(Loader.java:2024)   ;    org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)       org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)        org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)        org.blojsom.fetcher.database.DatabaseFetcher.findEntries(DatabaseFetcher.java:692)       org.blojsom.plugin.search.SimpleSearchPlugin.process(SimpleSearchPlugin.java:108)       org.blojsom.servlet.BlojsomServlet.service(BlojsomServlet.java:253)   ;    javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ;      org.blojsom.filter.PermalinkFilter.doFilter(PermalinkFilter.java:207)   ;    org.blojsom.filter.SkipEntriesFilter.doFilter(SkipEntriesFilter.java:103)       org.blojsom.filter.PageFilter.doFilter(PageFilter.java:167)       org.blojsom.filter.FeedFilter.doFilter(FeedFilter.java:198) Etc……R30;……... The log files do not appear to shed much light on a solution. Couple of areas I am looking into: 1) Is the search function / plugin normally enabled by default? 2) Is this the same search function as Blojsom 2? It also appears that Blojsom 3 does not have any "properties"; files and all settings are now in the database. Anyone have any suggestions? Any help is much appreciated. Blojsom appears to be a great product and I hope to integrate this software with our internal Web portal here at the Kennedy Space Center in Florida. We are using Jetspeed (from Apache) which is a Java app running under Tomcat also. Blojsom appeared to be a good match with our architecture. Michael Dalton Michael.D.Daltonnasa.gov ------------------------------------------------------------------------- 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/ _______________________________________________ Blojsom-users mailing list Blojsom-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/blojsom-users -- David Czarnecki http://www.blojsom.com/blog/ \| http://blojsom.sf.net
Re: Blojsom 3.2 "search" not working (Could not execute query)
United States	2007-05-04 10:21:37

What is the “hibernate.dialect” property set to in the blojsom-helper-beans-include.xml file? Is it set to “org.hibernate.dialect.SQLServerDialect”? On 5/4/07 10:25 AM, "Dalton, Michael D. (KSC)"; <michael.d.daltonnasa.gov> wrote: Hello, I have recently installed Blojsom 3.2 on a Windows 2003 server with Tomcat 5.5.17 with Microsoft SQL (MSSQL) 2000 database. Blojsom appears to work well, however, the upper right hand corner search function does not work. I get the following error when I attempt a search: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.hibernate.exception.GenericJDBCException: could not execute query     ;  org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)     ; org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)     ;  org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)       ;org.hibernate.loader.Loader.doList(Loader.java:2148)        org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)       ;org.hibernate.loader.Loader.list(Loader.java:2024)   ;    org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)       org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)        org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)        org.blojsom.fetcher.database.DatabaseFetcher.findEntries(DatabaseFetcher.java:692)       org.blojsom.plugin.search.SimpleSearchPlugin.process(SimpleSearchPlugin.java:108)       org.blojsom.servlet.BlojsomServlet.service(BlojsomServlet.java:253)   ;    javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ;      org.blojsom.filter.PermalinkFilter.doFilter(PermalinkFilter.java:207)   ;    org.blojsom.filter.SkipEntriesFilter.doFilter(SkipEntriesFilter.java:103)       org.blojsom.filter.PageFilter.doFilter(PageFilter.java:167)       org.blojsom.filter.FeedFilter.doFilter(FeedFilter.java:198) Etc……R30;……... The log files do not appear to shed much light on a solution. Couple of areas I am looking into: 1) Is the search function / plugin normally enabled by default? 2) Is this the same search function as Blojsom 2? It also appears that Blojsom 3 does not have any "properties"; files and all settings are now in the database. Anyone have any suggestions? Any help is much appreciated. Blojsom appears to be a great product and I hope to integrate this software with our internal Web portal here at the Kennedy Space Center in Florida. We are using Jetspeed (from Apache) which is a Java app running under Tomcat also. Blojsom appeared to be a good match with our architecture. Michael Dalton Michael.D.Daltonnasa.gov ------------------------------------------------------------------------- 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/ _______________________________________________ Blojsom-users mailing list Blojsom-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/blojsom-users -- David Czarnecki http://www.blojsom.com/blog/ \| http://blojsom.sf.net
Re: Blojsom 3.2 "search" not working (Could not execute query)
United States	2007-05-04 10:22:40

Also, are you using the latest jTDS driver? <http://sourceforge.net/project/showfiles.php?group_id=33291> On 5/4/07 10:25 AM, "Dalton, Michael D. (KSC)"; <michael.d.daltonnasa.gov> wrote: Hello, I have recently installed Blojsom 3.2 on a Windows 2003 server with Tomcat 5.5.17 with Microsoft SQL (MSSQL) 2000 database. Blojsom appears to work well, however, the upper right hand corner search function does not work. I get the following error when I attempt a search: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.hibernate.exception.GenericJDBCException: could not execute query     ;  org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)     ; org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)     ;  org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)       ;org.hibernate.loader.Loader.doList(Loader.java:2148)        org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)       ;org.hibernate.loader.Loader.list(Loader.java:2024)   ;    org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)       org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)        org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)        org.blojsom.fetcher.database.DatabaseFetcher.findEntries(DatabaseFetcher.java:692)       org.blojsom.plugin.search.SimpleSearchPlugin.process(SimpleSearchPlugin.java:108)       org.blojsom.servlet.BlojsomServlet.service(BlojsomServlet.java:253)   ;    javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ;      org.blojsom.filter.PermalinkFilter.doFilter(PermalinkFilter.java:207)   ;    org.blojsom.filter.SkipEntriesFilter.doFilter(SkipEntriesFilter.java:103)       org.blojsom.filter.PageFilter.doFilter(PageFilter.java:167)       org.blojsom.filter.FeedFilter.doFilter(FeedFilter.java:198) Etc……R30;……... The log files do not appear to shed much light on a solution. Couple of areas I am looking into: 1) Is the search function / plugin normally enabled by default? 2) Is this the same search function as Blojsom 2? It also appears that Blojsom 3 does not have any "properties"; files and all settings are now in the database. Anyone have any suggestions? Any help is much appreciated. Blojsom appears to be a great product and I hope to integrate this software with our internal Web portal here at the Kennedy Space Center in Florida. We are using Jetspeed (from Apache) which is a Java app running under Tomcat also. Blojsom appeared to be a good match with our architecture. Michael Dalton Michael.D.Daltonnasa.gov ------------------------------------------------------------------------- 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/ _______________________________________________ Blojsom-users mailing list Blojsom-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/blojsom-users -- David Czarnecki http://www.blojsom.com/blog/ \| http://blojsom.sf.net
Re: Blojsom 3.2 "search" not working (Could not execute query)
United States	2007-05-04 11:57:29

Here is the entry for hibernateProperties inside my blojsom-helper-beans-include.xml file: ; <property name="hibernateProperties"> <props> <prop key="c3p0.min_size">10</prop> <prop key="c3p0.max_size">50</prop> <prop key="c3p0.timeout">1800</prop> <prop key="c3p0.max_statements">100</prop> <prop key="show_sql">false</prop> <prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop> <!-- <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop> --> </props> </property> I also noticed the following line at the end which is commented out: <!-- net.sourceforge.jtds.jdbc.Driver"/> --> From: blojsom-users-bounceslists.sourceforge.net [mailto:blojsom-users-bounceslists.sourceforge.net] On Behalf Of David Czarnecki Sent: Friday, May 04, 2007 11:22 AM To: blojsom-users Subject: Re: [Blojsom-users] Blojsom 3.2 "search" not working (Could not execute query) What is the “hibernate.dialect” property set to in the blojsom-helper-beans-include.xml file? Is it set to “org.hibernate.dialect.SQLServerDialect”? On 5/4/07 10:25 AM, "Dalton, Michael D. (KSC)" <michael.d.daltonnasa.gov> wrote: Hello, I have recently installed Blojsom 3.2 on a Windows 2003 server with Tomcat 5.5.17 with Microsoft SQL (MSSQL) 2000 database. Blojsom appears to work well, however, the upper right hand corner search function does not work. I get the following error when I attempt a search: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.hibernate.exception.GenericJDBCException: could not execute query         org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)   ;    org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)     ; org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) ;      org.hibernate.loader.Loader.doList(Loader.java:2148)       org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)         org.hibernate.loader.Loader.list(Loader.java:2024)         org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)       ;org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533) ;     org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)     ; org.blojsom.fetcher.database.DatabaseFetcher.findEntries(DatabaseFetcher.java:692)       org.blojsom.plugin.search.SimpleSearchPlugin.process(SimpleSearchPlugin.java:108) ;      org.blojsom.servlet.BlojsomServlet.service(BlojsomServlet.java:253) ;       javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ;     org.blojsom.filter.PermalinkFilter.doFilter(PermalinkFilter.java:207)       org.blojsom.filter.SkipEntriesFilter.doFilter(SkipEntriesFilter.java:103)     ; org.blojsom.filter.PageFilter.doFilter(PageFilter.java:167)        org.blojsom.filter.FeedFilter.doFilter(FeedFilter.java:198) Etc……R30;……... The log files do not appear to shed much light on a solution. Couple of areas I am looking into: 1) Is the search function / plugin normally enabled by default? 2) Is this the same search function as Blojsom 2? It also appears that Blojsom 3 does not have any "properties" files and all settings are now in the database. Anyone have any suggestions? Any help is much appreciated. Blojsom appears to be a great product and I hope to integrate this software with our internal Web portal here at the Kennedy Space Center in Florida. We are using Jetspeed (from Apache) which is a Java app running under Tomcat also. Blojsom appeared to be a good match with our architecture. Michael Dalton Michael.D.Daltonnasa.gov ------------------------------------------------------------------------- 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/ _______________________________________________ Blojsom-users mailing list Blojsom-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/blojsom-users -- David Czarnecki http://www.blojsom.com/blog/ \| http://blojsom.sf.net
Re: Blojsom 3.2 "search" not working (Could not execute query)
United States	2007-05-04 11:57:23

Yes, we are using JTDS 1.2. From: blojsom-users-bounceslists.sourceforge.net [mailto:blojsom-users-bounceslists.sourceforge.net] On Behalf Of David Czarnecki Sent: Friday, May 04, 2007 11:23 AM To: blojsom-users Subject: Re: [Blojsom-users] Blojsom 3.2 "search" not working (Could not execute query) Also, are you using the latest jTDS driver? <http://sourceforge.net/project/showfiles.php?group_id=33291> On 5/4/07 10:25 AM, "Dalton, Michael D. (KSC)" <michael.d.daltonnasa.gov> wrote: Hello, I have recently installed Blojsom 3.2 on a Windows 2003 server with Tomcat 5.5.17 with Microsoft SQL (MSSQL) 2000 database. Blojsom appears to work well, however, the upper right hand corner search function does not work. I get the following error when I attempt a search: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.hibernate.exception.GenericJDBCException: could not execute query         org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)   ;    org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)     ; org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) ;      org.hibernate.loader.Loader.doList(Loader.java:2148)       org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)         org.hibernate.loader.Loader.list(Loader.java:2024)         org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)       ;org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533) ;     org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)     ; org.blojsom.fetcher.database.DatabaseFetcher.findEntries(DatabaseFetcher.java:692)       org.blojsom.plugin.search.SimpleSearchPlugin.process(SimpleSearchPlugin.java:108) ;      org.blojsom.servlet.BlojsomServlet.service(BlojsomServlet.java:253) ;       javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ;     org.blojsom.filter.PermalinkFilter.doFilter(PermalinkFilter.java:207)       org.blojsom.filter.SkipEntriesFilter.doFilter(SkipEntriesFilter.java:103)     ; org.blojsom.filter.PageFilter.doFilter(PageFilter.java:167)        org.blojsom.filter.FeedFilter.doFilter(FeedFilter.java:198) Etc……R30;……... The log files do not appear to shed much light on a solution. Couple of areas I am looking into: 1) Is the search function / plugin normally enabled by default? 2) Is this the same search function as Blojsom 2? It also appears that Blojsom 3 does not have any "properties" files and all settings are now in the database. Anyone have any suggestions? Any help is much appreciated. Blojsom appears to be a great product and I hope to integrate this software with our internal Web portal here at the Kennedy Space Center in Florida. We are using Jetspeed (from Apache) which is a Java app running under Tomcat also. Blojsom appeared to be a good match with our architecture. Michael Dalton Michael.D.Daltonnasa.gov ------------------------------------------------------------------------- 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/ _______________________________________________ Blojsom-users mailing list Blojsom-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/blojsom-users -- David Czarnecki http://www.blojsom.com/blog/ \| http://blojsom.sf.net

[1-6]

about | contact Other archives ( Real Estate discussion Medical topics )