LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Hi,

I am new to Lavastorm. I have installed LAE 4.6.1. But I am not getting a clear idea on how DB Execute and JDBC Execute node works by reading the help link.
Can somebody help me out in writing a simple query? I am not sure about the syntax.

EG: How to write the following query in DB Execute node?
select * from employee where empid=100

How to write the following query in JDBC Execute node?
Update employee set empname='john' where empid='A1001'

Please explain me the syntax.

I am using the following code:
query="select * from employee where empid=:100"
sqlSelect(1,query,'empid')

But the node is not running and showing an error. Please consider this as urgent.

Thanks,
Sreya

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

To get the code that you have written to work, change query to be:
query="select * from employee where empid=:1"
It should be 1 because 'empid' is the first parameter after query.

If you have a second parameter it would be :2 like this:
query="select * from employee where empid=:1 or empid=:2"
sqlSelect(1,query,'empid','empid2')

If you are going to run an update statement you should use the sqlNonSelect() function. The first parameter to the sqlSelect() function is the output number but update statements do not write anything to the output.

So here is an example that should work. (I didn't test it so there may be a syntax error in it):
query = "update employee set whatever_field = :1 where empid = :2"
sqlNonSelect(query,'new_value','empid')

Notice that in the SQL statement I always put the parameters in numerical order, :1, :2, :3 etc.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: DanRosenblatt

			
				How to write the following query in JDBC Execute node?

Update employee set empname='john' where empid='A1001'
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

select * from employee where empid=100
			

I would expect this statement to work with a JDBC Execute node-- what is the error message?

			
				EG: How to write the following query in DB Execute node?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

thanks a lot for your quick reply.

I tried the code you mentioned but unfortunately its not working.
Currently my code is:
query="select * from dim_claim where CLAIM_ID=:1"
sqlSelect(1,query,'CLAIM_ID')

It is giving the following error:
ERROR initializing expert output:
unknown field for source '': 'CLAIM_ID'
2014-01-29 20:55:04.000; WARN: unknown field for source '': 'CLAIM_ID'
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::Field_Expr::findField() ..\expert\Field_Expr.cpp@150

2014-01-29 20:55:04.000; WARN: ...in expression starting on line 2
id: 0 chain: 0 group: 0
cppDetail: context: Expr::parseExpr() ..\expert\Expr.cpp@89

2014-01-29 20:55:04.000; WARN: ...in statement starting on line 2
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::Statement_Expr::tryParseStatement() ..\expert\ExprStatement.cpp@158

2014-01-29 20:55:04.000; WARN: ...in expression starting on line 2
id: 0 chain: 0 group: 0
cppDetail: context: Expr::parseExpr() ..\expert\Expr.cpp@89

2014-01-29 20:55:04.000; WARN: ...handling expression #2 in file
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::ExprTableIo::initialize() .\ExprTableIo.cpp@86

2014-01-29 20:55:04.000; WARN: ...exception seen
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::NodeControl::initializeExpert() .\NodeControl.cpp@1331

2014-01-29 20:55:04.000; ERROR: ERROR initializing expert output:
unknown field for source '': 'CLAIM_ID'
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::NodeMain::errorMsg() .\NodeMain.cpp@28


can you tell me where did i go wrong?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

In the line:
sqlSelect(1,query,'CLAIM_ID')
the code is referencing a field named CLAIM_ID in your input data stream. The error is saying that it doesn't exist.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

hi,

even after passing the field name in input error is coming.

ERROR initializing expert output:
invalid output index: '1'
2014-01-29 21:04:00.000; WARN: invalid output index: '1'
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::SqlSelect_ExprStmt::SqlSelect_ExprStm t() .\SqlSelect_ExprStmt.cpp@61

2014-01-29 21:04:00.000; WARN: ...in statement starting on line 2
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::Statement_Expr::tryParseStatement() ..\expert\ExprStatement.cpp@158

2014-01-29 21:04:00.000; WARN: ...in expression starting on line 2
id: 0 chain: 0 group: 0
cppDetail: context: Expr::parseExpr() ..\expert\Expr.cpp@89

2014-01-29 21:04:00.000; WARN: ...handling expression #2 in file
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::ExprTableIo::initialize() .\ExprTableIo.cpp@86

2014-01-29 21:04:00.000; WARN: ...exception seen
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::NodeControl::initializeExpert() .\NodeControl.cpp@1331

2014-01-29 21:04:00.000; ERROR: ERROR initializing expert output:
invalid output index: '1'
id: 0 chain: 0 group: 0
cppDetail: context: Salmon::NED::NodeMain::errorMsg() .\NodeMain.cpp@28

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Good. I think you've made progress.

This error indicates that there is no output pin on your node. The sqlSelect() expects to send the results of a select statement somewhere.

So to fix this you would go to the IO tab on that node and add an output.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Thanks a lot for your help.. Now the node is giving me an output..
This is what exactly i was looking for.

Thanks a lot..

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Wonderful! Thanks for the update.

Just to close the loop on how to do the same thing with the JDBC. You would use the JDBC Query node if you want to do a select and the JDBC Execute node if you want to do an update or some other type of database statement.
So the SqlQuery parameter would question marks for all of the parameters:
select * from employee where empid=?
And then SqlQueryFieldBindings would have a comma delimited list of fields, one for each question mark:
empid