You can lead some folks to knowledge, but you can not make them think. Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson BlogSQLException 17410 No more data from socket Oracle Database If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just to explain that situation.. Check This Out
This is likely a bug See this : https://blogs.oracle.com/db/entry/ora-600_troubleshooting share|improve this answer answered Nov 9 '11 at 17:57 sensware 711 add a comment| up vote 0 down vote For future googlers, I replaced MERGE with t-sql stored procedure call. akka.persistence.jdbc.journal.GenericStatements$class.insertMessage(Statements.scala:43) akka.persistence.jdbc.journal.OracleSyncWriteJournal.insertMessage(Journals.scala:16) akka.persistence.jdbc.journal.JdbcSyncWriteJournal$$anonfun$writeMessages$1.apply(JdbcSyncWriteJournal.scala:24) akka.persistence.jdbc.journal.JdbcSyncWriteJournal$$anonfun$writeMessages$1.apply(JdbcSyncWriteJournal.scala:22) scala.collection.Iterator$class.foreach(Iterator.scala:727) scala.collection.AbstractIterator.foreach(Iterator.scala:1157) scala.collection.IterableLike$class.foreach(IterableLike.scala:72) scala.collection.AbstractIterable.foreach(Iterable.scala:54) akka.persistence.jdbc.journal.JdbcSyncWriteJournal$class.writeMessages(JdbcSyncWriteJournal.scala:22) akka.persistence.jdbc.journal.OracleSyncWriteJournal.writeMessages(Journals.scala:16) akka.persistence.journal.SyncWriteJournal$$anonfun$receive$1$$anonfun$1.apply$mcV$sp(SyncWriteJournal.scala:27) akka.persistence.journal.SyncWriteJournal$$anonfun$receive$1$$anonfun$1.apply(SyncWriteJournal.scala:27) akka.persistence.journal.SyncWriteJournal$$anonfun$receive$1$$anonfun$1.apply(SyncWriteJournal.scala:27) scala.util.Try$.apply(Try.scala:161) akka.persistence.journal.SyncWriteJournal$$anonfun$receive$1.applyOrElse(SyncWriteJournal.scala:27) ... 20:50:36.056 [isb-akka.persistence.dispatchers.default-plugin-dispatcher-32] DEBUG s.StatementExecutor$$anon$1 - SQL execution completed [SQL Execution] INSERT INTO PSYS_AKKA.akka_journal (persistence_id, sequence_number, Depending on the oracle version different workarounds apply. http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
Unique representation ID for 5-card poker hand using combination without sorting Bad audio quality from two stage audio amplifier What is this strange almost symmetrical location in Nevada? java.sql.SQLException 17410 No more data from socket What is the fix and solution for this error? I am getting following error in an event of a webpage.
I'm running this on Mac (as well as you, I assume) bpg added a commit to bpg/akka-persistence-jdbc that referenced this issue Jan 23, 2015 bpg http://dba.stackexchange.com/questions/7691/oracle-no-more-data-to-read-from-socket posted 4 years ago from stack overflow http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error Tapan Prajapati Greenhorn Posts: 27 posted 4 years ago Koen Aerts wrote:Did you look in the DBMS log file and see if
posted 4 years ago Have you done any reseach into this issue, other than posting here, as I found a few intersting issues, involving db setup with certain oracle version, reporting Ora-17410 No More Data To Read From Socket More discussions in Java Database Connectivity (JDBC) All PlacesJavaDatabase ConnectivityJava Database Connectivity (JDBC) This discussion is archived 1 2 Previous Next 21 Replies Latest reply on Feb 28, 2012 9:38 PM Re: Oracle SQLException: No more data to read from socket Joe Weinstein-Oracle Feb 13, 2012 7:57 PM (in response to Subhadeep Roy) The version of the Oracle JDBC driver you're using This "no more data from socket" error may also be because your database doesn't support connection sharing (shared servers, a.k.a.
Like Show 0 Likes(0) Actions 5. You signed out in another tab or window. No More Data To Read From Socket Oracle 11g Can anybody pin point the problem area.. (11g DB) Thanks in Advance..!! Oracle 12c No More Data To Read From Socket Re: Oracle SQLException: No more data to read from socket Subhadeep Roy Feb 21, 2012 4:34 PM (in response to rp0428) Hi..
If you're using a listener, then it's probably in listener.log in the $ORACLE_HOME/diag and/or $ORACLE_HOME/network/log directories, otherwise do a search for either alert.log or log.xml file. his comment is here Not the answer you're looking for? Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count). Koen Aerts Ranch Hand Posts: 344 I like... No More Data To Read From Socket Oracle 10g
akka.persistence.jdbc.journal.OracleStatements$class.selectMessagesFor(Statements.scala:102) akka.persistence.jdbc.journal.OracleSyncWriteJournal.selectMessagesFor(Journals.scala:16) akka.persistence.jdbc.journal.JdbcSyncWriteJournal$$anonfun$asyncReplayMessages$1.apply$mcV$sp(JdbcSyncWriteJournal.scala:78) akka.persistence.jdbc.journal.JdbcSyncWriteJournal$$anonfun$asyncReplayMessages$1.apply(JdbcSyncWriteJournal.scala:78) akka.persistence.jdbc.journal.JdbcSyncWriteJournal$$anonfun$asyncReplayMessages$1.apply(JdbcSyncWriteJournal.scala:78) scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:401) scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) ... 20:49:33.083 [isb-akka.actor.default-dispatcher-21] DEBUG s.StatementExecutor$$anon$1 - SQL execution completed [SQL Execution] SELECT MAX(sequence_number) FROM PSYS_AKKA.akka_journal WHERE persistence_id = Reload to refresh your session. What would I call a "do not buy from" list? this contact form Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions Incoming Links Re: I got No more data to read from socket by SQLdeveloper.What shoud I do
I made some changes in unit tests to reproduce it, could you please take a look at bpg/[email protected] ? Java.sql.sqlrecoverableexception No More Data To Read From Socket Tomcat What happens when MongoDB is down? Feel free to ask questions on our Oracle forum.
I will let you know. Like Show 0 Likes(0) Actions 10. In Oracle 11gR1 this "no data from socket" is a hidden parameter issue with bind variable peeking, and you should make this change after contacting Oracle technical support: alter system set Ora-17410 Solution I get this error intermittently in JDBC.
Personal Open source Business Explore Sign up Sign in Pricing Blog Support Search GitHub This repository Watch 7 Star 91 Fork 45 dnvriend/akka-persistence-jdbc Code Issues 5 Pull requests 1 Projects Have your DBA check the DBMS error log to see if there is any hint of problems there, when you have this happen to you. To avoid seeing above error, you can increase this number by modifying datasource.xml file, under conf/ directory. navigate here Upgrading to the latest supported JDBC client is probably a good idea most of the time. –WW.
but no change in the error. Like Show 0 Likes(0) Actions 2. Can you connect to DB using sqlplus while logged onto DB server system? Limited number of places at award ceremony for team - how do I choose who to take along?
Post Reply Bookmark Topic Watch Topic New Topic programming forums Java Java JSRs Mobile Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and java -jar your.jar -Djava.security.egd=file:/dev/../dev/urandom your.main.Class bpg commented Jan 23, 2015 No, setting property java.security.egd did not help. It works fine but after leaving the project running for some time or when the database is stopped it throws the following error and it is unable to recover: 2014/12/05 09:25:23.887 Sign in to comment Contact GitHub API Training Shop Blog About © 2016 GitHub, Inc.
Just e-mail: and include the URL for the page. asked 4 years ago viewed 47160 times active 11 months ago Related 10create incremental number in oracle sql query2What to do with those invalid JAVA CLASS object type objects in SYS We are using 11g database. Owner dnvriend commented Jan 27, 2015 Hi Good find the merge statement! ☺ Makes you wonder why that is.
Were students "forced to recite 'Allah is the only God'" in Tennessee public schools? Reload to refresh your session. Where will be located this file? Watson Product Search Search None of the above, continue with my search java.sql.SQLException: No more data to read from socket No more data to read from socket Technote (troubleshooting) Problem(Abstract) java.sql.SQLException:
Also if I try to "reduce" the rownum filter to a lower level of records the query runs fine: where rownum<10 Searching on internet I have found that it could be Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Database Characterset is US7ASCII No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting