| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| VerbProcessingFailedException;NumberFormatException |
« View previous topic :: View next topic » |
| Author |
Message
|
| brokerics |
 Posted: Sat Feb 25, 2006 6:32 am Post subject: VerbProcessingFailedException;NumberFormatException |
 |
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
hi guys
im tryin to pick events from a DB2 database application. The connector holds only one BO in its supported BO's section.
the trigger works fine, the adapter even picks up the event from the event table. this is where the error is
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg
: Polling every 2000 milliseconds.] ]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg
: Polling for subscription events.] ]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: Thread:appPolling:executing poll ca
ll]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering pollForEvents] ]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieveEvents] ]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieveEvents] ]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 33024] [Mesg
: No events to Process..!] ]
[Time: 2006/02/25 19:59:24.147] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/02/25 19:59:26.180] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg
: Polling every 2000 milliseconds.] ]
[Time: 2006/02/25 19:59:26.330] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg
: Polling for subscription events.] ]
[Time: 2006/02/25 19:59:26.480] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: Thread:appPolling:executing poll ca
ll]
[Time: 2006/02/25 19:59:26.640] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/02/25 19:59:26.821] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering pollForEvents] ]
[Time: 2006/02/25 19:59:26.821] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieveEvents] ]
[Time: 2006/02/25 19:59:26.821] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieveEvents] ]
[Time: 2006/02/25 19:59:26.821] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 33024] [Mesg
: No events to Process..!] ]
[Time: 2006/02/25 19:59:26.821] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/02/25 19:59:28.824] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg
: Polling every 2000 milliseconds.] ]
[Time: 2006/02/25 19:59:28.974] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg
: Polling for subscription events.] ]
[Time: 2006/02/25 19:59:29.124] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: Thread:appPolling:executing poll ca
ll]
[Time: 2006/02/25 19:59:29.264] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/02/25 19:59:29.364] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering pollForEvents] ]
[Time: 2006/02/25 19:59:29.514] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieveEvents] ]
[Time: 2006/02/25 19:59:29.715] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 32016] [Mesg
: Polling for eventID,name of BO,verb:"58","NEWORDER","Retrieve"] ]
[Time: 2006/02/25 19:59:29.875] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieveEvents] ]
[Time: 2006/02/25 19:59:30.025] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering updateEventStatus] ]
[Time: 2006/02/25 19:59:30.175] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37021] [Mesg
: Database Commited Successfully] ]
[Time: 2006/02/25 19:59:30.326] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37022] [Mesg
: DBManager Operation success] ]
[Time: 2006/02/25 19:59:30.486] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting updateEventStatus] ]
[Time: 2006/02/25 19:59:30.716] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering doVerbFor] ]
[Time: 2006/02/25 19:59:30.916] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:NEWORDER>
BusinessObject = NEWORDER
Verb = Retrieve
Locale = en_US
CUSTID = 44
FNAME = CxIgnore
LNAME = CxIgnore
MNAME = CxIgnore
STREET = CxIgnore
CITY = CxIgnore
STATE = CxIgnore
ZIPCODE = CxIgnore
ObjectEventId = CxIgnore
<EndBO:NEWORDER>]
[Time: 2006/02/25 19:59:31.878] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering fetchConnection] ]
[Time: 2006/02/25 19:59:32.048] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39015] [Mesg
: Number of DB Connections in Use 2] ]
[Time: 2006/02/25 19:59:32.198] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting fetchConnection] ]
[Time: 2006/02/25 19:59:32.378] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34505] [Mesg
: Entering method retrieve() in JDBCSPRetriever] ]
[Time: 2006/02/25 19:59:32.539] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34506] [Mesg
: Exiting method retrieve() in JDBCSPRetriever] ]
[Time: 2006/02/25 19:59:32.689] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieve] ]
[Time: 2006/02/25 19:59:32.859] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieve] ]
[Time: 2006/02/25 19:59:33.009] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 35962] [Mesg
: Verb for the present BO is Retrieve] ]
[Time: 2006/02/25 19:59:33.180] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering doRetrieve] ]
[Time: 2006/02/25 19:59:33.330] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieve] ]
[Time: 2006/02/25 19:59:33.480] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieve] ]
[Time: 2006/02/25 19:59:33.650] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg
: No Stored Procedure verb object for BeforeRetrieve!] ]
[Time: 2006/02/25 19:59:33.800] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering execSP] ]
[Time: 2006/02/25 19:59:33.951] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg
: No Stored Procedure to execute. Exiting method execSP()] ]
[Time: 2006/02/25 19:59:34.101] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering setCopyAttributes] ]
[Time: 2006/02/25 19:59:34.251] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieve] ]
[Time: 2006/02/25 19:59:34.401] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieve] ]
[Time: 2006/02/25 19:59:34.582] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting setCopyAttributes] ]
[Time: 2006/02/25 19:59:34.732] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg
: No Stored Procedure verb object for Retrieve!] ]
[Time: 2006/02/25 19:59:34.882] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering execSP] ]
[Time: 2006/02/25 19:59:35.032] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg
: No Stored Procedure to execute. Exiting method execSP()] ]
[Time: 2006/02/25 19:59:35.182] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering retrieve] ]
[Time: 2006/02/25 19:59:35.333] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting retrieve] ]
[Time: 2006/02/25 19:59:35.513] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :select CUSTID,FNAME,LNAME,MNAME,ST
REET,CITY,STATE,ZIPCODE from NEWORDER where CUSTID=44
]
[Time: 2006/02/25 19:59:35.733] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37016] [Mesg
: Values that are being set on the PreparedStatement:] ]
[Time: 2006/02/25 19:59:35.883] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :44
]
[Time: 2006/02/25 19:59:36.034] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Error] [MsgID: 37011] [Mesg: NumberFormatExceptio
n occurred while setting the values on the prepared statement]
[Time: 2006/02/25 19:59:36.204] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Error] [MsgID: 37005] [Mesg: DBManager Operation
Failed]
[Time: 2006/02/25 19:59:36.354] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Error] [MsgID: 35015] [Mesg: Retrieve Operation f
ailed on the BusinessObject NEWORDER]
[Time: 2006/02/25 19:59:36.504] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:NEWORDER>
BusinessObject = NEWORDER
Verb = Retrieve
Locale = en_US
CUSTID = 44
FNAME = CxIgnore
LNAME = CxIgnore
MNAME = CxIgnore
STREET = CxIgnore
CITY = CxIgnore
STATE = CxIgnore
ZIPCODE = CxIgnore
ObjectEventId = CxIgnore
<EndBO:NEWORDER>]
[Time: 2006/02/25 19:59:37.456] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering testDBStatus] ]
[Time: 2006/02/25 19:59:37.616] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting testDBStatus] ]
[Time: 2006/02/25 19:59:37.796] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering releaseConnection] ]
[Time: 2006/02/25 19:59:37.946] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting releaseConnection] ]
[Time: 2006/02/25 19:59:38.317] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Error] [MsgID: 10556] [Mesg: Exception Detail: co
m.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException
[Type: Error] [MsgID: 37011] [Mesg: NumberFormatException occurred while setting
the values on the prepared statement] ]
[Time: 2006/02/25 19:59:38.567] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type:
Error] [MsgID: 37011] [Mesg: NumberFormatException occurred while setting the va
lues on the prepared statement]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler
.java:1601)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConne
ctorBOHandler.java:127)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2167)
at com.crossworlds.cwconnectorapi.CWConnectorBusObj.doVerbFor(CWConnecto
rBusObj.java:126)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBC
ConnectorAgent.java:1299)
at AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:5
81)
at AppSide_Connector.AppCalls.poll(AppCalls.java:192)
at AppSide_Connector.AgentBusinessObjectManager.poll(AgentBusinessObject
Manager.java:716)
at AppSide_Connector.AppPolling.poll(AppPolling.java:290)
]
[Time: 2006/02/25 19:59:39.619] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg
: Entering updateEventStatus] ]
[Time: 2006/02/25 19:59:39.779] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37021] [Mesg
: Database Commited Successfully] ]
[Time: 2006/02/25 19:59:39.929] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37022] [Mesg
: DBManager Operation success] ]
[Time: 2006/02/25 19:59:40.079] [System: ConnectorAgent] [SS: JDBC_X] [Thread: a
ppPolling (#728837212)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg
: Exiting updateEventStatus] ]
but in the BO , the verbs retrieve & create are specified.
i dont see any number format problem in the database either.
could someone help? |
|
| Back to top |
|
 |
| djeripo |
| Posted: Sat Feb 25, 2006 10:35 am Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
In the BO structure,Does the types defined for the attributes match with the data you are retrieving from the Table?
To make it more simple,Did you use JDBC ODA to generate your BO? |
|
| Back to top |
|
|
| brokerics |
| Posted: Sun Feb 26, 2006 10:30 pm Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
yes i used JDBC ODA to generate BO's...
what cud be the problem then? |
|
| Back to top |
|
|
| brokerics |
| Posted: Mon Feb 27, 2006 8:31 am Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
im stuck wit this thing now guys
Type: Error] [MsgID: 37011] [Mesg: NumberFormatException occurred while setting
the values on the prepared statement]
and so another error : DBManger Operation Failed
this keeps cumin...
i specified the BO generated from ODA in the connector file...
help needed pls! |
|
| Back to top |
|
|
| vk |
| Posted: Mon Feb 27, 2006 3:38 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
When you create a BO using BO Designer (Using ODA), columns which are defined as Integer or Decimal in the table will be created as String in the BO.
What is the data type of CUSTID in the table and in the BO? If it is Integer or Decimal in the table and String in the BO, then this should be the reason why you are getting the error.
Change the data type of CUSTID in the BO to Double or Integer and retry.
Regards,
VK. |
|
| Back to top |
|
|
| djeripo |
| Posted: Mon Feb 27, 2006 5:43 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
The object_key of event table needs to be "varchar" type. But many
database applications use the "integer" datatype for unique key
fields.
If the event trigger or stored procedure do not consider this, ex. if
the trigger is like: CREATE TRIGGER USER ... INSERT INTO
xworlds_events (object_key, ... VALUES ( CHAR(n.user_id), ...) And
user_id is defined as integer, then when JDBC adapter polling the
event, you'll get NumberFormatException. The reason is: when user_id
is inserted to event table as char(user_id), it will be automatically
be padded with space.
When JDBC adapter poll the event table, get this '11 ' value, and
since the corresponding BO's attribute is defined as integer, it will
try to convert, but will get error as standard JAVA API, like
parseInt('11 ') will throw NumberFormatException. Workaround: Add
RTRIM in the trigger, RTRIM(CHAR(n.user_id)), then there won't be
padding space when inserting to event table, so parseInt('11') will be
ok |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
You cannot vote in polls in this forum
|
|
|
|
