Login  Register

values are not getting stored in database

Posted by smaran on Feb 18, 2011; 10:06am
URL: https://discuss.orbeon.com/values-are-not-getting-stored-in-database-tp3312334p3312349.html

Hi All,
I am new to orbeon form builder.I am using the orbean community edition war file and mysql 5.5.9
and tomcat 5.5. and followed the following link.
http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer 
when restarted the tomcat and opened the link
http://localhost:8080/orbeon/fr/orbeon/bookshelf/new
and entered the value and saved.and i queryed the database. but the values are not stored in database.

i have following doubts in prcocess
 i am using mysql-connector-java-5.1.15-bin.jar instead of  mysql-connector-java-5.1.12-bin.jar since its higher version it should not be a problem.


in server.xml of tomcat we have already entry as
<Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved"
           factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
          pathname="conf/tomcat-users.xml" />
we need to delete this and add

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
    initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
    driverClassName="com.mysql.jdbc.Driver"
    poolPreparedStatements="true"
    username="orbeon"
    password="orbeon"
    url="jdbc:mysql://localhost:3306/orbeon"/>  or we need to append this can any one send me this xml it will be help full for me.
why data is not getting inserted in database? Do we need to restart the database?
 regards,
Smaran

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws