OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Apex image access

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Apex image access (APEX4.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Apex image access [message #653305]

Fri, 01 July 2016 04:22

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

Littlefoot
Messages: 21824
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.

Report message to a moderator

Re: Add new image button [message #653517 is a reply to message #653305]

Sat, 09 July 2016 02:05

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

Report message to a moderator

APEX images acces [message #653899 is a reply to message #653305]

Thu, 21 July 2016 10:56

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

Report message to a moderator

Re: APEX images acces [message #653900 is a reply to message #653899]

Thu, 21 July 2016 11:12

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

Report message to a moderator

Re: APEX images acces [message #653901 is a reply to message #653900]

Thu, 21 July 2016 11:16

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

John Watson
Messages: 8978
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?

Report message to a moderator

Re: APEX images acces [message #653906 is a reply to message #653903]

Thu, 21 July 2016 23:02

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

APEX 4.0.2
Oracle10Express Edition
Linux Ubuntu
On Amazon Server

Regards

Report message to a moderator

Re: APEX images acces [message #653909 is a reply to message #653906]

Fri, 22 July 2016 01:31

John Watson
Messages: 8978
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.

Report message to a moderator

Re: APEX images acces [message #653913 is a reply to message #653909]

Fri, 22 July 2016 01:48

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

Report message to a moderator

Re: APEX images acces [message #653914 is a reply to message #653913]

Fri, 22 July 2016 01:51

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

Report message to a moderator

Re: APEX images acces [message #653916 is a reply to message #653914]

Fri, 22 July 2016 02:04

John Watson
Messages: 8978
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.

Report message to a moderator

Re: APEX images acces [message #653920 is a reply to message #653916]

Fri, 22 July 2016 02:25

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

Report message to a moderator

Re: APEX images acces [message #653922 is a reply to message #653920]

Fri, 22 July 2016 02:33

John Watson
Messages: 8978
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.

Report message to a moderator

Re: APEX images acces [message #653928 is a reply to message #653922]

Fri, 22 July 2016 04:37

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

Report message to a moderator

Re: APEX images acces [message #653932 is a reply to message #653928]

Fri, 22 July 2016 07:14

John Watson
Messages: 8978
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.

Report message to a moderator

Re: APEX images acces [message #653940 is a reply to message #653932]

Fri, 22 July 2016 10:25

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

Report message to a moderator

Re: APEX images acces [message #654001 is a reply to message #653940]

Mon, 25 July 2016 03:46

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

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

Report message to a moderator

Re: APEX images acces [message #654034 is a reply to message #654005]

Tue, 26 July 2016 01:52

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/

Report message to a moderator

Re: APEX images acces [message #654035 is a reply to message #654034]

Tue, 26 July 2016 02:22

John Watson
Messages: 8978
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.

Report message to a moderator

Previous Topic:	Java.exe error
Next Topic:	APEX variable not updated for javascript calling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 09 08:26:00 CDT 2025