Thank you for the response.. At the moment, the service works in a java environment... We are using SQL Server 2000..
The url is passed through a java object into axis, and is returned the same way. I'm trying to expose this so that a .NET application can access the same webservice. ...Robin ----- Original Message ----- From: Martin Gainty To: axis-user@ws.apache.org Sent: Wednesday, December 10, 2008 12:32 PM Subject: RE: Help with service you need to get your connection parameters sorted out at a min username/password/host/port/DatabaseName check to make sure there is a DB listener installed 3306 for MySQL use netstat to verify 1521 for Oracle use tnsping SID to verify Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: [EMAIL PROTECTED] > To: axis-user@ws.apache.org > Subject: Re: Help with service > Date: Wed, 10 Dec 2008 11:26:33 -0700 > > Alright, to add to this method, i've figured out how to pass in parameters, > but the parameters keep getting mixed up (even though i am passing the name > of the field in as well). > > http://localhost/vip/services/BookInfoPort?method=GetBookInfoByISBN&isbn=9780312949631&customeraccount=test2&customersubaccount=test1&loginname=robin&loginpassword=test > > For some reason, based on my log on the above, this is what comes up.. > > 2008-12-10 11:24:04,640 [INFO ] - ISBN: test > 2008-12-10 11:24:04,640 [INFO ] - Converted ISBN: test > 2008-12-10 11:24:04,640 [INFO ] - Check using ISBN: > 2008-12-10 11:24:04,640 [INFO ] - Account: 9780312949631 > 2008-12-10 11:24:04,640 [INFO ] - SubAccount: test1 > 2008-12-10 11:24:04,640 [INFO ] - UserName: test2 > 2008-12-10 11:24:04,640 [INFO ] - Password: robin > 2008-12-10 11:24:04,640 [INFO ] - Username NOT found > 2008-12-10 11:24:04,640 [INFO ] - VIP: Invalid User or Wrong Password > 2008-12-10 11:24:04,640 [INFO ] - User: test2 > 2008-12-10 11:24:04,640 [INFO ] - Password: robin > 2008-12-10 11:24:04,640 [ERROR] - User: Invalid User or Wrong Password > > So, ISBN consists of the password, password consists of username, Account > and subaccount seem right, but the main info require are the loginname, and > loginpassword... > > The order of the getBookInfoByISBN (String ISBN, String customerAccount, > String customerSubAccount, String loginName, String loginPassword). > > All i'd like this to do is return an xml in the browser (as an external > program will be doing the same thing, and then parsing the info directly) so > this is all i'd need it to do. > > Anyone have any suggestions? > > Thank you. > > ...Robin > > ----- Original Message ----- > From: "Robin Lee (Tech Support @ ULS)" <[EMAIL PROTECTED]> > To: <axis-user@ws.apache.org> > Sent: Wednesday, December 10, 2008 9:31 AM > Subject: Re: Help with service > > > >I was able to get as far as this. > > > > http://localhost/vip/services/BookInfoPort?method=GetBookInfoByISBN > > > > <soapenv:Envelope> > > ? > > <soapenv:Body> > > ? > > <soapenv:Fault> > > <faultcode>soapenv:Server.userException</faultcode> > > <faultstring>java.lang.NullPointerException</faultstring> > > <detail/> > > </soapenv:Fault> > > </soapenv:Body> > > </soapenv:Envelope> > > > > If i try to pass in anything in after the method listed, i get this error. > > > > org.xml.sax.SAXParseException: Element type "GetBookInfoByISBN" must be > > followed by either attribute specifications, ">" or "/>". > > > > If there is any more information that you can add to this, i would > > appreciate it. > > > > Thanks. > > > > ----- Original Message ----- > > From: "Robin Lee (Tech Support @ ULS)" <[EMAIL PROTECTED]> > > To: <axis-user@ws.apache.org> > > Sent: Tuesday, December 09, 2008 10:06 AM > > Subject: Re: Help with service > > > > > >> 1. I do not know... i think its 1... whatever version 1.4 is... This > >> software came with the development of a web service called "VIP", which > >> is from the company known as Dynix (which has since merged). > >> 2. Sure can.. i'll send it after i answer the rest of the questions. > >> 3. I'm sorry, i don't understand the question... > >> > >> Like i said, i don't have a lot of experience with web services, so this > >> is new territory for me in what i am trying to work on. > >> > >> Here is the wsdl. > >> > >> Thanks, > >> ...Robin > >> > >> > >> <wsdl:definitions targetNamespace="http://www.dynix.com/schema/book";> > >> ? > >> <wsdl:types> > >> ? > >> <schema targetNamespace="GetBookInfoByISBN"> > >> ? > >> <complexType name="BookInfoType"> > >> ? > >> <sequence> > >> <element maxOccurs="1" minOccurs="0" name="Title" nillable="true" > >> type="xsd:string"/> > >> <element maxOccurs="1" minOccurs="0" name="Author" nillable="true" > >> type="xsd:string"/> > >> <element maxOccurs="1" minOccurs="0" name="ISBN" nillable="true" > >> type="xsd:string"/> > >> <element maxOccurs="1" minOccurs="0" name="Publisher" nillable="true" > >> type="xsd:string"/> > >> <element maxOccurs="1" minOccurs="0" name="PublicationDate" > >> nillable="true" type="xsd:string"/> > >> <element maxOccurs="1" minOccurs="0" name="PublicationPlace" > >> nillable="true" type="xsd:string"/> > >> <element maxOccurs="1" minOccurs="0" name="Edition" nillable="true" > >> type="xsd:string"/> > >> <element name="DiscountPrice" type="xsd:double"/> > >> <element maxOccurs="1" minOccurs="0" name="Availability" nillable="true" > >> type="xsd:string"/> > >> <element name="ListPrice" type="xsd:double"/> > >> <element name="DiscountPercent" type="xsd:double"/> > >> </sequence> > >> </complexType> > >> ? > >> <complexType name="BookInfoResponseType"> > >> ? > >> <sequence> > >> <element maxOccurs="1" minOccurs="0" name="Status" nillable="true" > >> type="xsd:string"/> > >> <element name="BookInfo" nillable="true" type="tns1:BookInfoType"/> > >> <element maxOccurs="1" minOccurs="0" name="Marc" nillable="true" > >> type="xsd:string"/> > >> </sequence> > >> </complexType> > >> ? > >> <element name="GetBookInfoByISBN"> > >> ? > >> <complexType> > >> ? > >> <sequence> > >> <element name="ISBN" type="xsd:string"/> > >> <element name="CustomerAccount" type="xsd:string"/> > >> <element name="CustomerSubAccount" type="xsd:string"/> > >> <element name="LoginName" type="xsd:string"/> > >> <element name="LoginPassword" type="xsd:string"/> > >> </sequence> > >> </complexType> > >> </element> > >> ? > >> <element name="GetBookInfoByISBNResponse"> > >> ? > >> <complexType> > >> ? > >> <sequence> > >> <element name="GetBookInfoByISBNResult" > >> type="tns1:BookInfoResponseType"/> > >> </sequence> > >> </complexType> > >> </element> > >> </schema> > >> </wsdl:types> > >> ? > >> <wsdl:message name="getBookInfoByISBNResponse"> > >> <wsdl:part element="tns1:GetBookInfoByISBNResponse" name="parameters"/> > >> </wsdl:message> > >> ? > >> <wsdl:message name="getBookInfoByISBNRequest"> > >> <wsdl:part element="tns1:GetBookInfoByISBN" name="parameters"/> > >> </wsdl:message> > >> ? > >> <wsdl:portType name="BookInfoPortType"> > >> ? > >> <wsdl:operation name="getBookInfoByISBN" parameterOrder=""> > >> <wsdl:input message="impl:getBookInfoByISBNRequest" > >> name="getBookInfoByISBNRequest"/> > >> <wsdl:output message="impl:getBookInfoByISBNResponse" > >> name="getBookInfoByISBNResponse"/> > >> </wsdl:operation> > >> </wsdl:portType> > >> ? > >> <wsdl:binding name="BookInfoPortSoapBinding" > >> type="impl:BookInfoPortType"> > >> <wsdlsoap:binding style="document" > >> transport="http://schemas.xmlsoap.org/soap/http"/> > >> ? > >> <wsdl:operation name="getBookInfoByISBN"> > >> <wsdlsoap:operation soapAction=""/> > >> ? > >> <wsdl:input name="getBookInfoByISBNRequest"> > >> <wsdlsoap:body namespace="GetBookInfoByISBN" use="literal"/> > >> </wsdl:input> > >> ? > >> <wsdl:output name="getBookInfoByISBNResponse"> > >> <wsdlsoap:body namespace="GetBookInfoByISBN" use="literal"/> > >> </wsdl:output> > >> </wsdl:operation> > >> </wsdl:binding> > >> ? > >> <wsdl:service name="BookInfoService"> > >> ? > >> <wsdl:port binding="impl:BookInfoPortSoapBinding" name="BookInfoPort"> > >> <wsdlsoap:address location="http://localhost/vip/services/BookInfoPort"/> > >> </wsdl:port> > >> </wsdl:service> > >> </wsdl:definitions> > >> ----- Original Message ----- > >> From: "Deepal jayasinghe" <[EMAIL PROTECTED]> > >> To: <axis-user@ws.apache.org> > >> Sent: Saturday, December 06, 2008 3:59 PM > >> Subject: Re: Help with service > >> > >> > >>> Few things > >>> 1. Are you using Axis2 or Axis1 ? > >>> 2. Can we have a look at your wsdl > >>> 3. Are you trying to invoke REST manner or using SOAP ? > >>> > >>> Thank you! > >>> Deepal > >>>> Hi there, > >>>> > >>>> Currently i am running axis 1.4 with tomcat 5.5.9.. > >>>> > >>>> Right now i have a service at > >>>> http://localhost/vip/services/BookInfoPort > >>>> > >>>> I can pull up the wsdl > >>>> http://localhost/vip/services/BookInfoPort?wsdl > >>>> > >>>> Now, in order to use this service, one must wrap a java object around > >>>> "bookinfoport", and send the info to the service via the java object. > >>>> > >>>> What i want to do is convert/modify so that the java object is not > >>>> required for this. > >>>> > >>>> In otherwards, > >>>> http://localhost/vip/services/BookInfoPort?GetBookInfoByISBN?ISBN=9781111111113 > >>>> > >>>> Or somehow make it work that way, and then return the full info via > >>>> XML. > >>>> > >>>> This service was set up by me, although i had an SDK and his help on > >>>> setting it all up. I am not able to get a hold of him, and need to > >>>> change the way this service works without having to write a brand new > >>>> version. > >>>> > >>>> Does anyone have any clues on what i need to do to make this work this > >>>> way? > >>>> > >>>> Thank you. > >>>> > >>>> ...Robin > >>>> > >>>> --------------------------------------------------------------------- > >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>> For additional commands, e-mail: [EMAIL PROTECTED] > >>>> > >>>> > >>> > >>> > >>> -- > >>> Thank you! > >>> > >>> > >>> http://blogs.deepal.org > >>> > >>> > >>> --------------------------------------------------------------------- > >>> To unsubscribe, e-mail: [EMAIL PROTECTED] > >>> For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >> > > > ------------------------------------------------------------------------------ Send e-mail anywhere. No map, no compass. Get your Hotmail® account now.
