Flex :: Oracle - Remoteobject Multiple Records In Database Of Same Info?
Feb 11, 2012
Case1: When a client makes a remoteObject request ie to save some Info... A call is made to Java SAVE_INFO method. If request failed ie came back to FaultHandler ( we save the info in an arrayCollection).Later we call SAVE_INFO again for each item in arrayCollection ie( if arrayCollection has 10 items.. We call 10 times the same method.. I know that's kind of stupid but we have no control over java to write a overloading method). Some times we see there are multiple records of same info in DB. I am not sure if this happens when looping over arraycollection and making calls or during normal one time call. We could not find a pattern to reproduce. Java LOG level is at Error level in production. can't set to INFO in production to monitor all calls. We dont know if this multiple times saved record is, the one in arrayCollection or normal one.
Flex3 RemoteObject --> WAS 6.1 , lCDS 3.0, Java1.5 --> Webservice -- > Java (hibernate) --> Oracle 10gCase2: When application is left open and user leaves for the day and submits info the following morning, we see duplicate records in DB of that info.(No arrayCollection here. Simple straight one call)Flex3 RemoteObject --> OC4J Blazeds Java1.5 (JDBC) --> Oracle 10g.Recently one of our Testers testing case 2 application found this pattern and I am starting to think that may be in the case 1 also.. users might be leaving for lunch/break and resubmitted the arrayCollection after coming back. During lunch java might have killed the sessions for the client and after resubmitting 10 at same time.
View 1 Replies
Similar Posts:
Jun 8, 2011
I'm working on Flash project for which I have to conenct to Oracle database, retrieve data and display it.Is it possible to connect to Oracle database from Flash?
View 2 Replies
Mar 16, 2011
im trying to output my database information in a text input field in flex by using remoteObject(cfc). The information is being provided by a database using a query and an array collection. I'm just unsure how i go about taking the queried array collection information and display it into TextInput Fields.
[Code]...
View 1 Replies
Aug 24, 2010
I was wondering what is considered to be a best practice when I have multiple components and use RemoteObject for AMF communication with a PHP backend.
Have the RemoteObject in the Main.mxml file with all the methods declared here (with handlers and all) and have all components call functions from the parentApplication, thus having a centralized result and fault handling, but making reusiability more difficult.Have a RemoteObject in each component with only the methods (and handlers) relevant to that component, thus making it easy to have clean, reusable components.
View 1 Replies
Jul 7, 2009
I'm trying to list in flash, several records that come from my database. I'm not talking about a datagrid or anything to fancy. I just want to list the values inside text boxes. (to allow editing). I already have fetch an array of records that come from the database, here:
[Code]...
My question is: How can I display several records, instead of only 1? Should I change the call to, instead of 1, uses a variable? But where would that variable comme from? Then I should loop again the addChild method for each child of form2 that needs to have different records on each of them?
View 1 Replies
Jul 14, 2010
looking to create an option menu (at least that is what it is called in HTML).[code]looking to do this in flash though with AS3, PHP and MySQL. The data can be stored in XML. please let me know if anyone has done something like this before, or if they know of a good tutorial which details how.
View 1 Replies
Jul 11, 2009
I have a couple of remote object methods that I want to respond to in different ways depending on the context, but I'd rather not set up a bunch of different RemoteObject aliases.Some background: Let's say I have an admin application that displays sales stats in different ways. The remote method looks like:
<mx:RemoteObject id="rpt" destination="AMFServer">
<mx:method name="getSalesStats" fault="getSalesStatsFault(event)"
result = "getSalesStatsSuccess(event)" />[code]........
The getSalesStats method takes an employee ID and a sales type as its arguments. You'd call it like:
rpt.getSalesStats(120, "peanuts");
public function getSalesStatsSuccess(e:ResultEvent):void {
salesdata:ArrayCollection = e.result.rows as ArrayCollection;[code]......
I'd like to pass something through the remote method to the responding function, like:
rpt.getSalesStats(120, "peanuts", "clicked button one");
but that of course throws an error because the server doesn't want that last argument.
View 6 Replies
Feb 6, 2009
I've got records being populated into our database from paypal's Instant payment notification methods...great. now i turn to our flash cs3 app to populate a component datagrid with the stored database data and to my surprise I'm unable to identify any examples on how this might even be done.
How do you connect to an mssql database from within flash cs3 to retrieve data for displaying within a flash datagrid?
I can write a cfc from coldfusion to return a dataset, but overall i'm not sure if i 'have' to learn Flex, or AIR or what to get the records 'read'.
My ActionScript 3.0 bible is vague at best and resorts to php. (which i dont know)
View 6 Replies
Nov 24, 2010
My only experience with Flex is some limited reading over the web. What i am wondering is if i want to use Flex or some variant of it for generating reports, specifically Charts, coming off a Java/Oracle backend can i accomplish that in an environment where the streaming media (we cannot play videos on our systems at work) is turned off? Also, are there any other restrictions revolving around using Flex for reporting in the form of charts? Currently, we use Jfree Chart API to develop charts but just exploring an alternative.
View 2 Replies
Jul 7, 2009
programming and on AS3... have patience. :s
I have the following on my php service file :
Code: Select all function updateRecords($id,$name,$age){
$query = mysql_query("UPDATE data SET name= '$name', age= '$age' WHERE id = '$id'");
[code]....
View 4 Replies
Jun 9, 2004
I am trying to get a .asp example file from an actionscripting book to work, but it keeps telling me that there is an error trying to open the .asp page on my server.I uploaded the .asp file, and the access file onto my server, but it is not communicating.Are there any browswer settings or web-hosting settings I should be aware of before I try to send and receive information from a database? Also, I eliminated one variable. In another document, I was able to pull information from a text file from my web server without any problems.
View 3 Replies
May 6, 2010
I am looking to subclass RemoteObject. Instead of:
<mx:RemoteObject ... >
<mx:method ... />
<mx:method ... />
[code].....
View 1 Replies
Nov 27, 2004
so i got the info all in the database and then i have a php page that goes and retrieves the id that the e-mail sent through. here is my code on the load.php page so far:
[Code]...
View 6 Replies
Jun 27, 2009
I have a page display people's name and when you click on a name information such as age, height, and weight are displayed. In Flash, can you create the same thing? I know with displaying data from a database you have to have dynamic text boxes set up to load the info but can you have it set up so you can load a name from a database and THEN click that name to have it load the other info?
View 1 Replies
Nov 27, 2004
i got the info all in the database and then i have a php page that goes and retrieves the id that the e-mail sent through. here is my code on the load.php page so far:
PHP Code:
<?php
//database connect
require_once("connect.php");[code]...
now i've got all the records of value $card (lets say 8 for this instance) pulled into this php page, how would i go about loading them into flash with loadVars()? for the record names, i used this line to originally insert them:
PHP Code:
$result = mysql_query("INSERT into ecard (fname, femail, tname, temail, message) values ('$fromName', '$fromEmail', '$toName', '$toEmail', '$message')");
View 6 Replies
Nov 30, 2011
I want to create 2 tables in a single adobe air database. I am using Adobe flash builder with the import flash.data.*;
I tried initializing the statement below. it give me the error on creating the second table. Do I have to use other API so that
private function db_opened(e:SQLEvent):void {
sqls.sqlConnection = sqlc;
sqls.text = "CREATE TABLE IF NOT EXISTS test_table ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT);";
sqls.execute();
[Code] .....
ERROR
Error: Error #3106: Property cannot be changed while SQLStatement.executing is true.
at Error$/throwError()
at flash.data::SQLStatement/set text()
View 1 Replies
Jan 31, 2004
if i have a a database how can i get info from it show up in a flash document in a dyanamic text box
View 3 Replies
Jan 31, 2004
if i have a a database how can i get info from it show up in a flash document in a dyanamic text box
View 3 Replies
Jun 9, 2004
I am trying to get a .asp example file from an actionscripting book to work, but it keeps telling me that there is an error trying to open the .asp page on my server.I uploaded the .asp file, and the access file onto my server, but it is not communicating.Are there any browswer settings or web-hosting settings I should be aware of before I try to send and receive information from a database?Also, I eliminated one variable. In another document, I was able to pull information from a text file from my web server without any problems.
View 3 Replies
Feb 3, 2006
I am building a dynamic menu with xml via php, mysql. Attaching clips from the library for each database row/xml node, etc. My question is how can I rebuild that menu if another database call is made and the list needs to be repopulated? I imagine I could create a clip on the fly and attach clips, but how could I get rid of the previous one? I'd like to re-use the xml object just write a function that either rebuilds the clip or creates a new instance of an empty clip and builds the menu with that one?
View 1 Replies
Apr 22, 2002
Is it at all possible for flash to access images from outside flash the way it draws info from a database?
View 1 Replies
Jan 18, 2004
I need help to make a form (in Flash) that submits info to a database, and then displays it in Flash. Even better, submits the info to a Flash-made database.
View 7 Replies
Mar 31, 2010
I have a remoteobject within my main.mxml.I can call a function on the service from an init() function on my main.mxml, and my java debugger triggers a breakpoint.When I move the remoteobject declaration and function call into a custom component (that is declared within main.mxml), the remote function on java-side no longer gets called, no breakpoints triggered, no errors, silence.[code]
View 2 Replies
Feb 9, 2011
This is more of a database design issue but almost everybody here uses database integration with their apps so I feel it is important. I am integrating AS3 + mysql + php and need to clear up the database design for multiple students results in various activities. Developing an online e-learning course with a "dashboard" or teacher control panel with all kids results in each activity. I have read the database design rules by Codd etc... understand the need for parent and child tables so information is relational and not duplicated etc... BUT I am not sure how to design the results part. Various students do various lessons with 10 activities which each give a mark out of ten. The table would be updating every few seconds as 10,000 users would be online at the same time
1. Would I create a results table with all the students results going in the same table ie: Tom would be the first row
[Code]....
View 5 Replies
Jul 19, 2010
I have a advanced datagrid and displying the 10 records. but when loading the data, the first record should be selected.
View 1 Replies
Aug 29, 2011
I am trying to create some charts in Flex/FlashBuilder 4.5The issue I have it that the information I wish to display is the number of events within an area. I am using HTTP service to access a rails controller which is returning an XML list of the events.I need to figure out how to chart the number of events, eg number of records returned. There is no numeric value within chart, as there would be if I was charting sales or prices for example.
View 1 Replies
Feb 2, 2011
In the AdvancedDataGrid shown bellow I have one groupingField as one can see. I would like to have the ability to click in a record (let´s say the 26/01/2011 - Pag.) and right bellow it to have some action buttons.
How can I do it? Would it be by using a AdvancedDataGridRendererProvider? I´ve tried to do it but didn´t get the expected result.
View 1 Replies
Aug 8, 2011
I'm using Flex 4.5 with PHP Zend webservice framework. Basically, I have 2 DataGrids that can drag and drop between each other. At the initializing of the component, I call a webservice to populate the top DataGrid. Then the user can drag rows to the bottom DataGrid that get processed and saved later on. My problem is that I want to have a reset button (or cancel button), that will take the user to a new component in the ViewStack, and if they return to the component with the DataGrids, the top DataGrid has the original records and the bottom DataGrid is empty.
I just can't figure out a good way to repopulate the top DataGrid. I can clear it, but it doesn't seem to refresh with the original data. I've tried unsuccessfully to call the webservice again and set the dataprovider to the new lastResult token. I've also tried unsuccessfully to copy the results of the initial webservice call to an ArrayCollection and simply set a Bindable variable to that ArrayCollection (or a backup of that ArrayCollection holding original records).
<?xml version="1.0" encoding="utf-8"?>
<s:NavigatorContent xmlns:fx="[URL]"
xmlns:s="library://ns.adobe.com/flex/spark"
xmlns:mx="library://ns.adobe.com/flex/mx"
xmlns:valueObjects="valueObjects.*"
[Code] .....
View 1 Replies
Oct 1, 2009
In the code below when I call chkAuthentication function from another function the remoteObj.login (login function in my service file (.php)) is called after the remaining code in that function. i.e., the loginStatus is returned from the function before the result-handler function loginResult is called. but my loginStatus is supposed to be set in loginResult function. It seems that the asynchronous behaviour is the culprit. what should I do in order to get the loginResult function to complete first?
[Code]...
View 2 Replies
Oct 21, 2009
I've been tinkering around with Flex RemoteObjects, and I've found that they aren't very well behaved with respect to timing out.First, I can't figure out how to set a timeout on "connect". I know I can set requstTimeout, which will correctly timeout after an initial handshake... But if the server doesn't handshake, the connection doesn't time out (eg, the server accepts the connection, then does nothing with it, the client will just be left hanging).
Second, when a requestTimeout fires (timing out the request), Flex doesn't actually take any steps to tear down the connection - it just leaves it hanging there (no RST or the like). Clearly, this is more than a little bit undesirable. Is there any way to explicitly tear down the connection after the timeout?
View 1 Replies
