Hi Thomas,Yes, I do have good hold over SQL. I tried this long before but with no luck. One thing I noticed. If I am using any other variable for storing the ouput rows and navigating to the same variable through xpath in the sql editor then while testing it's showing 1 row affected. Later when I te...

Hi Thomas,I followed the same thing. For the output of the no.of rows affected in the SQL Statement I used an integer variable. My table has few columns. employee_id,date,designation,employee_name,evaluator_name,reporting_manager. I had created xsd schema and binded all those fields as per the data ...

Hi Thomas,I did the same much earlier but with no result.Don't I need any other activity like "processFormSubmission" for extracting form data? Lets say I have a form which will be opened in the Workspace. The form will be in xdp format? As I know the form data would be of the format .xml. But How t...

Hi,I have designed a form which has several fields. I have created a table inside "adobe" schema (Installed through turnkey). I want o create process in such a way that after filling all the requried fields if the user in workspace clicks complete or submit the form then the corresponding columns in...

Hi,I used the adobe schema for test. Made a simple form to update the DB. It worked well while giving hardcoded values in test. But it did not work while detching data from the form.I used JDBC service by using the following statement : INSERT INTO adobe.feedback_form VALUES ('{$ /process_data/formD...

One morw thing I would like to ask? Do we need Xml schema or sample xml data is a must for every form? Do we need LC DataService anyway?Thanks,Bibhu.

Hi Nith,I am sorry. I did not get your response correctly. Where to use the complete table ref name? Is it in the DSN? or else where? I got the following error when I tested it as per your instruction in the SQL statement of the action.Exception: No matching credentials in Subject!; - nested throwab...

Hi Nith,I have managed to create a DSN. I just opened the adobe.ds xml file and edited it. Below is my adobe.ds xml file.=============================================================<?xml version="1.0" encoding="UTF-8"?><datasources>    <local-tx-datasource>        <jndi-name>IDP_DS</jndi-name>     ...

Hi,No, it does not install MySQL JDBC driver. I don't know why my repeated instances of installing MySQL driver is failing. I created a schemadifferently. But it's not accessing it.Do you have any examples/resources/videos which will help me?Thanks,Bibhu.

Hi Nith,Yes, I had MySQL, default JBOSS installed. But I have one doubt while installing MySQL by turnkey does it install MySQL JDBC connector with it? Because I did not find it. While installing JDBC connector by myself I did not get the option in the JDBC administrative tool. There is only one opt...