11-24-2014 07:42 PM
Hi,
I am trying to use JAX-WS based on the demo app at the below URL. When i try to modify it to do an ExecuteSQL the return gives me list but row = null for each instance. Using Eclipse debug i can see the information under the ArrayList but it seems the .getRow() is not returning the value.
Can anyone point me to how i can get the actual value returned?
https://developer.cisco.com/site/axl/learn/how-to/axl-java-sample-application.gsp
String sSQLQuery = "select processnodeservice.servername from processnodeservice,typeservice where processnodeservice.tkservice = typeservice.enum and typeservice.processname='ctftp'";
ExecuteSQLQueryReq axlParams = new ExecuteSQLQueryReq();
axlParams.setSql(sSQLQuery);
try{
ExecuteSQLQueryRes getSQLResponse = axlPort.executeSQLQuery(axlParams);
List<Object> vServerList = getSQLResponse.getReturn().getRow();
List<String> strings = new ArrayList<String>();
for (Object object : vServerList) {
textArea_Log.insert(object.toString() + "\n",0);
}
I get returned [row: null] for every record returned.
Regards
Chris
Solved! Go to Solution.
11-25-2014 09:51 AM
This code only returns the first row, but perhaps it will help you understand how the API works...
String ucCritString = "select processnodeservice.servername from processnodeservice,typeservice where processnodeservice.tkservice = typeservice.enum and typeservice.processname='ctftp'"; | ||
sqlReq.setSql(ucCritString); |
try { | ||||
List<Object> returnList = new ArrayList<Object>(); | ||||
ExecuteSQLQueryRes getResponse = axlPort.executeSQLQuery(sqlReq); | ||||
returnList = getResponse.getReturn().getRow(); | ||||
ElementNSImpl rowElement = (ElementNSImpl) returnList.get(0); | ||||
servername = rowElement.getElementsByTagName("servername").item(0).getFirstChild().getTextContent(); | ||||
System.out.println(servername); | ||||
} catch (AXLError e) { | ||||
System.out.println("An AXLError occurred: " + e.getFaultInfo()); | ||||
} |
11-25-2014 09:51 AM
This code only returns the first row, but perhaps it will help you understand how the API works...
String ucCritString = "select processnodeservice.servername from processnodeservice,typeservice where processnodeservice.tkservice = typeservice.enum and typeservice.processname='ctftp'"; | ||
sqlReq.setSql(ucCritString); |
try { | ||||
List<Object> returnList = new ArrayList<Object>(); | ||||
ExecuteSQLQueryRes getResponse = axlPort.executeSQLQuery(sqlReq); | ||||
returnList = getResponse.getReturn().getRow(); | ||||
ElementNSImpl rowElement = (ElementNSImpl) returnList.get(0); | ||||
servername = rowElement.getElementsByTagName("servername").item(0).getFirstChild().getTextContent(); | ||||
System.out.println(servername); | ||||
} catch (AXLError e) { | ||||
System.out.println("An AXLError occurred: " + e.getFaultInfo()); | ||||
} |
11-25-2014 09:59 AM
Nice!
11-27-2014 07:37 PM
Perfect. Although i ended up using Element instead of ElementNSImpl
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide