3 Replies Latest reply on Oct 20, 2009 6:50 AM by mewk

    Insert data into MySQL database



      I have set up data services in order to retrieve/query/insert data into my MySQL database, querying works very well so far, but "insert" makes troubles. I have created a pop-up form in which you can enter data and finally press a "confirm"-button. This confirm-button should perform the "insert" into the database, which it actually does, but I get an error message after pressing the button (see below). Basically the data gets into the database and it also works well when I use the "test operation"-functionality in the dev. environment. When running a debug-session the error message appears, but also a new tab along with the mxml files, its name is "mx.data::DataList/http://www.adobe.com/2006/flex/mx/internal::processSequenceResult" and contents is "Source not found" and a button labelled "Edit Source Lookup Path..."


      Does anyone have a hint?




      error message:


      at mx.data::DataList/http://www.adobe.com/2006/flex/mx/internal::processSequenceResult()[C:\depot\DataServices\ branches\dune_rc\frameworks\projects\data\src\mx\data\DataList.as:3043]
      at mx.data::DataListRequestResponder/result()[C:\depot\DataServices\branches\dune_rc\framewo rks\projects\data\src\mx\data\DataListRequestResponder.as:103]
      at mx.data::RPCDataServiceAdapter/sendResultEvent()[C:\depot\DataServices\branches\dune_rc\f rameworks\projects\data\src\mx\data\RPCDataServiceAdapter.as:1508]
      at mx.data::RPCDataServiceAdapter/executeQueryResult()[C:\depot\DataServices\branches\dune_r c\frameworks\projects\data\src\mx\data\RPCDataServiceAdapter.as:1444]
      at mx.collections::ItemResponder/result()[E:\dev\gumbo_beta2\frameworks\projects\framework\s rc\mx\collections\ItemResponder.as:129]
      at mx.rpc::AsyncToken/http://www.adobe.com/2006/flex/mx/internal::applyResult()[E:\dev\gumbo_beta2\frameworks\pr ojects\rpc\src\mx\rpc\AsyncToken.as:239]
      at mx.rpc.events::ResultEvent/http://www.adobe.com/2006/flex/mx/internal::callTokenResponders()[E:\dev\gumbo_beta2\frame works\projects\rpc\src\mx\rpc\events\ResultEvent.as:207]
      at mx.rpc::AbstractOperation/http://www.adobe.com/2006/flex/mx/internal::dispatchRpcEvent()[E:\dev\gumbo_beta2\framewor ks\projects\rpc\src\mx\rpc\AbstractOperation.as:244]
      at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::resultHandler()[E:\dev\gumbo_beta2\frameworks\ projects\rpc\src\mx\rpc\AbstractInvoker.as:318]
      at mx.rpc::Responder/result()[E:\dev\gumbo_beta2\frameworks\projects\rpc\src\mx\rpc\Responde r.as:56]
      at mx.rpc::AsyncRequest/acknowledge()[E:\dev\gumbo_beta2\frameworks\projects\rpc\src\mx\rpc\ AsyncRequest.as:84]
      at NetConnectionMessageResponder/resultHandler()[E:\dev\gumbo_beta2\frameworks\projects\rpc\ src\mx\messaging\channels\NetConnectionChannel.as:547]
      at mx.messaging::MessageResponder/result()[E:\dev\gumbo_beta2\frameworks\projects\rpc\src\mx \messaging\MessageResponder.as:235]

        • 1. Re: Insert data into MySQL database


          Can you list the server configuration?


          Also, to generate a form, you can use the Generate Form functionality. (Right click on operation in Data/Service view ->Select Generate Form)



          • 2. Re: Insert data into MySQL database
            python79 Level 1


            I am running the newest version of XAMPP on a Windows XP machine. I will test this

            "generate form"-tool when I'm back on my computer in a few hours.


            Thanks in the meanwhile.



            • 3. Re: Insert data into MySQL database
              mewk Level 3



              It's fairly typical for code to break in intermediary classes that you never explicitly call (in this case DataList). This could be a flex bug, but 99.9% of the time the problem is incorrect initialization/use of a class you did call. So rather than look at the end of a stack trace, it's more constructive to look at the beginning and follow the trace up (hopefully you'll see your own classes in there).


              Here, it looks like your program is receiving a response from the server after the insert service call. Can you check the returned message and also the code handling the response? Thanks,


              - e