-->
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.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: ORA-01465:invalid hex number-while calling sql from hibernat
PostPosted: Wed Mar 02, 2016 3:51 am 
Newbie

Joined: Wed Mar 02, 2016 3:00 am
Posts: 2
ORA-01465:invalid hex number-while calling sql through hibernate:

Could you please provide me help to resolve this issue ASAP..

While executing the below sql query through Hibernate, it is giving
Quote:
ORA-01465:invalid hex number
error.
Please see below for the code and log message for clear idea.

Sql Query is


Code:
SELECT
        distinct        H.EMPL_PPNT_ID_NU AS emplPpntIdNu,
        H.EMPL_USER_ID AS emplUserId,
        H.EMPL_FST_NA AS empFirstName,
        H.EMPL_LAST_NA AS empLastName,
        L.LOC_NU AS locNum,
        L.LOC_DS AS locDesc,
        JC.EMPL_JOB_TITL_DS AS jobTitle       
    FROM
        SRCE_HIERARCHY H,
        GSS_AUTHORIZED_SIGNER GAS,
        V1SRCE_ORALOCATION L,
        OOB_JOBCODE_XREF JC       
    WHERE
        GAS.CLIENT_ID = ?       
        AND GAS.DLLR_LMT >= ?       
        AND DECODE(NVL(GAS.VNDR_SITE_ID,0),0,?,GAS.VNDR_SITE_ID) = ?       
        AND DECODE(NVL(GAS.GBL,'0'),'0',?,GAS.GBL) = ?         
        AND DECODE(NVL(GAS.GLOBALACCOUNT,'0'),'0',NVL(?,'0'),GAS.GLOBALACCOUNT) = NVL(?,'0')       
        AND DECODE(NVL(GAS.ORACLE_PROJECT_NUMBER,'0'),'0',NVL(?,'0'),ORACLE_PROJECT_NUMBER) = NVL(?,'0')       
        AND DECODE(NVL(GAS.SUBACCOUNT,'0'),'0',NVL(?,'0'),GAS.SUBACCOUNT) = NVL(?,'0')       
        AND DECODE(NVL(GAS.LOCALACCOUNT,'0'),'0',NVL(?,'0'),GAS.LOCALACCOUNT) = NVL(?,'0')       
        AND DECODE(NVL(GAS.COMPANY,'0'),'0',NVL(?,'0'),GAS.COMPANY) = NVL(?,'0')           
        AND GAS.EMPL_USER_ID =H.EMPL_USER_ID         
        AND L.LOC_NU = H.EMPL_LOC_NU             
        AND JC.EMPL_JOB_TITL_CD = H.EMPL_JOB_TITL_CD         
        AND JC.CLIENT_ID =H.CLIENT_ID   
    ORDER  BY
        H.EMPL_FST_NA,
        H.EMPL_LAST_NA



Calling Peace of code in Java

public List getAlternateApproversList(AuthorizedSignerQueryParams theParms)
       {
              String gbl = theParms.getGbl();
              Long clientId = theParms.getLClientId();
              Long vndrSiteId = theParms.getVendorSiteId();
              Float invcAmt = theParms.getAmount();
              String global = theParms.getGlobal();
              String sub = theParms.getSub();
              String local = theParms.getLocal();
              String company = theParms.getCompany();
              String projectNumber = theParms.getProjectNumber();                  // MARK SNIDER 8/18/2014 projectNumber is passed in now
             
              System.out.println("ACTION: InvoicingDASImple METHOD:getAlternateApproversList gbl " + gbl + " clientId " + clientId + " vndrSiteId " + vndrSiteId + " invcAmt " + invcAmt + " global " + global + " sub " + sub + " local " + local + " company " + company + " projectNumber " + projectNumber);
              List listOfAppvrs = new ArrayList();                         
              Session session = getSessionFactory().openSession();
              Transaction tx =  session.getTransaction();
              Query q = null;
              tx.begin();
                           
              String SQLString = HibernateConstants.CORP_INVOICE_ALTERNATE_APPROVERS_QUERY;
             
              q = session.createSQLQuery(SQLString)
                     .addScalar("emplPpntIdNu", Hibernate.LONG).addScalar("emplUserId", Hibernate.STRING)
                     .addScalar("empFirstName", Hibernate.STRING).addScalar("empLastName", Hibernate.STRING)
                     .addScalar("locNum", Hibernate.STRING).addScalar("locDesc", Hibernate.STRING) //added by kamala -05/22
                     .addScalar("jobTitle", Hibernate.STRING) //added by kamala -05/22
                     .setResultTransformer(Transformers.aliasToBean(DocumentApprovalProfileTo.class));
                     q.setParameter("clientId", clientId);
                     q.setParameter("invcAmt", invcAmt);
                     q.setParameter("vndrSiteId", vndrSiteId);
                     q.setParameter("gbl", gbl);
                     q.setParameter("global", global);
                     q.setParameter("sub", sub);
                     q.setParameter("local", local);
                     q.setParameter("company", company);
                     q.setParameter("projectNumber", projectNumber);        // MARK SNIDER 8/18/2014 projectNumber is passed in now
                     listOfAppvrs.addAll(q.list());                                       // add the result of the query to our list
                     
                     System.out.println("ACTION: InvoicingDASImple METHOD:getAlternateApproversList listOfAppvrs.size() " + listOfAppvrs.size());
              session.flush();
              tx.commit();         
              return listOfAppvrs;
       }

       public static final String CORP_INVOICE_ALTERNATE_APPROVERS_QUERY =  "SELECT distinct"
              + "        H.EMPL_PPNT_ID_NU AS emplPpntIdNu,"
              + "        H.EMPL_USER_ID AS emplUserId,"
              + "        H.EMPL_FST_NA AS empFirstName,"
              + "        H.EMPL_LAST_NA AS empLastName,"
              + "        L.LOC_NU AS locNum,"
              + "        L.LOC_DS AS locDesc,"
              + "        JC.EMPL_JOB_TITL_DS AS jobTitle   "
              + "    FROM"
              + "        SRCE_HIERARCHY H,"
              + "        GSS_AUTHORIZED_SIGNER GAS,"
              + "        V1SRCE_ORALOCATION L,"
              + "        OOB_JOBCODE_XREF JC   "
              + "    WHERE "
              + "        GAS.CLIENT_ID = :clientId"
              + "        AND GAS.DLLR_LMT >= :invcAmt"
              + "        AND DECODE(NVL(GAS.VNDR_SITE_ID,0),0,:vndrSiteId,GAS.VNDR_SITE_ID) = :vndrSiteId"
              + "        AND DECODE(NVL(GAS.GBL,'0'),'0',:gbl,GAS.GBL) = :gbl "
              // MARK SNIDER 8/18/2014 added Global Account Number and Oracle Project Number
              + "        AND DECODE(NVL(GAS.GLOBALACCOUNT,'0'),'0',NVL(:global,'0'),GAS.GLOBALACCOUNT) = NVL(:global,'0')"
              + "        AND DECODE(NVL(GAS.ORACLE_PROJECT_NUMBER,'0'),'0',NVL(:projectNumber,'0'),ORACLE_PROJECT_NUMBER) = NVL(:projectNumber,'0')"
              + "        AND DECODE(NVL(GAS.SUBACCOUNT,'0'),'0',NVL(:sub,'0'),GAS.SUBACCOUNT) = NVL(:sub,'0')"
              + "        AND DECODE(NVL(GAS.LOCALACCOUNT,'0'),'0',NVL(:local,'0'),GAS.LOCALACCOUNT) = NVL(:local,'0')"
              + "        AND DECODE(NVL(GAS.COMPANY,'0'),'0',NVL(:company,'0'),GAS.COMPANY) = NVL(:company,'0')   "
              + "        AND GAS.EMPL_USER_ID =H.EMPL_USER_ID  "
              + "        AND L.LOC_NU = H.EMPL_LOC_NU      "
              + "        AND JC.EMPL_JOB_TITL_CD = H.EMPL_JOB_TITL_CD "
              + "        AND JC.CLIENT_ID =H.CLIENT_ID"
              + "    ORDER  BY  H.EMPL_FST_NA,   H.EMPL_LAST_NA";



Below are the log messages:

[11/23/15 6:18:22:623 CST] 00001d51 SystemOut O ACTION: InvoicingDASImple METHOD:getAlternateApproversList gbl 195500204000 clientId 82475 vndrSiteId 3461918 invcAmt 104375.0 global null sub null local null company null projectNumber 52093
[11/23/15 6:18:22:623 CST] 00001d51 SystemOut O InvoicingDASImpl method: getSessionFactory
[11/23/15 6:18:22:623 CST] 00001d51 SystemOut O InvoicingDASImpl method: getSessionFactory before lookup
[11/23/15 6:18:22:624 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:625 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:626 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:627 CST] 00001d51 SystemOut O Hibernate:
/* dynamic native SQL query */ SELECT
distinct H.EMPL_PPNT_ID_NU AS emplPpntIdNu,
H.EMPL_USER_ID AS emplUserId,
H.EMPL_FST_NA AS empFirstName,
H.EMPL_LAST_NA AS empLastName,
L.LOC_NU AS locNum,
L.LOC_DS AS locDesc,
JC.EMPL_JOB_TITL_DS AS jobTitle
FROM
SRCE_HIERARCHY H,
GSS_AUTHORIZED_SIGNER GAS,
V1SRCE_ORALOCATION L,
OOB_JOBCODE_XREF JC
WHERE
GAS.CLIENT_ID = ?
AND GAS.DLLR_LMT >= ?
AND DECODE(NVL(GAS.VNDR_SITE_ID,0),0,?,GAS.VNDR_SITE_ID) = ?
AND DECODE(NVL(GAS.GBL,'0'),'0',?,GAS.GBL) = ?
AND DECODE(NVL(GAS.GLOBALACCOUNT,'0'),'0',NVL(?,'0'),GAS.GLOBALACCOUNT) = NVL(?,'0')
AND DECODE(NVL(GAS.ORACLE_PROJECT_NUMBER,'0'),'0',NVL(?,'0'),ORACLE_PROJECT_NUMBER) = NVL(?,'0')
AND DECODE(NVL(GAS.SUBACCOUNT,'0'),'0',NVL(?,'0'),GAS.SUBACCOUNT) = NVL(?,'0')
AND DECODE(NVL(GAS.LOCALACCOUNT,'0'),'0',NVL(?,'0'),GAS.LOCALACCOUNT) = NVL(?,'0')
AND DECODE(NVL(GAS.COMPANY,'0'),'0',NVL(?,'0'),GAS.COMPANY) = NVL(?,'0')
AND GAS.EMPL_USER_ID =H.EMPL_USER_ID
AND L.LOC_NU = H.EMPL_LOC_NU
AND JC.EMPL_JOB_TITL_CD = H.EMPL_JOB_TITL_CD
AND JC.CLIENT_ID =H.CLIENT_ID
ORDER BY
H.EMPL_FST_NA,
H.EMPL_LAST_NA
[11/23/15 6:18:22:629 CST] 00001d51 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 1465, SQLState: 72000
[11/23/15 6:18:22:629 CST] 00001d51 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions ORA-01465: invalid hex number

[11/23/15 6:18:22:630 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:630 CST] 00001d51 RemoteExcepti E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getAlternateApproversList" on bean "BeanId(gDataAccessServiceEar#gInvcDASEJB.jar#GInvoicingDASMgr, null)". Exception data: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
at com.mcd.invoicing.das.mgr.InvoicingDASImpl.getAlternateApproversList(InvoicingDASImpl.java:17295)
at com.mcd.invoicing.das.mgr.GInvoicingDASMgrBean.getAlternateApproversList(GInvoicingDASMgrBean.java:3252)
at com.mcd.invoicing.das.mgr.EJSRemoteStatelessGInvoicingDASMgr_8bcd7987.getAlternateApproversList(EJSRemoteStatelessGInvoicingDASMgr_8bcd7987.java:4794)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:612)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:547)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1165)
at $Proxy47.getAlternateApproversList(Unknown Source)
at com.mcd.invoicing.das.mgr._GInvoicingDASMgr_Stub.getAlternateApproversList(_GInvoicingDASMgr_Stub.java:22001)
at com.mcd.invoicing.client.facade.GInvoicingFacadeBean.getAlternateApproversList(GInvoicingFacadeBean.java:5181)
at com.mcd.invoicing.client.facade.EJSRemoteStatelessGInvoicingFacade_af197413.getAlternateApproversList(EJSRemoteStatelessGInvoicingFacade_af197413.java:4342)
at com.mcd.invoicing.client.facade._GInvoicingFacade_Stub.getAlternateApproversList(_GInvoicingFacade_Stub.java:21215)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.processApproval(SubmitCorpReviewInvoiceAction.java:329)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.execute(SubmitCorpReviewInvoiceAction.java:188)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)
Caused by: java.sql.SQLException: ORA-01465: invalid hex number

at java.lang.Throwable.<init>(Throwable.java:67)
at java.sql.SQLException.<init>(SQLException.java:101)
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:68)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1104)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:725)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
... 57 more

[11/23/15 6:18:22:632 CST] 00001d51 RemoteExcepti E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getAlternateApproversList" on bean "BeanId(gUIEar#gInvoicingUIFacade.jar#GInvoicingFacade, null)". Exception data: javax.ejb.EJBException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
org.hibernate.exception.GenericJDBCException: could not execute query vmcid: 0x0 minor code: 0 completed: No
at com.mcd.invoicing.client.facade.GInvoicingFacadeBean.getAlternateApproversList(GInvoicingFacadeBean.java:5183)
at com.mcd.invoicing.client.facade.EJSRemoteStatelessGInvoicingFacade_af197413.getAlternateApproversList(EJSRemoteStatelessGInvoicingFacade_af197413.java:4342)
at com.mcd.invoicing.client.facade._GInvoicingFacade_Stub.getAlternateApproversList(_GInvoicingFacade_Stub.java:21215)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.processApproval(SubmitCorpReviewInvoiceAction.java:329)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.execute(SubmitCorpReviewInvoiceAction.java:188)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)


Top
 Profile  
 
 Post subject: Re: ORA-01465:invalid hex number-while calling sql from hibernat
PostPosted: Wed Mar 02, 2016 5:02 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1638
Location: Romania
First, try to isolate the problem.
You could first check if the SQL is properly executed on the JDBC layer-side.
For this, you need to remove the:

Code:
.setResultTransformer(Transformers.aliasToBean(DocumentApprovalProfileTo.class));


and simply return the Object[] result.

If that still fails, you need to manually check which parameter might cause you the problem.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: ORA-01465:invalid hex number-while calling sql from hibernat
PostPosted: Fri Mar 04, 2016 9:12 am 
Newbie

Joined: Wed Mar 02, 2016 3:00 am
Posts: 2
Thank you very much for giving response.

We are getting above mentioned error
Quote:
ORA-01465:invalid hex number
in Production.
But I am unable to replicate the same issue in local development environment.
we are using the same code and data in both Production and local.
Could you please help me to understand why this issue is occurring in Production but not in Local Development Environment.
How to replicate the same issue in local to provide the resolution.


Top
 Profile  
 
 Post subject: Re: ORA-01465:invalid hex number-while calling sql from hibernat
PostPosted: Fri Mar 04, 2016 11:01 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1638
Location: Romania
You'll have to take a database dump from production and run it on your development environment and check the column that's causing the issue.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


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

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.