You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@rave.apache.org by "Jasha Joachimsthal (JIRA)" <ji...@apache.org> on 2011/09/12 10:11:08 UTC

[jira] [Created] (RAVE-259) Document how to use a different database setup

Document how to use a different database setup 
-----------------------------------------------

                 Key: RAVE-259
                 URL: https://issues.apache.org/jira/browse/RAVE-259
             Project: Rave
          Issue Type: Sub-task
            Reporter: Jasha Joachimsthal
            Assignee: Jasha Joachimsthal




--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (RAVE-259) Document how to use a different database setup

Posted by "Jasha Joachimsthal (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/RAVE-259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jasha Joachimsthal resolved RAVE-259.
-------------------------------------

    Resolution: Fixed

See http://incubator.apache.org/rave/documentation/configure-database.html

> Document how to use a different database setup 
> -----------------------------------------------
>
>                 Key: RAVE-259
>                 URL: https://issues.apache.org/jira/browse/RAVE-259
>             Project: Rave
>          Issue Type: Sub-task
>            Reporter: Jasha Joachimsthal
>            Assignee: Jasha Joachimsthal
>             Fix For: 0.4-INCUBATING
>
>


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (RAVE-259) Document how to use a different database setup

Posted by "Jasha Joachimsthal (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/RAVE-259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13107657#comment-13107657 ] 

Jasha Joachimsthal commented on RAVE-259:
-----------------------------------------

The dataSourcePopulator should not try to insert data if the "executeScriptQuery" returns a row. The default query for the portal is "SELECT * FROM WIDGET".
I just tested using a h2 database with a local file storage and it works fine. 
Are you using the latest 0.4-incubating-SNAPSHOT version? In the 0.3-incubating release, the executeScriptQuery was wrong (non existent table name) and the database properties weren't read from the portal.properties.

> Document how to use a different database setup 
> -----------------------------------------------
>
>                 Key: RAVE-259
>                 URL: https://issues.apache.org/jira/browse/RAVE-259
>             Project: Rave
>          Issue Type: Sub-task
>            Reporter: Jasha Joachimsthal
>            Assignee: Jasha Joachimsthal
>             Fix For: 0.4-INCUBATING
>
>


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Issue Comment Edited] (RAVE-259) Document how to use a different database setup

Posted by "Xuan Wu (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/RAVE-259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13106857#comment-13106857 ] 

Xuan Wu edited comment on RAVE-259 at 9/16/11 10:12 PM:
--------------------------------------------------------

In order to make h2 use local file, I changed in rave-portal/src/main/webapp/WEB-INF/dataContext.xml:

        <property name="url" value="jdbc:h2:file:/home/somefile" />

After the first time populating by initial.sql, I removed the populating part in entityManagerFactory (rave-portal/src/main/webapp/WEB-INF/applicationContext.xml), as the exceptions seem to occur because of inserting duplicate records:

       <property name="populator" ref="dataSourcePopulator" />

This works fine afterwards. 

However I've not succeeded with changing portal.properties.

      was (Author: xuanwu):
    In order to make h2 use local file, I changed in rave-portal/src/main/webapp/WEB-INF/dataContext.xml:

        <property name="url" value="jdbc:h2:file:/home/somefile" />

After the first time populating by initial.sql, I removed the populating part in entityManagerFactory, as the exceptions seem to occur because of inserting duplicate records:

       <property name="populator" ref="dataSourcePopulator" />

This works fine afterwards. 

However I've not succeeded with changing portal.properties.
  
> Document how to use a different database setup 
> -----------------------------------------------
>
>                 Key: RAVE-259
>                 URL: https://issues.apache.org/jira/browse/RAVE-259
>             Project: Rave
>          Issue Type: Sub-task
>            Reporter: Jasha Joachimsthal
>            Assignee: Jasha Joachimsthal
>             Fix For: 0.4-INCUBATING
>
>


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (RAVE-259) Document how to use a different database setup

Posted by "Xuan Wu (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/RAVE-259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13106857#comment-13106857 ] 

Xuan Wu commented on RAVE-259:
------------------------------

In order to make h2 use local file, I changed in rave-portal/src/main/webapp/WEB-INF/dataContext.xml:

        <property name="url" value="jdbc:h2:file:/home/somefile" />

After the first time populating by initial.sql, I removed the populating part in entityManagerFactory, as the exceptions seem to occur because of inserting duplicate records:

       <property name="populator" ref="dataSourcePopulator" />

This works fine afterwards. 

However I've not succeeded with changing portal.properties.

> Document how to use a different database setup 
> -----------------------------------------------
>
>                 Key: RAVE-259
>                 URL: https://issues.apache.org/jira/browse/RAVE-259
>             Project: Rave
>          Issue Type: Sub-task
>            Reporter: Jasha Joachimsthal
>            Assignee: Jasha Joachimsthal
>             Fix For: 0.4-INCUBATING
>
>


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira