I'm struggling to set a rowset in Custom Task. I have a jdbc resultset rs
project.createOrReplaceVariable("db.rows", rs.getString(1)));
I get:- The value must be a Collection or a Rowset, but found 'java.lang.String'
project.createOrReplaceVariable("db.rows", rs);
gives me: -The value must be a Collection or a Rowset, but found 'oracle.jdbc.driver.OracleResultSetImpl'
Any clues or help appreciated on how to translate an rs to db.rows?
Thanks
Custom Task and Rowset
Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Custom Task and Rowset
gFrench,
The forum is not usually a place for support on Custom Tasks. It's about general usage of the product.
This is a business specific issue which would be a billable service or training.
Please contact our Support Desk for additional guidance at [email protected].
Thanks!
The forum is not usually a place for support on Custom Tasks. It's about general usage of the product.
This is a business specific issue which would be a billable service or training.
Please contact our Support Desk for additional guidance at [email protected].
Thanks!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Re: Custom Task and Rowset
Hi,
I was hoping the community could help where Linoma can not. That is one of the reasons for having a forum is it not?
As for "general usage of the product", do you mean this forum is just for the most popular parts of the product?
Building a custom task is part of the product. There are features like "install custom task" under the System menu in MFT and there is a product manual "Go Anywhere MFT Custom Task Guide", so although maybe less used its still part of the product and the use base can help. There are already posts on the beanInfo.xml which where useful.
I've actual fixed the issue now. Its a case of using a string array to return the results out of the custom task, then the variable can be used in a "forItem" loop.
ArrayList<String[]> resultSet = new ArrayList<String[]>();
resultSet.add("Hello World);
resultSet.add("Goodbye Planet");
project.createOrReplaceVariable(resultVariableAttribute, resultSet);
I hope that helps anyone else who stumbles on this forum.
Thanks
I was hoping the community could help where Linoma can not. That is one of the reasons for having a forum is it not?
As for "general usage of the product", do you mean this forum is just for the most popular parts of the product?
Building a custom task is part of the product. There are features like "install custom task" under the System menu in MFT and there is a product manual "Go Anywhere MFT Custom Task Guide", so although maybe less used its still part of the product and the use base can help. There are already posts on the beanInfo.xml which where useful.
I've actual fixed the issue now. Its a case of using a string array to return the results out of the custom task, then the variable can be used in a "forItem" loop.
ArrayList<String[]> resultSet = new ArrayList<String[]>();
resultSet.add("Hello World);
resultSet.add("Goodbye Planet");
project.createOrReplaceVariable(resultVariableAttribute, resultSet);
I hope that helps anyone else who stumbles on this forum.
Thanks
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Custom Task and Rowset
You are absolutely correct, and that's why we approved this for the community ... in case someone has options or suggestions that can help, they are more than welcome to reply!
My apologies if it appeared we weren't going to support the product, we just have to make a determination between product support and specific business need.
Thank you for the reply!
My apologies if it appeared we weren't going to support the product, we just have to make a determination between product support and specific business need.
Thank you for the reply!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696