Category APEX Community / Posted on by

I'm finalist for Oracle Database Developer Choice Awards in Oracle Application Express (APEX) category.

I'm very impressed and surprised for this honor.
I want thank all who have filled nomination form and voted.
Special thanks to all who have also leave comments and supported me
by blog posts and spreading word other ways.

If you haven't vote yet, now it's time. Voting ends at 15th of October.
Please remember you can vote multiple persons in all categories.

I hope Denes Kubicek's blog post encourage everybody to vote.

Category Oracle SQL Developer / Posted on by

If your web server use self signed certificate for https you most probably get "peer not authenticated" error when you try administrate Oracle REST Data Service (ORDS) using Oracle SQL Developer.

Peer not authenticated error message

To resolve this issue, you need import server certificate to Java cacerts keystore.

You can download server certificate e.g. using browser. In this example I use Firefox.

First navigate to your server URL and click lock icon next to URL. From popup click More Information.

Get server certificate using Firefox step 1

From opening window click View Certificate

Get server certificate using Firefox step 2

Click Details tab and then Export button

Get server certificate using Firefox step 3

Change the ‘Save as type’ to ‘X.509 Certificate with chain (PEM)’ and save the certificates to a file.

Get server certificate using Firefox step 3

Open command prompt and import certificate to Java cacert keystore. Please note that you need import certificate to Java installation/version witch SQL Developer uses.

Here is example of command how import certificate in Windows

C:\sqldeveloper\jdk\jre\bin\keytool.exe -import -noprompt -trustcacerts ^
-alias vbox-apex.localdomain ^
-file C:\Temp\vbox-apex.localdomain.crt ^
-keystore C:\sqldeveloper\jdk\jre\lib\security\cacerts ^
-storepass changeit

Import certificate using Java keytool

Now administrating Oracle REST Data Service using Oracle SQL Developer over https works.

ORDS connection


Category APEX Sample Applications / Posted on by

Finally I did have some time finish and publish new version of APEX Blogging Platform.

Application is completely rewritten and have much more features and new theme. It is simple to install also to hosted APEX instance.

You can download application from SourceForge.

If you have comments or enhancement ideas please submit those to SourceForge project page Tickets or Discussion.

New APEX Blogging Platform

1 2 3 4 5 6 7 8 9 10 Next Set



Subscribe in a Reader

Build with Oracle Application Express