IPD Error - LawsonGuru.com - LawsonGuru.com Forums

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Sameera

Advanced Member

Posts: 30

1/16/2014 11:04 AM

Getting the following error when trying to connect to the 'SQL Query' node in IPD, Any idea to sort this issue ?

SQL Ver - SQL 2008 R2

Activity started: Start (Run Id: 1)

Executing Start Activity...

Variables in Process:

Activity completed: Start

Activity started: SQLQuery1540 (Run Id: 1)

SQL Query SQLQuery1540: Query string SELECT * FROM LTM2.EMPLOYEE

SQL SQLQuery1540: Using JDBC connection String Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver, URL: jdbc:sqlserver://BI3-LTMTEST:1433;databaseName=LTM, User: LTMuser

SQL Query SQLQuery1540: Query string SELECT * FROM LTM2.EMPLOYEE

SQLQuery1540_RETURN_MSG = SQL SQLQuery1540: JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in classpath. Please add jdbc driver to Lawson Process Server classpath.

SQLQuery1540_RETURN_CODE = -1

Variables in Process:

lastReturnMessage = SQL SQLQuery1540: JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in classpath. Please add jdbc driver to Lawson Process Server classpath.

lastErrorCode = 1

lastOutputData = java.lang.Exception: SQL SQLQuery1540: JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in classpath. Please add jdbc driver to Lawson Process Server classpath.

at com.lawson.bpm.processflow.workFlow.flowGraph.FgSQL.executeQuery(FgSQL.java:455)

at com.lawson.bpm.processflow.workFlow.flowGraph.FgaSQLQuery.startActivity(FgaSQLQuery.java:115)

at com.lawson.bpm.processflow.workFlow.flowGraph.FgActivity.execute(FgActivity.java:742)

at com.lawson.bpm.processflow.workFlow.flowGraph.FgProcess.run(FgProcess.java:2178)

at com.lawson.bpm.designer.runtime.LocalFlowRunner.run(Unknown Source)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

lastInformationCode = -1

Thanks
Sameera

Srini Rao

Veteran Member

Posts: 149

1/16/2014 1:00 PM

Why you are using the SQL Query node? I prefer to use Landmark Transaction node.

Woozy

Veteran Member

Posts: 709

1/16/2014 2:48 PM

Sameera - Based on the error, it appears that IPA can't find the driver in the classpath. If you are running the flow locally in IPA designer, you need to point to the driver on your local machine via Designer preferences under "External Jars". If you are running it on the server, you need to make sure the drivers are included in the server classpath - unfortunately, I can't guide you on the server side stuff.

Srini Rao - I use SQL extensively in my flows, particularly flows that are "batch" rather than "action" related. SQL provides much greater performance and flexibility when using multiple tables with complex join relationships, and it is possible to perform logic within the query itself rather than querying the data and then manipulating with javascript. The filter functionality within Landmark nodes is painful and can be deadly slow in some cases. I use Landmark nodes if I am querying a single business class, performing an update, or querying for derived fields that are difficult to duplicate using SQL. It's just a matter of determining which node works best for the situation.

Sameera

Advanced Member

Posts: 30

1/17/2014 6:09 AM

Hi Srini

Thanks for the reply. I also prefer to use SQL node because of the flexibility compared to Transaction node

Thanks
Sameera

Sameera

Advanced Member

Posts: 30

1/17/2014 6:20 AM

Hi Kelly

Thanks a lot for the info. I also agree with you regarding the SQL node. It's very easy to work with it.

I tried following discussion & it works for me.

https://www.lawsonguru.co...low/ipa-sqlqry-node/
(refer document shared by Dave Lis)

Thanks
Sameera