java.sql.SQLException: java.net.ConnectException

[ngaisteve1]

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?

[ngaisteve1]

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.

[ngaisteve1]

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

[JosAH]

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