Re: JDBCR4:Can't connect,not sure how to get full java error text

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Tony,

A quick Google turns up the following Microsoft page:
http://support.microsoft.com/kb/826080

I'm not sure if that page directly relates or not, but it does tell me 
the following:

a) SQL Server has an option that forces SSL for all clients (Whether 
they enable it or not.)

b) There have been bugs in that support for Type 4 JDBC drivers (which 
is what you're using) in the past, and that there's a fix for it.

You may already have that fix, and you simply don't have SSL set up on 
the server side, I don't know..   But maybe it'll get you hopping along 
the right path (sorry, it's Easter tomorrow, so I had to use that sort 
of wording.)


Tony Carolla wrote:
> Aha!  I found the post about overriding STDERR and STDOUT, and I read the
> entire java error message:
> Mar 21, 2008 9:25:09 PM
> com.microsoft.sqlserver.jdbc.TDSChannelenableSSL
> WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL
> handshake failed: null
> com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not
> establish a secure connection to SQL Server by using Secure
>  at java.lang.Throwable.<init>(Throwable.java:195)
>
>  at java.lang.Exception.<init>(Exception.java:41)
>
>  at java.sql.SQLException.<init>(SQLException.java:40)
>
>  at com.microsoft.sqlserver.jdbc.SQLServerException.<init>(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.TDSChannel.throwSSLConnectionFailed(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
> Source)
>  at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
> Source)
>
> But I am not sure why it would be using SSL...  I am not specifying SSL, but
> maybe that is a requirement.  Is this telling me that I am missing a
> protocol driver?
>
> On Fri, Mar 21, 2008 at 6:35 PM, Tony Carolla <carolla@xxxxxxxxx> wrote:
>
> > Good Afternoon!
> >
> > I have started using Scott Klement's JDBCR4 service program to connect to
> > an SQL server, and I have a quick question.  First of all, I would like to
> > thank Scott for this service program and the documentation.  Integrating DB2
> > with other DB platforms is becoming the core challenge at my shop, and this
> > will greatly simplify accessing all data from the iSeries.  I am trying to
> > connect to an MS SQL 2000 server (see source below).
> >
> >      d/copy carollat/jdbcr,jdbc_h
> >      d LynxConn        s                   like(Connection)
> >      d UserName        s             50a   inz
> >      d Password        s             50a   inz
> >       /free
> >        *inlr = *on;
> >        UserName='username';
> >        Password='password';
> >        LynxConn=JDBC_Connect('com.microsoft.sqlserver.jdbc.SQLServerDriver
> > '
> >                              :'jdbc:sqlserver://10.10.4.22:1433'
> >                              :%trim(UserName)
> >                              :%trim(Password));
> >        if LynxConn=*Null;
> >           dump(A);
> >        endif;
> >        return;
> >       /end-free
> >
> > When I run the program the first time, I get a JVAB56D message in my job
> > log (Java Virtual Machine is Classic.).  Then, I get a screen like this:
> > ___________________________________________________________________
> >            at java.lang.Throwable.<init>(Throwable.java:195)
> >
> >            at java.lang.Exception.<init>(Exception.java:41)
> >
> >            at java.sql.SQLException.<init>(SQLException.java:40)
> >
> >            at com.microsoft.sqlserver.jdbc.SQLServerException.<init>(Unknown
> > Sou
> >
> > rce)
> >
> >            at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate
> > (Unknown
> >
> > Source)
> >            at
> > com.microsoft.sqlserver.jdbc.TDSChannel.throwSSLConnectionFailed(U
> >    nknown
> > Source)
> >            at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(Unknown
> > Source)
> >            at
> > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unk
> >    nown
> > Source)
> >            at
> > com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailo
> >    ver(Unknown
> > Source)
> >            at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
> > S
> >
> > ource)
> >
> >            at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
> > Sourc
> >
> > e)
> >
> >
> >
> >  ===>
> >
> >
> >
> >  F3=Exit F4=End of File F6=Print F9=Retrieve
> > F17=Top
> >  F18=Bottom  F19=Left   F20=Right F21=User Window
> > _____________________________________________________________________
> >
> > and then I get the following error:
> >
> > The driver could not establish a secure connection to SQL Server by using
> >   SecureJNI_CHECKERROR  Ø       Xë « Ø       ­ÏFs
> >
> > I have some java experience, and if I could just see the top the java
> > error message, I could at least have something to go on.  But the screen
> > above is input inhibited the entire time it is shown (can't scroll "up"!),
> > and the dump just shows the stuff in the RPG program.  I have tried using
> > the 'JDBC_ConnProp()' method also, and with the same result (what I can see
> > of the result anyway).
> >
> > So my question is, first of all, to anyone who uses this service program
> > (or Scott, if he has time 8)), can you see anything wrong with the
> > connection attempt, assuming the IP and user/pwd are valid, and the java
> > odbc driver is installed correctly?  Or to anyone who uses java with RPG,
> > how can I view the entire java error message.  Thanks in advance!
> >
> > --
> > "I'm out of my mind!  Please leave a message..." - unk