SPJ w result set failed with ERROR[8413]
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Pavani Puppala |
Bug Description
Tested with Trafodion build, 20140801-0830.
Calling a SPJ with result set:
public static void NS786(String paramString, ResultSet[] paramArrayOfRes
throws Exception
{
String str1 = "jdbc:default:
Connection localConnection = DriverManager.
String str2 = "select * from " + paramString;
Statement localStatement = localConnection
paramArray
}
it failed with ERROR[8413]:
*** ERROR[8413] The string argument contains characters that cannot be converted. [2014-08-11 04:06:32]
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:LARGEINT(
The SPJ Jar file is attached. Here are the steps to produce the error:
set schema testspj;
create library spjrs file '/<Jar location>
create procedure RS786(varchar(100))
language java
parameter style java
external name 'Testrs.NS786'
dynamic result sets 1
library spjrs;
create table datetime_interval (
date_key date not null,
date_col date default date '0001-01-01',
time_col time default time '00:00:00',
yr2_to_mo interval year to month
yr6_to_mo interval year(6) to month
yr16_to_mo interval year(16) to month default
year18 interval year(18) default
day2 interval day default interval '00' day,
day18 interval day(18)
day16_to_hr interval day(16) to hour
hour2 interval hour default interval '00' hour,
hour18 interval hour(18)
min2 interval minute default interval '00' minute,
min18 interval minute(18) default
min13_s3 interval minute(13) to second(3) default
min16_s0 interval minute(16) to second(0) default
seconds interval second default interval '00' second,
seconds5 interval second(5) default interval '00000' second(5),
seconds18 interval second(18,0) default
seconds15 interval second(15,3) default
primary key (date_key)
) ;
insert into datetime_interval
interval_year, yr2_to_mo, yr6_to_mo, yr16_to_mo, year18)
values
(date '0011-12-30', date '1239-01-01', time '01:01:01',
interval '11-11' year to month,
Call RS786('
*** ERROR[8413] The string argument contains characters that cannot be converted. [2014-08-11 04:06:32]
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:LARGEINT(
Changed in trafodion: | |
assignee: | nobody → Pavani Puppala (pavani-puppala) |
Changed in trafodion: | |
milestone: | none → r1.0 |
Changed in trafodion: | |
milestone: | r1.0 → r1.1 |
Changed in trafodion: | |
milestone: | r1.1 → r2.0 |
importance: | Medium → High |
Changed in trafodion: | |
status: | New → In Progress |