Oracle 17008 Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and oracle closed connection vendor code 17008 try again. More discussions in SQL Developer All PlacesDatabaseDatabase Application DevelopmentSQL Developer This discussion is
Sql Error: 17008, Sqlstate: Null
archived 9 Replies Latest reply on Mar 30, 2010 8:15 AM by -K- ORA-17008 error message 733833 Mar 15, 2010 9:35 PM Hello
Vendor Code 17008 Oracle Sql Developer
users, I'm having a connection problem in SQL Developer and am not able to run any queries on the SQL worksheet. I get either a popup window with the following ORA-17008 error message: "An error was encountered performing
Sql Error: 17008, Sqlstate: 08003
the requested operation" Closed Connection Vendor code 17008 Or this msg on the Script Output window: "SQL Error: No more data to read from socket" I've been using SQL Developer for months now and this is the first time I encounter this problem. I ran the same queries last week succesfully so this is not a syntax issue. I'm using version 2.1.0.62 with a Basic connection. Does anybody know how to fix this? so far ora 17008 jdbc I haven't found any solutions. Thanks, I have the same question Show 0 Likes(0) 35818Views Tags: none (add) connectionContent tagged with connection, errorContent tagged with error, sql_developerContent tagged with sql_developer This content has been marked as final. Show 9 replies 1. Re: ORA-17008 error message 561237 Mar 16, 2010 2:38 AM (in response to 733833) This just sounds like your connection to the database has been lost and you simply need to reconnect. I have only seen this when I have left SQL Developer connected to a DB that is restarted. theFurryOne Like Show 0 Likes(0) Actions 2. Re: ORA-17008 error message -K- Mar 16, 2010 7:50 AM (in response to 733833) Being badly disconnected causes this, also when e.g. killing a remote debug. As theFurryOne pointed out, disconnecting and reconnection should solve it. Regards, K. Like Show 0 Likes(0) Actions 3. Re: ORA-17008 error message 733833 Mar 16, 2010 4:33 PM (in response to -K-) Thanks for your quick responses. I tried disconnecting and connecting back several times. I also logged on and off several times and kept getting the same error. No debugging yet. Any other ideas? Like Show 0 Likes(0) Actions 4. Re: ORA-17008 error message -K- Mar 17, 2010 9:46 AM (in response to 733833) What DB version is that on? Can you connect with other tools like SQL*Plus? K.
This Site Careers Other all forums Forum: Oracle/OAS oracle error 17008 - reason? sql error 17008 sqlstate 99999 Sree Nivas Ranch Hand Posts: 95 posted 10 ora-17008 sql developer years ago Hello All, Our Application got into strange state today where every display dsra0010e: sql state = 08003, error code = 17,008 or edit user via the GUI failed with oracle error 17008. There's nothing wrong with the database, situation resolved by restarting of https://community.oracle.com/thread/1045906 the application. error received at the app GUI : ElementException_PreparedStatementCallback; uncategorized SQLException for SQL state [null]; error code [17008]; Closed Connection; nested exception is java.sql.SQLException: Closed Connection [ELEMENT: 5020CSC-A][TYPE: SN] Our applicatin running using JBoss 3.2.4 and databas version is Oracle 9. Any idea https://coderanch.com/t/80969/Oracle-OAS/oracle-error-reason why this oracle error 17008 occurred. regards Sreenivas Mark Spritzler ranger Sheriff Posts: 17278 6 I like... posted 10 years ago Well it just looks like the JDBC Connections got closed somehow. by restarting you recreated those connections. Mark Perfect World Programming, LLC - iOS Apps How to Ask Questions the Smart Way FAQ Post Reply Bookmark Topic Watch Topic New Topic Similar Threads Using DataSource with Oracle 10g Application Server results in error DataSource.getConnection() returning closed connections OrionCMTConnection not closed, check your code! Logical connection not closed, check your code! Oracle 10g (RAC) and WebSphere 6.0.2.27 DSRA9110E: ResultSet is closed All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter Contact Us | advertise | mobile view | Powered by JForum | Copyright © 1998-2016 Paul Wheaton
Hello users, I'm having a connection problem in SQL Developer and am not able to run any queries on the SQL worksheet. I get either a popup window with the following ORA-17008 error message: "An error was encountered http://boardreader.com/thread/ORA_17008_error_message_m941Xmdhe.html performing the requested operation" Closed Connection Vendor code 17008 Or this msg on the Script Output window: "SQL Error: No more ... Top contributing authors: Name Posts Adalberto Pineda 4 user's latest post: ORA-17008 error message Published (2010-03-29 16:30:00) I installed an older version of SQL Developer (1.5.5.59.69) and was able to reset the DB connection. It's working just fine. I think the new version (2.1.1.64.39) wasn't running because the software automatically kept the same settings sql error I had. When I installed the older version I was asked if I wanted to migrate the current settings. I declined that and set the connection to the DB manually. That made the trick. What is still unclear... -K- 4 user's latest post: ORA-17008 error message Published (2010-03-30 01:15:00) If you suspect you have corrupt settings, backup/delete the SQL Developer/systemXXX directory in the hidden Application Data under your Windows profile to reset your installation to defaults. Hope vendor code 17008 that helps, K. thefurryone 1 user's latest post: ORA-17008 error message Published (2010-03-15 19:38:00) This just sounds like your connection to the database has been lost and you simply need to reconnect. I have only seen this when I have left SQL Developer connected to a DB that is restarted. theFurryOne Irian 1 user's latest post: ORA-17008 error message Published (2010-03-18 01:27:00) I saw a similar problem once on a completely different application running on an IBM AIX box with IPv6 enabled by default, it was related to a problem in the JDBC driver which could not handle really well connections with IPv6 and it was solved by disabling the IPv6 features of the OS. Please post your OS details, and while you are at it you can try disabling IPv6 if you have recently turned it on. If you are in a hurry you can switch from... Related threads on "Browse - Places | Oracle Community": Copy database ends up with ORA-17008 Copy database ends up with ORA-17008 ORA-29913: error in executing ODCIEXTTABLEOPEN callout +... ORA-29913: error in executing ODCIEXTTABLEOPEN callout + ORA-29400: data cartridge error + KUP-11010: unable to open at least one dump file for fetch Getting an error message (ORA-01417) when applying left... Getting an error message (ORA-01417) when applying left join twice on the same table ORA-19870: error while restoring backup pie