Monday, January 20, 2014

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

This exception can be caused by many problems such as wrong URL, wrong username/password, or the database server is not reachable from your computer. However, if you can access the database with sqlplus or other tools and checked the username/password carefully, it is most likely caused by using a wrong URL.

The basic structure of database URL is like this.

      jdbc:<vendor>:<driver type>@<database host ip address>:<port>:<database SID>

For example, an Oracle database URL could look like this: jdbc:oracle:thin:@11.08.0.123:1521:orcl

The database SID can be retrieved with the following query.

      select sys_context('userenv','instance_name') from dual;

-------------------------------------------------------------------------------------------------------------

                        
If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book free here.

No comments:

Post a Comment