Package java.sql

Examples of java.sql.CallableStatement.executeQuery()

277
278
279
280
281
282
283
284
285
286
287
            assertEquals(rs.getString(1), "SYSTEM_LOBS");
            assertEquals(rs.getString(2), "LOBS");
            rs.close();
        }

        rs = cs.executeQuery();

        rs.next();
        assertEquals(rs.getString(1), "SYSTEM_LOBS");
        assertEquals(rs.getString(2), "LOB_IDS");
        rs.close();
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
                    r.getBytes(2));

            System.out.println(temp);
        }

        r = s.executeQuery();

        s = c.prepareCall("CALL TEST_CUSTOM_RESULT(6, 1900)");

        try {
            s.execute();
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
      return (melodies);
    }

    try {
      statement = connection.prepareCall("{ call get_all_melodies() }", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
      result = statement.executeQuery();

      while (result.next() != false) {
        Melody melody = new Melody();
        melody.setId(result.getLong("system_id"));
        String sequence = result.getString("sequence");
View Full Code Here
402
403
404
405
406
407
408
409
410
411
412
        System.out.println("Standard parsing/execution: " + elapsedTime
            + " ms");

        storedProc = this.conn.prepareCall("{call testSpParse(?)}");
        storedProc.setString(1, "abc");
        this.rs = storedProc.executeQuery();

        assertTrue(this.rs.next());
        assertTrue(this.rs.getInt(1) == 1);

        Properties props = new Properties();
View Full Code Here
427
428
429
430
431
432
433
434
435
436
437
        System.out
            .println("Cached parse stage: " + elapsedTime + " ms");

        storedProc = cachedSpConn.prepareCall("{call testSpParse(?)}");
        storedProc.setString(1, "abc");
        this.rs = storedProc.executeQuery();

        assertTrue(this.rs.next());
        assertTrue(this.rs.getInt(1) == 1);

      } finally {
View Full Code Here
474
475
476
477
478
479
480
481
482
483
484
         try
         {
            CallableStatement ps = con.prepareCall(query);
            try
            {
               ResultSet rs = ps.executeQuery();
               while( rs.next() )
               {
                  value = rs.getString(1);
               }
               rs.close();
View Full Code Here
785
786
787
788
789
790
791
792
793
794
795
    ResultSet rs = null;

    try
    {
      stmt = c.prepareCall("{ call sp_helpuser }");
      rs = stmt.executeQuery();
      while (rs.next())
      {
        String userName = rs.getString(1);
        String loginName = rs.getString(3);
View Full Code Here
837
838
839
840
841
842
843
844
845
846
847
        buf.append("'\nGO\n\n");

        /* add users to the role. */
        userStmt = c.prepareCall("{ call sp_helprolemember ? }");
        userStmt.setString(1, roleName);
        userRs = userStmt.executeQuery();

        while (userRs.next())
        {
          String userInRole = userRs.getString(2);
          buf.append("exec sp_addrolemember N'");
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
    {
      stmt = c.prepareCall("{ call sp_helpconstraint ?, ? }");
      stmt.setString(1, oi.getSimpleName());
      stmt.setString(2, "nomsg");

      rs = stmt.executeQuery();

      while (rs.next())
      {
        String constraintType = rs.getString(1);
        String constraintName = rs.getString(2);
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
    try
    {
      stmt = c.prepareCall("{ call sp_helptext (?) }");
      stmt.setString(1, objectName);
      helpText = stmt.executeQuery();
      while (helpText.next())
      {
        buf.append(helpText.getString(1));
      }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.