I have a java application running in payara docker which connects to oracle database with connection pool. A particular functionality button in ui when clicked calls a database stored procedure to display some rows as result. When this functionality button is triggered multiple times in a single user sesion, it returns duplicate results. First time if it returns 2 rows( expected) , 2nd time would be 4 (2 extected results and 2 possibly from previous run) and then 6 and so on..i checked the database stored procedure which is running fine without duplication when directly run in db..Can you please help on this
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in PAYARA
- Uncompilable source code
- Glassfish 4.1.1 / EAR / java.lang.IllegalStateException: Unable to retrieve EntityManagerFactory for unitName XYZ
- When scanning too many entity in jpa hibernate, glassfish startup very slow or memorry leak
- WELD-001408 when trying to deploy rest project as war type that references a jar project with jpa content
- asadmin list-instances cluster glassfish
- A resource named jms/ressource.factory already exists
- including vaadin-cdi dependency in pom.xml is enough to make WAR undeployable. Why?
- payara 4.1.1.171 :: ecliselink jpa issue with case when condition
- Payara Server and NetBeans 8.2: Request is within the scope of a filter or servlet that does not support asynchronous operations
- Use apache as frontend to Glassfish
- JSF warning is logged before custom exception handler is called (Glassfish/Payara)
- spring boot application jndi on glassfish/payara container
- Payara Server 5 Community version #badassfish message on webpage fail
- Show Maintenance "Custom Message" to end User if server stops/down in payara
- Payara Server doesn't start, The Master Password is required to start the server
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
This looks to be a flaw in UI or data layer. You can do the following: