Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

JAX-WS: Using NodeList so that Excel Web Services Toolkit can use web

JAX-WS: Using NodeList so that Excel Web Services Toolkit can use web

JAX-WS: Using NodeList so that Excel Web Services Toolkit can use web

I am running into a couple of issues where an Excel spreadsheet is suppose to call a Java web service I have created in JAX-WS and get back the results. However, there is some issue with not sending, nor receiving, back a NodeList. I am not sure how I need to change my web service to handle this.

The other issue is that the MS Office 2003 Web Service Toolkit is defining the web method as a sub routine instead of a function.

My web method is defined in the endpoint interface as:


CreateWorkOrderItemResponse createWorkItems(@WebParam(name = "CreateWorkOrderItemRequest")CreateWorkOrderItemRequest request);

The CreateWorkOrderItemRequest is defined as:


@XmlType(name = "", propOrder = {
@XmlRootElement(name = "CreateWorkOrderItemRequest", namespace="")
public class CreateWorkOrderItemRequest {

    @XmlElement(name = "authentication", required = true)
    protected Authentication authentication = null;
    @XmlElement(name = "create_data", required = true)
    protected ArrayList<CreateWorkOrderItemData> createData = new ArrayList<CreateWorkOrderItemData>();

    public Authentication getAuthentication() {
        return authentication;

    public void setAuthentication(Authentication authentication) {
        this.authentication = authentication;

    public ArrayList<CreateWorkOrderItemData> getCreateData() {
        return createData;

    public void setCreateData(ArrayList<CreateWorkOrderItemData> createData) {
        this.createData = createData;

The CreateWorkOrderItemResponse is defined as:


@XmlType(name = "", propOrder = {
@XmlRootElement(name = "CreateWorkOrderItemResponse")
public class CreateWorkOrderItemResponse{

    @XmlElement(name = "submission_response", required = true)
    protected SubmissionResponse submissionResponse = new SubmissionResponse();

    @XmlElement(name="error", required = true, nillable = true)
    protected ArrayList<Error> errorList = new ArrayList<Error>();

    public SubmissionResponse getSubmissionResponse() {
        return submissionResponse;

    public void setSubmissionResponse(SubmissionResponse submissionResponse) {
        this.submissionResponse = submissionResponse;

    public ArrayList<Error> getErrorList() {
        return errorList;

    public void addError(Error error) {

    public void addErrors(ArrayList<Error> errors) {
        for (Error error : errors) {

    public void setErrorList(ArrayList<Error> errorList) {
        this.errorList = errorList;

The result from the Web Service Toolkit comes out like this:


Public Sub wsm_createWorkItems()
    'Proxy subroutine created from http://localhost:8080/gbswebsvcs/seiwebsvcs?wsdl.
    'Error Trap
        On Error GoTo wsm_createWorkItemsTrap

        Exit Sub
    SEIWebServiceImplServErrorHandler "wsm_createWorkItems"
End Sub

But apparently it is suppose to come out more like this:


Public Function wsm_createWorkItems(ByVal any_CreateWorkOrderItemRequest As MSXML2.IXMLDOMNodeList) As MSXML2.IXMLDOMNodeList

    'Proxy function created from http://localhost:8080/gbswebsvcs/seiwebsvcs?wsdl.
    '"wsm_createWorkItems, any_CreateWorkOrderItemRequest" is defined as XML. See Complex Types: XML Variables in
    'Microsoft Office 2003 Web Services Toolkit Help for details on implementing XML variables.
    'Error Trap
        On Error GoTo wsm_createWorkItemsTrap

        Set wsm_createWorkItems = sc_DataServicesServer.createWorkItems(any_CreateWorkOrderItemRequest)
        Exit Function
    DataServicesServerErrorHandler "wsm_createWorkItems"
End Function

How do I get it to this point? Thank you very much for the help.

RE: JAX-WS: Using NodeList so that Excel Web Services Toolkit can use web

I actually figured this out. I couldn't approach it the way I did. I had to add in some new annotations, along with a restructure of the folders. I needed to add in ObjectFactory, package-info and some other things to get it going. With that said, I think it was more of a JBoss issue than anything.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close