Feeds:
Posts
Comments

Posts Tagged ‘db connection’

When you create a new ADF Business component that uses a DB connection (like Business component From Table, Entity Object etc..), you can see that automatically the wizard connects you to a predefined DB connection.
Usually, if you have only one DB connection defined it’s not a problem. But when you have more than one connection, you want to control the required connection.

 

To change or control the default connection, follow the next steps –

Right click on your project and choose Project Properties:

Project Properties

(more…)

Read Full Post »

The below error can happen when you run any kind of a process that uses JDBC:

ORA-28267: Invalid Namespace Value In SOA Suite 11.1.1.7
ORA-02063

This is a bug!
The cause of the problem is when using Oracle JDBC Driver file (ojdbc6dms.jar) and calling a DB object (procedure, function etc…) that issues SQL over a DB link from 11g to 10g DB.

There is no patch for that at the moment.
I found a workaround, that was approved by oracle:

Under the below folders, replace the ojdbc6dms.jar file with ojdbc6.jar file:
$MID_HOME/wlserver_10.3/server/ext/jdbc/oracle/11g
$MID_HOME/oracle_common/modules/oracle.jdbc_11.1.1

You can find the ojdbc6.jar driver in the below link:
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

It is also suppose to be under $MID_HOME/wlserver_10.3/server/lib. You can just copy it from there.

There is one exception: No JDBC metrics will be produced. If you need it, you will have to open SR.

Good Luck!

Read Full Post »

The following steps describes how to create a JNDI location so you can use it later on your DbAdapter
(The configuration is done on Oracle EM 10g(10.1.3.1) Application Server Control):

1. Create a Connection Pool

In the EM click on your OC4J server (where Bpel PM exists in):

oc4j

 

 

(more…)

Read Full Post »