AnsweredAssumed Answered

jiveBinStore Table not created while installing jive 8.0.2.1 with oracle database

Question asked by darshan_patel on Jan 27, 2016

Hi,

Ryan King , Ryan Rutan

 

I want to install jive 8 with oracle database.

 

I have followed following steps :

 

  • Download settings.xml from https://community.aurea.com/docs/DOC-38298 and placed that file in .m2 folder and did required changes
  • Run mvn -U jive:create-project command to create jive project by providing required information.
  • Added oracle dependency in run-services/pom.xml as follows

             <dependency>

                <groupId>com.oracle</groupId>

               <artifactId>ojdbc6</artifactId>

                <version>11.2.0</version>

              </dependency>

  • updated  jive_startup.xml as required
  • Added oracle dependency in web/pom.xml
  • created two oracle database for jive and jive-eae
  • started search,eae and cargo and provide  set-up information as required and restarted jive instance.
  • I am getting following exception

     org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT count(binKey) FROM jiveBinStore WHERE namespace=? AND binKey=?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)

    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)

    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)

    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)

    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:805)

    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:824)

  • while checking jive database i found that "jiveBinStore" table was not created.

if I follow same steps for postgresql database then it creates 345 tables but with oracle i found only 344 tables and missing jiveBinStore table.

 

 

please let me know, If I missed any configuration...

Outcomes