database connection and form saving for latest version.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

database connection and form saving for latest version.

Bharamani
This post was updated on .
Hi All

i am doing fresh set up for orbeon 2016.3 with tomcat 8, java 8 and mysql 5.7.

however, I am able to run the instance.

i am unable to see any data in any table.

Can you please suggest me where i am doing mistake?

for database connection i kept jar file in tomcat-home/lib folder.
and added below lines in server.xml and context.xml

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="40" maxIdle="20" maxWait="1000" name="jdbc/mysql" password="root" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8" username="root" validationQuery="select version();"/>



is there anything i am missing?

please help me in this.

Thanks
Thanks
Bharamani
Reply | Threaded
Open this post in threaded view
|

Re: database connection and form saving for latest version.

Bharamani
Hi,

I am able to resolve this issue.

I was missing with properties-local.xml configuration.

                       <property
                        as="xs:anyURI"
                        name="oxf.url-rewriting.service.base-uri"
                        value="http://localhost:8080/orbeon"/>
                       
                        <property as="xs:string" name="oxf.fr.persistence.provider.*.*.*" value="mysql"/>

            <property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql"/>

            <property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>


Hope this helps someone..

Thanks
Thanks
Bharamani
Reply | Threaded
Open this post in threaded view
|

Re: database connection and form saving for latest version.

Alessandro  Vernet
Administrator
Great Bharamani, I am glad you found the solution to this one.

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet