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

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
 at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:420)
 at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
 at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:75)
 at com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:133)
 ... 99 more

Create the listener for Glassfish server

netstat -an |grep -i "LISTEN"

Down load the connecter

http://tomcat.apache.org/connectors-doc/

Complie the connecter

Create the listener of the ajp 8009

he problem is from "-Dcom.sun.enterprise.web.connector.enableJK=${AJP_PORT}" seems not the right way anymore, its in Glassfish 2.1 but in Glassfish 3.1.2 you need to :

1.    From your cluster config --> Network Config --> Network Listeners (click on this)

2.    Create "New..." listener.

3.    Fill new listener info :

·         Name it like : jk-connector , port with: ${AJP_PORT} , check on "JK Listener" to enable it , forprotocol select "Use an existing protocol" then select "http-listener-1" protocol , for Thread Pool select "http-thread-pool" (not sure about this till now, but used same pool of another listeners).

Then start instances, if started successfully try check their ports is listening using "netstat -an | grep " eg: "netstat -an | grep 9090" and so.

How to set NLS_LANG variable for Japanese

Go to Oracle folder in registery


NLS_LANG=JAPANESE_JAPAN.JA16SJISTILDE

java.sql.SQLException: ORA-04063: view

java.sql.SQLException: ORA-04063: view "XXXXX

 oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
 oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
 oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
 oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
 oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
 oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
 oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
 oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
 oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
 oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
 oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
 oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
 oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
 org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
 org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698)
 org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112)
 org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:122)
 

Solution:- If it is not finding related view we will get this error.To fix issue we need to create related view.

PreparedStatementCallback; bad SQL grammar nested exception is java.sql.SQLException: ORA-00980

ERROR [com..AN010Action] - PreparedStatementCallback; bad SQL grammar [ SELECT ? ]; nested exception is java.sql.SQLException: ORA-00980: シノニム変換が無効です。

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar nested exception is java.sql.SQLException: ORA-00980: シノニム変換が無効です。

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:111)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:187)
at com.gehc.ohr.common.dao.BaseDao.queryList(BaseDao.java:20)
at com.gehc.ohr.common.dao.impl.LoginSearchDaoImpl.searchUserInfo(LoginSearchDaoImpl.java:41)
at com.gehc.ohr.common.service.impl.LoginServiceImpl.getUserInfo(LoginServiceImpl.java:30)
at com.gehc.ohr.common.action.BaseAction.getUserSession(BaseAction.java:258)
at com.gehc.ohr.common.action.BaseAction.baseExecute(BaseAction.java:188)
at com.gehc.ohr.common.action.BaseAction.execute(BaseAction.java:133)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableReque

Solution:- If it is not finding related view we will get this error.To fix issue we need to create related view.

java.lang.NoClassDefFoundError: com/teradata/jdbc/jdbc_4/ifsupport/LocalEscapeFunctions

<Sep 12, 2014 6:28:17 AM UTC> <Error> <HTTP> <BEA-101017> <[ServletContext@1839328839[app:xxxx module:xxx path:/xxx  spec-version:2.5]] Root cause of ServletException.
java.lang.NoClassDefFoundError: com/teradata/jdbc/jdbc_4/ifsupport/LocalEscapeFunctions
       at java.lang.ClassLoader.defineClass1(Native Method)
       at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
       at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
       at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
       at weblogic.utils.classloaders.GenericClassLoader.defineClass(GenericClassLoader.java:343)
       Truncated. see log file for complete stacktrace
Caused By: java.lang.ClassNotFoundException: com.teradata.jdbc.jdbc_4.ifsupport.LocalEscapeFunctions
       at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)
       at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
       at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)
       Truncated. see log file for complete stacktrace

Solution:- 

we need to set  WEBLOGIC_CLASSPATH in commEnv.sh file.

Example:- 

WEBLOGIC_CLASSPATH="${JAVA_HOME}/lib/tools.jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic_sp.jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic.jar${CLASSPATHSEP}${FEATURES_DIR}/weblogic.server.modules_10.3.5.0.jar${CLASSPATHSEP}${WL_HOME}/server/lib/webservices.jar${CLASSPATHSEP}${ANT_HOME}/lib/ant-all.jar${CLASSPATHSEP}${ANT_CONTRIB}/lib/ant-contrib.jar${CLASSPATHSEP}${WL_HOME}/server/lib/tdgssconfig.jar${CLASSPATHSEP}${WL_HOME}/server/lib/terajdbc4.jar"

export WEBLOGIC_CLASSPATH

after adding class path like above restart server.

[org.hibernate.util.DTDEntityResolver] recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!

Solution:-


<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

Please change above one to like below one in hibernate.cfg.xml file 


<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">