Guest User

Untitled

a guest
Apr 9th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.83 KB | None | 0 0
  1. con = DriverManager.getConnection(url, props);
  2.  
  3. String url = "jdbc:oracle:thin:@localhost:1158:searchengine";
  4.  
  5. //properties for creating connection to Oracle database
  6. Properties props = new Properties();
  7. props.setProperty("user", "sys");
  8. props.setProperty("password", "1234");
  9.  
  10. //creating connection to Oracle database using JDBC
  11. try
  12. {
  13. //Class.forName("oracle.jdbc.OracleDriver");
  14. con = DriverManager.getConnection(url, props);
  15. //con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1158:searchengine", "system", "1234");
  16. String query = "alter session set nls_calendar='Persian'";
  17. PreparedStatement pr = con.prepareStatement(query);
  18. pr.execute();
  19. query = "select sysdate from dual";
  20. pr = con.prepareStatement(query);
  21. ResultSet res = pr.executeQuery();
  22. while (res.next())
  23. {
  24. System.out.println(res.toString());
  25. }
  26. }
  27. catch (Exception e)
  28. {
  29. e.printStackTrace();
  30. return false;
  31. }
  32.  
  33. java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
  34. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
  35. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
  36. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
  37. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  38. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
  39. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  40. at java.sql.DriverManager.getConnection(DriverManager.java:208)
  41. at Controllers.DBController.connect(DBController.java:24)
  42. at Wrapper.TestMain.start(TestMain.java:21)
  43. at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$162(LauncherImpl.java:863)
  44. at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$175(PlatformImpl.java:326)
  45. at com.sun.javafx.application.PlatformImpl.lambda$null$173(PlatformImpl.java:295)
  46. at java.security.AccessController.doPrivileged(Native Method)
  47. at com.sun.javafx.application.PlatformImpl.lambda$runLater$174(PlatformImpl.java:294)
  48. at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:95)
  49. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  50. at com.sun.glass.ui.win.WinApplication.lambda$null$148(WinApplication.java:191)
  51. at java.lang.Thread.run(Thread.java:745)
  52. Caused by: oracle.net.ns.NetException: Got minus one from a read call
  53. at oracle.net.ns.Packet.receive(Packet.java:311)
  54. at oracle.net.ns.NSProtocol.connect(NSProtocol.java:300)
  55. at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
  56. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
Add Comment
Please, Sign In to add comment