I have the next hibernate.cfg.xml file:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory name="java:comp/env/tsawiDS">
<property name="connection.datasource">jdbc/tsawiDS</property>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<!-- Mapping files -->
<mapping resource="com/tsawi/pm/pojo/Archivo.hbm.xml"/>
<mapping resource="com/tsawi/pm/pojo/Bitacora.hbm.xml"/>
.......
<mapping resource="com/tsawi/pm/pojo/TipoProyecto.hbm.xml"/>
<mapping resource="com/tsawi/pm/pojo/Usuario.hbm.xml"/>
<mapping resource="com/tsawi/pm/pojo/Proyecto.hbm.xml"/>
</session-factory>
</hibernate-configuration>
and this is an example of a hbm file:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.tsawi.pm.pojo.Archivo" table="ARCHIVO">
<id name="idArchivo" column="IDARCHIVO" type="integer" unsaved-value="null" >
<generator class="sequence">
<param name="sequence">ARCHIVO_ID_SEQ</param>
</generator>
</id>
<many-to-one name="mensaje" class="com.tsawi.pm.pojo.Mensaje" column="IDMENSAJE"/>
<property name="descripcion" column="DESCRIPCION" type="string"/>
<property name="archivo" column="ARCHIVO" type="string"/>
</class>
</hibernate-mapping>
this is the mesage a get from the container (9ias) went I try to do a query or anything againts the database which is a 9i (9.2.0.1):
Code:
INFO Environment:403 - Hibernate 2.0.2
10:35:33,006 INFO Environment:432 - hibernate.properties not found
10:35:33,016 INFO Environment:452 - using CGLIB reflection optimizer
10:35:33,016 INFO Environment:462 - JVM proxy support: true
10:35:33,227 INFO Configuration:703 - Configuration resource: /hibernate.cfg.xml
10:35:33,918 INFO Binder:178 - Mapping class: com.tsawi.pm.pojo.Bitacora -> BITACORA
10:35:34,068 INFO Configuration:270 - Mapping resource: com/tsawi/pm/pojo/Categoria.hbm.xml
10:35:34,098 INFO Binder:178 - Mapping class: com.tsawi.pm.pojo.Categoria -> CATEGORIA
10:35:34,098 INFO Binder:456 - Mapping collection: com.tsawi.pm.pojo.Categoria.proyectos -> PROYECTOCATEGORIA
.........
10:35:34,458 INFO Binder:178 - Mapping class: com.tsawi.pm.pojo.PalabraClave -> PALABRACLAVE
10:35:34,468 INFO Configuration:270 - Mapping resource: com/tsawi/pm/pojo/RRHH.hbm.xml
10:35:34,488 INFO Binder:178 - Mapping class: com.tsawi.pm.pojo.RRHH -> RRHH
10:35:34,488 INFO Binder:456 - Mapping collection: com.tsawi.pm.pojo.RRHH.proyectos -> PROYECTORRHH
10:35:34,499 INFO Configuration:270 - Mapping resource: com/tsawi/pm/pojo/TipoProyecto.hbm.xml
10:35:34,529 INFO Binder:178 - Mapping class: com.tsawi.pm.pojo.TipoProyecto -> TIPOPROYECTO
10:35:34,539 INFO Configuration:270 - Mapping resource: com/tsawi/pm/pojo/Usuario.hbm.xml
10:35:34,559 INFO Binder:178 - Mapping class: com.tsawi.pm.pojo.Usuario -> USUARIO
10:35:34,559 INFO Binder:456 - Mapping collection: com.tsawi.pm.pojo.Usuario.proyectos -> USUARIOPROYECTO
10:35:34,619 INFO Binder:456 - Mapping collection: com.tsawi.pm.pojo.Proyecto.categorias -> PROYECTOCATEGORIA
10:35:34,689 INFO Configuration:885 - Configured SessionFactory: java:comp/env/tsawiDS
10:35:34,689 INFO Configuration:492 - processing one-to-many association mappings
10:35:34,689 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Bitacora.mensajes -> MENSAJE
10:35:34,689 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.CategoriaBitacora.bitacoras -> BITACORA
10:35:34,689 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Empresa.RRHH -> RRHH
10:35:34,699 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Mensaje.mensajesHijos -> MENSAJE
10:35:34,699 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Mensaje.archivos -> ARCHIVO
10:35:34,699 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.TipoProyecto.proyectos -> PROYECTO
10:35:34,699 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Usuario.mensajes -> MENSAJE
10:35:34,699 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Proyecto.bitacoras -> BITACORA
10:35:34,699 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Proyecto.palabrasClaves -> PALABRACLAVE
10:35:34,709 INFO Binder:1024 - Mapping collection: com.tsawi.pm.pojo.Proyecto.fotos -> FOTO
10:35:34,709 INFO Configuration:503 - processing foreign key constraints
10:35:35,149 INFO SessionFactoryImpl:132 - building session factory
[b]10:35:35,160 INFO Dialect:37 - Using dialect: net.sf.hibernate.dialect.Oracle9Dialect[/b]
10:35:35,180 INFO NamingHelper:26 - JNDI InitialContext properties:{}
10:35:35,220 INFO DatasourceConnectionProvider:52 - Using datasource: jdbc/tsawiDS
10:35:35,230 INFO SessionFactoryImpl:162 - Use outer join fetching: true
10:35:35,690 INFO SessionFactoryImpl:185 - Use scrollable result sets: true
10:35:35,690 INFO SessionFactoryImpl:186 - JDBC 2 max batch size: 15
[b]10:35:35,921 ERROR ListarProyectosXTipoAction:62 - java.lang.NullPointerException
03/12/19 10:35:35 net.sf.hibernate.MappingException: Dialect does not support native key generation[/b]
I don't have why I getting this error, I have try the sequece generator plan and the native one, but those two does not work. I had read a lot of this in this forum and always is the same answer, and I applied the answer and still geting that error... Does anybody have a idea??????
Login
FAQ
Search