values are not getting stored in database

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

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

Smaran,

since i don't use MySQL myself, i can't offer a tested config example.
But at the first point i would check the mysql logs as well as the
tomcat logs for any errors or entries regarding the CRUD operations.
Regarding the tomcat logs, errors or other helpful info may appear in
catalina.out and/or orbeon.log. Depending on the individual way tomcat
was installed, one may has to adjust the path of orbeon.log
in /WEB-INF/resources/config/log4j.xml of the orbeon war.

HTH
florian




--
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

Hi Thanks,
For the reply.I checked orebeon.log
I am getting following error why this is happening


2011-02-18 17:40:37,015 ERROR ProcessorService  - Exception at
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
        at org.apache.naming.NamingContext.lookup(NamingContext.java:769)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
        at org.orbeon.oxf.processor.DatabaseContext.getConnection(DatabaseContext.java:55)
        at org.orbeon.oxf.processor.sql.SQLProcessorInterpreterContext.getConnection(SQLProcessorInterpreterContext.java:327)
        at org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:173)
        at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:542)
        at org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)
        at org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)
        at org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)
        at org.orbeon.oxf.processor.sql.SQLProcessor$RootInterpreter.endElement(SQLProcessor.java:304)
        at org.orbeon.oxf.xml.SAXStore.replay(SAXStore.java:290)
        at org.orbeon.oxf.xml.SAXStore.replay(SAXStore.java:204)

.
.
.
.
.
.
.
.
.
.
.
Regards,
Smaran
-----Original Message-----
From: Florian Schmitt [mailto:[hidden email]]
Sent: Friday, February 18, 2011 5:37 PM
To: [hidden email]
Subject: [ops-users] Re: values are not getting stored in database

Smaran,

since i don't use MySQL myself, i can't offer a tested config example.
But at the first point i would check the mysql logs as well as the tomcat logs for any errors or entries regarding the CRUD operations.
Regarding the tomcat logs, errors or other helpful info may appear in catalina.out and/or orbeon.log. Depending on the individual way tomcat was installed, one may has to adjust the path of orbeon.log in /WEB-INF/resources/config/log4j.xml of the orbeon war.

HTH
florian



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

Smaran,

--
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