title: Oracle 11g Express Java JDBC; Database Workspace
body: <p>I am experiencing some difficulty getting to the <code>Oracle 11g Express Workspace</code> in which resides my database.</p>
  
  <p>I am able to register my <code>JDBC Driver</code> via <code>Class.forName("jdbc.oracle.driver.OracleDriver")</code> and to connect successfully via <code>Connection con = DriverManager.getConnection("jdbc:oracle:thin:" + username + "/" + password + "@localhost:1521:xe")</code> but not able to get into the workspace containing the database I created.</p>
  
  <p>Any attempt to create a database via <code>Statement smt = Connection.createStatement()</code> yields a <code>java.lang.UnsupportedOperationException</code>.</p>
  
  <p>I am not even sure if I am connected to the right place.  I know when I look into the Oracle Database 11.2 XE parameters it lists the <code>db_name</code> as <code>xe</code> and I can connect to it via the <code>sys as sysdba</code> and using the password I established for the Oracle 11g Express database but I can't get into the workspace when I had created a database and utilized <code>ddl</code> and <code>dml</code> statements to populate it.</p>
  
  <p>Perhaps I simply don't know what to do at this point because I am new to JDBC.  I checked my TNSNAMES.ORA file and indeed there is an <code>XE</code> entry representing my Oracle 11g Express as well as other entries representing databases in Oracle.  I think I am there I just don't know what to do to get to my <code>XE</code> database I created.</p>
  
  <p>The code I am using to execute a SQL statement is as follows:</p>
  
  <pre><code>    Statement smt = null;
  
  
      try {
          smt = connection.createStatement();
  
          String command = "CREATE table x(y varchar(2))";
  
          smt.executeLargeUpdate(command);
  
      } catch (SQLException e) {
          // TODO Auto-generated catch block
          System.out.println(e.getMessage() + e.getCause());
      }
  </code></pre>