Re: RPG - MsSQL Connection

[Chamara Withanachchi <chamaraw@xxxxxxxxxx>]

Scott,

I found the reason for the error, it was a . (dot) with my file name, Thanks
for your valuable time and efforts


Chamara




On Mon, Sep 13, 2010 at 11:45 AM, Chamara Withanachchi
<chamaraw@xxxxxxxxxx>wrote:

> Scott,
>
> Bellow is the message.
>
>  Message ID . . . . . . :   RNX0301
>
>  Date sent  . . . . . . :   13/09/10      Time sent  . . . . . . :
> 11:39:05
>
>
>  Message . . . . :   Java exception received when calling Java method.
>
>
>
>  Cause . . . . . :   RPG procedure JDBC_EXECP in program MOBBNK/JDBCR4
>
>    received Java exception "java.sql.SQLException: Invalid object name
>
>    'dbo.table_site'." when calling method "executeQuery" with signature
>
>    "()Ljava.sql.ResultSet;" in class "java.sql.PreparedStatement".
>
>  Recovery  . . . :   Contact the person responsible for program maintenance
> to
>    determine the cause of the problem.
>
>  Technical description . . . . . . . . :   If the exception indicates that
> the
>    Java class was not found, ensure the class for the method is in the
> class
>    path. If the exception indicates that the Java method was not found,
> check
>    the method name and signature. If the signature is not correct, change
> the
>    RPG prototype for the method, or change the Java method, so that the
> return
>    type and parameter types match. You can determine the signatures for all
> the
>    methods in class XYZ using command QSH CMD('javap -s XYZ').
>
>
>
> Chamara
>
>
>
>
> On Mon, Sep 13, 2010 at 10:38 AM, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx
> > wrote:
>
> > No, that message just means that the JVM has already ended, and you
> > can't restart it.
> >
> > As I said before I want the 2nd-level text of the "Java exception
> > received when calling Java method" (RNX0301) message.  You posted the
> > first level text (Which is simply "Java exception received", please post
> > the 2nd-level text, as that will describe what the actual exception is.
> >
> >
> > On 9/12/2010 11:49 PM, Chamara Withanachchi wrote:
> > > Scott,
> > >
> > >
> > > I believe you are referring to bellow messages
> > >
> > > FATAL ERROR in native method: Received NULL object reference
> > > java.lang.Throwable
> > >
> > > Java i5/OS PASE internal error number 102.
> > > Unable to run i5/OS PASE startup program /usr/lib/start32.
> > >
> > > Unable to create Java Virtual Machine.
> > --
> > This is the RPG programming on the IBM i / System i (RPG400-L) mailing
> > list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
>
>
> --
> Regards,
>
> Chamara Withanachchi
> IBM Certified Power System Expert
> RPG Programmer
> (owner of www.rpgiv.info)
>
> WWW.RPGIV.INFO
> Mob: +94 77 1678646
> chamaraw@xxxxxxxxxx
>
> i want to be future ready. i want control. i want an i.