5 Replies Latest reply on Jan 24, 2006 7:24 AM by svaret

    Problems creating jbossportal database content.

    svaret Newbie

      Hi there,

      I use jboss-portal-2.0-jboss-4.0.2 and MySQL 4.0.22 that I understand that version of jboss portal was tested with. When I try to create content in the jbossportal database I get an error. The stack-trace includes the create table statements that I copied and tested directly in MySQL and it works!

      Anyone with an idea what could be the problem?

      Best regards Lasse

      Stacktrace
      14:06:53,447 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
      14:06:53,447 INFO [Configuration] processing extends queue
      14:06:53,447 INFO [Configuration] processing collection mappings
      14:06:53,447 INFO [Configuration] processing association property references
      14:06:53,447 INFO [Configuration] processing foreign key constraints
      14:06:53,447 INFO [Configuration] processing extends queue
      14:06:53,447 INFO [Configuration] processing collection mappings
      14:06:53,447 INFO [Configuration] processing association property references
      14:06:53,447 INFO [Configuration] processing foreign key constraints
      14:06:53,457 INFO [SchemaExport] Running hbm2ddl schema export
      14:06:53,457 INFO [SchemaExport] exporting generated schema to database
      14:06:53,457 INFO [NamingHelper] JNDI InitialContext properties:{}
      14:06:53,457 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      14:06:53,457 INFO [SchemaExport] schema export complete
      14:07:11,483 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
      14:07:11,483 INFO [Configuration] processing extends queue
      14:07:11,483 INFO [Configuration] processing collection mappings
      14:07:11,483 INFO [Configuration] processing association property references
      14:07:11,483 INFO [Configuration] processing foreign key constraints
      14:07:11,493 INFO [Configuration] processing extends queue
      14:07:11,493 INFO [Configuration] processing collection mappings
      14:07:11,493 INFO [Configuration] processing association property references
      14:07:11,493 INFO [Configuration] processing foreign key constraints
      14:07:11,493 INFO [SchemaExport] Running hbm2ddl schema export
      14:07:11,493 INFO [SchemaExport] exporting generated schema to database
      14:07:11,493 INFO [NamingHelper] JNDI InitialContext properties:{}
      14:07:11,493 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      14:07:11,503 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid integer not null auto_incremen
      t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid))
      14:07:11,503 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_roles (jbp_r
      id integer not null auto_increment]
      14:07:11,503 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref (jbp_id integer not null auto_incre
      ment, jbp_name varchar(255) not null, jbp_type integer, jbp_set_id integer, primary key (jbp_id))
      14:07:11,503 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref (j
      bp_id integer not null auto_increment]
      14:07:11,513 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref_set (jbp_id integer not null auto_i
      ncrement, jbp_parent_id integer, name varchar(255) not null, primary key (jbp_id))
      14:07:11,513 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref_se
      t (jbp_id integer not null auto_increment]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid integer not null auto_incremen
      t, jbp_root_pref_set_id integer, jbp_uname varchar(255) unique, jbp_givenname varchar(255), jbp_familyname var
      char(255), jbp_password varchar(255), jbp_realemail varchar(255), jbp_fakeemail varchar(255), jbp_regdate date
      time, jbp_viewrealemail bit, jbp_enabled bit, primary key (jbp_uid))
      14:07:11,523 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_users (jbp_u
      id integer not null auto_increment]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership add index FKF4101738A7430374 (
      jbp_rid), add constraint FKF4101738A7430374 foreign key (jbp_rid) references jbp_roles (jbp_rid)
      14:07:11,523 ERROR [SchemaExport] Wrong data type: FKF4101738A7430374 in statement [alter table jbp_role_membe
      rship add index FKF4101738A7430374]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership add index FKF4101738E70E4BD7 (
      jbp_uid), add constraint FKF4101738E70E4BD7 foreign key (jbp_uid) references jbp_users (jbp_uid)
      14:07:11,523 ERROR [SchemaExport] Wrong data type: FKF4101738E70E4BD7 in statement [alter table jbp_role_membe
      rship add index FKF4101738E70E4BD7]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref add index FK93CC44D0AF499A90 (jbp_se
      t_id), add constraint FK93CC44D0AF499A90 foreign key (jbp_set_id) references jbp_user_pref_set (jbp_id)
      14:07:11,523 ERROR [SchemaExport] Table not found: JBP_USER_PREF in statement [alter table jbp_user_pref]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_prop_value add index FKC4963064D50D5
      281 (jbp_prop_id), add constraint FKC4963064D50D5281 foreign key (jbp_prop_id) references jbp_user_pref (jbp_i
      d)
      14:07:11,523 ERROR [SchemaExport] Wrong data type: FKC4963064D50D5281 in statement [alter table jbp_user_pref_
      prop_value add index FKC4963064D50D5281]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_set add index FK97AA4873E3AFC41A (jb
      p_parent_id), add constraint FK97AA4873E3AFC41A foreign key (jbp_parent_id) references jbp_user_pref_set (jbp_
      id)
      14:07:11,523 ERROR [SchemaExport] Table not found: JBP_USER_PREF_SET in statement [alter table jbp_user_pref_s
      et]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_prop add index FK93CC4610E70E4BD7 (jbp_ui
      d), add constraint FK93CC4610E70E4BD7 foreign key (jbp_uid) references jbp_users (jbp_uid)
      14:07:11,523 ERROR [SchemaExport] Wrong data type: FK93CC4610E70E4BD7 in statement [alter table jbp_user_prop
      add index FK93CC4610E70E4BD7]
      14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_users add index FKF6060141FD4AFF8F (jbp_root_p
      ref_set_id), add constraint FKF6060141FD4AFF8F foreign key (jbp_root_pref_set_id) references jbp_user_pref_set
      (jbp_id)
      14:07:11,523 ERROR [SchemaExport] Table not found: JBP_USERS in statement [alter table jbp_users]
      14:07:11,523 INFO [SchemaExport] schema export complete

        • 1. Re: Problems creating jbossportal database content.
          Roy Russo Master

          Use AS 4.0.3.SP1.

          Please post messages such as this in the User Forum, as well.

          • 2. Re: Problems creating jbossportal database content.
            svaret Newbie

            Hi,

            Ok I will post this in the user forum as well.

            However I now downloaded AS 4.0.3.SP1 as u said. I run it on the db server which is tested according to the documentation MySQL 4.0.22 and I still get the same error. What am I doing wrong. I have created a database named jbossportal where a user portal with pwd portalpassword is created and granted full access.

            Best regards Lasse


            17:53:57,307 INFO [SessionFactoryBinder] Hibernate dialect used org.hibernate.dialect.MySQLDialect
            17:53:57,617 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            17:53:57,617 ERROR [JDBCExceptionReporter] Table not found in statement [select userprefse0_.jbp_id as jbp1_6_
            , userprefse0_.jbp_parent_id as jbp2_6_, userprefse0_.name as name6_ from jbp_user_pref_set userprefse0_ limit
            ?]
            17:53:57,627 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            17:53:57,627 ERROR [JDBCExceptionReporter] Table not found in statement [select roleimpl0_.jbp_rid as jbp1_0_,
            roleimpl0_.jbp_name as jbp2_0_, roleimpl0_.jbp_displayname as jbp3_0_ from jbp_roles roleimpl0_ limit ?]
            17:53:57,647 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            17:53:57,647 ERROR [JDBCExceptionReporter] Table not found in statement [select userimpl0_.jbp_uid as jbp1_2_,
            userimpl0_.jbp_root_pref_set_id as jbp2_2_, userimpl0_.jbp_uname as jbp3_2_, userimpl0_.jbp_givenname as jbp4
            _2_, userimpl0_.jbp_familyname as jbp5_2_, userimpl0_.jbp_password as jbp6_2_, userimpl0_.jbp_realemail as jbp
            7_2_, userimpl0_.jbp_fakeemail as jbp8_2_, userimpl0_.jbp_regdate as jbp9_2_, userimpl0_.jbp_viewrealemail as
            jbp10_2_, userimpl0_.jbp_enabled as jbp11_2_ from jbp_users userimpl0_ limit ?]
            17:53:57,657 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            17:53:57,657 ERROR [JDBCExceptionReporter] Table not found in statement [select userpref0_.jbp_id as jbp1_4_,
            userpref0_.jbp_name as jbp2_4_, userpref0_.jbp_type as jbp3_4_ from jbp_user_pref userpref0_ limit ?]
            17:53:57,677 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
            17:53:57,677 INFO [Configuration] processing extends queue
            17:53:57,677 INFO [Configuration] processing collection mappings
            17:53:57,677 INFO [Configuration] processing association property references
            17:53:57,677 INFO [Configuration] processing foreign key constraints



            Ok I don't have the tables so I try to create them using the link
            http://localhost:8080/jmx-console/HtmlAdaptor?action=inspectMBean&name=portal%3Aservice%3DHibernate

            I then get the following.


            17:59:48,912 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
            17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid integer not null auto_incremen
            t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid))
            17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_roles (jbp_r
            id integer not null auto_increment]
            17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref (jbp_id integer not null auto_incre
            ment, jbp_name varchar(255) not null, jbp_type integer, jbp_set_id integer, primary key (jbp_id))
            17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref (j
            bp_id integer not null auto_increment]
            17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref_set (jbp_id integer not null auto_i
            ncrement, jbp_parent_id integer, name varchar(255) not null, primary key (jbp_id))
            17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref_se
            t (jbp_id integer not null auto_increment]
            17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid integer not null auto_incremen
            t, jbp_root_pref_set_id integer, jbp_uname varchar(255) unique, jbp_givenname varchar(255), jbp_familyname var
            char(255), jbp_password varchar(255), jbp_realemail varchar(255), jbp_fakeemail varchar(255), jbp_regdate date
            time, jbp_viewrealemail bit, jbp_enabled bit, primary key (jbp_uid))
            17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_users (jbp_u
            id integer not null auto_increment]
            17:59:48,922 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership add index FKF4101738E70E4BD7 (
            jbp_uid), add constraint FKF4101738E70E4BD7 foreign key (jbp_uid) references jbp_users (jbp_uid)
            17:59:48,922 ERROR [SchemaExport] Wrong data type: FKF4101738E70E4BD7 in statement [alter table jbp_role_membe
            rship add index FKF4101738E70E4BD7]
            17:59:48,922 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership add index FKF4101738A7430374 (
            jbp_rid), add constraint FKF4101738A7430374 foreign key (jbp_rid) references jbp_roles (jbp_rid)
            17:59:48,922 ERROR [SchemaExport] Wrong data type: FKF4101738A7430374 in statement [alter table jbp_role_membe
            rship add index FKF4101738A7430374]
            17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref add index FK93CC44D0AF499A90 (jbp_se
            t_id), add constraint FK93CC44D0AF499A90 foreign key (jbp_set_id) references jbp_user_pref_set (jbp_id)
            17:59:48,932 ERROR [SchemaExport] Table not found: JBP_USER_PREF in statement [alter table jbp_user_pref]
            17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_prop_value add index FKC4963064D50D5
            281 (jbp_prop_id), add constraint FKC4963064D50D5281 foreign key (jbp_prop_id) references jbp_user_pref (jbp_i
            d)
            17:59:48,932 ERROR [SchemaExport] Wrong data type: FKC4963064D50D5281 in statement [alter table jbp_user_pref_
            prop_value add index FKC4963064D50D5281]
            17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_set add index FK97AA4873E3AFC41A (jb
            p_parent_id), add constraint FK97AA4873E3AFC41A foreign key (jbp_parent_id) references jbp_user_pref_set (jbp_
            id)
            17:59:48,932 ERROR [SchemaExport] Table not found: JBP_USER_PREF_SET in statement [alter table jbp_user_pref_s
            et]
            17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_prop add index FK93CC4610E70E4BD7 (jbp_ui
            d), add constraint FK93CC4610E70E4BD7 foreign key (jbp_uid) references jbp_users (jbp_uid)
            17:59:48,932 ERROR [SchemaExport] Wrong data type: FK93CC4610E70E4BD7 in statement [alter table jbp_user_prop
            add index FK93CC4610E70E4BD7]
            17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_users add index FKF6060141FD4AFF8F (jbp_root_p
            ref_set_id), add constraint FKF6060141FD4AFF8F foreign key (jbp_root_pref_set_id) references jbp_user_pref_set
            (jbp_id)
            17:59:48,932 ERROR [SchemaExport] Table not found: JBP_USERS in statement [alter table jbp_users]
            17:59:48,932 INFO [SchemaExport] schema export complete
            17:59:52,838 INFO [SessionFactoryBinder] Creating database content
            17:59:52,918 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            17:59:52,918 ERROR [JDBCExceptionReporter] Table not found in statement [insert into jbp_roles (jbp_name, jbp_
            displayname) values (?, ?)]
            17:59:52,918 ERROR [SessionFactoryBinder] Error in the bsh script
            Sourced file: inline evaluation of: ``// This bsh script setup the default content of the portal. // It is ca
            lled whe . . . '' : Method Invocation session.save : at Line: 39 : in file: inline evaluation of: ``// This bs
            h script setup the default content of the portal. // It is called whe . . . '' : session .save ( adminRole )


            Target exception: org.hibernate.exception.SQLGrammarException: could not insert: [org.jboss.portal.core.impl.r
            ole.RoleImpl]

            at bsh.BSHMethodInvocation.eval(Unknown Source)
            at bsh.BSHPrimaryExpression.eval(Unknown Source)
            at bsh.BSHPrimaryExpression.eval(Unknown Source)
            at bsh.BSHBlock.evalBlock(Unknown Source)
            at bsh.BSHBlock.eval(Unknown Source)
            at bsh.BSHBlock.eval(Unknown Source)
            at bsh.BSHTryStatement.eval(Unknown Source)
            at bsh.Interpreter.eval(Unknown Source)
            at bsh.Interpreter.eval(Unknown Source)
            at bsh.Interpreter.eval(Unknown Source)
            at org.jboss.portal.core.hibernate.SessionFactoryBinder.createContent(SessionFactoryBinder.java:330)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:
            127)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
            at org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:243)
            at org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:208)
            at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorServlet.java:247)
            at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdaptorServlet.java:85)
            at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServlet.java:67)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.ja
            va:744)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
            at java.lang.Thread.run(Thread.java:534)

            • 3. Re: Problems creating jbossportal database content.
              Roy Russo Master

              1. Drop all your tables.
              2. Restart JBoss AS 4.0.3SP1.

              The errors you are seeing "table not found ..." are correct. It will create the tables for you.

              • 4. Re: Problems creating jbossportal database content.
                svaret Newbie

                I forgot to sat that I put connector 3.0.16 into the server\default\deploy directory. I have a database called jbossportal in the db. There are no tables there. I restart the AS as u said.

                I then get

                11:07:13,288 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
                11:07:13,288 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid integer not null auto_incremen
                t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid))
                11:07:13,288 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_roles (jbp_r
                id integer not null auto_increment]
                11:07:13,288 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref (jbp_id integer not null auto_incre
                ment, jbp_name varchar(255) not null, jbp_type integer, jbp_set_id integer, primary key (jbp_id))
                11:07:13,288 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref (j
                bp_id integer not null auto_increment]
                11:07:13,288 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref_set (jbp_id integer not null auto_i
                ncrement, jbp_parent_id integer, name varchar(255) not null, primary key (jbp_id))
                11:07:13,298 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref_se
                t (jbp_id integer not null auto_increment]
                11:07:13,298 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid integer not null auto_incremen
                t, jbp_root_pref_set_id integer, jbp_uname varchar(255) unique, jbp_givenname varchar(255), jbp_familyname var
                char(255), jbp_password varchar(255), jbp_realemail varchar(255), jbp_fakeemail varchar(255), jbp_regdate date
                time, jbp_viewrealemail bit, jbp_enabled bit, primary key (jbp_uid))
                11:07:13,298 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_users (jbp_u
                id integer not null auto_increment]


                But if I paste one of the create table statements at the mysql prompt create table jbp_roles (jbp_rid integer not null auto_increment, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid)) then the table is created successfully.

                What am I doing wrong?

                Best regards

                /Lasse

                • 5. Re: Problems creating jbossportal database content.
                  svaret Newbie

                  After this I dropped the user ... created the user once again..

                  After that I started AS and no tables were created.

                  After that I try to destroy and create schema as well as creating database content according to the User Guide. When I click the createSchema button at the page displayed by going to the link http://localhost:8080/jmx-console/HtmlAdaptor?action=inspectMBean&name=portal%3Aservice%3DHibernate and the I get:

                  13:14:44,139 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
                  13:14:44,139 INFO [Configuration] processing extends queue
                  13:14:44,139 INFO [Configuration] processing collection mappings
                  13:14:44,139 INFO [Configuration] processing association property references
                  13:14:44,139 INFO [Configuration] processing foreign key constraints
                  13:14:44,149 INFO [Configuration] processing extends queue
                  13:14:44,149 INFO [Configuration] processing collection mappings
                  13:14:44,149 INFO [Configuration] processing association property references
                  13:14:44,149 INFO [Configuration] processing foreign key constraints
                  13:14:44,149 INFO [SchemaExport] Running hbm2ddl schema export
                  13:14:44,149 INFO [SchemaExport] exporting generated schema to database
                  13:14:44,159 INFO [NamingHelper] JNDI InitialContext properties:{}
                  13:14:44,159 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
                  13:14:44,169 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid integer not null auto_incremen
                  t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid))
                  13:14:44,169 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_roles (jbp_r
                  id integer not null auto_increment]


                  This seem quite straightforward. Is there really nobody here that has experienced this?

                  Best regards

                  Lasse