Learn with Pavan

I had an issue in configuring the JDev 11g TP4. Earlier I had JDev 11g TP3 in my database and I wanted to install / configure TP4 in my database. But when I checked the scripts, I had seen that the tables and views and queues are same as TP3. So, I thought of removing TP3. For that I had to drop the adrs_soainfra user in the database (now it is renamed to jdev_soainfra).

When I tried to drop the user, I got an error : The ADRS_SOAINFRA cannot be dropped as there is a dependent queue IP_OUT_queue and it needs to be dropped first.

So, I had dropped it and again tried to drop the user. But again same error with different queue. So, I had created the following script to drop the related queues of this user and then dropped the user as follows:

SQL> set serveroutput off
SQL> set pages 1000
SQL> set head off

SQL> spool dropp.sql

SQL> select 'exec dbms_aqadm.stop_queue( queue_name => ''ADRS_SOAINFRA.'||name||''', wait => FALSE);' from dba_queues where owner='ADRS_SOAINFRA';

SQL> select 'exec dbms_aqadm.drop_queue( queue_name => ''ADRS_SOAINFRA.'||name||''');' from dba_queues where owner='ADRS_SOAINFRA';

SQL> select 'exec dbms_aqadm.drop_queue_table(queue_table => ''ADRS_SOAINFRA.'||queue_table||''',force=>TRUE);' from dba_queues where owner='ADRS_SOAINFRA';

SQL> spool off

Now run the dropp.sql using 'SYS' user.

Then execute the following to create the objects in the database. Please check the usernames carefully before creating the objects:

$ cd $JOH\rcu\integration\soainfra\sql

$ sqlplus sys/ as sysdba
SQL> @createuser_soainfra_oracle_all.sql jdev_soainfra SYSTEM TEMP
SQL> conn jdev_soainfra/
SQL> @createschema_soainfra_oracle_all.sql jdev_soainfra

Then configure JDEV 11g TP4:

1. From Tools > Preferences > Run > Select Integrated Server.

2. Ensure no proxy being set (if your database and jdev are in the same domain, then it is not needed).

3. Again from Tools > Configure SOA > enter the database details and click on Test.

That should work now. Enjoy the new version.