Friday, April 30, 2021

Oracle Apex Software Development Companies

Oracle Apex Software Development Companies (1st page on google.) https://adjacentsolutions.com/http://ogesinfotech.com/index.phphttps://www.insum.ca/https://pretius.com/main/https://www.octalsoft.com/https://www.foex.athttps://diceus.com-----------------------------------------------------------------------------------------------------------------------...

Monday, April 19, 2021

Oracle Apex Date Picker to Text Field Dynamic Action PLsql

 DECLARE  V VARCHAR2(10):='';  vAttdt date;BEGIN  vAttdt := :p44_attdt;  :P44_ATTDT2:=TO_CHAR(VaTTDT,'RRRRMMDD');E...

Jasper Soft Character to Date conversion in Expression Editor

click [..] to go to Expression Editor.new SimpleDateFormat("yyyyMMdd").parse($P{P_ATTDT})$P{P_ATTDT}    ------------ > This is the Parameter or field.Note : Month should be in MM format not in mm Format. e.g.  new SimpleDateFormat("yyyyMMdd").parse($P{P_ATTDT})enjoy...

Friday, April 9, 2021

How to enable/disable ssh login through putty

Some time you may want to disable login through putty by the port 22 SSH. You have to reboot the pc after disable sshd. Then add the firewall ports. Start listener. Restart tomcat and start Apache.Step 1 : Enable or disable sshd in vultr.com console after login---- systemctl enable sshdsystemctl disable sshdStep 2 : Restart the server.init 6Step 3...

Tuesday, April 6, 2021

How to integrate Jasper Report in Linux

cd /opt/oracle/apexcopy jri-2.7.0-jasper-6.16.0.zip to /opt/oracle/apex ---- By SSH Secure file transferDownload : https://github.com/daust/JasperReportsIntegration/releasesunzip jri-2.7.0-jasper-6.16.0.zipmv jri-2.7.0-jasper-6.16.0 jricd /opt/oracle/apex/jrimkdir confmkdir logsmkdir reportscd /opt/oracle/apex/jri/binchmod +x setConfigDir.shcd...

Saturday, April 3, 2021

How to Install SSL Certbot of LetsEncrypt

 How to Install SSL Certbot of LetsEncrypt :vi /usr/local/tomcat/conf/server.xml-- Change tomcat port to : 1610cd /usr/local/tomcat/bin./shutdown.sh ./startup.shfirewall-cmd --zone=public --add-port=1610/tcpfirewall-cmd --zone=public --add-port=443/tcpsudo systemctl start httpdcd /etc/httpd/conf.dvi 10-apex.conf<VirtualHost *:80> ...