Re: RPG - MsSQL Connection

[Chamara Withanachchi <chamaraw@xxxxxxxxxx>]

Scott,

I Have forward the error messages to spool and got the following errors

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.

Chamara



On Sat, Sep 11, 2010 at 10:17 AM, Chamara Withanachchi
<chamaraw@xxxxxxxxxx>wrote:

> Scott,
>
> When I change
>
> JDBC_setProp(prop: 'user'         : 'sa');
>
> to
>
> JDBC_setProp(prop: 'userName'         : 'sa');
>
> program gives following error,
>
>
> java.sql.SQLException: Single-Sign-On is only supported on Windows. Please
> specify a user name.
>
>         at java.lang.Throwable.<init>(Throwable.java:195)
>
>         at java.sql.SQLException.<init>(SQLException.java:61)
>
>         at
> net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1878)
>
>         at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:588)
>
>         at
> net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
>
>         at
> net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
>
>         at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
>
>
>
>
> Chamara
>
>
>
>
> On Sat, Sep 11, 2010 at 9:46 AM, Chamara Withanachchi <chamaraw@xxxxxxxxxx
> > wrote:
>
> > Scott,
> >
> > I have changed the driver to jtds and connection string as following
> >
> >        prop = JDBC_Properties();
> >          // JDBC_setProp(prop: 'userName'     : 'sa');
> >          JDBC_setProp(prop: 'user'         : 'sa');
> >          JDBC_setProp(prop: 'password'     : 'sdb#123');
> >          JDBC_setProp(prop: 'databaseName' : 'testDB');
> >
> >          //conn =
> > JDBC_ConnProp('com.microsoft.sqlserver.jdbc.SQLServerDriver'
> >          //                    :'jdbc:sqlserver://10.100.19.36:1433'
> >          //                    : prop );
> >          conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'
> >                              :'jdbc:jtds:sqlserver://10.100.19.36:1433'
> >                              : prop );
> >          JDBC_freeProp(prop);
> >
> >
> > but now I'm getting the following error.
> >
> > call sqltest
> >      Printer device PRT01 not found. Output queue changed to QPRINT in
> > library
> >        QGPL.
> >
> >      Environment variable added.
> >
> >      Java Virtual Machine is Classic.
> >
> >      Java exception received when calling Java method.
> >
> >      The Java Virtual Machine has ended.
> >
> >      Application error.  MCH74A5 unmonitored by QJVAJNICLS at statement
> >
> >        0000000001, instruction X'0000'.
> >
> >      Pointer not set for location referenced.
> >
> >      Application error.  MCH3601 unmonitored by QJVAJNICLS at statement
> >
> >        0000000001, instruction X'0000'.
> >
> >      Unable to create Java Virtual Machine.
> >
> >      Unable to create Java Virtual Machine.
> >
> >      Pointer not set for location referenced.
> >
> >      Unable to create Java Virtual Machine.
> >
> >      Unable to create Java Virtual Machine.
> >
> >      Pointer not set for location referenced.
> >
> >      Unable to create Java Virtual Machine.
> >
> >      Unable to create Java Virtual Machine.
> >
> >      Pointer not set for location referenced.
> >
> >      Pointer not set for location referenced.
> >
> >      Function check. MCH3601 unmonitored by QRNXUTIL at statement
> > 0000000018,
> >        instruction X'0000'.
> >
> >      The call to JDBC_FREER ended in error (C G D F).
> >
> >
> > Thanking You
> >
> > Chamara
> >
> > On Fri, Sep 10, 2010 at 10:54 PM, Scott Klement <
> > rpg400-l@xxxxxxxxxxxxxxxx> wrote:
> >
> > > Chamara,
> > >
> > > You simply haven't provided me with any information.  I know exactly two
> > > words about your situation, and they are 'Unrecoverable Error'.
> > >
> > > Put yourself in my position.  I've never worked with a Microsoft
> > > Database, you're running a version of the JDBC drivers that I've never
> > > seen, I don't have the program in front of me that I can do any sort of
> > > troubleshooting or experimenting to try to find the error.  I don't even
> > > know what your code looks like (though, knowing that probably wouldn't
> > > help.)
> > >
> > > All I know is 'Unrecoverable Error'. Would you be able to solve a
> > > problem given that situation?
> > >
> > > My suggestion at this point:  Try the jTDS driver.  Many people have had
> > > better luck with jTDS vs. the Microsoft driver, because it's developed
> > > in a cross-platform method.
> > >
> > > Maybe it'll at least give you a more useful error message.
> > >
> > >
> > > On 9/9/2010 10:58 PM, Chamara Withanachchi wrote:
> > > > Can you please tell me what is the wrong im my code (Im using your
> > > JDBCR4
> > > > Service program)
> > > --
> > > 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.
>
>
>
> --
> 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.