8 Replies Latest reply on Feb 22, 2012 11:47 PM by Rohit . Kumar

    ADEP Data Services JEE 4.6 related Issue.

    buntyk

      Hello,

      I tried to use build simple application in Flash Builder 4.6 with data model i.e. model driven development. I tried to follow the example of lcds data services but doesn't work for me.

      I am able to generate the tables and able to generate form and display data in the datagrid without writing single line of code.

      But when I try to insert data I get errror. And I am not able to go ahead since last few days.

      Please help me.

      Even if somebody can give me some detailed example for this...that would be helpful.

      Thanks alot,

        • 1. Re: ADEP Data Services JEE 4.6 related Issue.
          Rohit . Kumar Adobe Employee

          Hi Buntyk,

           

          What error are you getting? As for the link: Check out the ADEP Data Services 4.6 documentation at: http://help.adobe.com/en_US/dataservicesjee/4.6/Modeling/index.html. Specificically refer to the various Model Driven Development sections.

           

          Hope that helps,

          Rohit

          • 2. Re: ADEP Data Services JEE 4.6 related Issue.
            buntyk Level 1

            Hello Rohit,

            I read the link you have sent.

            And I have gone through that again. But still I am getting some kind of

            error...

             

            "Error occurred completing a transaction

            null"

             

            I have mac and FB 4.6 installed on it. with Modeler plugin for 4.6 is also

            installed.

            I have installed ADEP Data Services JEE 4.6.

            I have created tried to create the sample app MyDSApp using the

            instructions in the link povided by you,

            Developing Data Services forJava EE 4.6 Model-Driven Applications

             

             

            There only thing I did change is I didn't have flex 4.5 sdk installed so I

            used the default 4.6....rather than that everything is the same.

             

            After I finished the app using the instructions I run it. It showed me the

            product table's all the data.But when I tried to edit a cell in the

            datagrid....I got message

             

            *"Error occurred completing a transaction *

            null"

             

            So only thing is while updating I am getting error...

            Please Let me know what is wrong.

            Thank you,

            • 3. Re: ADEP Data Services JEE 4.6 related Issue.
              buntyk Level 1

              More over..

              this is I found in the tomcat server log....

               

               

              Data Services] Error notifying transaction before completion

              handlers: org.hibernate.TransactionException: JDBC commit failed

              at

              org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:157)

              at

              flex.data.adapters.FlexHibernateSessionContext$SessionSynch.beforeCompletion(FlexHibernate SessionContext.java:139)

              at

              flex.data.DataServiceTransaction.notifyBeforeCompletion(DataServiceTransaction.java:2069)

              at

              flex.data.DataServiceTransaction.complete(DataServiceTransaction.java:1673)

              at flex.data.DataService.serviceTransactedMessage(DataService.java:1028)

              at flex.data.DataService.serviceMessage(DataService.java:528)

              at flex.messaging.AsyncMessageBroker.in(AsyncMessageBroker.java:414)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at flex.messaging.filters.AsyncMessageFilterChain.in

              (AsyncMessageFilterChain.java:205)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at

              flex.messaging.AsyncMessageBroker$EndpointSplitter.in(AsyncMessageBroker.java:809)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at flex.messaging.endpoints.BaseSocketServerEndpoint.in

              (BaseSocketServerEndpoint.java:476)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at

              flex.messaging.endpoints.RTMPConnection.handleTCCommandIn(RTMPConnection.java:886)

              at flex.messaging.endpoints.RTMPConnection.in(RTMPConnection.java:1032)

              at

              flex.messaging.endpoints.RTMPConnection.serviceTCMessage(RTMPConnection.java:1116)

              at flex.messaging.endpoints.RTMPConnection.doRead(RTMPConnection.java:654)

              at

              flex.messaging.endpoints.RTMPProtocolHandler.doRead(RTMPProtocolHandler.java:124)

              at

              flex.messaging.socketserver.Connection$ConnectionReader.run(Connection.java:874)

              at

              java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

              at

              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

              at java.lang.Thread.run(Thread.java:680)

              Caused by: java.sql.SQLException: StandardXAConnectionHandle:commit:This

              connection is part of a global transaction

              at

              org.enhydra.jdbc.standard.StandardXAConnectionHandle.commit(StandardXAConnectionHandle.jav a:129)

              at

              org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:16 6)

              at

              org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:142)

              ... 22 more

               

              Error while completing transaction:

              flex.data.DataServiceException: Error occurred completing a transaction

              stacktrace=flex.data.DataServiceException: Error occurred completing a

              transaction

              at

              flex.data.DataServiceTransaction.complete(DataServiceTransaction.java:1689)

              at flex.data.DataService.serviceTransactedMessage(DataService.java:1028)

              at flex.data.DataService.serviceMessage(DataService.java:528)

              at flex.messaging.AsyncMessageBroker.in(AsyncMessageBroker.java:414)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at flex.messaging.filters.AsyncMessageFilterChain.in

              (AsyncMessageFilterChain.java:205)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at

              flex.messaging.AsyncMessageBroker$EndpointSplitter.in(AsyncMessageBroker.java:809)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at flex.messaging.endpoints.BaseSocketServerEndpoint.in

              (BaseSocketServerEndpoint.java:476)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at

              flex.messaging.endpoints.RTMPConnection.handleTCCommandIn(RTMPConnection.java:886)

              at flex.messaging.endpoints.RTMPConnection.in(RTMPConnection.java:1032)

              at

              flex.messaging.endpoints.RTMPConnection.serviceTCMessage(RTMPConnection.java:1116)

              at flex.messaging.endpoints.RTMPConnection.doRead(RTMPConnection.java:654)

              at

              flex.messaging.endpoints.RTMPProtocolHandler.doRead(RTMPProtocolHandler.java:124)

              at

              flex.messaging.socketserver.Connection$ConnectionReader.run(Connection.java:874)

              at

              java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

              at

              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

              at java.lang.Thread.run(Thread.java:680)

              Caused by: org.hibernate.TransactionException: JDBC commit failed

              at

              org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:157)

              at

              flex.data.adapters.FlexHibernateSessionContext$SessionSynch.beforeCompletion(FlexHibernate SessionContext.java:139)

              at

              flex.data.DataServiceTransaction.notifyBeforeCompletion(DataServiceTransaction.java:2069)

              at

              flex.data.DataServiceTransaction.complete(DataServiceTransaction.java:1673)

              ... 19 more

              Caused by: java.sql.SQLException: StandardXAConnectionHandle:commit:This

              connection is part of a global transaction

              at

              org.enhydra.jdbc.standard.StandardXAConnectionHandle.commit(StandardXAConnectionHandle.jav a:129)

              at

              org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:16 6)

              at

              org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:142)

              ... 22 more

               

              Error invoking service 'data-service':

              flex.data.DataServiceException: Error occurred completing a transaction

                incomingMessage: Flex Message (flex.data.messages.DataMessageExt)

                  operation = transacted

                  id = null

                  clientId = 46CC4646-66D2-ED16-9DF7-9612C59D36F8

                  correlationId =

                  destination = MyDSApp.Product

                  messageId = D97330F0-08FD-2866-FD1F-9612C82F2A21

                  timestamp = 1329662712754

                  timeToLive = 0

                  body =

                  [

                    Flex Message (flex.data.messages.DataMessage)

                        operation = update

                        id = ASObject(1206661731){productid=1}

                        clientId = 46CC4646-66D2-ED16-9DF7-9612C59D36F8

                        correlationId = D97330F0-08FD-2866-FD1F-9612C82F2A21

                        destination = MyDSApp.Product

                        messageId = B97F910A-239C-E7B5-A7B5-9612DBAEAD61

                        timestamp = 1329662712766

                        timeToLive = 0

                        body =

                        [

               

                          [

                            price

                          ],

                          [Proxy(inst=MyDSApp.package1.Product@20) proxyClass=class

              flex.messaging.io.BeanProxy descriptor=[ excludes: null]],

                          MyDSApp.package1.Product@20

                        ]

                        hdr(DSId) = 64813F88-6D96-4801-8435-C65442DF79C8

                        hdr(DSEndpoint) = my-rtmp

                  ]

                  hdr(DSId) = 64813F88-6D96-4801-8435-C65442DF79C8

                  hdr(DSEndpoint) = my-rtmp

                Exception: flex.data.DataServiceException: Error occurred completing a

              transaction

              at

              flex.data.DataServiceTransaction.complete(DataServiceTransaction.java:1722)

              at flex.data.DataService.serviceTransactedMessage(DataService.java:1028)

              at flex.data.DataService.serviceMessage(DataService.java:528)

              at flex.messaging.AsyncMessageBroker.in(AsyncMessageBroker.java:414)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at flex.messaging.filters.AsyncMessageFilterChain.in

              (AsyncMessageFilterChain.java:205)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at

              flex.messaging.AsyncMessageBroker$EndpointSplitter.in(AsyncMessageBroker.java:809)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at flex.messaging.endpoints.BaseSocketServerEndpoint.in

              (BaseSocketServerEndpoint.java:476)

              at flex.messaging.MessageContext.doIn(MessageContext.java:295)

              at

              flex.messaging.endpoints.RTMPConnection.handleTCCommandIn(RTMPConnection.java:886)

              at flex.messaging.endpoints.RTMPConnection.in(RTMPConnection.java:1032)

              at

              flex.messaging.endpoints.RTMPConnection.serviceTCMessage(RTMPConnection.java:1116)

              at flex.messaging.endpoints.RTMPConnection.doRead(RTMPConnection.java:654)

              at

              flex.messaging.endpoints.RTMPProtocolHandler.doRead(RTMPProtocolHandler.java:124)

              at

              flex.messaging.socketserver.Connection$ConnectionReader.run(Connection.java:874)

              at

              java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

              at

              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

              at java.lang.Thread.run(Thread.java:680)

              Caused by: flex.data.DataServiceException: Error occurred completing a

              transaction

              at

              flex.data.DataServiceTransaction.complete(DataServiceTransaction.java:1689)

              ... 19 more

              Caused by: org.hibernate.TransactionException: JDBC commit failed

              at

              org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:157)

              at

              flex.data.adapters.FlexHibernateSessionContext$SessionSynch.beforeCompletion(FlexHibernate SessionContext.java:139)

              at

              flex.data.DataServiceTransaction.notifyBeforeCompletion(DataServiceTransaction.java:2069)

              at

              flex.data.DataServiceTransaction.complete(DataServiceTransaction.java:1673)

              ... 19 more

              Caused by: java.sql.SQLException: StandardXAConnectionHandle:commit:This

              connection is part of a global transaction

              at

              org.enhydra.jdbc.standard.StandardXAConnectionHandle.commit(StandardXAConnectionHandle.jav a:129)

              at

              org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:16 6)

              at

              org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:142)

              ... 22 more

              • 4. Re: ADEP Data Services JEE 4.6 related Issue.
                Ashish Vashisht Level 1

                Hi

                 

                You need to set the following properties on your Fiber model, as appropriate for your app server:

                 

                 

                •   hibernate.transaction.factory_class

                 

                •   hibernate.transaction.manager_lookup_class

                Please see here: http://help.adobe.com/en_US/enterpriseplatform/10.0/AEPDeveloperGuide/WSa53bf8bf8189e60776 c71f0d133f0350afe-8000.html

                 

                Regards,

                 

                Ashish Vashisht

                • 5. Re: ADEP Data Services JEE 4.6 related Issue.
                  buntyk Level 1

                  HI I checked but I am using Tomcat and on that page its written for JBOSS and also when I tried to put those values It gives error on model.

                  So probably not for Tomcat server.

                  What I created is just a basic app.

                  Here are the steps I did hundreds of times.

                  When I installed ADEP Data Services 4.6

                  It has built in tomcat server and sampledb

                  And on the link http://help.adobe.com/en_US/dataservicesjee/4.6/Modeling/WS4ba8596dc6a25eff-1bd28c95126af7 77a3e-8000.html  is

                  " Create a simple model-driven application ".

                  I tried those steps to create the app. All steps as stated in the above link.

                  When I run the app it displays records in the datagrid. But then when I try to update any cell it gives error. As I have posted in my earlier messages.

                  So I am just stuck at starting point and not able to go ahead and try out more....

                  Please help.

                  Thanks,

                  • 6. Re: ADEP Data Services JEE 4.6 related Issue.
                    Ashish Vashisht Level 1

                    Hi

                     

                    As mentioned on the page, you need to provide values for those properties as per your respective App Server. The exact App Server specific values can be found in the Hibernate documentation (also linked to on the page): http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/session-configuration.html#c onfiguration-optional-transactionstrategy

                     

                    Specifically for Tomcat, the below values should work:

                     

                    <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactor y</property>

                    <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JOTMTransacti onManagerLookup</property>

                     

                    I will check to see that the sample documentation is updated to mention the same.

                     

                    Thanks,

                     

                    Ashish Vashisht

                    • 7. Re: ADEP Data Services JEE 4.6 related Issue.
                      buntyk Level 1

                      HI Ashish,

                      I am able to figureout the problem.

                       

                      Actually In the model

                      <annotation name="DMS" Table="PRODUCT" hibernate.connection.url="jdbc:hsqldb:hsql://localhost:9002/ordersDB" hibernate.connection.driver_class="org.hsqldb.jdbcDriver"/>

                              <annotation name="RDS" introspectedColumns="PRODUCTID,DESCRIPTION,PRICE,PRODUCTNAME"/>

                              <annotation name="ActionScriptGeneration" DisplayColumn="productname" Package="valueObjects" ImplicitServicePackage="services"/>

                              <annotation name="service Group" service="Dummy,ProductService"/>

                              <annotation name="FbEntityProperties" AssemblerClass="fiber.data.assemblers.FiberAssembler" contextRoot="/dataservices-samples" rootUrl="http://localhost:8400/dataservices-samples"/>

                      After putting these properties it worked ok.

                      Also The DMS was defined at model level but still I have to define DMS at the entity level for these above annotations...

                      Thanks for your help.

                      • 8. Re: ADEP Data Services JEE 4.6 related Issue.
                        Rohit . Kumar Adobe Employee

                        FYI, these properties get added when you actually introspect the entity and place it on the Model canvas.

                         

                        Rohit