Brent_Verkler

RE: [PAM - General Discussion] RE: Functions?

Discussion created by Brent_Verkler on Sep 18, 2012
Latest reply on Sep 19, 2012 by ken_huynh
Good morning.

I was able to get this working after support let me know there was a working example in the out of the box PAM 4.0 SP 1 install.

One thing that may help you is to change : 'com.sqlserver.jdbc.Driver'
to: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

Thank You,
Brent

If you would like I can send you the entire script that I use to populate the drop-downs in the form on-load.

From: CA Process Automation Global User Community [mailto:CommunityAdmin@communities-mail.ca.com]
Sent: Monday, September 17, 2012 4:26 PM
To: mb.11871426.99111758@myca-email.ca.com
Subject: [PAM - General Discussion] RE: Functions?

{
populateDataInTable: function()
{
var callBack = new Object();

callBack.onSuccess = function(result)
{
ca_pam_setTableData('Form.GroupList',result);
}

callBack.onFailure = function(caught)
{
alert(caught);
}

ca_pam_getDataUsingSQLQuery('com.sqlserver.jdbc.Driver','jdbc:sqlserver://sqlserver1234,'username','password',ca_fd.js.queryGroupList(),callBack);
},
queryGroupList: function()
{
return "SELECT [last_name] FROM [mdb].[dbo].[ca_contact] where [contact_type] = 2308 and [inactive] = 0 order by [last_name] asc";
}
}

Trying to get data back from sQL server. Keep getting OasisException. Anyone known why or what this mean?
Posted by:ken_huynh
--
CA Communities Message Boards
CA Process Automation/view_message/99111758
mb.11871426.99111758@myca-email.ca.com<mailto:mb.11871426.99111758@myca-email.ca.com>
https://communities.ca.com

Outcomes