Results 1 to 4 of 4
  1. #1
    ngaisteve1 is offline Member
    Join Date
    Aug 2010
    Location
    Kuala Lumpur, Malaysia
    Posts
    4
    Rep Power
    0

    Default java.sql.SQLException: java.net.ConnectException

    I'm following this tutorial. At step A4j, when I click "Test Connection", I got an error message as attached.

    The test connection operation failed for data source Order DS on server server1 at node xxxxx with the following exception: java.sql.SQLException: java.net.ConnectException : Error opening socket to server localhost on port 1527 with message : Connection refused: connectDSRA0010E: SQL State = null, Error Code = -4,499. View JVM logs for further details.

    Then I went to open 1527 port, but still the same error message. Any idea?

  2. #2
    ngaisteve1 is offline Member
    Join Date
    Aug 2010
    Location
    Kuala Lumpur, Malaysia
    Posts
    4
    Rep Power
    0

    Default

    After I run startNetworkServer.bat, the previous error message is not more. But now is another error message,

    The test connection operation failed for data source Order DS on server server1 at node xxxxxxx with the following exception: java.sql.SQLException: The application server rejected establishment of the connection. An attempt was made to access a database, JPATEST, which was not found.DSRA0010E: SQL State = 08004, Error Code = -4,499. View JVM logs for further details.

    Will try to figure this out.

  3. #3
    ngaisteve1 is offline Member
    Join Date
    Aug 2010
    Location
    Kuala Lumpur, Malaysia
    Posts
    4
    Rep Power
    0

    Default

    After I run CONNECT 'JPATEST;create=true'; at ij command. I can now test the connection without any error.

  4. #4
    JosAH's Avatar
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,732
    Blog Entries
    7
    Rep Power
    21

    Default

    Quote Originally Posted by ngaisteve1 View Post
    After I run CONNECT 'JPATEST;create=true'; at ij command. I can now test the connection without any error.
    ... as you could have read in the documentation.

    kind regards,

    Jos

Similar Threads

  1. java.sql.SQLException: Closed Connection
    By sunjavaboy in forum JDBC
    Replies: 4
    Last Post: 03-21-2012, 02:38 PM
  2. Replies: 6
    Last Post: 09-01-2010, 12:29 PM
  3. Replies: 2
    Last Post: 06-07-2010, 09:45 AM
  4. Replies: 3
    Last Post: 01-26-2009, 06:30 PM
  5. java.net.ConnectException: Connection refused
    By Albert in forum Advanced Java
    Replies: 2
    Last Post: 07-03-2007, 05:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •