Error printing  success messages  whith tomcat and apex listener - ORDS, SODA & JSON in the Database

Hi
when I submit button to validate something in my apex application using tomcat 6 and apex listener, I have the following
print success message checksum content error:  : 00ABFFFF8E57CDD55EE2BF095633CA51
someone can help me please!!!
Edited by: madiaw on 23 juin 2010 09:50

Related

Apex Listener Configuration Issue.

Hi there,
As I wanted to try the latest Restful services in apex 4.2, I decided to install Apex Listener 2.0. I downloaded the file and followed the steps as in the installation notes. As a pre-requisite, I configured the Restful services successfully in apex 4.2 along with Oracle 11g Express Edition. However, the installation of listener seems to be not compleated successfully with the following installation feed back.
D:\software\apex_listener>java -jar apex.war
This Listener instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data:d:\apexlistnerconf
Dec 27, 2012 3:34:47 PM oracle.dbtools.common.config.cmds.ConfigDir execute
INFO: Set config.dir to d:\apexlistnerconf in: D:\software\apex_listener\apex.war
Dec 27, 2012 3:34:49 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
INFO: Using configuration folder: D:\apexlistnerconf\apex
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2
Enter the database SID [xe]:
Enter the database user name [APEX_PUBLIC_USER]:
Enter the database password for APEX_PUBLIC_USER:
Password must not be empty
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:3
Dec 27, 2012 3:37:03 PM oracle.dbtools.common.config.file.ConfigurationFiles update
INFO: Updated configurations: defaults, apex
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:
Enter the APEX static resources location or Enter to skip:D:\software\apex42en\apex\images
Enter the HTTP port [8080]:
Dec 27, 2012 3:41:17 PM oracle.dbtools.standalone.Standalone execute
INFO: NOTE:
Standalone mode is designed for use in development and test environments. It isnot supported for use in production environments.
Dec 27, 2012 3:41:17 PM oracle.dbtools.standalone.Standalone execute
INFO: Starting standalone Web Container in:  d:\apexlistnerconf\apex
Dec 27, 2012 3:41:17 PM oracle.dbtools.standalone.Deployer deploy
INFO: Will deploy application path = d:\apexlistnerconf\apex\apex\WEB-INF\web.xml
Dec 27, 2012 3:41:17 PM oracle.dbtools.standalone.Deployer deploy
INFO: Deployed application path = d:\apexlistnerconf\apex\apex\WEB-INF\web.xml
Dec 27, 2012 3:41:18 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
INFO: Using configuration folder: D:\apexlistnerconf\apex
Default Database connection not configured properly
Dec 27, 2012 3:41:20 PM oracle.dbtools.rt.web.SCListener contextInitialized
INFO: Oracle Application Express Listener initialized
Application Express Listener version : 2.0.0.354.17.06
Application Express Listener server info: Grizzly/1.9.49
Dec 27, 2012 3:41:20 PM com.sun.grizzly.Controller logVersion
INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 12/27/12 3:41 PM
Dec 27, 2012 3:41:20 PM com.sun.grizzly.SelectorHandlerRunner handleSelectException
SEVERE: doSelect IOException
java.net.BindException: No free port within range: 8080=com.sun.grizzly.http.SelectorThreadHandler#480d41f3
        at com.sun.grizzly.TCPSelectorHandler.initSelector(TCPSelectorHandler.java:432)
        at com.sun.grizzly.TCPSelectorHandler.preSelect(TCPSelectorHandler.java:378)
        at com.sun.grizzly.SelectorHandlerRunner.doSelect(SelectorHandlerRunner.java:188)
        at com.sun.grizzly.SelectorHandlerRunner.run(SelectorHandlerRunner.java:132)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Dec 27, 2012 3:41:20 PM com.sun.grizzly.http.SelectorThread$3 onException
SEVERE: Exception during starting the controller
java.net.BindException: No free port within range: 8080=com.sun.grizzly.http.SelectorThreadHandler#480d41f3
        at com.sun.grizzly.TCPSelectorHandler.initSelector(TCPSelectorHandler.java:432)
        at com.sun.grizzly.TCPSelectorHandler.preSelect(TCPSelectorHandler.java:378)
        at com.sun.grizzly.SelectorHandlerRunner.doSelect(SelectorHandlerRunner.java:188)
        at com.sun.grizzly.SelectorHandlerRunner.run(SelectorHandlerRunner.java:132)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
java.net.BindException: No free port within range: 8080=com.sun.grizzly.http.SelectorThreadHandler#480d41f3
        at com.sun.grizzly.TCPSelectorHandler.initSelector(TCPSelectorHandler.java:432)
        at com.sun.grizzly.TCPSelectorHandler.preSelect(TCPSelectorHandler.java:378)
        at com.sun.grizzly.SelectorHandlerRunner.doSelect(SelectorHandlerRunner.java:188)
        at com.sun.grizzly.SelectorHandlerRunner.run(SelectorHandlerRunner.java:132)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Dec 27, 2012 3:41:20 PM oracle.dbtools.standalone.Standalone execute
INFO: http://localhost:8080/apex started.It simply hangs at the last line and I couldn't make any further progress.
Can you please help to find out what went wrong?
Thanks in advance.
Regards,
Natarajan 
Hi Nattu,
Here is the error.
>
Dec 27, 2012 3:41:20 PM com.sun.grizzly.SelectorHandlerRunner handleSelectException
SEVERE: doSelect IOException
java.net.BindException: No free port within range: 8080=com.sun.grizzly.http.SelectorThreadHandler#480d41f3
>
Its a port conflict. The 11g XE EPG is using 8080 so the apexlistener cannot use the same port.
Try 8585 for Apexlistener.
If you want to use 8080 then disable EPG by connecting to the instance with SQLPlus as SYSDBA and running the following commands
SQL>EXEC DBMS_XDB.SETHTTPPORT(0);
SQL>COMMIT;Then start ApexListener on 8080
Cheers, 
Thank you Probodh for your quick help. I set the port 8080 to apex listener and it does not give that error now.
However, it still says "Default Database Connection not configured properly"
I gave the SID name as xe which is the default one, and that is the correct SID for my DB also.
Any possible mistakes in there?
D:\software\apex_listener>java -jar apex.war
Dec 27, 2012 7:29:45 PM oracle.dbtools.standalone.Standalone execute
INFO: NOTE:
Standalone mode is designed for use in development and test environments. It is
not supported for use in production environments.
Dec 27, 2012 7:29:45 PM oracle.dbtools.standalone.Standalone execute
INFO: Starting standalone Web Container in:  d:\apexlistnerconf\apex
Dec 27, 2012 7:29:45 PM oracle.dbtools.standalone.Deployer deploy
INFO: Will deploy application path = d:\apexlistnerconf\apex\apex\WEB-INF\web.xm
l
Dec 27, 2012 7:29:46 PM oracle.dbtools.standalone.Deployer deploy
INFO: Deployed application path = d:\apexlistnerconf\apex\apex\WEB-INF\web.xml
Dec 27, 2012 7:29:46 PM oracle.dbtools.common.config.file.ConfigurationFolder lo
gConfigFolder
INFO: Using configuration folder: D:\apexlistnerconf\apex
Default Database connection not configured properly
Dec 27, 2012 7:29:48 PM oracle.dbtools.rt.web.SCListener contextInitialized
INFO: Oracle Application Express Listener initialized
Application Express Listener version : 2.0.0.354.17.06
Application Express Listener server info: Grizzly/1.9.49
Dec 27, 2012 7:29:48 PM com.sun.grizzly.Controller logVersion
INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 12/27/12 7:29 PM
Dec 27, 2012 7:29:48 PM oracle.dbtools.standalone.Standalone execute
INFO: http://localhost:8080/apex started.Regards,
Natarajan 
Hi,
I set the port 8080 to apex listener and it does not give that error now.However, it still says "Default Database Connection not configured properly"
I gave the SID name as xe which is the default one, and that is the correct SID for my DB also.
>
SID=xe is correct as you are using 11g XE.
What is more important is whether you are able to access the Apex Application Builder through the ApexListener or not.
If Apex is not accessible then the thing to check would be the Apex_Public_user password. Can you login to XE using Apex_Public_user with the password you supplied when configuring the ApexListener?
Also ensure that the Apex_Public_user , and the other 2 users of ApexListener 2.0EA, are UNLOCKED.
Cheers, 
Thank you so much, Probodh. That was the case, after unlocking the accounts, the listener started successfully. Thanks again. 
I am now able to login to apex (that is http://localhost:8585/apex), but unable to get the page http://localhost:8585/apex/listenerConfigure or http://localhost:8585/apex/listenerAdmin and get Page not found error. As mentioned in the another thread Re: Getting blank page using APEX Listener in standalone mode , checked the images folder and it seems correct. The link http://localhost:8585/i/apex_version.txt returns the version correctly. Not sure what is wrong. Will highly appreciate your help.
Thanks,
Natarajan 
Hi,
both listenerConfigure and listenerAdmin don't exist in APEX Listener 2. These two interfaces are only available in the "old" APEX Listener 1/1.1 releases. APEX Listener 2 is configured using SQL Developer or its command line interface (CLI).
For the CLI, you should read the [url http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/config.htm#CBDCHGDF]APEX Listener Installation and Configuration Guide Release 2.0.
For SQL Developer, check [url http://docs.oracle.com/cd/E35137_01/appdev.32/e35117/intro.htm#CEGEEHGB]the corresponding section of the User´s Guide for Release 3.2.
-Udo 
Thank you Udo, very useful information for the new bees on Apex Listener. I did also try using SQL Developer, but for a silly reason it did not work. Being case sensitive, it did not accept the user name "Adminlistener" but accepted "adminlistener". Thanks again. 
Though I got steps successfully, I still need the great help from the forum. I have set everything for the listener thro SQL Developer, after that, The TEST button appears on the RESTful Service>Resource Template> Resource Handler Page in Apex SQL Workshop. However, if I click the button it says 404 Page not found error. The URL is http://localhost:8585/apex/natarajan/hr/empinfo where apex is the default data base, natarajan is my workspace name, hr is the RESTful service module and empinfo is the URI template. Note, it is the url of the sample web service oracle.example.hr created by Oracle itself. I am not sure what went wrong with this.
I followed the steps in the SQL Developer (version 3.2) User Guide for administrating RESTful services http://docs.oracle.com/cd/E35137_01/appdev.32/e35117.pdf , in there it is told in the section 1.16.4.2 to Enable RESTful Services, but I couldn't find an option in the SQL Developer window under the Listener>Database Settings>apex>Connections>RESTful Connection. I was able to give password for APEX_LISTENER and APEX_REST_PUBLIC_USER and the listener started successfully.
Will highly appreciate your help.
Regards,
Natarajan 
Reopening the issue as I get new issues. 
Hi,
Your new issue is not related to the Original Post. So I suggest you start a new thread for it.
Cheers, 
Thanks Probodh, I created a new post for the issue. RESTful web services throws page not found error in apex listener

MQJE001: Completion Code 2, Reason 2009 & 2019

Hi,
I had been working on the MDB off late and had encountered the following error
while trying to send out a message from the my system to an MQ.
All the connections are established when the service is brought up in Websphere.
My application is hosted on WebSphere 6.1.0.11.
On every incoming message to a particular queue my program consumes it and
onmessage() some other message will be send to a different queue. My program is able
to consume the first message but fails to write into the other queue.
I'm getting two errors, first MQ Exception 2009 and next MQ Exception 2019
I did some search on the below error which is an extract from my log created for the program.
People are saying its related to some MQ problem or something external rather than my application.
Its a known issue and they even have a fix in MQ for AIX but sadly couldn't find any for Windows.
Anybody there who can help me by letting me know how to handle this programmatically.
As far as connection objects are concerned it is not losing the object or getting null. Everything seems to ok.
But rather I believe there is some problem on the physical connection between the MQ and WebSphere.
I'm not sure too. But please provide me your valuable suggestions.
I tried changing the WebSphere connection pool and session pool settings to Entirepool and all but no Luck!
LOG EXTRACT FOR THE ISSUE
--------------------------------------------------------------------------------
FINE: Time : 06/10/2008 05:43:55.921 Inside SendSyncMessage
Oct 6, 2008 5:43:55 PM ejbs.MAPListenerBean
FINE: Time : 06/10/2008 05:43:55.921 IP Queue Name for Request Message : UIST.ONL.RQ.SVRG1.EWSS.BW
Oct 6, 2008 5:43:55 PM ejbs.MAPListenerBean
INFO: Reason Code : 2019
Oct 6, 2008 5:43:55 PM ejbs.MAPListenerBean
INFO: Reason Code : MQJE001: Completion Code 2, Reason 2019
Oct 6, 2008 5:43:55 PM ejbs.MAPListenerBean
SEVERE: MQException Occurred MQJE001: Completion Code 2, Reason 2019
--------------------------------------------------------------------------------
Thanks,
Arun Prithviraj

Axis error

Hello,
A client of us get's a invalid operation error when accessing our newly deployed axis webservice.
When I monitor the request and response I see the client pushes a soap envelope to our service and our service responds with an almost similar soap enveloppe. Can someone tell what's wrong? I see 2 differences in the enveloppe:
1) their encoding of the request enveloppe is with soap:Enveloppe tags, ours is with soapenv:Enveloppe . Is that a problem?
2) they send a xsi:type="ElaboratedDataPublication" attribute in 1 of the nodes of the message itself.
Our response leaves that attribute out. Can that be a problem. I think it might be, but, if so, how can I configure wsdl2java to set that right ? )
I hope you can help me. I' ve been spending to much time on it already ....
Edited by: waver on Oct 29, 2007 12:42 PM
Edited by: waver on Oct 29, 2007 12:43 PM

Axis2 with Tomcat 5.0.28

Joined: Sep 01, 2009
Messages: 4
     
[Post New]posted Today 2:51:36 PM
Quote Edit [Up]
Hi,
I am working Axis2 with Tomcat 5.0.28. I am facing same problem in enabling Admin service, please can any one help me.
I tried with below URL and received

Pages not displaying images when accessed from remote system-error on page.

Urgent pls help...
Hi,
We installed 10G database and installed application express.
we installed apex using the command #apexins SYSAUX SYSAUX TEMP /i/
then changed password using #apxchpwd
then #apxldimg.sql D:\oraclexe
we installed databse in D:
in D:/oraclexe we copied apex folder and done the above operations.
we run the listener using command
java -Dapex.home=D:/oraclexe/apex -Dapex.images=D:/oraclexe/apex/apex/images -Dapex.port=8585 -jar D:/oraclexe/apex/apex.war
then for four days it was working fine,
our team can access pages from client system and we were working on our project.
But for the last two days it is not working properly. I mean apex is loading with errors(without images).
the page is showing without images and links are not working
just data's in pages is only seen.
But when i connect through localhost it is working properly.
we installed it on server then there also localhost:8080 is working
but from client system has the above said problem
Give us a solution...
Thanks in advance...
Edited by: 874343 on Jul 22, 2011 5:26 AM 
Hi,
is your images directory still in place? Which port does your client use to call APEX what is the images prefix for that APEX instance? What do you see in the APEX Listeners error log? (see /listenerAdmin)
Did you try to restart the APEX Listener? Did anything change on the system or the network environment?
Usually things don't happen to stop working on a sudden...
-Udo 
hi
the link i am using from client system is
http://10.209.21.40:8585/apex
port:8585
image directory is in D:/oraclexe/apex
i rerun my listener many times using command
java -Dapex.home=D:/oraclexe/apex -Dapex.images=D:/oraclexe/apex/apex/images -Dapex.port=8585 -jar D:/oraclexe/apex/apex.war
i think nothing changed in the system settings and network.
listener is working thats why i am getting pages
but no images in it
JK
Edited by: 874343 on Jul 22, 2011 6:09 AM 
Very odd... What about the error log in listenerAdmin? And could you post the console output of the restart?
-Udo 
Hi
How to get the error log in listener admin 
ListenerAdmin is showing blank screen
this is my command prompt when running listener
D:\oraclexe>cd apex
D:\oraclexe\apex>java -Dapex.home=D:/oraclexe/apex -Dapex.images=D:/oraclexe/ape
x/apex/images -Dapex.port=8585 -jar D:/oraclexe/apex/apex.war
INFO: Starting: D:\oraclexe\apex\apex.war
See: 'java -jar apex.war --help' for full range of configuration options
INFO: Extracting to: D:\oraclexe\apex
INFO: Using classpath: file:/D:/oraclexe/apex/apex/____embedded/start.jar:file:/
D:/oraclexe/apex/apex/WEB-INF/lib/apex.jar:file:/D:/oraclexe/apex/apex/WEB-INF/l
ib/commons-fileupload-1.2.1.jar:file:/D:/oraclexe/apex/apex/WEB-INF/lib/je-4.0.1
03.jar:file:/D:/oraclexe/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/D:/oraclexe/apex
/apex/WEB-INF/lib/ojmisc.jar:file:/D:/oraclexe/apex/apex/WEB-INF/lib/poi-3.6-200
91214.jar:file:/D:/oraclexe/apex/apex/WEB-INF/lib/ucp.jar:file:/D:/oraclexe/apex
/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/D:/oraclexe/apex/apex/WEB-INF/lib/xmlpars
erv2-11.2.0.jar:
INFO: Starting Embedded Web Container in: D:\oraclexe\apex
Jul 22, 2011 6:48:19 PM ____bootstrap.Deployer deploy
INFO: Will deploy application path=D:\oraclexe\apex\apex\WEB-INF\web.xml
Jul 22, 2011 6:48:19 PM ____bootstrap.Deployer deploy
INFO: deployed application path=D:\oraclexe\apex\apex\WEB-INF\web.xml
Using config file: D:\oraclexe\apex\apex-config.xml
-- listing properties --
PropertyCheckInterval=60
ValidateConnection=true
MinLimit=1
MaxLimit=10
InitialLimit=3
AbandonedConnectionTimeout=900
MaxStatementsLimit=10
InactivityTimeout=1800
MaxConnectionReuseCount=1000
APEX Listener version : 1.1.2.131.15.23
APEX Listener server info: Grizzly/1.9.18-o
Jul 22, 2011 6:48:44 PM com.sun.grizzly.Controller logVersion
INFO: Starting Grizzly Framework 1.9.18-o - Fri Jul 22 18:48:44 IST 2011
INFO: http://localhost:8585/apex started.
Using JDBC driver: Oracle JDBC driver version: 11.2.0.2.0
Edited by: 874343 on Jul 22, 2011 6:42 AM
Edited by: 874343 on Jul 22, 2011 6:51 AM 
It should be reachable by calling http://10.209.21.40:8585/apex/listenerAdmin using username and password you entered upon the first start of your APEX Listener. Default username would be "adminlistener". Go to the "Status" Tab and find "Error Tracking" there.
-Udo 
Hi
listenerAdmin is showing blank screen
i think password is incorrect
do u have any idea what password is?
Edited by: 874343 on Jul 22, 2011 7:08 AM 
do u have any idea what password is?No, you have to enter this upon the first startup and there is no default...
You could reset it by just erasing the contents of the directory in apex.home and restart the listener again. Of course, you'll lose the state until that point, so you have to reproduce the error... If you have anything you need, e.g. resource templates, you should make a backup first - or just rename the directory and create a new one, or just change the value of the apex.home to point somewhere else...
-Udo 
Hi Udo,
I changed my port to 8585 from 8080 using exec EXEC DBMS_XDB.SETHTTPPORT(8585);
then even using http:\\localhost:8585\apex i have the problem
earlier using http:\\localhost:8080\apex i get pages properly.
My apex listener port is too set at 8585
is it the problem of port number
how to reset it by just erasing the contents of the directory in apex.home
Edited by: 874343 on Jul 22, 2011 7:51 AM 
Hi udo,
I found the problem.
it was due to port number clash i think
i changed the port number to 8080 for listener then it is working
i got these idea from one of ur old post
thank you udo
thank u very much 
Hi,
I didn't expect that you changed the XDBs HTTP port as well. You definetly have a port conflict now. Please note that XDBs HTTP Server and APEX Listener are two separate and completely different web servers, so you'll have to either run
EXEC DBMS_XDB.SETHTTPPORT(<newport>); or pass in a different port when starting the APEX Listener ( -Dapex.port=<newport> ).
-Udo 
Great to hear that!
Could you mark this question as answered then? And if applicable, mark relevant posts as "helpful" or "correct" so others searching for that issue can spot those posts easily.
Thanks,
Udo 
thank you udo 
Hi udo,
I changed XDB port using exec sethttp.... to 8585
then localhost was not working may be due to listener port is also 8585
then i rerun listener resetting port number to 8080
then i can get pages from client systems
i didnt checked localhost
since it is a server i dont need localhost access in that system...
so i will disable http server port by setting port number to 0.
But still i didnt understand what really the problem was
what i understand is listener was not working properly when localhost access is using simultanously with client system access
Edited by: 874343 on Jul 22, 2011 9:18 PM

Categories

Resources