You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by MY <mu...@wachovia.com> on 2007/12/11 16:32:44 UTC
Random ORA Errror
Hi,
I am using iBATIS 2.3.0 version. I started getting this below ORA error in
random.
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-01722: invalid number
Can some one help me.. is there any known issues around these error with
IBATIS.
Thanks in Advance,
MY
--
View this message in context: http://www.nabble.com/Random-ORA--Errror-tp14276333p14276333.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: Random ORA Errror
Posted by Chetan Nayak <ch...@gmail.com>.
what kind of column are u trying to insert to and wat's the value ur trying
to insert
On 12/11/07, Larry Meadors <lm...@apache.org> wrote:
>
> Nope.
>
> Maybe if you give us some details, we can give better help.
>
> Larry
>
>
> On Dec 11, 2007 8:32 AM, MY <mu...@wachovia.com> wrote:
> >
> > Hi,
> >
> > I am using iBATIS 2.3.0 version. I started getting this below ORA error
> in
> > random.
> > ORA-01858: a non-numeric character was found where a numeric was
> expected
> > ORA-01722: invalid number
> >
> > Can some one help me.. is there any known issues around these error with
> > IBATIS.
> >
> > Thanks in Advance,
> > MY
> > --
> > View this message in context:
> http://www.nabble.com/Random-ORA--Errror-tp14276333p14276333.html
> > Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> >
> >
>
Re: Random ORA Errror
Posted by Larry Meadors <lm...@apache.org>.
Nope.
Maybe if you give us some details, we can give better help.
Larry
On Dec 11, 2007 8:32 AM, MY <mu...@wachovia.com> wrote:
>
> Hi,
>
> I am using iBATIS 2.3.0 version. I started getting this below ORA error in
> random.
> ORA-01858: a non-numeric character was found where a numeric was expected
> ORA-01722: invalid number
>
> Can some one help me.. is there any known issues around these error with
> IBATIS.
>
> Thanks in Advance,
> MY
> --
> View this message in context: http://www.nabble.com/Random-ORA--Errror-tp14276333p14276333.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
Re: Random ORA Errror
Posted by MY <mu...@wachovia.com>.
[12/11/07 11:20:18:933 EST] 0000006b SessionContex E handlePropertyHits:
Failed to replicate attribute
:com.cts.asg.geekshowers.chaos.artemis.defaultimpl.requests.GenericArtemisRequest[(
Attribute Name-Values : ) ( Field Values : dataAccessCriteria =
com.cts.asg.geekshowers.chaos.artemis.defaultimpl.criteria.GenericDataAccessCriteria[(
Attribute Name-Values : ) ( Field Values : constraintsCriteria =
com.cts.asg.geekshowers.chaos.artemis.defaultimpl.criteria.GenericConstraintsCriteria[(
Attribute Name-Values : ) ( Field Values : aggregationConstraints = [],
example = null, exampleClass = null, exampleConstraints = [],
orderingConstraints = [], propertiesConstraints = [], sortByProperties =
null, sortByPropertiesCount = 0, sortbyPropertiesOrders = null,
sortByPropertiesPositions = null, sortByPropertyName = null, sortOrder =
null, sortAscending = true)], dataAccessCriteriaName = NotUsed,
pagingCriteria =
com.cts.asg.geekshowers.chaos.artemis.defaultimpl.criteria.GenericPagingCriteria[(
Attribute Name-Values : ) ( Field Values : firstRowPosition = 0, pageCount
= 0, pageCountRequiredFlag = false, pageNumber = 1, pageRequiredFlag =
false, pageSize = 20, rowsCount = 0, firstRowPositionUsed = false,
pageCountRequired = false, pageRequired = false)])], errorMessage =
com.cts.asg.geekshowers.chaos.pegasus.exception.ParameterizedRuntimeException:
com.cts.asg.geekshowers.chaos.pegasus.exception.ParameterizedException:
com.cts.asg.geekshowers.chaos.pegasus.exception.ParameterizedRuntimeException:
com.cts.asg.geekshowers.chaos.pegasus.exception.ParameterizedException:
com.cts.asg.geekshowers.chaos.pegasus.exception.ParameterizedRuntimeException:
org.springframework.transaction.TransactionSystemException: Caught an
exception while executing a activity; nested exception is
com.cts.asg.geekshowers.chaos.pegasus.exception.ParameterizedException:
com.cts.asg.geekshowers.chaos.palaemon.exceptions.DataAccessException:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
config/dataaccess/sqlmaps/ek_previous_note.sqlmap.xml.
--- The error occurred while applying a parameter map.
--- Check the
EkPreviousNote.UpdatePreviousNoteForRenewal-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-01858: a non-numeric character was
found where a numeric was expected, requestDataObject =
net.wachovia.bcs.dealnavigator.dto.module.structuring.StructuringModuleSaveItem[(
Attribute Name-Values : ) ( Field Values : codeDecodeListingManager = {},
identifier = 1060126512, identifiersMap = {}, activeRowDealId = 1785039145,
activeRowFacilitiesCount = 1, activeRowFacilityId = 1785039157, activeRowId
= , activeRowPiplineDealFlag = Y, activeRowType = DEAL, containedItemsList =
[net.wachovia.bcs.dealnavigator.dto.composite.procedures.RenewalSummaryProcedureCompositeItem@427d427d,
net.wachovia.bcs.dealnavigator.dto.module.structuring.renewalsummary.RenewalSummarySaveModuleItem[(
Attribute Name-Values : ) ( Field Values : codeDecodeListingManager = {},
identifier = 1115898499, identifiersMap = {}, activeRowDealId = 1785039145,
activeRowFacilitiesCount = 1, activeRowFacilityId = 1785039157, activeRowId
= , activeRowPiplineDealFlag = Y, activeRowType = DEAL, containedItemsList =
[net.wachovia.bcs.dealnavigator.dto.basic.BasicEkPreviousNoteMappedItem[(
Attribute Name-Values : ) ( Field Values : codeDecodeListingManager = {},
identifier = 1785039239, identifiersMap = {prevNoteId=1785039239}, asOfDte =
2007-12-10 00:00:00.0, bankNum = 01, clasProcessType = 0101, collTypeCde =
005, csLoanNum = null, curAccrdIntAmt = 41.66, curPrinOutstAmt = null,
fdrAcctNum = null, highUsageAmt = null, ibisNum = , lastLoanFeeAmt = 0.0,
lastModTs = null, lastModUser = a008154, lockseq = 0, longestNumDaysAt0 = 0,
lowUsageAmt = null, noteDte = 2006-07-25 00:00:00.0, noteFaceAmt = null,
oblgNumCur = 00000000067, oblgNumFut = 00000000059, oblrNum = 4661307232,
prevExpDte = 2007-10-20 00:00:00.0, prevNoteId = 1785039239, renewalId =
1785039236, specDocTypCde = null)]], creditApplicationId = 1785039109,
currentMQId = , currentSelectedDealId = 0, currentUserId = 4652,
currentUserMQId = r008154, currentUserName = Doom, Tom, readOnlyFlag =
false, activeRowTypeDeal = false, activeRowTypeFacility = true,
activeRowTypePipelineDeal = false, activeRowTypePipelineDealFacility = true,
editable = true, readOnly = false, facCategory = RENEW ,
facilityRenewalUpdateItem =
net.wachovia.bcs.dealnavigator.dto.basic.BasicEkFacilityMappedItem[(
--
View this message in context: http://www.nabble.com/Random-ORA--Errror-tp14276333p14278123.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: Random ORA Errror
Posted by Vinaya Tirikkovalluru <vi...@converge.com>.
Hi,
I encountered this error when I was trying to pass java.util.date
instead of java.sql.date
Vinaya
-----Original Message-----
From: MY [mailto:murthy.yerramilli@wachovia.com]
Sent: Tuesday, December 11, 2007 10:33 AM
To: user-java@ibatis.apache.org
Subject: Random ORA Errror
Hi,
I am using iBATIS 2.3.0 version. I started getting this below ORA error
in
random.
ORA-01858: a non-numeric character was found where a numeric was
expected
ORA-01722: invalid number
Can some one help me.. is there any known issues around these error with
IBATIS.
Thanks in Advance,
MY
--
View this message in context:
http://www.nabble.com/Random-ORA--Errror-tp14276333p14276333.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
This electronic message is intended only for the use of the individual(s) or entity(ies) named above and may contain information which is privileged and/or confidential. If you are not the intended recipient, be aware that any disclosure, copying, distribution, dissemination or use of the contents of this message is prohibited. If you received this message in error, please notify the sender immediately.