Error 17002 Sqlstate Null
Contents |
not work correctly without it enabled. Please turn JavaScript back on and sql error 17002 sqlstate 08006 reload this page. All Places > sql error 17002 sqlstate 08006 hibernate JBoss AS 7 > Discussions Please enter a title.
Errorcode 17002 Sqlstate 08006
You can not post a blank message. Please type your message and try again.
Oracle Sql Error: 17002, Sqlstate: 08006
1 Reply Latest reply on Apr 15, 2014 9:09 AM by Tomaz Cerar SQL Error: 17002, SQLState: 08006 IO Error: Connection reset in JBOSS 7.1 Ritika Gupta Apr 15, 2014 sql error: 17008, sqlstate: 08003 8:06 AM I am getting following error regarding database connections-08:05:21,828 WARN [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) SQL Error: 17002, SQLState: 0800608:05:21,828 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) IO Error: Connection reset08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) org.hibernate.exception.JDBCConnectionException: could not execute query08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doList(Loader.java:2223)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.list(Loader.java:2099)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(Abstra
Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.
17002 "Io Exception: The Network Adapter could not establish the connection" October 5, 2010Technical StuffOracle 11g R2chris If you search for the Oracle error "Io Exception: The Network Adapter could not establish the connection" (ORA-17002) you will find plenty of discussion on the web. It usually http://www.christoph-jahn.com/?p=1074 comes down to what the message says, that is a network issue. But the error can also be caused by e.g. incompatible jar files. In my case, however, I was trying to access a 11g R2 instance from SQL Developer and during initial setup everything had worked. And local access, also with SQL Developer, worked absolutely fine. Solution: Replace "simple" DB hostname with the fully qualified one. I am not sure sql error why this changed the behavior. I can think of either a DNS setup issue (although my search list included the domain) or some kind of reverse lookup logic that is being applied. Anyway, I wanted to share this finding and also record it for my own future use. Post navigation ← Oracle DB 11g R2 on 32 bit Linux: DBCA does not start Free Screenshot Tool for Windows → 20 thoughts error 17002 sqlstate on “Oracle Error 17002 "Io Exception: The Network Adapter could not establish the connection"” Exether says: June 3, 2011 at 13:22 Thanks for the tip, it worked for me too !! Even, I changed localhost to my machine name, it worked, and it was still working when I reverted to localhost. There must be some strange network behaviour beneath. enxel says: August 17, 2011 at 19:33 thank you very much! I tried a lot of complex solutions and this was the winner, now I can continue my work, thanks again mahendra says: November 2, 2011 at 11:52 thank you very much …! sinan says: November 22, 2011 at 09:33 other solution : you make sure that you have the right DNS on your IP Address this is happened if you have 2 network Good luck Aneeq says: February 15, 2012 at 15:57 It didn't work for me. Neil says: April 9, 2012 at 19:56 Thank you very much, it helped me to solve the problem I had wardi-ahamed says: April 12, 2012 at 18:37 Thank you so much for your helping me. kamel says: April 21, 2012 at 12:25 it worked fo me too ! merci beacoup !! Ravi Joshi says: May 18, 2012 at 12:53 Awesome tip! worked for me too…i