You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-11-11 15:48:04

patgream
Member
24 posts

patgream said:

Error message in beforeSavingCheck causes database connection increase

Hi all,

I have sample preCheck job (based on TDMDTriggerInput and TDMDTriggerOutput) called in beforeSaving process. The job check for business validation of an address (length ...) If i manually insert new adresses record all work fine, even for the reject record. If i massively insert new record via an external job, everything work fine with no rejected records, but for each rejected record i have a new database connection what appeared for my container master connection. The message and the exception are correct (cf class BeforeSaving code).


Does anyone have an idea ?

Talend Open Studio for MDM : Version: 6.1.1

Job call
---------
_DEFAULT_  text        result  output_error

<configuration>
<url>ltj://AddressCreationChecks/0.5</url>
</configuration>


Exception
---------

Caused by: com.amalto.core.save.SaveException: <AddrTest><ADRT2/><Msg>Country name is mandatory and must be greater than 2 characters</Msg></AddrTest>



Code
-----

public class BeforeSaving implements DocumentSaver {
....

[table][tr][td] [/td]
[/tr]
[/table]
[table][tr][td]if (!"info".equals(errorCode)) { //$NON-NLS-1$[/td]
[/tr]
[/table]
[table][tr][td]throw new BeforeSavingErrorException(message);[/td]
[/tr]
[/table]
}


.....

Last edited by patgream (2016-11-12 10:31:33)

Offline

#2 2016-11-14 04:19:41

xdshi
Talend Team


xdshi said:

Re: Error message in beforeSavingCheck causes database connection increase

Hi,
Could you please post your current job setting screenshots into forum which will be helpful for us to address your issue?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-11-14 15:39:20

patgream
Member
24 posts

patgream said:

Re: Error message in beforeSavingCheck causes database connection increase

Hi Sabrina,
I finally found. The issue comes from hibernate, I set connection release mode to after_transaction and now it works fine and the number of connections is stable.

Best regards,

Pat

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy