0 Replies Latest reply on Nov 13, 2005 8:31 AM by Jason Banico

    My portal installation doesn't create the portal database

    Jason Banico Newbie

      In the documents, it was mentioned that the installation creates the database schema. It doesn't happen in mine.

      My fresh portal installation returns the following error when starting up Jboss AS:

      00:27:43,664 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext
      00:27:43,664 INFO [NamingHelper] JNDI InitialContext properties:{}
      00:27:43,664 INFO [SessionFactoryImpl] Checking 0 named queries
      00:27:43,664 INFO [SessionFactoryBinder] Hibernate dialect used org.hibernate.dialect.MySQLDialect
      00:27:44,445 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: S1000
      00:27:44,445 ERROR [JDBCExceptionReporter] General error message from server: "Table 'jbossportal.jbp_user_pref_set' doesn't exist"
      00:27:44,515 WARN [ServiceController] Problem starting service portal:service=Hibernate
      org.hibernate.exception.GenericJDBCException: could not execute query
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2150)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)