jpql - java.sql.SQLException: Fail to convert to internal representation -

-

i'm trying execute following query: 

string query = "select entity, entity.id site entity"; list resultlist = entitymanager.createquery(query).getresultlist();

and take exception:

[...] caused by: java.sql.sqlexception: fail convert internal representation     @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:112)     @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:146)     @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:208)     @ oracle.jdbc.driver.charcommonaccessor.getlong(charcommonaccessor.java:239)     @ oracle.jdbc.driver.oracleresultsetimpl.getlong(oracleresultsetimpl.java:552)     @ oracle.jdbc.driver.oracleresultset.getlong(oracleresultset.java:1575)     @ org.jboss.resource.adapter.jdbc.wrappedresultset.getlong(wrappedresultset.java:724)     @ org.hibernate.type.longtype.get(longtype.java:28)     @ org.hibernate.type.nullabletype.nullsafeget(nullabletype.java:163)     @ org.hibernate.type.nullabletype.nullsafeget(nullabletype.java:154)     @ org.hibernate.type.manytoonetype.hydrate(manytoonetype.java:103)     @ org.hibernate.type.entitytype.nullsafeget(entitytype.java:204)     @ org.hibernate.loader.hql.queryloader.getresultcolumnorrow(queryloader.java:338)     @ org.hibernate.loader.loader.getrowfromresultset(loader.java:606)     @ org.hibernate.loader.loader.doquery(loader.java:701)     @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:236)     @ org.hibernate.loader.loader.dolist(loader.java:2220)     ... 102 more

what doing wrong? thank in advance.

your data types mismatched when retrieving field values. check code , ensure each field retrieving java object matches type. example, retrieving date , int. if doing select * possible change in fields of table has happened causing error occur. sql should select fields want in order avoid error.

hope helps.


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more