Fetching values from database and populate values in the dropdownlist

[bharathi_reddy]

Hi All,

I am new to adobe live cycle workbench ,

I am creating a process,which will fetch values from the database based on selection of country group code, will populate the  values of that particular country along with country code and country description  in the second  dropdown list .This process is invoked as a webservice and process is short lived process.

Database(ORACLE SQl DEVELOPER) having two tables first:country code and country group code; second: country code and country description.

Form designer ES : two dropdown list based on selection of listing values

in first dropdown list second dropdown list has to be displayed along with the listing values(Which are fetched from the database);

I tried so many  times but it is giving read time out error......

can anyone suggest me how can i solve the problem?

Thanks,

Bharathi.

[wasil_z]

If it is timeout issue, you can increase the default timeout value. : http://help.adobe.com/en_US/livecycle/9.0/workbenchHelp/help.htm?content=003006.html

Thanks,

Wasil

[bharathi_reddy]

Hi wasil,

Can u tell me how to check  whether the  database connection is happening or not?

[wasil_z]

If you are using JDBC operation ( http://help.adobe.com/en_US/livecycle/10.0/WorkbenchHelp/WS92d06802c76abadb799416c212826bea627-8000.... ) to fetch the data from database, there is a test button you can use to check the connection.

Also, you could put the recording ON for the process and check the returned values.

Thanks,

Wasil