TDI 7, SQL Lookup and link criterias in JDBC-Connector

[Helena Larsson]

Hi!

I'm working with migration of a project from TDI 6 to TDI 7 and has
run into a problem. I have lots of JDBC-Connectors where I've written
my own sql. This works just fine in TDI 6, but now in TDI 7 you must
have a table name in the connector (required field)? Ignoring the
error-msg of table name required and runing the AL anyway results in
"Multiple entries found and no 'On Multiple Entries' Hook defined."-
error. Somehow my link criteria is never used in the sql query, and it
doesn't seem to matter weather I use the predefined GUI or if I write
my own custom script for link criteras. What is wrong? Have the
behavour of JDBC-Connector in Lookup-mode changed between TDI 6 and
TDI 7. How can I make the Connector to use my link criteria?

When I imported this connectors to TDI 7 I had to write in my "SQL
Lookup" again, and if I look in the xml-file I have one parameter
"jdbcSelect" (my original which I can't see anymore in the GUI) and
one parameter "jdbcLookup" ... ?

What to do ? Have anyone else had problems with this? I have spent the
last couple of days scanning the internet in different discussion-
forums etc but I can't find any solutions for my problem ...

Kindly
/ Helena :o)

[Eddie Hartman]

HI Helena,

The migration to 7 should be painless, and I have not heard of this
issue before. If stuff is going missing after the upgrade/migration
then I would open a PMR asap on it (ib...@us.ibm.com).

That said, the JDBC Connector behavior for Lookup should not be any
different in 7 than in 6. Perhaps you could send me the TDI 6 Config
and I can have a look.eddie.hartman curly-a no.ibm.com.

-Eddie

[officepr...@gmail.com]

Hi
How are you Friend.Nice information Share God Bless You...
http://cosmedica.no/h-m-artikler-hudpleie-produkter.html

[nade...@gmail.com]

Hi Eddie,

I am also working on TDI6 to TDI7 migration. I am facing a similiar problem with Add functionality. The Assembly Line seems to work fine in TDI 6. The Assmebly line uses a JDBC connector. The server throws the below Exception. The error occurs at the below statement. 'indiv_user_add' is a Assembly Line component which inherits JDBC connector. Can you please suggest what is the issue.

code:
indiv_user_add.add(work);

Exception:
com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][1061][10303] Escape syntax error. See attached Throwable for details.
at com.ibm.db2.jcc.c.bb.c(bb.java:687)
at com.ibm.db2.jcc.c.qh.m(qh.java:2532)
at com.ibm.db2.jcc.c.qh.a(qh.java:1743)
at com.ibm.db2.jcc.c.qh.c(qh.java:522)
at com.ibm.db2.jcc.c.qh.executeUpdate(qh.java:506)
at com.ibm.di.connector.JDBCConnector.executeUpdate(JDBCConnector.java:1081)
at com.ibm.di.connector.JDBCConnector.putEntry(JDBCConnector.java:1174)
at com.ibm.di.server.AssemblyLineComponent.executeOperation(AssemblyLineComponent.java:3166)
at com.ibm.di.server.AssemblyLineComponent.add1(AssemblyLineComponent.java:1987)
at com.ibm.di.server.AssemblyLineComponent.update(AssemblyLineComponent.java:1713)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:298)
at com.ibm.jscript.types.FBSObject.call(FBSObject.java:153)
at com.ibm.jscript.ASTTree.ASTCall.interpret(ASTCall.java:151)
at com.ibm.jscript.ASTTree.ASTBlock.interpret(ASTBlock.java:101)
at com.ibm.jscript.ASTTree.ASTIf.interpret(ASTIf.java:76)
at com.ibm.jscript.ASTTree.ASTBlock.interpret(ASTBlock.java:101)
at com.ibm.jscript.ASTTree.ASTIf.interpret(ASTIf.java:73)
at com.ibm.jscript.ASTTree.ASTProgram.interpretEx(ASTProgram.java:102)
at com.ibm.jscript.JSExpression.interpretExpression(JSExpression.java:399)
at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:249)
at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:236)
at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:239)
at com.ibm.jscript.JSInterpreter.interpret(JSInterpreter.java:53)
at com.ibm.di.script.ScriptEngine.interpret(ScriptEngine.java:903)
at com.ibm.di.script.ScriptEngine.interpret(ScriptEngine.java:888)
at com.ibm.di.server.ScriptComponent.add1(ScriptComponent.java:244)
at com.ibm.di.server.ScriptComponent.add(ScriptComponent.java:210)
at com.ibm.di.server.AssemblyLine.msExecuteNextConnector(AssemblyLine.java:3677)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3308)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2944)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2927)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2896)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1296)
Caused by: com.ibm.db2.jcc.c.n: [ibm][db2][jcc][1058][10637] Incorrect escape clause: d 'Function:[object Function]'.
at com.ibm.db2.jcc.c.mb.a(mb.java:48)
at com.ibm.db2.jcc.c.tb.a(tb.java:54)
at com.ibm.db2.jcc.c.tb.a(tb.java:119)
at com.ibm.db2.jcc.c.bb.c(bb.java:684)
... 36 more