Posted by smaran on Feb 18, 2011; 9:58am
URL: https://discuss.orbeon.com/values-are-not-getting-stored-in-database-tp3312334.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?
 regards,
Smaran