[opencms-dev] WebForms Module

[Michael Moossen]

Hi Folks!

Webforms 1.2 supports MySql and Oracle, previous versions only MySql.
Once you have the right version, just RTFM, in special section 4.1.2:

 > 4.1.2   Database Provider
 > At the moment supported database providers are only MySql and Oracle.
 > Being MySql the default. If you are using Oracle as database provider
 > you have to set following module parameters:
 > db-provider=oracle and index-tablespace=<your tablespace>, here the
 > default is ‘users’. After changing these parameters you will have to
 > restart your servlet container.

and the db tables will be created automagically ;)

HTH

Kind regards,
Michael

-------------------

Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org


Roberto Fernández wrote:
> I checked the databases of two opencms instalations, one with Webform
> installed, and the other without it, and I noticed the one with
> webform has this tables:
> 
> table cms_webform_data:
> -------------------------------------------
> column_name | data_type | numeric_precision
> -------------------------------------------
> REF_ID	    | int	|		 10
> FIELDNAME   | varchar	|	
> FIELDVALUE  | text	|	
> -------------------------------------------
> 
> table cms_webform_entries:
> --------------------------------------------
> column_name  | data_type | numeric_precision
> --------------------------------------------
> ENTRY_ID     | int	 |		  10
> FORM_ID      | varchar	 |		
> DATE_CREATED | bigint	 |		  19
> RESOURCE_ID  | varchar	 |		
> STATE	     | int	 |		  10
> --------------------------------------------
> 
> This is where it saves what I enter in the forms. I think you should
> check this tables are correctly created.
> 
> 2008/10/31 Vahe Momjian <m_vahe at yahoo.com>:
>> Thank you for your answer.
>>
>> But I have also followed all PDF instruction, but to send any WebForm as
>> Email no problem, problem is to save these webforms in DB.
>> I still cant save them to DB. And In log I see a DB error that Table could
>> not be found.
>>
>>> Ther is a pdf that comes with the module, I followed it and it worked
>>> fine (I don´t use Oracle, but I do have Tomcat+OpenCms 7.0.5)
>>>
>>> 2008/10/30 Vahe Momjian <m_vahe at yahoo.com>:
>>>> Hi all.
>>>> Have anybody configured the OpenCms WebForms Module so that it stores
>>>> data
>>>> into database?
>>>> If yes please help me to configure it.
>>>>
>>  > Tomcat+OpenCms 7.0.5+Oracle
>>>> Thank you.
>>>>
>>>>
>>>> _______________________________________________
>>>> This mail is sent to you from the opencms-dev mailing list
>>>> To change your list options, or to unsubscribe from the list, please
>>>> visit
>>>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>>>
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev