I am using Oracle 12c db and ojdbc7.jar to connect to it. Below is the java code
18:08:00,278 ERROR [[action]] Servlet.service() para servlet action lanz� excepci�n
java.lang.IllegalArgumentException: Removing a detached instance es.encore.nollego.comun.to.SubcategoriaPrivadaTO#es.encore.nollego.comun.to.SubcategoriaPrivadaPK@b0d5f5
at org.hibernate.ejb.event.EJB3DeleteEventListener.performDetachedEntityDeletionCheck(EJB3DeleteEventListener.java:47)
at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:86)
at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:52)
at org.hibernate.impl.SessionImpl.fireDelete(SessionImpl.java:766)
at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:744)
at org.hibernate.ejb.AbstractEntityManagerImpl.remove(AbstractEntityManagerImpl.java:245)
at es.encore.nollego.comun.dao.subcategoriaPrivada.SubcategoriaPrivadaDAO_HBM.remove(SubcategoriaPrivadaDAO_HBM.java:67)
at es.encore.nollego.comun.bo.subcategoriaPrivada.SubcategoriaPrivadaBO.remove(SubcategoriaPrivadaBO.java:42)
...
org.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [
bdd.subcategoria.compras.alimentacion,
es.encore.nollego.comun.to.UsuarioTO[...]
]
[delete from SubcategoriaTO sc where sc.subcategoria=? and sc.usuarios=?]
10:50:44,321 INFO [STDOUT] 2008/09/12 10:50:44 ERROR hibernate.hql.PARSER[http-127.0.0.1-8080-1]: line 1:58: unexpected token: join
java.lang.IllegalArgumentException: node to traverse cannot be null!
at org.hibernate.hql.ast.util.NodeTraverser.traverseDepthFirst(NodeTraverser.java:31)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:254)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:92)
at es.encore.nollego.comun.dao.subcategoria.SubcategoriaDAO_HBM.deleteByNick(SubcategoriaDAO_HBM.java:206)
... 34 more
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/encore/XXXXXXX/hibernate/mappings/Paises.hbm.xml
11:39:05,535 INFO [HbmBinder] Mapping class: com.encore.XXXXXXX.hibernate.beans.Paises -> paises
11:39:05,570 INFO [Configuration] Reading mappings from resource : /com/encore/XXXXXXX/hibernate/mappings/Subcategorias.hbm.xml
11:39:06,870 INFO [HbmBinder] Mapping class: com.encore.XXXXXXX.hibernate.beans.Subcategorias -> subcategorias
11:39:06,874 INFO [Configuration] Reading mappings from resource : /com/encore/XXXXXXX/hibernate/mappings/SubcategoriasUser.hbm.xml
11:39:08,213 INFO [HbmBinder] Mapping class: com.encore.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
<?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/NoLlego</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/encore/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>
<!-- ... -->
<plug-in className="com.mmm.XXXXXXX.hibernate.plugin.HibernatePlugin">
<set-property property="path" value="/WEB-INF/hibernate.cfg.xml"/>
</plug-in>
</struts-config>
<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>
:THIS IS THE HEADER
THIS IS THE MENUBAR
The requested resource (/NoLlego/web/jsp/struts/estimaciones/estimaciones) is not available
THIS IS THE COPYRIGHT