| Author | Message | ||
     Saint Megastar Username: Saint Post Number: 21379 Registered: 01-2011 Posted From: 68.13.100.193 Rating: N/A |
replace that big decimal with oracle ref cursor. if it is char/int/single value..its easy n staight forward I got some error...oracleresultsetimpl cannot type cast to lis/hash/class/ etc errors... | ||
| Dreamcatcher Side Hero Username: Dreamcatcher Post Number: 4555 Registered: 11-2009 Posted From: 96.231.199.120 Rating: N/A |
What do you mean how do you do that? That is how you do it, when you do an aggregate function in select, it returns a BigDecimal back to you in the result set. What error are you getting? Post the error and stack trace if you can. | ||
| Saint Megastar Username: Saint Post Number: 21355 Registered: 01-2011 Posted From: 68.13.100.193 Rating: N/A |
freeeeeeee freeeeeee | ||
| Saint Megastar Username: Saint Post Number: 21354 Registered: 01-2011 Posted From: 68.13.100.193 Rating: N/A |
Go to the end. You have String sup_name ="Tortuga Trading"; BigDecimal sum = (BigDecimal)em.createNativeQuery("SELECT sum_total(?1) FROM DUAL") .setParameter(1, sup_name) .getSingleResult(); out.println("The total cost of the ordered products supplied by Tortuga Trading: " + sum +"<br/>"); Assume that this stored function (not procedure) returns a cursor which has all columns from orderlineitems table how do you do that? I tried with getResult, getSingleResult but have issues with reading the data. | ||
| Dreamcatcher Side Hero Username: Dreamcatcher Post Number: 4554 Registered: 11-2009 Posted From: 96.231.199.120 Rating: N/A |
Post few lines of your code...I want to see wha method you are calling on Query. | ||
| Dreamcatcher Side Hero Username: Dreamcatcher Post Number: 4553 Registered: 11-2009 Posted From: 96.231.199.120 Rating: N/A |
Does tis help? http://www.oracle.com/technetwork/articles/vasiliev-jpql-087 123.html | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 8505 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
its actually standard or implementation....daniki evadiki tochinattu vadu frameworks raaskunnar...openjpa etc ROM lo undi DB ni prawxy lo chuse mahanubavulu kosam ee signature | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 8504 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
adhi framework kada annai...!! billing emi seperate ga undadhu java job lo jpa ni oka req ga adugutaru ROM lo undi DB ni prawxy lo chuse mahanubavulu kosam ee signature | ||
| Rudraksha Comedian Username: Rudraksha Post Number: 1417 Registered: 07-2012 Posted From: 70.181.57.58 Rating: N/A |
JPA emi tool? billing enta untadi?  | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 8502 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
annai nee file ampinchu if it is ok with u....if u want change package names etc. ROM lo undi DB ni prawxy lo chuse mahanubavulu kosam ee signature | ||
| Saint Megastar Username: Saint Post Number: 21352 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
adi kooda ayyidni..it wont work. | ||
| Saint Megastar Username: Saint Post Number: 21351 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
This doesnt return a cursor. | ||
| Saint Megastar Username: Saint Post Number: 21350 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
I am not sure...if it works...since it is JPA way of doing..little complicated | ||
| Saint Megastar Username: Saint Post Number: 21349 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
Need not be mama..nativequery tho resultsets kooda ravochu...we were expecting single set in SP call...it didnt work.. | ||
| Abhysg Hero Username: Abhysg Post Number: 11089 Registered: 08-2008 Posted From: 68.46.32.32 Rating: N/A |
friday 4pm ki ee kochen adugutava... enti ee durmargam.. no siggy | ||
| Megastar Username: Twitter Post Number: 29660 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
asalu edoka type lo kaakunda genl object lo petti choodu | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 8501 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
instead of query try typedquery TypedQuery<abc> query = em.createQuery("SELECT c FROM xxx c", xxx.class); List<abc> results = query.getResultList(); ROM lo undi DB ni prawxy lo chuse mahanubavulu kosam ee signature | ||
| Biriyani Side Hero Username: Biriyani Post Number: 9609 Registered: 03-2012 Posted From: 171.161.160.10 Rating: N/A |
before typecasting...find out the type of object by using getclass method... | ||
| Saint Megastar Username: Saint Post Number: 21342 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
stored procedure return chesedi cursor (group of columns) ...resltset try chesina work out avvaledu... we were gettng the same typecast error.. | ||
| Triggerblaster Side Hero Username: Triggerblaster Post Number: 2853 Registered: 03-2008 Posted From: 140.98.210.243 Rating: N/A |
I mean Just the resultset not list of resultsets | ||
| Triggerblaster Side Hero Username: Triggerblaster Post Number: 2852 Registered: 03-2008 Posted From: 140.98.210.243 Rating: N/A |
Native query use cheste resultset vastadi not list | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 8498 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
List<resultset>kada pettalsindhi...a result set lo objects untayi ga...then iterate thru them? ROM lo undi DB ni prawxy lo chuse mahanubavulu kosam ee signature | ||
| Saint Megastar Username: Saint Post Number: 21341 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
Oracle Stored fucntion emnativequery use chesi call chesthunna..it returns a cursor... I could execute it successfully but while reading the List it complains oracleresultsetimpl cannot type cast to java.lang.string or hash or list... sare ani aa SP return chesthe DB object class loki read chesthunna avvatam ledu..it throws an exception... ela fix cheyyali ee issue? EntityManager em = this.em; List<state> states= null; try { Query query = em.createNativeQuery |
