|
static void | main (String[] args) |
|
|
static final Logger | logger = LoggerFactory.getLogger(FirstTry.class) |
|
static final String | JDBC_DRIVER = "com.omnisci.jdbc.OmniSciDriver" |
|
static final String | DB_URL = "jdbc:omnisci:localhost:6273:omnisci:http" |
|
static final String | USER = "admin" |
|
static final String | PASS = "HyperInteractive" |
|
Definition at line 25 of file FirstTry.java.
◆ main()
static void FirstTry.main |
( |
String [] |
args | ) |
|
|
inlinestatic |
Definition at line 36 of file FirstTry.java.
37 Connection conn = null;
38 Statement stmt = null;
44 logger.info(
"Connecting to database...");
51 PreparedStatement ps = null;
74 logger.info(
"Creating statement...");
75 stmt = conn.createStatement();
77 sql =
"SELECT uniquecarrier from flights_2008_7M limit 5";
78 rs = stmt.executeQuery(sql);
85 String uniquecarrier = rs.getString(
"uniquecarrier");
89 logger.info(
"uniquecarrier: " + uniquecarrier);
94 logger.info(
"Doing prepared statement");
97 sql =
"SELECT uniquecarrier from flights limit 5";
98 ps = conn.prepareStatement(sql);
100 rs = ps.executeQuery();
107 String uniquecarrier = rs.getString(
"uniquecarrier");
111 logger.info(
"PS uniquecarrier: " + uniquecarrier);
117 DatabaseMetaData dbmeta = conn.getMetaData();
119 rs = dbmeta.getSchemas();
121 String schema = rs.getString(
"TABLE_SCHEM");
122 logger.info(
"TABLE_SCHEM: " + schema);
125 rs = dbmeta.getTableTypes();
127 String schema = rs.getString(1);
128 logger.info(
"TYPE: " + schema);
135 }
catch (SQLException se) {
137 se.printStackTrace();
138 }
catch (Exception e) {
147 }
catch (SQLException se2) {
153 }
catch (SQLException se) {
154 se.printStackTrace();
static final String JDBC_DRIVER
static final String DB_URL
◆ DB_URL
final String FirstTry.DB_URL = "jdbc:omnisci:localhost:6273:omnisci:http" |
|
staticpackage |
◆ JDBC_DRIVER
final String FirstTry.JDBC_DRIVER = "com.omnisci.jdbc.OmniSciDriver" |
|
staticpackage |
◆ logger
final Logger FirstTry.logger = LoggerFactory.getLogger(FirstTry.class) |
|
staticpackage |
◆ PASS
final String FirstTry.PASS = "HyperInteractive" |
|
staticpackage |
◆ USER
final String FirstTry.USER = "admin" |
|
staticpackage |
The documentation for this class was generated from the following file:
- /home/jenkins-slave/workspace/core-os-doxygen/java/omniscijdbc/src/test/java/FirstTry.java