-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
jpdehon
 Post subject: Socket read freeze
PostPosted: Thu Mar 17, 2005 2:19 pm 
Newbie

Joined: Thu Mar 17, 2005 2:07 pm
Posts: 1
Hello friends..

I have a problem while try execute a simple SELECT with Hibernate. The socket read freeze without cause.

Stack in moment of freeze:

Code:
SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int) line: not available [native method]
   SocketInputStream.read(byte[], int, int) line: 129
   DataPacket(Packet).receive() line: not available
   DataPacket.receive() line: not available
   NetInputStream.getNextPacket() line: not available
   NetInputStream.read(byte[], int, int) line: not available
   NetInputStream.read(byte[]) line: not available
   NetInputStream.read() line: not available
   MAREngine.unmarshalUB1() line: 931
   MAREngine.unmarshalSB1() line: 893
   Oall7.receive() line: 375
   TTC7Protocol.doOall7(byte, byte, int, byte[], DBType[], DBData[], int, DBType[], DBData[], int) line: 1983
   TTC7Protocol.fetch(DBStatement, DBDataSet, int) line: 1250
   OraclePreparedStatement(OracleStatement).doExecuteQuery() line: 2529
   OraclePreparedStatement(OracleStatement).doExecuteWithTimeout() line: 2857
   OraclePreparedStatement.executeUpdate() line: 608
   OraclePreparedStatement.executeQuery() line: 536
   BatchingBatcher(BatcherImpl).getResultSet(PreparedStatement) line: 87
   CriteriaLoader(Loader).getResultSet(PreparedStatement, RowSelection, SessionImplementor) line: 875
   CriteriaLoader(Loader).doQuery(SessionImplementor, QueryParameters, Object, Serializable, Serializable[], boolean) line: 269
   CriteriaLoader(Loader).doQueryAndInitializeNonLazyCollections(SessionImplementor, QueryParameters, Object, Serializable, Serializable[], boolean) line: 133
   CriteriaLoader(Loader).doList(SessionImplementor, QueryParameters) line: 1033
   CriteriaLoader(Loader).list(SessionImplementor, QueryParameters, Set, Type[]) line: 1024
   CriteriaLoader.list(SessionImplementor) line: 118
   SessionImpl.find(CriteriaImpl) line: 3613
   CriteriaImpl.list() line: 238
   HibernateTemplate$5.doInHibernate(Session) line: 216
   HibernateTemplate.execute(HibernateCallback) line: 150
   HibernateTemplate.executeFind(HibernateCallback) line: 170
   HibernateTemplate.loadAll(Class) line: 213
   SGCDaoHibernate.loadAll(Class) line: 50


Hibernate version: 2

Mapping documents: Malha.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping package="br.com.jmacedo.sgc.model">
<class name="Malha" table="T_MDT">
<cache usage="read-write"/>
<id name="id" column="IS_MDT" type="java.lang.Long">
<generator class="native">
</generator>
</id>

<many-to-one class="EmpresaDoGrupo" name="planta" not-null="true">
<column name="IS_EJA_PLA" />
</many-to-one>

<many-to-one class="EmpresaDoGrupo" name="ufat" not-null="true">
<column name="IS_EJA_UNF" />
</many-to-one>

<many-to-one class="Produto" name="produto" not-null="true">
<column name="IS_SKU" />
</many-to-one>

<property column="QT_MDT_KGR" length="30" name="quantidade" not-null="false" type="java.lang.Float"/>

</class>
</hibernate-mapping>

Name and version of the database: Oracle 9

The generated SQL (show_sql=true): Hibernate: select this.IS_MDT as IS_MDT5_, this.IS_EJA_PLA as IS_EJA_PLA5_, this.IS_EJA_UNF as IS_EJA_UNF5_, this.IS_SKU as IS_SKU5_, this.QT_MDT_KGR as QT_MDT_KGR5_, empresadog1_.IS_EJA as IS_EJA0_, empresadog1_.NM_EJA_FAN as NM_EJA_FAN0_, empresadog1_.TP_EJA_PLA as TP_EJA_PLA0_, empresadog1_.TP_EJA_UNF as TP_EJA_UNF0_, empresadog1_.TP_EJA_USO as TP_EJA_USO0_, empresadog2_.IS_EJA as IS_EJA1_, empresadog2_.NM_EJA_FAN as NM_EJA_FAN1_, empresadog2_.TP_EJA_PLA as TP_EJA_PLA1_, empresadog2_.TP_EJA_UNF as TP_EJA_UNF1_, empresadog2_.TP_EJA_USO as TP_EJA_USO1_, produto3_.IS_SKU as IS_SKU2_, produto3_.NM_SKU as NM_SKU2_, produto3_.TP_SKU_USO as TP_SKU_USO2_, produto3_.IS_CPR as IS_CPR2_, categoria4_.IS_CPR as IS_CPR3_, categoria4_.NM_CPR as NM_CPR3_, categoria4_.TP_CPR_USO as TP_CPR_USO3_, categoria4_.TP_CPR_FAR as TP_CPR_FAR3_, categoria4_.TX_CPR_MAX_PRS as TX_CPR_M5_3_, categoria4_.TP_CPR_EXC_CTR as TP_CPR_E6_3_, categoria4_.IS_LIN as IS_LIN3_, lin5_.IS_LIN as IS_LIN4_, lin5_.NM_LIN as NM_LIN4_, lin5_.TP_LIN_USO as TP_LIN_USO4_, lin5_.TP_LIN_MTM as TP_LIN_MTM4_, lin5_.NR_LIN_ORD as NR_LIN_ORD4_ from T_MDT this, T_EJA empresadog1_, T_EJA empresadog2_, T_SKU produto3_, T_CPR categoria4_, T_LIN lin5_ where 1=1 and this.IS_EJA_PLA=empresadog1_.IS_EJA(+) and this.IS_EJA_UNF=empresadog2_.IS_EJA(+) and this.IS_SKU=produto3_.IS_SKU(+) and produto3_.IS_CPR=categoria4_.IS_CPR(+) and categoria4_.IS_LIN=lin5_.IS_LIN(+)
Top
 Profile  
 
max
 Post subject:
PostPosted: Thu Mar 17, 2005 5:12 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
try to use another driver.

_________________
Max
Don't forget to rate

Top
 Profile  
 
BlueAngel
 Post subject:
PostPosted: Wed Aug 01, 2007 7:00 am 
Newbie

Joined: Wed Aug 01, 2007 6:49 am
Posts: 1
'Mbare, I experience the same problem. I use Hibernate 3.1.3 server is JBoss 4.0.2 and the DataBase server is Oracle 10g2 10.2.1.0... as jpdehon I have a simple select:

Code:
select t15
from it.ss.dbCupMapping.model.CcT15AngNazioni as t15
where t15.t15Datafinevalidita is null
order by t15.t15Descrizione asc


using Exadel Studio in Eclipse 3.1 it doesn't produce any error as well as using Hibernate Tools plugin 3.2.0.beta9a but when using this query in our application (I work for a small company), as I wrote, I experience the Socket.read freeze. I didn't have any stack trace before, I know it freeze for the same reason becouse debugging in Eclipse freeze inside the socketRead() method of SocketInputStream.

Excuse me Max but your answer is a bit... useless. Forgive my words but have you nothing else more? Any information?
I've tried to change driver but my only option was to upgrade my old Oracle driver from Oracle itself, I'm not able to find any other driver.
Another option is to write a driver myself... but it's not the most suitable option.
Can someone help me? Thank you in advance.
Top
 Profile  
 
ualex
 Post subject:
PostPosted: Wed Aug 01, 2007 4:14 pm 
Newbie

Joined: Tue Dec 05, 2006 7:40 am
Posts: 14
Quote:
SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int) line: not available


I already similar error and was jdbc driver error... I don't have but details you could find more help in oracle forum...

I don't think that it is hibernate issue, anyway I don't sure about it
Top
 Profile  
 
max
 Post subject:
PostPosted: Thu Aug 02, 2007 4:05 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
exactly - it's not a hibernate specific issue hence my reply.

_________________
Max
Don't forget to rate

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.