title: JDBC insert query does not insert record in oracle database
body: <p>I have established the database connection successfully but not when I run this code through Java , my code keeps running and nothing happens.
  Nothing means neither it is inserting into database nor giving me any exceptions.</p>
  
  <p>I am using spatial data types from Oracle 11g (MDSYS.SDO_POINT_TYPE). I ran this query in Oracle 11g database directly and it works fine , but somehow does not insert the record when I use it through java code.</p>
  
  <p>I also tried with a simple student table and was able to insert statement it using java.</p>
  
  <p>Here is my snippet:</p>
  
  <pre><code>String insert = "insert into table1 values('p0', MDSYS.SDO_POINT_TYPE(228,102, null))";
      try
      {
          Statement statement = connection.createStatement();
          statement.executeUpdate(insert);
          System.out.println("Inserted record in the table");
      }catch(SQLException e)
      {
          System.out.println("Error due to SQL Exception");
          e.printStackTrace();
      }
      try
      {
  
          connection.close();
          System.out.println("Closing the connection");
      }catch(SQLException e)
      {
          System.out.println("Error in closing connection");
          e.printStackTrace();
      }
  </code></pre>
  
  <p>Connection JDBC is :</p>
  
  <pre><code>try {
          Class.forName("oracle.jdbc.driver.OracleDriver");
  
      } catch (ClassNotFoundException e) {
          System.out.println("Where is your Oracle JDBC Driver?");
          e.printStackTrace();
      }
      System.out.println("Oracle JDBC Driver Registered!");
  
      Connection connection = null;
  
      try {
  
          connection = DriverManager.getConnection(
                  "jdbc:oracle:thin:@localhost:1521:db11g", username,
                  pass);
  
  
      } catch (SQLException e) {
          System.out.println("Connection Failed!");
          e.printStackTrace();
      }
      if (connection != null) {
          System.out.println("Database connected");
      } else {
          System.out.println("Failed to connect the database");
      }
      return connection;
  </code></pre>