DayTrader
  1. DayTrader
  2. DAYTRADER-85

DayTrader 2.1.3 : test PingServlet2Session2 JDBCCollection : java.sql.SQLException error

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.3
    • Fix Version/s: 2.1.7, 2.2.1, 3.0
    • Component/s: None
    • Security Level: public (Regular issues)
    • Labels:
      None
    • Environment:

      Description

      Hello,

      I have downloaded the latest revision for Day Trader 2.1.3
      in the svn here
      http://svn.apache.org/viewvc/geronimo/daytrader/branches/old_2.1.3/?sortby=date

      and compiled it with :

      • JDK 1.6_021
      • Mandriva Linux 2010.1
      • Maven 2.2.1

      by following the instructions in the file
      http://svn.apache.org/viewvc/geronimo/daytrader/branches/2.1.3/README.jboss5?revision=907211&view=markup&sortby=file

      But when I launch the test PingServlet2Session2JDBCCollection , I have in the web page :

      PingServlet2Session2JDBCCollection
      PingServlet2Session2JDBCCollection tests the common path of a Servlet calling a Session EJB which perform a multi-row JDBC query.
      initTime: Wed Nov 24 14:42:02 CET 2010
      Hit Count: 4User: uid:57 is currently holding 0 stock holdings:

      and I have the following errors in the logs :

      15:33:13,887 ERROR [Log] Error: TradeDirect:getHoldings – error getting user holings
      java.sql.SQLException: You cannot set autocommit during a managed transaction!
      15:33:13,887 INFO [STDOUT] java.sql.SQLException: You cannot set autocommit during a managed transaction!
      15:33:13,888 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:599)
      ....
      15:33:13,903 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@15fddb7
      java.lang.Throwable: STACKTRACE
      at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:278)
      ....

        Activity

        Hide
        Forrest Xia added a comment -

        Close this one since it's verified. thank you!

        Show
        Forrest Xia added a comment - Close this one since it's verified. thank you!
        Hide
        Yannick LE NY added a comment -

        Tested with daytrader 2.1.8 snapshot code source at
        http://svn.apache.org/viewvc/geronimo/daytrader/branches/2.1/?sortby=date
        revision 1038956.
        Bug fixed.

        Show
        Yannick LE NY added a comment - Tested with daytrader 2.1.8 snapshot code source at http://svn.apache.org/viewvc/geronimo/daytrader/branches/2.1/?sortby=date revision 1038956. Bug fixed.
        Hide
        Yannick LE NY added a comment -

        I will try the patch tonight.

        Show
        Yannick LE NY added a comment - I will try the patch tonight.
        Hide
        Forrest Xia added a comment -

        please verify 2.1 branch. thank you for reporting this.

        Show
        Forrest Xia added a comment - please verify 2.1 branch. thank you for reporting this.
        Hide
        Yannick LE NY added a comment -

        test PingServlet2Session2JDBCCollection.log error log file.

        Show
        Yannick LE NY added a comment - test PingServlet2Session2JDBCCollection.log error log file.

          People

          • Assignee:
            Forrest Xia
            Reporter:
            Yannick LE NY
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development