5 Replies Latest reply on Nov 7, 2008 2:20 PM by Orlando

    MS SQL with Jboss Forums

    Orlando Newbie

      Hi everyone:

      I have installed Jboss forums 1.10 alpha in jboss portal 2.6.4 with MS SQL 2000, but it does not seem to work.

      Does someone know if the forums portlet will have MS SQL support?

        • 1. Re: MS SQL with Jboss Forums
          Ryszard Kozmik Master

          Hi

          Define "does not work" please. Any Exceptions, information from logs and what happens ? It should work on MS SQL.

          Regards
          ------------------
          Ryszard Kozmik
          JBoss Forums Lead
          JBoss Labs Team

          • 2. Re: MS SQL with Jboss Forums
            Orlando Newbie

            Ok, sorry for my lack of information,

            I'm deploying the EAR in the deploy directory, I start the jboss portal and the new tables are created in the MS SQL database.

            I make a post and content isn't saved. It saves the post but every post i do are empty.

            when i try to enter the forum the log shows this:

            2008-04-17 13:31:51,453 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
            2008-04-17 13:31:51,453 DEBUG [org.hibernate.SQL] select top 2147483646 topicimpl0_.jbp_id as jbp1_374_0_, posterimpl1_.jbp_id as jbp1_372_1_, topicimpl0_.jbp_forum_id as jbp2_374_0_, topicimpl0_.jbp_view_count as jbp3_374_0_, topicimpl0_.jbp_replies as jbp4_374_0_, topicimpl0_.jbp_last_post_date as jbp5_374_0_, topicimpl0_.jbp_poster as jbp6_374_0_, topicimpl0_.jbp_type as jbp7_374_0_, topicimpl0_.jbp_status as jbp8_374_0_, topicimpl0_.jbp_subject as jbp9_374_0_, topicimpl0_.jbp_poll as jbp10_374_0_, posterimpl1_.jbp_user_id as jbp2_372_1_, posterimpl1_.jbp_post_count as jbp3_372_1_ from jbp_forums_topics topicimpl0_ inner join jbp_forums_posters posterimpl1_ on topicimpl0_.jbp_poster=posterimpl1_.jbp_id where topicimpl0_.jbp_forum_id=? and topicimpl0_.jbp_type=? order by topicimpl0_.jbp_last_post_date desc
            2008-04-17 13:31:51,468 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
            2008-04-17 13:31:51,468 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
            2008-04-17 13:31:51,468 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
            2008-04-17 13:31:51,468 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
            2008-04-17 13:31:51,468 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
            2008-04-17 13:31:51,468 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select topicimpl0_.jbp_id as jbp1_374_0_, posterimpl1_.jbp_id as jbp1_372_1_, topicimpl0_.jbp_forum_id as jbp2_374_0_, topicimpl0_.jbp_view_count as jbp3_374_0_, topicimpl0_.jbp_replies as jbp4_374_0_, topicimpl0_.jbp_last_post_date as jbp5_374_0_, topicimpl0_.jbp_poster as jbp6_374_0_, topicimpl0_.jbp_type as jbp7_374_0_, topicimpl0_.jbp_status as jbp8_374_0_, topicimpl0_.jbp_subject as jbp9_374_0_, topicimpl0_.jbp_poll as jbp10_374_0_, posterimpl1_.jbp_user_id as jbp2_372_1_, posterimpl1_.jbp_post_count as jbp3_372_1_ from jbp_forums_topics topicimpl0_ inner join jbp_forums_posters posterimpl1_ on topicimpl0_.jbp_poster=posterimpl1_.jbp_id where topicimpl0_.jbp_forum_id=? and topicimpl0_.jbp_type=? order by topicimpl0_.jbp_last_post_date desc]
            java.sql.SQLException: ResultSet may only be accessed in a forward direction.
            at net.sourceforge.jtds.jdbc.JtdsResultSet.checkScrollable(JtdsResultSet.java:303)
            at net.sourceforge.jtds.jdbc.JtdsResultSet.absolute(JtdsResultSet.java:680)
            at org.jboss.resource.adapter.jdbc.WrappedResultSet.absolute(WrappedResultSet.java:114)
            at org.hibernate.loader.Loader.advance(Loader.java:1478)
            at org.hibernate.loader.Loader.getResultSet(Loader.java:1792)
            at org.hibernate.loader.Loader.doQuery(Loader.java:674)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
            at org.hibernate.loader.Loader.doList(Loader.java:2220)
            at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
            at org.hibernate.loader.Loader.list(Loader.java:2099)
            at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
            at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
            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)



            • 3. Re: MS SQL with Jboss Forums
              Ryszard Kozmik Master

              Hi

              I created http://jira.jboss.com/jira/browse/JBFORUMS-278 bug task for this issue. Solving it might take a while because I'm not a Windows user, nor have I SQL Server installation. Your stack trace doesn't contain any org.jbosss.portlet.forums.* entries what makes it harder to guess bug's cause without having full environment to test.

              Regards
              ------------------
              Ryszard Kozmik
              JBoss Forums Lead
              JBoss Labs Team

              • 4. Re: MS SQL with Jboss Forums
                Ryszard Kozmik Master

                Hello

                The JIRA issue (http://jira.jboss.com/jira/browse/JBFORUMS-278) has been resolved by Przemek. Code fix is available in project's svn repository and will be packaged in next Forums release, 1.1.0 Beta.

                Regards
                -----------------
                Ryszard Kozmik
                JBoss Forums Lead
                JBoss Labs Team

                • 5. Re: MS SQL with Jboss Forums
                  Orlando Newbie

                  It's a little late but, Thanks a lot!