import oracle.jdbc.driver.*;
import oracle.xml.sql.query.OracleXMLQuery;
import java.lang.*;
import java.sql.*;

public class xsuGet {
  public static void main(String[] argv) throws SQLException {
    try {
      Class.forName ("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
        System.out.println ("Could not load the driver");
        return;
      }
    Connection conn =
        DriverManager.getConnection(
          "jdbc:oracle:thin:@tinman.cs.gsu.edu:1521:sid9ir2",
          "book","book");

    // Create the query class.
    OracleXMLQuery qry = new OracleXMLQuery(conn, "select * from cat");

    // Get the XML string
    String str = qry.getXMLString();

    // Print the XML output
    System.out.println(" The XML output is:\n"+str);
    qry.close();
    conn.close();
  }
}