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