[Persistence, JBoss/CMP, Hibernate, Database] - Problems configuring Hibernate on JBoss
by 2lopez
Hi there!
I'm configuring a struts project to access a mysql db through hibernate. It's my first time configuring hibernate in a project, so I have some problems.
The most important, and the only I can't solve is this:
- I have written my hibernate.cfg.xml with the config stuff.
- I have written some table mappings (and their beans) and introduced them into hibernate.cfg.xml.
- I have written a plugin to hook hibernate into struts, and declared it into struts-config.xml.
I package the whole project (struts + hibernate) and deploy it to my JBoss 4.2.2 server. Then, I get the following output:
anonymous wrote : 11:39:03,021 INFO [TomcatDeployer] deploy, ctxPath=/XXXXXXX, warUrl=.../tmp/deploy/tmp23130XXXXXXX-exp.war/
| 11:39:03,391 INFO [ActionServlet] Loading chain catalog from jndi:/localhost/XXXXXXX/WEB-INF/chain-config.xml
| 11:39:03,924 INFO [TilesPlugin] Tiles definition factory loaded for module ''.
| 11:39:04,003 INFO [Environment] Hibernate 3.2.6
| 11:39:04,010 INFO [Environment] hibernate.properties not found
| 11:39:04,015 INFO [Environment] Bytecode provider name : javassist
| 11:39:04,024 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
| 11:39:04,141 INFO [Configuration] configuring from url: file:/opt/jboss-4.2.2.GA/server/default/tmp/deploy/tmp23130XXXXXXX-exp.war/WEB-INF/hibernate.cfg.xml
| 11:39:04,151 INFO [Configuration] Reading mappings from resource : /com/mmm/XXXXXXX/hibernate/mappings/Paises.hbm.xml
| 11:39:05,535 INFO [HbmBinder] Mapping class: com.mmm.XXXXXXX.hibernate.beans.Paises -> paises
| 11:39:05,570 INFO [Configuration] Reading mappings from resource : /com/mmm/XXXXXXX/hibernate/mappings/Subcategorias.hbm.xml
| 11:39:06,870 INFO [HbmBinder] Mapping class: com.mmm.XXXXXXX.hibernate.beans.Subcategorias -> subcategorias
| 11:39:06,874 INFO [Configuration] Reading mappings from resource : /com/mmm/XXXXXXX/hibernate/mappings/SubcategoriasUser.hbm.xml
| 11:39:08,213 INFO [HbmBinder] Mapping class: com.mmm.XXXXXXX.hibernate.beans.SubcategoriasUser -> subcategorias_user
| 11:39:08,214 INFO [Configuration] Configured SessionFactory: null
| 11:39:08,383 INFO [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
| 11:39:08,383 INFO [DriverManagerConnectionProvider] Hibernate connection pool size: 20
| 11:39:08,383 INFO [DriverManagerConnectionProvider] autocommit mode: false
| 11:39:08,384 INFO [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/XXXXXXX
| 11:39:08,384 INFO [DriverManagerConnectionProvider] connection properties: {user=administrador, password=ubuntur00t}
| 11:39:08,397 INFO [SettingsFactory] RDBMS: MySQL, version: 5.0.51a-3ubuntu5.1
| 11:39:08,397 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.5 ( Revision: ${svn.Revision} )
| 11:39:08,421 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
| 11:39:08,428 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
| 11:39:08,431 INFO [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
| [...]
| [...SettingsFactory info...]
| [...]
| 11:39:08,506 INFO [SessionFactoryImpl] building session factory
| 11:39:09,058 INFO [DriverManagerConnectionProvider] cleaning up connection pool: jdbc:mysql://localhost:3306/XXXXXXX
| 11:39:09,251 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
As you can read on the last line, the factory isn't bound to any JNDI uri. Could anyone help me? Bellow are my config files.
hibernate.hbm.xml:
<?xml version='1.0' encoding='UTF-8'?>
| <!DOCTYPE hibernate-configuration PUBLIC
| "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
| "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
| <hibernate-configuration>
| <session-factory>
|
| <property name="connection.url">jdbc:mysql://localhost:3306/XXXXXXX</property>
| <property name="connection.username">XXX</property>
| <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
| <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
| <property name="connection.password">XXXX</property>
| <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
| <!-- thread is the short name for
| org.hibernate.context.ThreadLocalSessionContext
| and let Hibernate bind the session automatically to the thread
| -->
| <property name="current_session_context_class">thread</property>
| <!-- this will show us all sql statements -->
| <property name="hibernate.show_sql">true</property>
|
| <!-- mapping files -->
| <mapping resource="/com/mmm/XXXXXXX/hibernate/mappings/Paises.hbm.xml"/>
| <mapping resource="/com/mmm/XXXXXXX/hibernate/mappings/Subcategorias.hbm.xml"/>
| <mapping resource="/com/mmm/XXXXXXX/hibernate/mappings/SubcategoriasUser.hbm.xml"/>
|
| </session-factory>
| </hibernate-configuration>
struts-config.xml:
<struts-config>
| <!-- ... -->
| <plug-in className="com.mmm.XXXXXXX.hibernate.plugin.HibernatePlugin">
| <set-property property="path" value="/WEB-INF/hibernate.cfg.xml"/>
| </plug-in>
| </struts-config>
By the way, I can't understand hibernate-service.xml. I have read that I need to introduce the server datasource I want hibernate to use, but in hibernate.cfg.xml I have written the uri of mysql. Isn't it redundant? It's necessary to introduce the datasource in hibernate-service.xml??? Bellow its code:
<server>
| <mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=Hibernate">
| <attribute name="DatasourceName">java:/DefaultDS</attribute>
| <attribute name="Dialect">org.hibernate.dialect.MySQLDialect</attribute>
| <attribute name="SessionFactoryName">java:/hibernate/XXXXXXX</attribute>
| <attribute name="CacheProviderClass">
| net.sf.hibernate.cache.HashtableCacheProvider
| </attribute>
|
| <attribute name="Hbm2ddlAuto">create-drop</attribute>
| <attribute name="ShowSqlEnabled">true</attribute>
| </mbean>
| </server>
The last question: do I need to separately package the hibernate application to access it from my struts webapp? I'm using ant to package and deploy my war, is there any ant task to package a har? I've searched on google and didn't found anything.
Thank you very much in advance.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4162238#4162238
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4162238
17 years, 9 months