1:54 a.m.
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...