0 Replies Latest reply on Feb 7, 2006 10:55 AM by Qaiser Mehmood

    schema export unsuccessful You cannot commit during a manage

    Qaiser Mehmood Newbie

      Hi ,

      I am getting this error when I am starting my jboss application server:

      10:26:15,093 ERROR [SchemaExport] schema export unsuccessful

      java.sql.SQLException: You cannot commit during a managed transaction!

      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcComm

      it(BaseWrapperManagedConnection.java:432)

      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConne

      ction.java:331)

      at org.hibernate.tool.hbm2ddl.SchemaExport$ProviderConnectionHelper.getC

      onnection(SchemaExport.java:470)

      at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:183

      )

      at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:135)



      at org.jboss.portal.core.hibernate.SessionFactoryBinder.createSchema(Ses

      sionFactoryBinder.java:377)

      at org.jboss.portal.core.hibernate.SessionFactoryBinder.startService(Ses

      sionFactoryBinder.java:280)

      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS

      upport.java:274)

      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1

      81)

      at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBo

      ssService.java:73)



      My datasource file is :



      <?xml version="1.0" encoding="UTF-8"?>



      <local-tx-datasource>

      <jndi-name>PortalDS</jndi-name>

      <connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection-url>

      <driver-class>org.gjt.mm.mysql.Driver</driver-class>

      <user-name>portal</user-name>

      portalpassword

      </local-tx-datasource>







      My hibernate configuration file is :



      <?xml version='1.0' encoding='utf-8'?>

      <!DOCTYPE hibernate-configuration PUBLIC

      "-//Hibernate/Hibernate Configuration DTD//EN"

      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

      <hibernate-configuration>

      <session-factory>

      java:PortalDS

      false

      org.hibernate.cache.EhCacheProvider

      true



      <!-- Force the dialect instead of using autodetection -->

      <!--

      org.hibernate.dialect.PostgreSQLDialect

      -->

      org.hibernate.dialect.MySQLDialect

      <!-- Mapping files -->



      </session-factory>

      </hibernate-configuration>

      I am using jboss application server version 4.0.3 and jboss-portal-2.2.0 and mysql version 4.1. Help me in this regard.

      Qaiser