Jahia in English > How to change the...

0 (0 Good)
0 (0 Bad)

How to change the data base for Jahia DigitalFactory SDK.

by  Jahia Data Base Configuration »  2015/02/28 08:30

Good Day

I'm testing jahia cms with "Enterprise Trail version SDK" not exe file. Everything worked fine with Default Database. But i want to change the data base to MSSQL. I changed the Data base Configurations but its throwing the following error error while starting for the first time build. 

Error: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Stack trace:
-------------
Cause level : 0 (level 0 is the most precise exception)
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'jahia_nodetypes_provider'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

So far i chnaged the connection settings in 

--> tomcat\webapps\ROOT\META-INF\Context.xml 

-->tomcat\webapps\ROOT\WEB-INF\etc\config\jahia.properties 

 

Please suggest me to get through this.

Regards

Naani

 

Jahia Data Base Configuration
Number of messages  1
Not registered
0 (0 Good)
0 (0 Bad)

Re: How to change the data base for Jahia DigitalFactory SDK.

by  shyrkov »  2015/03/02 22:25

Hello Naani,

unfortunately, you cannot swich the DBMS type after the installation. And the Digital Factory SDK package comes with a pre-configured Apache Derby as a target DBMS only.

You can take the installer (download section) and run the installation, selecting "Advanced install" to be able to chose the target database type.

 

Kind regards

Sergiy

  • Re: How to change the data base for Jahia DigitalFactory SDK.
    2015/03/02 22:25

    shyrkov <p>Hello Naani,</p> <p>unfortunately, you cannot swich the DBMS type after the installation. And the Digital Factory SDK package comes with a pre-configured Apache Derby as a target DBMS only.</p> <p>You can take the installer (<a href="http://www.jahia.com/documentation-and-downloads/developers-downloads" title="jahia.com Downloads">download section</a>) and run the installation, selecting &quot;Advanced install&quot; to be able to chose the target database type.</p> <p>&nbsp;</p> <p>Kind regards</p> <p>Sergiy</p>

  • Number of messages  407
    Registration date Mar 2, 2015
    0 (0 Good)
    0 (0 Bad)

    Comment

    by  manny »  2015/03/04 01:55

    i hope this will work

  • Comment
    2015/03/04 01:55

    manny <p>i hope this will work</p>

  • Number of messages  1
    Registration date Mar 4, 2015
    0 (0 Good)
    0 (0 Bad)

    How to change the data base for Jahia DigitalFactory SDK

    by  tantelyralaivao@gmail.com »  2016/10/06 06:57

    good day 

    I'm testing jahia cms with "CommunityTrail version SDK" not exe file. Everything worked fine with Default Database. But i want to change the data base to MySQL..... I changed the Data base Configurations but its throwing the following error error while starting for the first time build

    javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.pool.DerbyPersistenceManager

    ...................

    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE syscs_util.SYSCS_SET_DATABASE_PROPERTY does not exist

    ......

    i changed the connection settings in :

    C:\DigitalExperienceManager-CommunityDistribution-7.1.2.0\digital-factory-config\jahia\jahia.propreties

    C:\DigitalExperienceManager-CommunityDistribution-7.1.2.0\tomcat\webapps\ROOT\WEB-INF\etc\repository\jackrabbit\repository.xml

    C:\DigitalExperienceManager-CommunityDistribution-7.1.2.0\tomcat\webapps\ROOT\META-INF\context.xml

     

    Can I suggest the solution through this

    Regards

    Tantely Tina

     

     

  • How to change the data base for Jahia DigitalFactory SDK
    2016/10/06 06:57

    tantelyralaivao@gmail.com <p>good day&nbsp;</p> <p><span style="color: rgb(88, 88, 91); font-family: Lato, sans-serif; font-size: 16px;">I&#39;m testing jahia cms with &quot;CommunityTrail version SDK&quot; not exe file. Everything worked fine with Default Database. But i want to change the data base to MySQL..... I changed the Data base Configurations but its throwing the following error&nbsp;error while starting&nbsp;for the first time build</span></p> <p><span style="color:#FF0000;">javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.pool.DerbyPersistenceManager</span></p> <p><span style="color:#FF0000;">...................</span></p> <p><span style="color:#FF0000;">Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE syscs_util.SYSCS_SET_DATABASE_PROPERTY does not exist</span></p> <p><span style="color:#FF0000;">......</span></p> <p>i changed the connection settings in :</p> <p>C:\DigitalExperienceManager-CommunityDistribution-7.1.2.0\digital-factory-config\jahia\jahia.propreties</p> <p>C:\DigitalExperienceManager-CommunityDistribution-7.1.2.0\tomcat\webapps\ROOT\WEB-INF\etc\repository\jackrabbit\repository.xml</p> <p>C:\DigitalExperienceManager-CommunityDistribution-7.1.2.0\tomcat\webapps\ROOT\META-INF\context.xml</p> <p>&nbsp;</p> <p style="box-sizing: border-box; margin: 0px 0px 30px; font-size: 16px; font-family: Lato, sans-serif; color: rgb(88, 88, 91); line-height: 1.8;">Can I suggest the solution&nbsp;through this</p> <p style="box-sizing: border-box; margin: 0px 0px 30px; font-size: 16px; font-family: Lato, sans-serif; color: rgb(88, 88, 91); line-height: 1.8;">Regards</p> <p style="box-sizing: border-box; margin: 0px 0px 30px; font-size: 16px; font-family: Lato, sans-serif; color: rgb(88, 88, 91); line-height: 1.8;">Tantely Tina</p> <p>&nbsp;</p> <p>&nbsp;</p>

  • Number of messages  1
    Registration date Oct 6, 2016
    0 (0 Good)
    0 (0 Bad)

    Re: How to change the data base for Jahia DigitalFactory SDK

    by  shyrkov »  2016/10/06 08:44

    Hello,

    please, refer to my comment (it is the second one in this thread).

    Kind regards

    Sergiy

  • Re: How to change the data base for Jahia DigitalFactory SDK
    2016/10/06 08:44

    shyrkov <p>Hello,</p> <p>please, refer to my comment (it is the second one in this thread).</p> <p>Kind regards</p> <p>Sergiy</p>

  • Number of messages  407
    Registration date Oct 6, 2016
    Contact
    Share
    Feedback

    Get in touch

    Whether you are a current user or if you are just evaluating Jahia, we are here to help.

    Contact us

    Share this page