It is resolved.
previously I used apex_listener.220.127.116.117.04.27 & ords.18.104.22.168.15.01, both of them did not work.
so I used apex_listener.22.214.171.124.00.12, which is a previous version and it worked, as soon as I used the links provided after we launch the application (https://<hostname>:8181/apex/listenerConfigure) i was able to configure the apex listener.
So the solution was to use lower version of apex listener instead of higher version when configuring against glassfish.
I've had a similar issue with ORDS, where the configdir didn't point to the right place. This happened because I didn't configure the directory before configuring the listener. To work around it, I removed all the ords files, re-installed them, ran the directory configuration first, and then the listener configuration. After deploying the ords.war file, the listener worked correctly.
Hello Chirstoph, how did you set the configuration directory?
did you set in "/apps/gf/glassfish3/glassfish/domains/domain1/applications/apex1/WEB-INF/web.xml" file, or did you run it as "java -jar apex.war configdir /path".
Hello Ghana, I tried using ords.war, it didn't work, so I used the lower version, i think it was a problem due to the setting of the configdir, I guess in the lower version the configdir is set automatically,.
When I used ords.war, i tried setting the configdir in web.xml file and also manually by running the "java -jar apex.war configdir" command.
is there an order in which we have to set the configdir, like should I set it before a step or after a step in the process of configuring glassfish listener. Me, first I created the application "apex" and then changed the ords.war. still the logs were written to /var/tmp/apex directory (default)
When I first started configuring apex listener on glassfish, I used the web.xml to set the config directory. when that didn't work, I used the java -jar to set the config directory. it didn't work. it may be because I set the config directory in two locations that my listener configuration didn't work.
I will try to set it up using java -jar only and will try if that works for the latest version of apex listener.
Normally this happens in Linux, i don't know if it is a known issue ,where when you set the configuration location it defaults to the glassfish location OR some temp location.
The best thing to do is
- to clear the folder of the ORDS settings left
- Set the configuration location to the location specified
- reconfigure the ords.war file again using
java -jar ords.war setup
Hello Ghana / Christoph
Thank You for your replies.
For the time being I am fine with a lower version of apex listener. I want to get a feel of working with apex and setting up connection pools before moving forward.
I configured Apex Listener 1.1 with Glassfish 3.
the server where I installed apex doesn't contain oracle RDBMS software and no databases are running on this server.
I got to the page https://<localhost>:8181/apex/listenerConfigure and I entered the details of the database present in another server.
after the click apply the page just hangs
it goes to the following link and just stays there (the tab in the google chorme says "Application Express Login")
https://<localhost>:8181/apex/f?p=4550:1:14105114011306 (localhost is the host were the listener and glassfish are installed but not the database where apex is installed.)
Now to see if I made any mistakes i go to the https://<localhost>:8181/apex/listenerAdmin and login with the adminlistener account
when i go to the page, I see that all the fields asking for the database info are greyed out, I am not able to enter any information in them.
1. Is it required that a dummy database be created in the server where the listener is installed and setup apex on that dummy database?
2. How can I add more databases to the connection pool?
3. Where can I find the URLs that I can use to connect to other databases present in other servers using the apex listener?
I'm with Ghana here: Use the new listener (ORDS) which will allow you to add multiple databases.
The database does not have to be on the same server as the web server (that's kind of the point of the listener).
When you configure additional databases with ORDS, you configure a URL path as well. Your first database will probably be <host>:8181/ords, the additional databases will be something like <host>:8181/ords/database2/ or <host>:8181/ords/database3.
Hello Ghana, that is what I've been trying to do, i've been trying to configure ords 2.07 against glassfish3, but it is not working. after I launch the applications, I get the screen that the application listener has not been configured. i am not sure where i am going wrong,
---unzipped the ogs-126.96.36.199.zip file
---unzipped the ords.188.8.131.52.15.01.zip file
---created "adminlistener" in ADMIN group & "managerlistener" in Manager group
---enabled default to principle role mapping
---set JACC to "simple" from "default" in security
---set the configdir manually for the ords.war by "/usr/bin/java -jar ords.war configdir /directory/path"
---created the ords application by select the ords.war.
---moved the image files from "/apex/image"s to "glassfish3/glassfish/domains/domain1/docroot/i"
---launched the application ords.
I get two links and click on any of them "https://<localhost>:8181/ords/listenerConfigure", after that I get the page saying the Listener hasn't been installed.
but with apex listener 1.1.4 all the above steps work fine and I get to the listenerAdmin page. but after configuring one database connection I am not able to configure another database connection, because the fields requiring me to enter the database info for the connection are grayed out.
I just have two question I am trying to find the answer to.
1. why is ords and apex listener 2 not working for glassfish3 where as apex listener 1 does? is it because I am running glassfish3 instead of glassfish4
2. why can't I configure more database connection with the apex listener 1.1.4? (i am totally fine with having a lower version of apex listener as long as it meets my requirements of connecting to multiple database and running apex.)
####My java version####
java version "1.6.0_51"
Java(TM) SE Runtime Environment (build 1.6.0_51-b11)
Java HotSpot(TM) Server VM (build 20.51-b01, mixed mode)
First check to the location of the Configuration File ie.
java -jar apex.war configdir
if that is null then, there has to be reconfigure to the appropriate location.
java -jar apex.war configdir <location path>
If this doesnt work in linux for the glassfish then , make sure to set it to the appropriate location it specifies.
Then rerun the setup again
java -jar apex.war setup
Setup to the port of choice there.
and recheck that the port is indeed there located in the apex.properties file in the apex folder located in the configuration path you set
Something like this
apex.images=<Image path here> http.port=8181
Try launching Apex from glassfish server again .
Hope this works