... connects to the database and just hangs:
Check your JDBC Driver Version.
Didnt work with:
4.17.29
Updated it to 4.19.26
Works like a charm.
Thursday, January 29, 2015
Wednesday, January 11, 2012
Eddie Vedder on the cover of Classic Rock magazine
i had to laugh .... this considering Pearl Jam and their role in coining 'Modern Rock'
Thursday, December 29, 2011
Calling Microsoft CRM 2011 Web Services from Rational Application Developer's Generic Service Client Test
My previous blog post on calling MS-CRM 2011 web services using SoapUI applies. The only thing you have to do extra (assuming your services are secured using NTLM on the server side), is enter your username, password and domain under the 'HTTP Security Settings' section (found in the Transport tab).
Wednesday, December 28, 2011
Calling Microsoft CRM 2011 Web Services from SoapUI
I will assume you are very familiar with SoapUI and have at least a basic understanding of the MS-CRM 2011 WCF interface. I also assume you are using NTLM to authenticate
(the next part of my journey will be see if i can get WS-Security to work).
1) Import the WSDL from the CRM Server: Start a new SoapUI project and get the wsdl from:
http://your_box_name:yourport/your_crm_context_root/XRMServices/2011/Organization.svc?wsdl=wsdl0
2) I chose just a simple Retrieve operation to get back a single Contact. I changed the stub XML request from:
<!--
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://schemas.microsoft.com/xrm/2011/Contracts/Services" xmlns:con="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:arr="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<soap:Header/>
<soap:Body>
<ser:Retrieve>
<!--Optional:-->
<ser:entityName>?</ser:entityName>
<!--Optional:-->
<ser:id>?</ser:id>
<!--Optional:-->
<ser:columnSet>
<!--Optional:-->
<con:AllColumns>?</con:AllColumns>
<!--Optional:-->
<con:Columns>
<!--Zero or more repetitions:-->
<arr:string>?</arr:string>
</con:Columns>
</ser:columnSet>
</ser:Retrieve>
</soap:Body>
</soap:Envelope>
-->
To:
<!--
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://schemas.microsoft.com/xrm/2011/Contracts/Services" xmlns:con="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:arr="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<soap:Body>
<ser:Retrieve>
<ser:entityName>contact</ser:entityName>
<ser:id>c3d945f0-9824-e111-b825-005056a30027</ser:id>
<ser:columnSet>
<con:AllColumns>false</con:AllColumns>
<con:Columns>
<arr:string>fullname</arr:string>
</con:Columns>
</ser:columnSet>
</ser:Retrieve>
</soap:Body>
</soap:Envelope>
-->
You will notice i had to change the soap envelope from the default generated: "http://www.w3.org/2003/05/soap-envelope" to "http://schemas.xmlsoap.org/soap/envelope/"
3) Enter the following HTTP request headers into SoapUI:
SOAPAction http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/Retrieve
Accept application/xml, text/xml, */*
Content-Type text/xml; charset=utf-8
4) Set your endpoint to: http://your_box_name_and_port/your_crm_context_root/XRMServices/2011/Organization.svc/web
You should get some data back.
If you get a "bad request", check your SOAP Message.
If you get a "The server cannot service the request because the media type is unsupported.", check your Content-Type.
(the next part of my journey will be see if i can get WS-Security to work).
1) Import the WSDL from the CRM Server: Start a new SoapUI project and get the wsdl from:
http://
2) I chose just a simple Retrieve operation to get back a single Contact. I changed the stub XML request from:
<soap:Header/>
<soap:Body>
<ser:Retrieve>
<!--Optional:-->
<ser:entityName>?</ser:entityName>
<!--Optional:-->
<ser:id>?</ser:id>
<!--Optional:-->
<ser:columnSet>
<!--Optional:-->
<con:AllColumns>?</con:AllColumns>
<!--Optional:-->
<con:Columns>
<!--Zero or more repetitions:-->
<arr:string>?</arr:string>
</con:Columns>
</ser:columnSet>
</ser:Retrieve>
</soap:Body>
</soap:Envelope>
-->
To:
<soap:Body>
<ser:Retrieve>
<ser:entityName>contact</ser:entityName>
<ser:id>c3d945f0-9824-e111-b825-005056a30027</ser:id>
<ser:columnSet>
<con:AllColumns>false</con:AllColumns>
<con:Columns>
<arr:string>fullname</arr:string>
</con:Columns>
</ser:columnSet>
</ser:Retrieve>
</soap:Body>
</soap:Envelope>
-->
You will notice i had to change the soap envelope from the default generated: "http://www.w3.org/2003/05/soap-envelope" to "http://schemas.xmlsoap.org/soap/envelope/"
Accept application/xml, text/xml, */*
Content-Type text/xml; charset=utf-8
You should get some data back.
If you get a "bad request", check your SOAP Message.
If you get a "The server cannot service the request because the media type is unsupported.", check your Content-Type.
Wednesday, February 9, 2011
Alkaline Trio in South Africa
... 2 weeks after hearing this it still seems unreal!
I cannot believe that my favourite band is making their way to South Africa!
I am hoping to pull off some miracle and catch them in Johannesburg, Durban and Cape Town.
Hell Yes!
I cannot believe that my favourite band is making their way to South Africa!
I am hoping to pull off some miracle and catch them in Johannesburg, Durban and Cape Town.
Hell Yes!
Tuesday, December 21, 2010
Top 3 Albums of 2010
Quite a good year for music this. Still easy to come up with my top 3 albums (in no particular order):
1) Alkaline Trio - This Addiction
2) Matt Skiba - Demos
3) Against Me! - White Crosses
Unlikely we will see any new music from these artists in 2011 - 2012 then.
1) Alkaline Trio - This Addiction
2) Matt Skiba - Demos
3) Against Me! - White Crosses
Unlikely we will see any new music from these artists in 2011 - 2012 then.
Friday, July 31, 2009
Ruby on Rails IDE Tip
After working on a Ruby on Rails (RoR) project for a bit I would suggest using NetBeans IDE over Aptana IDE for a number of reasons.
Too many to mention at the moment.
Since you don't know me (maybe) I can't just say: "Trust me!" (But you can :) )
Too many to mention at the moment.
Since you don't know me (maybe) I can't just say: "Trust me!" (But you can :) )
Subscribe to:
Comments (Atom)