Creating an Oracle Table to Store Java Types
import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; publicclass Main { publicstaticvoid main(String[] argv) throws Exception { String driverName = "oracle.jdbc.driver.OracleDriver"; Class.forName(driverName); String serverName = "127.0.0.1"; String portNumber = "1521"; String sid = "mydatabase"; String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username = "username"; String password = "password"; Connection connection = DriverManager.getConnection(url, username, password); Statement stmt = connection.createStatement(); stmt.execute("CREATE TYPE number_varray AS VARRAY(10) OF NUMBER(12, 2)"); stmt.execute ("CREATE TYPE my_object AS OBJECT(col_string2 VARCHAR(30), col_int2 INTEGER)"); // Column Name Oracle Type Java Type String sql = "CREATE TABLE oracle_all_table(" + "col_short SMALLINT, "// short + "col_int INTEGER, "// int + "col_float REAL, "// float; can also be NUMBER + "col_double DOUBLE PRECISION, "// double; can also be FLOAT or NUMBER + "col_bigdecimal DECIMAL(13,0), "// BigDecimal + "col_string VARCHAR2(254), "// String; can also be CHAR(n) + "col_characterstream LONG, "// CharacterStream or AsciiStream + "col_bytes RAW(2000), "// byte[]; can also be LONG RAW(n) + "col_binarystream RAW(2000), "// BinaryStream; can also be LONG RAW(n) + "col_timestamp DATE, "// Timestamp + "col_clob CLOB, "// Clob + "col_blob BLOB, "// Blob; can also be BFILE + "col_array number_varray, "// oracle.sql.ARRAY + "col_object my_object)"; // oracle.sql.OBJECT stmt.executeUpdate(sql); } } Related examples in the same category
