JDE Standalone 9.1.0 - Dynamic Connector Issue - SpecFailureException: Fail to co

tej_datta

Member
Hello,
I have installed JDE Standalone 9.1.0 successfully. I could successfully login to Solution Explorer and Webclient. Now I have written a Java program to connect to JDE using Dynamic connector. It compiles successfully, but fails to run:

import com.jdedwards.system.connector.dynamic.ApplicationException;
import com.jdedwards.system.connector.dynamic.*;
import com.jdedwards.system.connector.dynamic.ServerFailureException;
import com.jdedwards.system.connector.dynamic.SystemException;
import com.jdedwards.system.connector.dynamic.callmethod.BSFNExecutionWarning;
import com.jdedwards.system.connector.dynamic.callmethod.ExecutableMethod;
import com.jdedwards.system.connector.dynamic.spec.SpecFailureException;
import com.jdedwards.system.connector.dynamic.spec.source.BSFNMethod;
import com.jdedwards.system.connector.dynamic.spec.source.BSFNSpecSource;
import com.jdedwards.system.connector.dynamic.spec.source.OneworldBSFNSpecSource;

public class TestJDEConnection {
public static void main(String args[]) {
Connector connectorProxy = null;
// OneWorldInterface ow;
BSFNSpecSource specSource = null;

int sessionID = 0;
System.out.println("1");
//connectorProxy = new Connector();
try {
System.out.println("Login in now");
Class.forName("oracle.jdbc.driver.OracleDriver");
sessionID = Connector.getInstance().login("DEMO", "DEMO", "DEMO910","*ALL");
System.out.println("Log in successfully");
System.out.println("Session id - " + sessionID);

UserSession userSession = com.jdedwards.system.connector.dynamic.Connector.getInstance().getUserSession(sessionID);

System.out.println("Got User Session - " + userSession);

OneworldTransaction transaction = userSession.createOneworldTransaction(true);

System.out.println("Got Transaction - " + transaction);

specSource = new OneworldBSFNSpecSource(sessionID);
/*BSFNMethod allBSFNMethod[] = specSource.getBSFNMethods();
for (int i = 0; i < allBSFNMethod.length; i++) {
BSFNMethod bsfn = allBSFNMethod;
System.out.println("Method name is " + bsfn.getName());
}*/
System.out.println("I am HERE - "+specSource);
BSFNMethod bsfnMethod = (BSFNMethod) specSource.getBSFNMethod("GetEffectiveAddress");
String methodName = bsfnMethod.getName();
System.out.println("Method name is " + methodName);
System.out.println("bsfn called");
System.out.println("The BSFN Method is - :" + bsfnMethod);

ExecutableMethod addressbook = bsfnMethod.createExecutable();
System.out.println("The Addressbook variable is - :" + addressbook);
try {
// addressbook.setValue("szUserName", "USER");
System.out.println("before warning");
BSFNExecutionWarning warning = addressbook.execute(sessionID);
System.out.println("after warning");
System.out.println("Date= "+ addressbook.getValueString("jdDate"));
System.out.println("Time= "+ addressbook.getValueString("mnTime"));

} catch (Exception e) {
System.out.println("unable to call");
e.printStackTrace();
}

} catch (Exception r) {
System.out.println("unable to call");
r.printStackTrace();
}
}
}

it gives following output when running:

1
Login in now
Log in successfully
Session id - 260360814
Got User Session - com.jdedwards.system.connector.dynamic.UserSession@221e9e
Got Transaction - com.jdedwards.system.connector.dynamic.OneworldTransactionImpl
@1f6f27b
I am HERE - com.jdedwards.system.connector.dynamic.spec.source.OneworldBSFNSpec
Source@1931579
unable to call
com.jdedwards.system.connector.dynamic.spec.SpecFailureException: Fail to connec
t to Oneworld Spec Source: null
at com.jdedwards.system.connector.dynamic.spec.source.OneworldBSFNSpecSo
urce.getBSFNMethodExternal(Unknown Source)
at com.jdedwards.system.connector.dynamic.spec.source.AbstractBSFNSpecSo
urce.getBSFNMethod(Unknown Source)
at TestJDEConnection.main(TestJDEConnection.java:43)

Please help

Thanks in advance...
 
Back
Top