BHCandidate lookup - SSN

Forum for users and developers of Bullhorn's Webservices API suite

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
sourov.chatterjee
User
Posts: 20
Joined: Thu Sep 02, 2010 11:21 am

BHCandidate lookup - SSN

Post by sourov.chatterjee » Tue Nov 02, 2010 1:23 pm

I get this JDBC error when searching for candidate SSN that uses Bullhorn API. Any idea what's causing this? Are some indexes missing in the DB?

Error at record 0 -- ID: -- org.hibernate.exception.GenericJDBCException: Cannot release connection
Stack Trace:
[ApplicationException: Error at record 0 -- ID: -- org.hibernate.exception.GenericJDBCException: Cannot release connection]
STNA.BullHornAPI.BullHornBase.GetAssociationObjects(BHEntityType ParentType, BHEntityType ChildType, Int32 ParentID) +3375
STNA.BullHornAPI.BHCandidate.fillObject(candidateDto& oCand) +5516
STNA.BullHornAPI.BHCandidate..ctor(Int32 CandidateID) +330
SSNLookup._Default.btnSearch_Click(Object sender, EventArgs e) +1094
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: BHCandidate lookup - SSN

Post by apsmith » Wed Nov 03, 2010 9:20 am

Sourov,

Do you get this error all the time? or just some times? This appears to be a session issue.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

sourov.chatterjee
User
Posts: 20
Joined: Thu Sep 02, 2010 11:21 am

Re: BHCandidate lookup - SSN

Post by sourov.chatterjee » Wed Nov 03, 2010 10:19 am

When there is no match I get a 'no match message' from our system that uses Bulhorn API. When there is match that is when the sytem just times out and throws this error always.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: BHCandidate lookup - SSN

Post by apsmith » Wed Nov 03, 2010 2:54 pm

Thanks,

Can you send you an example query where this error is returned, so that I can reproduce it?
Andrew Smith
Director, Technical Operations
Developer Forum Admin

sourov.chatterjee
User
Posts: 20
Joined: Thu Sep 02, 2010 11:21 am

Re: BHCandidate lookup - SSN

Post by sourov.chatterjee » Thu Nov 04, 2010 1:50 pm

This err occurs for a particular candidate ID when we try to inflate a candidate object to populate SSN & candidate's last name , firstname. We pass candidate ID , that is the parameter. I can send you the candidate ID # to your email address if you post it here.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: BHCandidate lookup - SSN

Post by apsmith » Thu Nov 04, 2010 3:14 pm

Sourov,

Yes, please post a single candidate ID example that is causing an issue, I will then test it locally.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

sourov.chatterjee
User
Posts: 20
Joined: Thu Sep 02, 2010 11:21 am

Re: BHCandidate lookup - SSN

Post by sourov.chatterjee » Thu Nov 04, 2010 3:18 pm

Never mind. It appears our DLLs were old and rebuilding them resolved the issue. It still does not make sense why some candidate id would give result and some give time out. Thanks for the help.

Post Reply