Package java.sql

Examples of java.sql.Connection

94
95
96
97
98
99
100
101
102
103
104
                userName = pc.getUserName();
                xacon = getXADataSource().
                    getXAConnection(userName,
                                    new String(pc.getPassword()));
            }
            Connection con = xacon.getConnection();
            return new CciManagedConnection
                (this, pc, xacon, con, true, true);
        } catch (SQLException ex) {
            ResourceException re =
                new EISSystemException("SQLException: " + ex.getMessage());
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
      info.setProperty(TeiidURL.CONNECTION.USER_NAME, user);
    }
    if (password != null) {
      info.setProperty(TeiidURL.CONNECTION.PASSWORD, password);
    }
    Connection c = TeiidDriver.getInstance().connect(url, info);
    if (c == null) {
      throw new SQLException("Invalid url " + url);
    }
    return new TeiidSql(c);
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
   }

   protected void initDatabase() throws Exception
   {
      DataSource ds = (DataSource)new InitialContext().lookup(datasource);
      Connection conn = ds.getConnection();
      boolean load = false;

      Statement st = conn.createStatement();
      ResultSet rs = null;
      try
      {
         rs = st.executeQuery(existsSql.trim());
         rs.close();
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
 
  /* (non-Javadoc)
   * @see org.hibernate.connection.ConnectionProvider#getConnection()
   */
  public Connection getConnection() throws SQLException {   
    final Connection conn = dataSource.getConnection();
    if(useProxy && conn!=null){
      return (new _Connection(conn,encoding)).getConnection();
    }
    return conn;
  }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
    Statement statement;
    String SQLQuery = "SELECT LJLEVEL, LCODE, nvl(LSYSLOGEQUIV,LLEVEL)  LSYSLOGEQUIV " +
                        "FROM TLOGLEVEL " +
                    "ORDER BY LLEVEL";
    ResultSet rs = null;
    Connection jdbc_conn = null;
         
    if (formatOK == false)
    {
      logger.log(Level.FATAL, "Connection parameters are not OK");   
    }
    else
    { 
      try{
        // connect to database
        Class.forName("oracle.jdbc.driver.OracleDriver");
        jdbc_conn = DriverManager.getConnection(JDBCurl, DbUser, DbPass);
         
        logger.debug( "JDBC Connection OK: " + jdbc_conn.toString());
         
        // get the PL/SQL and corresponding LOG4J log levels
        statement = jdbc_conn.createStatement();
        rs = statement.executeQuery(SQLQuery);
           
        if (rs != null)
        {
          while(rs.next())
          {
            Level l = new DynamicLevel (rs.getInt("LJLEVEL"),rs.getString("LCODE"),rs.getInt("LSYSLOGEQUIV"));
                Integer levelint = new Integer(rs.getInt("LSYSLOGEQUIV"));
             
                htLevels.put(levelint, l);
          }
        }
         
        // close the connection
        jdbc_conn.close();   
      }
      catch (SQLException SQLe) {
        logger.fatal("SQL error : " + SQLe);
      }
      catch (Exception e) {
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
  public Object invoke(Object proxy, Method m, Object args[])  throws Throwable
  {
    if (METHOD_NAME.equals(m.getName())){
      try {
        Connection conn = (Connection) m.invoke(dataSource, args);
        return (conn==null)?null:(new _Connection(conn,encoding)).getConnection();
      } catch (InvocationTargetException e) {
        throw e.getTargetException();
      }
    }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
    }
  }
 
  public static void testCreateTable() throws Exception{
    Class.forName("org.hsqldb.jdbcDriver");
    Connection conn = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost","sa","");
    PreparedStatement ps = null;
    ResultSet rs = null;
    try{
      //ps = conn.prepareStatement("create table dlog_bookmark (markid INTEGER,logid INTEGER,siteid INTEGER,userid INTEGER,marktype INTEGER,createTime DATE,markorder INTEGER);");
      //ps.executeUpdate();
     
      ps = conn.prepareStatement("SELECT * FROM dlog_user");
      rs = ps.executeQuery();
      while(rs.next()){
        System.out.println(rs.getString("displayName"));
      }
    }finally{
      if(rs!=null)
        rs.close();
      if(ps!=null)
        ps.close();
      if(conn!=null)
        conn.close();
    }
  }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
    /**
     * Connection to db and return the connection.
     */
    private static Connection createConnection() {
        Connection conn = null;
        try {
            conn = dataSource.getConnection();
        } catch (SQLException e) {
            LOG.fatal(e);
        }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
     */
    public Connection getConnection(boolean share) {
        if(share && sharedConnection != null) {
            return sharedConnection;
        } else {
            Connection conn = createConnection();
            if(share && sharedConnection == null) {
                sharedConnection = conn;
            }
            return conn;
        }
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
197
198
199
     * @throws QueryTestFailedException
     */
    public Connection getSource(String identifier)
      throws QueryTestFailedException {
 
  Connection conn = this.connStrategy.createDriverConnection(identifier);
  // force autocommit back to true, just in case the last user didnt
  try {
    conn.setAutoCommit(true);
  } catch (Exception sqle) {
    throw new QueryTestFailedException(sqle);
  }
 
  return conn;
View Full Code Here
TOP

Related Classes of java.sql.Connection

  • co.nubetech.hiho.hive.HiveUtility
  • co.nubetech.hiho.job.TestExportToDB
  • co.nubetech.hiho.job.TestExportToMySQLDB
  • com.acme.JNDITest
  • com.alibaba.wasp.jdbc.TestJdbcConnectionPool
  • com.alibaba.wasp.jdbcx.JdbcXAConnection
  • com.alimama.mdrill.adhoc.MysqlCallback
  • com.alimama.mdrill.adhoc.MysqlInfo
  • com.alimama.mdrill.ui.service.UserJson
  • com.alimama.web.TableJoin
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.