sql query is not working in jboss...

[chaitanya kiran pvn]

hai

i have one problem in jsp with sql tag in but this tag is working in weblogic but it wont work in jsp when i change into datasource=${ds}.
give any help on this.

hear i post my tag

  
  <sql:query var="stat" dataSource="${ds}">
    declare @start datetime
    set @start = ?
 
    select g.table_id, count (bet_id) 'bet_count', sum (amount) as 'stake', sum (payoff) as 'payoff'
     into #tmp_betting
     from Bet b inner join Game g on b.game_id = g.game_id
     inner join CasinoUser u on b.user_id = u.user_id
     where g.game_start >= @start and g.active_flag = 0 and u.usertype_code = 'PLAY'
     and b.place_time >= @start
     and u.casino_id like '<%=casino.getCasinoId()%>'
     group by g.table_id
 
    select gt.table_id, table_name, stake, payoff, payoff/stake as 'pay_percent', bet_count, count (game_id) as 'game_count',
      (select gametype_desc from GameType type inner join GameConfig gc on type.gametype_id = gc.gametype_id
        where gc.conf_id = gt.conf_id) as 'game_name'
     from game g inner join gametable gt on g.table_id = gt.table_id
     left outer join #tmp_betting t on gt.table_id = t.table_id
     where game_start >= @start
     group by gt.table_id, gt.conf_id, table_name, stake, payoff, bet_count
     order by game_name, table_name
 
     drop table #tmp_betting
      <sql :-P	 aram value="${call.getTime()}" />
    </sql:query>
<c:if test="${stat.rows.size == 0}">
    <tr class="formbgbold">
        <td colspan="8" align="middle">No Games Available</td>
      </tr>
    </c:if>
    <c:forEach items="${stats.rows}" var="stat" varStatus="statStatus">
    <tr class="formbg">
        <td><c :-o	 ut value="${statStatus.index}"/></td>
        <td><c :-o	 ut value="${stat.game_name}" /></td>
        <td><c :-o	 ut value="${stat.table_name}" /></td>
        <td align="center"><c:if test="${stat.game_count == null}">0</c:if><fmt:formatNumber pattern="#,##0" value="${stat.game_count}" /></td>
        <c:set var="total_games" value="${total_games + stat.game_count}" />
        <td align="center"><c:if test="${stat.bet_count == null}">0</c:if><fmt:formatNumber pattern="#,##0" value="${stat.bet_count}" /></td>
        <c:set var="total_bets" value="${total_bets + stat.bet_count}" />
        <td align="right"><c:if test="${stat.stake == null}">$0.00</c:if><fmt:formatNumber pattern="${sessionScope._casino_obj.currencyPattern}" value="${stat.stake}" /></td>
        <c:set var="total_staked" value="${total_staked + stat.stake}"/>
        <td align="right"><c:if test="${stat.payoff == null}">$0.00</c:if><fmt:formatNumber pattern="${sessionScope._casino_obj.currencyPattern}" value="${stat.payoff}" /></td>
        <c:set var="total_payoff" value="${total_payoff + stat.payoff}" />
        <td align="right"><c:if test="${stat.pay_percent == null}">n/a</c:if><fmt:formatNumber pattern="${applicationScope.PERCENT}" value="${stat.pay_percent}" /></td>
    </tr>
    </c:forEach>
  

i change the tld version to 1.1
thanks in advance
chaitanya

[Jaikiran Pai]

When you say, its not working, do you see any error messages? I don't have much knowledge about how that tag is supposed to work and this question looks more related to JSP than JBoss. I will move this to the JSP forum where you might get a solution.

Moderators: If later, this turns out to be JBoss specific issue, please feel free to move it back to the JBoss forum.

[Hongli Li]

if any of the table has blob or clob field, you need to make sure your query is in side of a transaction.

[chaitanya kiran pvn]

hai

iam using this as dynamic table creation of my reacent actiity from mssqlserver database but it throws in sql exception. in runtime jsp.

i am not using any blob are clob in my application.

thanks in advance
chaitanya