Export Cross Reference Table

Set below environment variables.


export OC4J_USERNAME=oc4jadmin
export OC4J_PASSWORD=oc4jadmin
export DB_URL=jdbc:oracle:thin:@HOST_NAME:1521:SERVICE_ID
export DB_USER=aia
export DB_PASSWORD=aia

Execute below commands to export ITEM_ITEMID table to Item_Xref.xml file.

$ cd $ORACLE_HOME/integration/esb/bin

$ ./xrefexport.sh -file ./Item_Xref.xml -table ITEM_ITEMID

NOTE: If you encounter any error as below then set the environment variable 'export oc4j_username=oc4jadmin' and 'export oc4j_password=welcome1' instead of upper_case variable name

$ ./xrefexport.sh -file ./Item_Xref.xml -table ITEM_ITEMID

./xrefexport.sh[49]: test: Specify a parameter with this command.
invoke:Connection Details =sun.net.www.protocol.http.HttpURLConnection:http://HostName:7777/esb/j_security_check
postAndReceive:Connection response code = 302
getCookie:Final cookie value = JSESSIONID=39256409e4e9d3aa94731f05baa844eb8e9e35bf6cde13a5b37bd08c486c6aa8.e3mMc3qLbN8Le34RbN4Rch8Na3j0; path=/esb
invoke:Connection Details =sun.net.www.protocol.http.HttpURLConnection:http://HostName:7777/esb/login_error.jsp
postAndReceive:Connection response code = 200
getCookie:Final cookie value = JSESSIONID=39256409e4e9d3aa94731f05baa844eb8e9e35bf6cde13a5b37bd08c486c6aa8.e3mMc3qLbN8Le34RbN4Rch8Na3j0; path=/esb
Export Failed .. reason : "Authendication Failed"


Above error occurs due to a bug in xrefexport.sh which reads the environment variable oc4j username and password with lower case oc4j_username/oc4j_password. This error occurs only in some versions of SOA Suite alone.