Refused Connection - Sybase - Weblogic

This is a discussion on Refused Connection - Sybase - Weblogic ; Could someone please help with this not sure what is happing. I had this working at one stage but not sure what has happened. I have reinstalled Sybase and WL 7, (clean installs). Trying to connect to Sybase 11 DBMS ...

+ Reply to Thread
Results 1 to 3 of 3

Thread: Refused Connection - Sybase

  1. Refused Connection - Sybase




    Could someone please help with this not sure what is happing. I had this
    working at one stage but not sure what has happened.

    I have reinstalled Sybase and WL 7, (clean installs).

    Trying to connect to Sybase 11 DBMS using WLS 7.
    I've set my connection pool as follows:
    ----------------------------------------------------------------------------
    -
    Name : SybasePool
    URL : jdbc:sybase:Tds:localhost:5000/Aims
    Driver Class:com.sybase.jdbc2.jdbc.SybDriver (Assume this uses WL drivers as
    I'm not installing 3rd party drivers)
    Properties : user=sa
    ----------------------------------------------------------------------------
    -




    Sybase sql.ini file is :
    ----------------------------------------------------------------------------
    -
    [pisces]
    query=NLWNSCK,pisces,5000
    master=NLWNSCK,pisces,5000

    [pisces_BS]
    $BASE$00=NLWNSCK,pisces,5001
    $BASE$01=NLMSNMP,\pipe\sybase\backup
    query=$BASE$00;$BASE$01;
    $BASE$02=NLWNSCK,pisces,5001
    $BASE$03=NLMSNMP,\pipe\sybase\backup
    master=$BASE$02;$BASE$03;

    [pisces_MS]
    $BASE$00=NLWNSCK,pisces,5002
    $BASE$01=NLMSNMP,\pipe\sybase\monitor
    query=$BASE$00;$BASE$01;
    $BASE$02=NLWNSCK,pisces,5002
    $BASE$03=NLMSNMP,\pipe\sybase\monitor
    master=$BASE$02;$BASE$03;
    ----------------------------------------------------------------------------
    -
    Results of Server start up :

    C:\bea\user_projects\mydomain>"C:\bea\jdk131_06\bin\java" -hotspot -Xms32m -
    Xmx200m -Dweblogic.security.SSL.trustedCAKey
    Store=C:\bea\weblogic700\server\lib\cacerts -Dweblogic.Name=myserver -Dbea.h
    ome="C:\bea" -Dweblogic.management.username=
    -Dweblogic.management.password= -Dweblogic.ProductionModeEnabled= -Djava.se
    curity.policy="C:\bea\weblogic700\server\lib
    \weblogic.policy" weblogic.Server
    <22/06/2004 22:19:28> <090065> user.>
    Enter username to boot WebLogic server:system
    Enter password to boot WebLogic server:
    Starting WebLogic Server...
    <22/06/2004 22:19:40> <140005> C:\bea\user_projects\mydomain\.\config.xml>

    <22/06/2004 22:19:52> <090082> using realm myrealm.>
    <22/06/2004 22:19:54> <000327> Admin Server "myserver" for domain "mydomain
    ">
    <22/06/2004 22:20:13> <141052> started for development server.>
    <22/06/2004 22:20:18> <000354> "ListenThread.Default" listening on port 7001>
    <22/06/2004 22:20:18> <141030> Managed Server... This feature is on by defa
    ult, you may turn this off by passing -Dweblogic.management.discover=false>
    <22/06/2004 22:20:18> <000331> Admin Server "myserver" for domain "mydomain"
    running in Development Mode>
    <22/06/2004 22:20:18> <000354> "SSLListenThread.Default" listening on port 7002>
    <22/06/2004 22:20:18> <000365> changed to RUNNING>
    <22/06/2004 22:20:18> <000360> RUNNING mode>
    <22/06/2004 22:27:43> <001060> pool "SybasePool" weblogic.common.ResourceExcep
    tion: weblogic.common.ResourceException:
    Could not create pool connection. The DBMS driver exception was:
    java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException:
    Connection refused: connect
    at
    com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(Erro rMessage.java:493)
    at
    com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheck Dead(ErrorMessage.java:729
    )
    at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3107)
    at com.sybase.jdbc2.tds.Tds.login(Tds.java:394)
    at
    com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybCo nnection.java:218)
    at
    com.sybase.jdbc2.jdbc.SybConnection.regularConnect (SybConnection.java:195)
    at
    com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:174)




  2. Re: Refused Connection - Sybase



    Glenn wrote:

    > Could someone please help with this not sure what is happing. I had this
    > working at one stage but not sure what has happened.
    >
    > I have reinstalled Sybase and WL 7, (clean installs).
    >
    > Trying to connect to Sybase 11 DBMS using WLS 7.
    > I've set my connection pool as follows:
    > ----------------------------------------------------------------------------
    > -
    > Name : SybasePool
    > URL : jdbc:sybase:Tds:localhost:5000/Aims
    > Driver Class:com.sybase.jdbc2.jdbc.SybDriver (Assume this uses WL drivers as
    > I'm not installing 3rd party drivers)


    Hi. No, it uses Sybase's driver, one we ship with the product. I assume the machine
    you're running weblogic on is named 'pisces', correct? It appears that the DBMS is
    refusing to give the driver a connection. I suspect your 'sa' password is incorrect.
    Joe

    > Properties : user=sa
    > ----------------------------------------------------------------------------
    > -
    >
    >
    >
    >
    > Sybase sql.ini file is :
    > ----------------------------------------------------------------------------
    > -
    > [pisces]
    > query=NLWNSCK,pisces,5000
    > master=NLWNSCK,pisces,5000
    >
    > [pisces_BS]
    > $BASE$00=NLWNSCK,pisces,5001
    > $BASE$01=NLMSNMP,\pipe\sybase\backup
    > query=$BASE$00;$BASE$01;
    > $BASE$02=NLWNSCK,pisces,5001
    > $BASE$03=NLMSNMP,\pipe\sybase\backup
    > master=$BASE$02;$BASE$03;
    >
    > [pisces_MS]
    > $BASE$00=NLWNSCK,pisces,5002
    > $BASE$01=NLMSNMP,\pipe\sybase\monitor
    > query=$BASE$00;$BASE$01;
    > $BASE$02=NLWNSCK,pisces,5002
    > $BASE$03=NLMSNMP,\pipe\sybase\monitor
    > master=$BASE$02;$BASE$03;
    > ----------------------------------------------------------------------------
    > -
    > Results of Server start up :
    >
    > C:\bea\user_projects\mydomain>"C:\bea\jdk131_06\bin\java" -hotspot -Xms32m -
    > Xmx200m -Dweblogic.security.SSL.trustedCAKey
    > Store=C:\bea\weblogic700\server\lib\cacerts -Dweblogic.Name=myserver -Dbea.h
    > ome="C:\bea" -Dweblogic.management.username=
    > -Dweblogic.management.password= -Dweblogic.ProductionModeEnabled= -Djava.se
    > curity.policy="C:\bea\weblogic700\server\lib
    > \weblogic.policy" weblogic.Server
    > <22/06/2004 22:19:28> <090065> > user.>
    > Enter username to boot WebLogic server:system
    > Enter password to boot WebLogic server:
    > Starting WebLogic Server...
    > <22/06/2004 22:19:40> <140005> > C:\bea\user_projects\mydomain\.\config.xml>
    >
    > <22/06/2004 22:19:52> <090082> > using realm myrealm.>
    > <22/06/2004 22:19:54> <000327> > Admin Server "myserver" for domain "mydomain
    > ">
    > <22/06/2004 22:20:13> <141052> > started for development server.>
    > <22/06/2004 22:20:18> <000354> > "ListenThread.Default" listening on port 7001>
    > <22/06/2004 22:20:18> <141030> > Managed Server... This feature is on by defa
    > ult, you may turn this off by passing -Dweblogic.management.discover=false>
    > <22/06/2004 22:20:18> <000331> > Admin Server "myserver" for domain "mydomain"
    > running in Development Mode>
    > <22/06/2004 22:20:18> <000354> > "SSLListenThread.Default" listening on port 7002>
    > <22/06/2004 22:20:18> <000365> > changed to RUNNING>
    > <22/06/2004 22:20:18> <000360> > RUNNING mode>
    > <22/06/2004 22:27:43> <001060> > pool "SybasePool" weblogic.common.ResourceExcep
    > tion: weblogic.common.ResourceException:
    > Could not create pool connection. The DBMS driver exception was:
    > java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException:
    > Connection refused: connect
    > at
    > com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(Erro rMessage.java:493)
    > at
    > com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheck Dead(ErrorMessage.java:729
    > )
    > at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3107)
    > at com.sybase.jdbc2.tds.Tds.login(Tds.java:394)
    > at
    > com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybCo nnection.java:218)
    > at
    > com.sybase.jdbc2.jdbc.SybConnection.regularConnect (SybConnection.java:195)
    > at
    > com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:174)
    >
    >
    >



  3. Re: Refused Connection - Sybase


    Thanks, Joe,
    I solved this by replacing the "localhost" (in the pool definition) with its eqivalent
    "pisces" and it worked. I have used this before (I'm sure) and it has worked but
    this time I am not sure why it requires me to have the explicit name and not localhost.

    If anyone can enlighten me that would be good. However, it has been solved!

    Regards
    Glenn

    Joe Weinstein wrote:
    >
    >
    >Glenn wrote:
    >
    >> Could someone please help with this not sure what is happing. I had

    >this
    >> working at one stage but not sure what has happened.
    >>
    >> I have reinstalled Sybase and WL 7, (clean installs).
    >>
    >> Trying to connect to Sybase 11 DBMS using WLS 7.
    >> I've set my connection pool as follows:
    >> ----------------------------------------------------------------------------
    >> -
    >> Name : SybasePool
    >> URL : jdbc:sybase:Tds:localhost:5000/Aims
    >> Driver Class:com.sybase.jdbc2.jdbc.SybDriver (Assume this uses WL drivers

    >as
    >> I'm not installing 3rd party drivers)

    >
    >Hi. No, it uses Sybase's driver, one we ship with the product. I assume
    >the machine
    >you're running weblogic on is named 'pisces', correct? It appears that
    >the DBMS is
    >refusing to give the driver a connection. I suspect your 'sa' password
    >is incorrect.
    >Joe
    >
    >> Properties : user=sa
    >> ----------------------------------------------------------------------------
    >> -
    >>
    >>
    >>
    >>
    >> Sybase sql.ini file is :
    >> ----------------------------------------------------------------------------
    >> -
    >> [pisces]
    >> query=NLWNSCK,pisces,5000
    >> master=NLWNSCK,pisces,5000
    >>
    >> [pisces_BS]
    >> $BASE$00=NLWNSCK,pisces,5001
    >> $BASE$01=NLMSNMP,\pipe\sybase\backup
    >> query=$BASE$00;$BASE$01;
    >> $BASE$02=NLWNSCK,pisces,5001
    >> $BASE$03=NLMSNMP,\pipe\sybase\backup
    >> master=$BASE$02;$BASE$03;
    >>
    >> [pisces_MS]
    >> $BASE$00=NLWNSCK,pisces,5002
    >> $BASE$01=NLMSNMP,\pipe\sybase\monitor
    >> query=$BASE$00;$BASE$01;
    >> $BASE$02=NLWNSCK,pisces,5002
    >> $BASE$03=NLMSNMP,\pipe\sybase\monitor
    >> master=$BASE$02;$BASE$03;
    >> ----------------------------------------------------------------------------
    >> -
    >> Results of Server start up :
    >>
    >> C:\bea\user_projects\mydomain>"C:\bea\jdk131_06\bin\java" -hotspot

    >-Xms32m -
    >> Xmx200m -Dweblogic.security.SSL.trustedCAKey
    >> Store=C:\bea\weblogic700\server\lib\cacerts -Dweblogic.Name=myserver

    >-Dbea.h
    >> ome="C:\bea" -Dweblogic.management.username=
    >> -Dweblogic.management.password= -Dweblogic.ProductionModeEnabled=

    >-Djava.se
    >> curity.policy="C:\bea\weblogic700\server\lib
    >> \weblogic.policy" weblogic.Server
    >> <22/06/2004 22:19:28> <090065>
    >from
    >> user.>
    >> Enter username to boot WebLogic server:system
    >> Enter password to boot WebLogic server:
    >> Starting WebLogic Server...
    >> <22/06/2004 22:19:40> <140005> >> C:\bea\user_projects\mydomain\.\config.xml>
    >>
    >> <22/06/2004 22:19:52> <090082> >> using realm myrealm.>
    >> <22/06/2004 22:19:54> <000327>
    >WebLogic
    >> Admin Server "myserver" for domain "mydomain
    >> ">
    >> <22/06/2004 22:20:13> <141052> >> started for development server.>
    >> <22/06/2004 22:20:18> <000354> >> "ListenThread.Default" listening on port 7001>
    >> <22/06/2004 22:20:18> <141030>
    >of
    >> Managed Server... This feature is on by defa
    >> ult, you may turn this off by passing -Dweblogic.management.discover=false>
    >> <22/06/2004 22:20:18> <000331> >> Admin Server "myserver" for domain "mydomain"
    >> running in Development Mode>
    >> <22/06/2004 22:20:18> <000354> >> "SSLListenThread.Default" listening on port 7002>
    >> <22/06/2004 22:20:18> <000365> >> changed to RUNNING>
    >> <22/06/2004 22:20:18> <000360>
    >in
    >> RUNNING mode>
    >> <22/06/2004 22:27:43> <001060> >> pool "SybasePool" weblogic.common.ResourceExcep
    >> tion: weblogic.common.ResourceException:
    >> Could not create pool connection. The DBMS driver exception was:
    >> java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException:
    >> Connection refused: connect
    >> at
    >> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(Erro rMessage.java:493)
    >> at
    >> com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheck Dead(ErrorMessage.java:729
    >> )
    >> at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3107)
    >> at com.sybase.jdbc2.tds.Tds.login(Tds.java:394)
    >> at
    >> com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybCo nnection.java:218)
    >> at
    >> com.sybase.jdbc2.jdbc.SybConnection.regularConnect (SybConnection.java:195)
    >> at
    >> com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:174)
    >>
    >>
    >>

    >