AnsweredAssumed Answered

jiveBinStore Table not created while installing jive with oracle database

Question asked by darshan_patel on Jan 27, 2016


Ryan King , Ryan Rutan


I want to install jive 8 with oracle database.


I have followed following steps :


  • Download settings.xml from 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






  • 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.core.JdbcTemplate.execute(

    at org.springframework.jdbc.core.JdbcTemplate.query(

    at org.springframework.jdbc.core.JdbcTemplate.query(

    at org.springframework.jdbc.core.JdbcTemplate.query(

    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(

    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(

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