This discussion is archived
3 Replies Latest reply: Jun 26, 2013 9:21 AM by Joe Weinstein RSS

WebLogic's Exception

995612 Newbie
Currently Being Moderated
Recently,there'r lot of errors below showed in the weblogic the same time, there'r a lot of INACTIVE session generated in the oracle DB's v$session table .
But the system shows normal.

<2013/02/19 10:00:00 CST> <Error> <JDBC> <zjq51101> <coo011> <[ACTIVE] ExecuteThread: '127' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <ce9d41a710a949eb:2e7eb449:13c8050d3d2:-8000-00000000001268ce> <1361255772945> <BEA-001112><Test "SELECT 1 FROM DUAL" set up for pool "DS_Coo01" failed with exception: "java.lang.NullPointerException".>

weblogic version:

What's the reason?

  • 1. Re: WebLogic's Exception
    Vijaya Moderator -Oracle Expert
    Currently Being Moderated
    Is the database up and running when you started weblogic server?

    Weblogic server executes default SQL "SELECT 1 FROM DUAL " to test the connectivity to Database configured in Weblogic Server data sources and to initialize the connections and to add it to the Connection Pool.

    You may see the errors if weblogic is unable to initialize the connections or unable to connect to DB to execute the default SQL Statement.

    Please check and revert back.

  • 2. Re: WebLogic's Exception
    VishalP-Oracle Pro
    Currently Being Moderated
    Explained in:
    <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "MSLVNoneTxPool" failed with exception: "java.sql.SQLException: Must be logged on to server".> [ID 1073691.1]

    You need to investigate database connectivity issues if there are any causing this message.
  • 3. Re: WebLogic's Exception
    Joe Weinstein Expert
    Currently Being Moderated

    That's really odd, and none of the answers here so far are relevant. Is this easily repeatable?

    Open an official SR so we can help.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points