Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Apex image access (APEX4.0.2)
Apex image access [message #653305] Fri, 01 July 2016 04:22 Go to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi

i search how add new images button to my APEX ?.
I could see in browser current custom images with http://xx.xx.xx.xx:8080/i
I have add new images into APEX with share components then Files and Images then Create and attach gif to my application
BUT my new images are not added to directory and i could not use it ??


I have searched too on remote Linux current existing button without succes.

Regards


[MERGED by LF]

[Updated on: Thu, 21 July 2016 14:55] by Moderator

Report message to a moderator

Re: Add new image button [message #653309 is a reply to message #653305] Fri, 01 July 2016 05:46 Go to previous messageGo to next message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

I have add new images into APEX with share components then Files and Images then Create and attach gif to my application

That's how I do it too, with one exception: I prefer having them NOT associated with a specified application, but rather the whole WORKSPACE.

Quote:

BUT my new images are not added to directory and i could not use it ??

That's because they are stored in the database. Anyway, how do you refer to those images in your application? I use (for example) #WORKSPACE_IMAGES#IMAGE_NAME.JPG (while you'd use #APP_IMAGES#IMAGE_NAME.JPG) and it works just fine.

Re: Add new image button [message #653517 is a reply to message #653305] Sat, 09 July 2016 02:05 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi,

I could not see my image on http://xxx.xxx.xxx.xxx/i when i use method to add images from APEX.
How could i resolve this problem ?


Thanks
APEX images acces [message #653899 is a reply to message #653305] Thu, 21 July 2016 10:56 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi,

I want to add new image button to my application
In first step i have make
*Choosing my application
*Then "Shared components", then "Files", and "as Images".
*And finally button "Create".
=> Ok my new GIF button are visible in this utility screen but not in my application.

Then in second step it seems me gif images are others
I could acces from application with
<img src="/clientappli/images/buttonlargeCSV.gif" alt="">
And when i go to http://xx.aaa.bbb.zzz:8080/clientappli/images , there is many gif too, but not my new GIF

SO,It seems me there is two things images in databases from Shared Component AND another in directory "clientappli" ??

http://xx.aaa.bbb.zzz:8080/clientappli/images
I have tried from LINUX to find this directory with sudo find command without succes ?
How could i acces to this directory ?

Regards
Phil





Re: APEX images acces [message #653900 is a reply to message #653899] Thu, 21 July 2016 11:12 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
sudo find / -name "buttonlargetariff.gif" -print
"buttonlargetariff.gif" is an old image visible in http://xx.aaa.bbb.zzz:8080/clientappli/images
Re: APEX images acces [message #653901 is a reply to message #653900] Thu, 21 July 2016 11:16 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
favori réseau (maj images, doc utilisateur):
system
xxxxx

But how ? my remote server has no samba and is not on my internal network ?

[Updated on: Thu, 21 July 2016 11:26]

Report message to a moderator

Re: APEX images acces [message #653903 is a reply to message #653899] Thu, 21 July 2016 13:17 Go to previous messageGo to next message
John Watson
Messages: 8313
Registered: January 2010
Location: Global Village
Senior Member
I approach this as a DBA, not as a developer. However, I do know that depending on whether you are using the embedded PL/SQL gateway, or Apache with modplsql, or ORDS deployed to a Java container of some sort, there are different mechanisms for making images available. For our commercial implementations, we use ORDS deployed to Glassfish on one machine and place images on an Apache reverse proxy server on a different machine. How is your environment configured?
Re: APEX images acces [message #653906 is a reply to message #653903] Thu, 21 July 2016 23:02 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi,

APEX 4.0.2
Oracle10Express Edition
Linux Ubuntu
On Amazon Server

Regards
Re: APEX images acces [message #653909 is a reply to message #653906] Fri, 22 July 2016 01:31 Go to previous messageGo to next message
John Watson
Messages: 8313
Registered: January 2010
Location: Global Village
Senior Member
Do you know if you are using ORDS or Apache or the EPG? The answer to your question is dependent on this.
Re: APEX images acces [message #653913 is a reply to message #653909] Fri, 22 July 2016 01:48 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi,

there is no apache directory on /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
How could i check it ?
With sudo find / -name "apache.conf" -print -> no file found
Re: APEX images acces [message #653914 is a reply to message #653913] Fri, 22 July 2016 01:51 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Directory on ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
in demo ldap nls plsql sauvegarde.dmp sqlnet.log
config hs lib odbc precomp sauvegarde.log sqlplus
ctx jdbc log opmn rdbms xdk
dbs jlib network oracore slax
Re: APEX images acces [message #653916 is a reply to message #653914] Fri, 22 July 2016 02:04 Go to previous messageGo to next message
John Watson
Messages: 8313
Registered: January 2010
Location: Global Village
Senior Member
Do you understand how APEX works? Did you install it, or your DBA?

You must have an http listening service. That is what you connect to when you issue a URL. That service could be an Apache httpd web listener with modplsql, which could be running on any machine in the universe. Or it could be be the ORDS (do you know what that is? Have you looked that up yet?) either running stand-alone or deployed to a Java container somewhere. Or it could be the database listener, running on your database server machine withe EPG configured within the database.

You really do need to this out. Then your question can be answered.
Re: APEX images acces [message #653920 is a reply to message #653916] Fri, 22 July 2016 02:25 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
I have not install this old server
And all this team leave or company, so i am alone with tis project which is new for me

Regards
Re: APEX images acces [message #653922 is a reply to message #653920] Fri, 22 July 2016 02:33 Go to previous messageGo to next message
John Watson
Messages: 8313
Registered: January 2010
Location: Global Village
Senior Member
Better do some studying, then. Read the installation guide. That explains the http listening options, and where your images are stored for each case.
Re: APEX images acces [message #653928 is a reply to message #653922] Fri, 22 July 2016 04:37 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
It seems solution is with webfolder
http://daust.blogspot.fr/2006/03/where-are-images-of-application.html
Re: APEX images acces [message #653932 is a reply to message #653928] Fri, 22 July 2016 07:14 Go to previous messageGo to next message
John Watson
Messages: 8313
Registered: January 2010
Location: Global Village
Senior Member
That is because you are using the Embedded PL/SQL Gateway. Nothing to do with using XE.
Re: APEX images acces [message #653940 is a reply to message #653932] Fri, 22 July 2016 10:25 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Ok but since APEX administration menu, i could not update this "/clientappli" directory which is not "/i" directory
Re: APEX images acces [message #654001 is a reply to message #653940] Mon, 25 July 2016 03:46 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi

I have tried following method on linux remoteserver contains Oracle10XE
https://www.packtpub.com/packtlib/book/Application-Development/9781849681063/1/ch01lvl1sec06/Embedded%20PL/SQL%20Gateway
BUT
ftp://SYS:XXXX@AA.BB.CC.DD:2100
give me following error message
Le serveur FTP 215 Unix Type:A Version:Oracle XML DB n'est pas géré dans cette version.

Regards

[Updated on: Mon, 25 July 2016 03:47]

Report message to a moderator

Re: APEX images acces [message #654005 is a reply to message #654001] Mon, 25 July 2016 04:11 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi
I have tried too with FileZilla
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
Réponse : 220 ciapacaprod FTP Server (Oracle XML DB/Oracle Database) ready.
Commande : USER system
Réponse : 331 pass required for SYSTEM
Commande : PASS **********
Réponse : 230 SYSTEM logged in
Statut : Connecté
Statut : Récupération du contenu du dossier...
Statut : Le serveur a envoyé une réponse passive avec une adresse non routable. Adresse remplacée par celle du serveur.

How could i config FileZilla or XMLDB for avoiding error message ?
Regards
Re: APEX images acces [message #654034 is a reply to message #654005] Tue, 26 July 2016 01:52 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Resolved

1 Sous SQLDEveloper
select dbms_xdb.getftpport from dual; -- Si 0
exec dbms_xdb.setftpport('2100'); --Active le serveur XMLDB
alter system register; -- prise en compte immediate

2 Sous UNIX depuis la machine
A Transfert par filezilla sur le serveur sous /home/ubuntu/img/t1 des GIF


B FTP en local depuis le serveur LINUX
ftp
> open serverName 2100 (user system et mot de passe)
cd /clientrep/images
lcd /home/ubuntu/img/t1
put buttonlargeCSV.gif
put buttonlargeExcel.gif

C verification images
http://xx.yy.zz.tt:8080/clientrep/images/

Re: APEX images acces [message #654035 is a reply to message #654034] Tue, 26 July 2016 02:22 Go to previous message
John Watson
Messages: 8313
Registered: January 2010
Location: Global Village
Senior Member
Nice description of how to make images available when using the EPG. I'm sure other members will find it helpful.

Remember that the technique is different when using ORDS. The company I work for uses ORDS for all production systems. Oracle states that the EPG is not supported for production systems. That does not apply to you because you are using XE, which isn't supported either. However, our developers tell me that they need access to facilities that ORDS provides which are simply not available through the EPG. If you intend to move this application forward, you may want to think about this.
Previous Topic: Java.exe error
Next Topic: APEX variable not updated for javascript calling
Goto Forum:
  


Current Time: Tue Aug 04 21:36:50 CDT 2020