topic Re: tMap Join problems in Talend Studio

tMap Join problems

_AnonymousUser — Sat, 16 Nov 2024 14:29:09 GMT

Hi,
Am very new to TOS and hope you have an answer to my question. I am trying to do a JOIN in tMap using 2 table schema's (both tPostgresqlInput components). I am getting the following error:
Exception in component tMap_1
java.lang.NullPointerException
at advice_now.tranformlinklibrary.TranformLinkLibrary.tPostgresqlInput_1Process(TranformLinkLibrary.java:468)
at advice_now.tranformlinklibrary.TranformLinkLibrary.runJob(TranformLinkLibrary.java:1567)
at advice_now.tranformlinklibrary.TranformLinkLibrary.main(TranformLinkLibrary.java:1500)
An example of my generated Java code is below and the error is referring to this line:
tHash_Lookup_row2.get(row2HashKey);

				java.util.List<row2Struct> listFromLookup_row2 = null;
				row2Struct row2ObjectFromLookup = null;
				if (!rejectedInnerJoin_tMap_1) { // G 20
					row2HashKey.hashCodeDirty = true;
					tHash_Lookup_row2.get(row2HashKey);
					if (tHash_Lookup_row2.hasResult()) { // G 90
						if (tHash_Lookup_row2.resultIsObject()) { // G 49
							row2ObjectFromLookup = (row2Struct) tHash_Lookup_row2
									.getResultObject();
							sizeResultsFromLookup_row2 = row2ObjectFromLookup != null ? 1
									: -1;
						} else { // G 49
							listFromLookup_row2 = (java.util.List<row2Struct>) tHash_Lookup_row2
									.getResultList();
							sizeResultsFromLookup_row2 = listFromLookup_row2 != null ? listFromLookup_row2
									.size()
									: -1;
						}
					} // G 90
					else { // G 91
						rejectedInnerJoin_tMap_1 = true;
						forceLooprow2 = true;
					} // G 91
				} // G 20
				else { // G 21
					forceLooprow2 = true;
				} // G 21

Does anyone know what is happening here? Your help would be much appreciated.
Regards,
Harin

Re: tMap Join problems

Anonymous — Fri, 11 Jan 2008 02:32:50 GMT

Hi
Which version of TOS did you use?
Can you upload some screenshots of your job and tMap?
Best regards

shong

Re: tMap Join problems

Anonymous — Fri, 11 Jan 2008 08:59:54 GMT

Hi,
I have uploaded images below of the following:
1. Job
2. tMap
3. library(input) properties
4. libraryData(input) properties
5 output properties
Regards,
Harin
Also i am using version:
Version: 2.2.4
Build id: r7943-20080107-1407

Re: tMap Join problems

amaumont — Fri, 11 Jan 2008 11:24:38 GMT

I can't reproduce your error, I used same type of inputs and outputs, set same lookup configuration with ALL MATCHES mode and INNER JOIN lookup.
Can you post your entirely code job ?
Thank you.

Re: tMap Join problems

Anonymous — Fri, 11 Jan 2008 11:41:06 GMT

Job code below. Sorry code tags didnt work for this for some reason.

// ============================================================================
//
// Copyright (c) 2005-2007, Talend Inc.
//
// This source code has been automatically generated by Talend Open Studio
// / JobDesigner (CodeGenerator version 2.2.4.r7943).
// You can find more information about Talend products at www.talend.com.
// You may distribute this code under the terms of the GNU LGPL license
// ( http://www.gnu.org/licenses/lgpl.html).
//
// ============================================================================
package advice_now.tranformlinklibrary;
import routines.DataOperation;
import routines.Mathematical;
import routines.Numeric; import routines.Relational; import routines.StringHandling;

To see the whole post, download it here
OriginalPost.pdf

Re: tMap Join problems

amaumont — Fri, 11 Jan 2008 13:11:51 GMT

I think I found the origin of error, it seems you have a filter set in your lookup such as :

row1.library_type == 3

The problem is that "library_type" is an Integer object type and the value 3 is a primitive value.
When java compare library_type and 3 when library_type is null, java throws a NullPointerException.
To get round this problem you can use one of these syntaxes:

row1.library_type != null && row1.library_type == 3

new Integer(3).equals(row1.library_type)

I hope this is the solution, I didn't see other explanation to the problem.

Re: tMap Join problems

Anonymous — Fri, 11 Jan 2008 14:28:06 GMT

Thank you very much amaumont, that was the issue that was causing it to fail. Very impressed with this software so far....its making my life a great deal easier!

Re: tMap Join problems

amaumont — Fri, 11 Jan 2008 14:47:59 GMT

Good news !
this is a common problem encountered with Java and its Autoboxing mode (automatic conversion between primitive and Object).