Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

I want to save data from the form to database?

Avatar

Level 3

Hi All,

I have a form which is designed using Adobe LiveCycle DesignerES2. And i want to save data which users enters in to form using Adobe LiveCycle WorkSpace. I have created a process which is used to store data to data base.Here is the screen shot.Here data base is Oracle 10g. and used Adobe LiveCycle WorkbenchES2 for designing process.

screenshot1.jpg

On qrFndAppr i have written insert SQL statement.

INSERT INTO TABLE1 VALUES('{$ /process_data/@column1 $}',

'{$ /process_data/@column2$}','{$ /process_data/@column3$}',

'{$ /process_data/@column4$}','{$ /process_data/@column5$}',

'{$ /process_data/@column6$}','{$ /process_data/@column7$}')

In this first four columns are string (DB- Varchar(255),and fifth column is INT(DB-Number) , and another two columns are date (DB- Varchar(255).

I am able to insert the data into data base but i am getting the error message as invalid SQL statement.

screenshot2.jpg

Please help me how i can resolve the exception !!!!!!!!!!

Thanks

Bharathi.

1 Reply

Avatar

Employee Advisor

See the attached LCA(processes JDBC and JDBC2). This has a working version of both approaches i.e.using parametrized query and dynamic process data resp.

-Wasil