-->
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
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
CRUCY
 Post subject: Does Oracle Lite require a specific dialect?
PostPosted: Wed Sep 27, 2006 6:20 am 
Newbie

Joined: Wed Sep 27, 2006 5:33 am
Posts: 2
Hi,

I currently write a Java application with Hibernate to run on Oracle Lite 10
Hibernate version: 3.1

My code works fine on an Oracle 9 or 10 with thin and Oracle9Dialect.
With Oracle lite, every time I perform a read, the following exception is thrown. I get the information I need and the program goes on. Since the Oracle Lite driver is not the same, I suspect the problem to be a dialect problem. If this a driver problem, wil there be a new dialect added soon?

As you can tell both driver are not the same nor the same jar.
Quote:
<entry key="DBDriver" value= "oracle.jdbc.driver.OracleDriver"/>
<entry key="DBDriver" value= "oracle.lite.poljdbc.POLJDBCDriver"/>



Log:
Code:
Hibernate: select lot0_.LOT_NUM as LOT1_, lot0_.LOT_TTVA as LOT2_, lot0_.LOT_OPE_PHAS as LOT3_, lot0_.LOT_SLOT as LOT4_, lot0_.LOT_OPE_CODE as LOT5_, lot0_.LOT_MAND as LOT6_11_, lot0_.LOT_TITU as LOT7_11_, lot0_.LOT_LIBE as LOT8_11_, lot0_.LOT_MHT as LOT9_11_, lot0_.LOT_MTTC as LOT10_11_, lot0_.LOT_MAR_NUM as LOT11_11_, lot0_.LOT_DVTE as LOT12_11_, lot0_.LOT_DVTG as LOT13_11_, lot0_.LOT_ST_TOTAL_AVOS as LOT14_11_, lot0_.LOT_ST_MAND as LOT15_11_, lot0_.LOT_MAR_VBMAR as LOT16_11_, lot0_.LOT_NATP as LOT17_11_, lot0_.LOT_STR as LOT18_11_, lot0_.LOT_VALI as LOT19_11_, lot0_.LOT_STAT as LOT20_11_, lot0_.LOT_UMC as LOT21_11_ from LOT lot0_ where lot0_.LOT_OPE_CODE=? and lot0_.LOT_OPE_PHAS=?
exception clearing maxRows/queryTimeout
java.sql.SQLException: [ODBC S1C00] driver not capable of this operation
   at oracle.lite.poljdbc.LiteEmbStatement.jniGetStmtOptionInt(Native Method)
   at oracle.lite.poljdbc.LiteEmbStatement.getOption(Unknown Source)
   at oracle.lite.poljdbc.POLJDBCStatement.getQueryTimeout(Unknown Source)
   at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:205)
   at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:143)
   at org.hibernate.loader.Loader.doQuery(Loader.java:433)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
   at org.hibernate.loader.Loader.doList(Loader.java:1593)
   at org.hibernate.loader.Loader.list(Loader.java:1577)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
   at fr.derbi.vopr.bdd.DBFacade.findAllInCurrentOperation(DBFacade.java:125)
   at fr.derbi.vopr.bdd.DBFacade.findAllInCurrentOperation(DBFacade.java:95)
   at fr.derbi.vopr.bdd.User.setCurrentOperation(User.java:110)
   at fr.derbi.vopr.ui.builder.MainBuilder$1.run(MainBuilder.java:152)
   at java.lang.Thread.run(Unknown Source)
Top
 Profile  
 
kaspatel
 Post subject:
PostPosted: Thu Jan 04, 2007 12:18 pm 
Newbie

Joined: Thu Jan 04, 2007 12:13 pm
Posts: 2
I have exact same problem, have you found a solution to this ?

Thanks.
KPATEL
Top
 Profile  
 
CRUCY
 Post subject:
PostPosted: Thu Jan 04, 2007 12:25 pm 
Newbie

Joined: Wed Sep 27, 2006 5:33 am
Posts: 2
Nope. I haven't solved the problem, and I've changed job, so I have no answers on this one. I'd be interested to know what's wrong though.
Top
 Profile  
 
kaspatel
 Post subject:
PostPosted: Mon Jan 22, 2007 2:53 pm 
Newbie

Joined: Thu Jan 04, 2007 12:13 pm
Posts: 2
FYI - I had to modify hibernate AbstractBatcher.java to get around this
problem. I think oracle.lite.poljdbc.POLJDBCDriver does not have a
everything that oracle.jdbc.driver.OracleDriver has.

-KPATEL
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
  [ 4 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.