OSB DB adapter in jdeveloper 12c having error

Thread description :https://community.oracle.com/thread/4084946

I’m using Jdev and while creating DB adapter getting an error message “Failed to generate the business service Can’t set text value, current token can have no text value”

I searched the web and found that Oracle has a patch for this issue, but the description for linux was not there and beside that the documentation is too large to get read all for a small and critical issue.

I will make it easy for you and I have tested myself.

download the patch Patch 26851310 from oracle support site here. or from my repo here.

  • unzip it anywhere
  • make sure to have oracle_home and java_home set
  • go to <oracle_home>/OPatch
  • ./opatch apply /User/mazinabdulah/oracle/Middleware/Oracle_Home/26851310/

Installing APEX 18.1 in a Docker container

I have APEX 5.1 installed in a docker container, when APEX 18.1 was out I thought about creating a new image, but I have customer applications running on APEX 5.1. Then I saw the idea of Dimitri Gielis about cloning the database and installing APEX on the new environment.  What you will be needing is your existing Oracle 12c image (you can download it from my docker hub).

  1. Oracle 12 image
  2. ORDS 18.1

Clone the database just like Dimitri Gielis is suggesting in his blog.

Create ORDS image from Oracle “docker-images-master” (you can download it from Git)

— copy apex18.1 to docker
docker cp apex_181..zip oracle12c:/temp/apex_18.1.zip

— shell to enter the container
docker exec -it oracle bash -c “source /home/oracle/.bashrc; bash”

— install APEX inside the docker container (login as sysdba)


— Run the apex_rest_config command

— before creating the ORDS container make sure that the needed users have no password expired.

alter user APEX_PUBLIC_USER identified by oracle;
alter user APEX_LISTENER identified by oracle;
alter user APEX_REST identified by oracle;

once APEX installation is done, create a new ORDS container from the image.

— create ords container
docker run -t -i \
–name ords \
–network=oracle_network \
-e DB_HOSTNAME=oracle \
-e DB_PORT=1521 \
-e APEX_REST_PASS=oracle \
-e ORDS_PASS=oracle \
-e SYS_PASS=oracle \
–volume /Volumes/HDD/docker/apex/18.1/images:/usr/local/tomcat/webapps/i \
-p 8081:8080 \

I have the old ORDS3 running on 8080, for ORDS18 I’m using 8081.

You are done, You have both APEX versions running side by side. now you can connect to APEX18.1 on localhost:8081/ords

If you have any question, just drop me a message.