Re: jdbc connection

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yeah, Sam, I am wondering about the same - why use JDBC to call a stored 
procedure in SQL Server that comes back to get data from the i? Why not 
just use JDBC to push the data as it is added/changed, etc.?

Vern

On 6/15/2020 12:49 PM, Sam_L wrote:
> FWIW: I'm not exactly sure what you are doing.  I think you'll need to 
> be more explicit to get responses.
>
> You said "connection to an sql server" so is the jdbc connection to 
> the sql server?  Because you also said "pulls records from the as400" 
> so the connection is to the as400.  And rnx0301 is probably an RPG 
> exception.
>
> Hence, I'm confused...
>
> If you are using JT400, make sure you have the latest version and 
> perhaps figure out how to turn on logging.
>
>
> On 6/15/2020 9:29 AM, Randy Cayton wrote:
> > Good morning ,
> > I am having an issue with an jdbc connecting to an sql server that 
> > calls an
> > stored procedure that pulls records from the as400. Works good until 
> > a file
> > is  > 900,000 bytes. I get error rnx0301 (sqlexception system call 
> > received
> > a parameter that is not valid) and error mch6801 (object domain or 
> > storage
> > protection error)
> > thanks in advance .