-
1. Re: MS SQL with Jboss Forums
unibrew Apr 17, 2008 5:41 AM (in response to darkwingedangel9)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
darkwingedangel9 Apr 17, 2008 4:57 PM (in response to darkwingedangel9)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
unibrew Apr 20, 2008 6:39 PM (in response to darkwingedangel9)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
unibrew May 27, 2008 6:34 PM (in response to darkwingedangel9)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
darkwingedangel9 Nov 7, 2008 2:20 PM (in response to darkwingedangel9)It's a little late but, Thanks a lot!