java.sql.SQLException: ResultSet.next was not called Oracle JDeveloper, B2B Callout

While running a Java code of B2B callout i was getting the below error. This was due to below Java code. The commented code was causing the problem then i defined it in if statement as shown below. I hope you understand the reason.  PreparedStatement pstmt = conn.prepareStatement("My select query=?");         pstmt.setInt(1, Integer.parseInt(SequenceNum));          ResultSet rs = pstmt.executeQuery();                //  TR=rs.getString(1);  ...

Read More

javax.naming.CommunicationException [Root exception is java.net.ConnectException: t3: Destination unreachable

While compiling some code in JDeveloper I was getting the below error. It was coming due to proxy issue. So go to Jdeveloper then Tools---Preferences---Web Browser and Proxy then in exceptions field enter your server hostname. Test your code again and this time hopefully error will not come. It resolved my issue and i hope it will be helpful. SEVERE: javax.naming.CommunicationException [Root exception is java.net.ConnectException: t3://hostname:port: Destination unreachable; nested exception is:  java.net.ProtocolException: unrecognized...

Read More

java.security.PrivilegedActionException: weblogic.common.ResourceException Oracle SOA

java.security.PrivilegedActionException: weblogic.common.ResourceException: java.security.PrivilegedActionException: weblogic.common.ResourceException: No credential mapper entry found for password indirection user=apps for data source DataSourceName While creating a war file and then deploying on weblogic we get this error. To get ride of this error in Jdeveloper go to application properties and then deployments and then uncheck "Auto Generate and Synchronize weblogic-jdbc.xml Descriptors During Deployment" then create WAR file again...

Read More

Error(1,1)mdssys/mdx/componentType.rdf: XML-20108: (Fatal Error) Start of root element expected.

 Error(1,1)mdssys/mdx/componentType.rdf<Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected. Sometimes when we build Oracle SOA project we get the above error. To resolve this issue just go to those file where this error is coming you can see this from compiler and remove those file or add following in those files  <xml version="1.0" encoding="UTF-8"/>  Save it and rebuild the code again and this error will be no more...

Read More

rul-05720 datatype mismatch for test jaxbelement >int Oracle SOA business rule

rul-05720 datatype mismatch for test jaxbelement >int Sometime we face this error while creating business rule. I was facing the same issue with variable that I was using in business rule by removing minOccurs="0" in my schema element. Like below  <xs:element name="netAmount" type="xs:decimal" minOccurs="0" nillable="true"/> just remove the highlighted area and try to create your business rule with newly updated schema. <xs:element name="netAmount" type="xs:decimal"  nillable="true"/> ...

Read More

Oracle SOA Business rule Fact not found in the rule engine working memory

The following error comes sometimes in Oracle SOA suite business rule. Fact not found in the rule engine working memory, rule session execution failed. This is most likely a rule modeling error. I was facing the same issue while working on business rule. The error was coming due to schema issues or namespace issues in schema. If you create a separate application and test this using the same schema the chances of error would be very less. I just created a new XSD with new target namespace and copy pasted the existing elements/complex elements...

Read More

Oracle BPM 12c vacation rule

Recently I was trying to use Oracle BPM 12c vacation rule but it was not working for me. I also posted on Oracle community and following was the detailed problem.  Oracle BPM 12c vacation rule issue How it worked for me then? So go to your .task file of that user like manager in my case as shown below in snapshot. Now double click on default.DefaultPerformet activity and go to properties. Then from General tab select names and expression...

Read More

Oracle SOA BPEL Email error Could not connect to SMTP host: smtp.gmail.com

I configured email server in Enterprise Manger and then I used email activity in BPEL to send notifications. But I was facing the below issue. After much troubleshooting I figured it out as network issue. My server was behind proxy server and it was blocking such type traffic then I have to check it with network guy who unblocked this port and then my emails started working properly. <Warning> <oracle.sdpinternal.messaging.driver.email.outbound.EmailOutboundConnection>...

Read More

Oracle BPM 12c error ADF_FACES-60097, ADF_FACES-60096 server exception during PPR #15

Recently I was working on Oracle BPM 12.1.3 and I was constantly getting the following error Error ADF_FACES-60097, ADF_FACES-60096 server exception during PPR #15 I also asked on Oracle community page and somehow got ride but for just short time and its started appearing again and again. If you are facing the same issue in 12.1.3 then raise an SR and you will be asked to apply a patch to fix this bug. I was too facing issues like that and after applying patch it started working fine. Error detail from log file [2015-02-26T12:35:06.794+05:00]...

Read More

Oracle BAM 12C error(BEA-240003,SPI:260112) while updating OracleBamAdapter

While updating Oracle BAM 12 adpater OracleBamAdapter I was facing the below error. After troubleshooting I figured out that OracleBamAdapter was not targeted to any server. To resolve this issue go to Deployments, then click on OracleBamAdapter and then select Targets from top menu bar of OracleBamAdapter  setting. From the servers list select any server like bam_server1 and hit save. Now try to update OracleBamAdapter  again and you will not face this issue. Hope this will help. <Jun 2, 2015 1:15:21 PM...

Read More

SQLDeveloper is not connecting to remote database

I have already written a post on SQL Developer connectivity problem. But recently I got one new error while connecting SQLDeveloper to remote database. First as I mentioned in my last post set proxy if you are using any in your SQLDeveloper and then try to connect it. But If it still gives the error then tried this workaround and I hope it will be helpful too. Sometime when we are connecting more than one internet connection due to any reason...

Read More

Linux command to set ORACLE_HOME temporary

When someone is newbie, these types of command are really helpful. I just want to share how to set  ORACLE_HOME path easily. Following is the command. export ORACLE_HOME=/Oracle/Middleware/Oracle_Home To check ORACLE_HOME use the following command echo $ORACLE_HOME It should be: /Oracle/Middleware/Oracle_Ho...

Read More

OPatch command error, Oracle SOA 12c opatch commad

I was executing opatch command to know about version but I had been facing the following error. I could not understand why is it happening. Then I used the correct path of JDK with below command an it worked. [oracle@bpm01 OPatch]$ ./opatch lsinventory Exception in thread "main" java.lang.UnsupportedClassVersionError: com/oracle/cie/gdr/external/InventoryException : Unsupported major.minor version 51.0         at java.lang.ClassLoader.defineClass1(Native Method)         at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)  ...

Read More

Oracle SOA Suite 12C search Instances by Flow ID

Well, its very simple post but you can face problem when use Oracle SOA suite 12c to search specific instance by using Flow ID  . If you have worked with Oracle SOA suite 11g, You would have observed search criteria which is very simple but in 12C, search criteria is little advance. I want to search instance by using Flow ID but in first glance I could not. To do this click on Add/Remove filters in search window and then check flow instance....

Read More

'javac' is not recognized command error while compiling Java program

I created a Java program and tried to compile it by command line via following command but it gave me the following error E:\Java>javac HelloClass.java 'javac' is not recognized as an internal or external command, operable program or batch file. So what was wrong in it? To compile Java program we need to set JDK path instead of JRE that was in my case.  So I simply set the JDK path via following command and then I compiled my program it worked fine. E:\Java>set PATH="C:\Program Files\Java\jdk1.7.0_75\bin" E:\Java>java -version java...

Read More

Unlock user command for Oracle Database

Sometime a user gets locked and can not log in to database. To unlock it we need to run following command. SQL> alter user username identified by Password account unlock;User altered.SQL>...

Read More