Please login or register to access secure site features.

Note: By continuing to use DevConnect Program Services you agree to our latest Registered Member Terms.

Sign in using DevConnect ID

Forgot password?

Trouble logging in?

Submit a ticket for Registration Support.

I have an SSO ID

?
sign in

Don't have a DevConnect or SSO ID ?

Create a DevConnect account or join the program.

register now
^
Forum Index » Avaya Orchestration Designer » Manually editing the Database DBOP file   XML
 
Author Message
GayathriManickam



Joined: 20/03/2014 07:00:52
Messages: 14
Offline

Ok . Thank you

In insert query is it possible to insert the values directly. without using parameter?

like

/}}END:CLASS:CONSTRUCTOR

setSQLQuery("INSERT INTO USE.FEEDBACKIVR ( QUESTIONNO) VALUES ( '1' )");
WilsonYu



Joined: 06/11/2013 14:29:24
Messages: 3836
Online

It should just execute the insert statement fine. But make sure you set the parameters to an empty list by do this first:

//}}END:CLASS:CONSTRUCTOR

List parameters = new ArrayList();
setParameters(parameters);
GayathriManickam



Joined: 20/03/2014 07:00:52
Messages: 14
Offline

Hi

setSQLQuery("SELECT STUDENT_DATA.ID, STUDENT_DATA.NAME FROM AVAYA.STUDENT_DATA");

// List variable that may be used
java.util.List list;

// Parameters
com.avaya.sce.runtime.connectivity.db.DbQueryParam parameter;
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("ID",0,12, "select:ID"));
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("NAME",0,12, "select:NAME"));

This select query contains 10 values... How can i retrieve all the value ?
WilsonYu



Joined: 06/11/2013 14:29:24
Messages: 3836
Online

You would be better off starting with the dbop wizard to create a query since it will create the variables and map them to the parameters or result columns for you and generate the code automatically. The Java api methods mentioned here were not designed for you to do things manually although you can make some modification on the generated code.
 
 
Go to: