resultset « oracle « Java Database Q&A

  1. Java Database Q&A
  2. oracle
  3. resultset




1. ResultSet.getBlob() Exception    stackoverflow.com

The Code: 

ResultSet rs = null;

try { 
    conn = getConnection();
    stmt = conn.prepareStatement(sql);
    rs = stmt.executeQuery();

    while (rs.next()) {
 ...

2. c3p0 ResultSet.unwrap throws an AbstractMethodError    stackoverflow.com

I have a ResultSet object that I need to turn into an OracleResultSet so that I can call the getOPAQUE(String) method on it. I'm using c3p0 as my connection pool. The ...

3. Getting a ResultSet/RefCursor over a database link    stackoverflow.com

From the answers to http://stackoverflow.com/questions/1122175/calling-a-stored-proc-over-a-dblink it seems that it is not possible to call a stored procedure and get the ResultSet/RefCursor back if you are making the SP call across ...

4. ResultSet.getTimestamp("date") vs ResultSet.getTimestamp("date", Calendar.getInstance(tz))    stackoverflow.com

java.util.Date, java.util.Timetamp were seems to be causing great confusion for many. Within StackOverflow there are so many questions, Unfortunately my question is bit twisted. There are 2 JDBC api. How they should ...

5. Why is retreiving a ResultSet from Oracle stored procedure soooo slow?    stackoverflow.com

I have to improve some code where an Oracle stored procedure is called from a Java program. Currently the code is really really slow : up to about 8 seconds on ...

6. JDBC ResultSet getDate losing precision    stackoverflow.com

I am losing precision in my ResultSet.getDate(x) calls. Basically: 

rs = ps.executeQuery();
rs.getDate("MODIFIED");
is returning dates truncated to the day where MODIFIED is an Oracle TIMESTAMP field of default precision. I think ...

7. JDBC - Resultset data processing : Strange behaviour : default fetchsize returned    stackoverflow.com

I have a oracle(10.2) PLSQL procedure which fetches 15 records from a table in a sysrefcursor. I then pass this cursor to a java class as a resultset. This java class is ...

8. How do I get the schema name from a resultset in Oracle using jdbc?    stackoverflow.com

I want to run a query on an Oracle database and for each column in the result set, I want to know the schema that the column came from. I ...

9. Populate Java table with resultSet    stackoverflow.com

I'm building a java application that gets its data from an oracle database and puts it into a JTable. My problem is I am not able to populate the table, I ...





10. Little Confusion (ResultSets, OracleDB, JAVA)    stackoverflow.com

I can successfully connect to an oracle database and print out the list of all table names using the getAllTableNames() method. My next Idea is to filter specific tables and display all ...

11. First ResultSet.next() call is taking more then a minute    stackoverflow.com

I am using JDBC api to call a store procedure. Which returns a cursor. Problem I am facing is, first two call of ResultSet.next() take more then a minute to return ...

12. null ResultSet exception    stackoverflow.com

I want to connect to oracle and get some records. 

java.sql.ResultSet r = s.executeQuery("Select * from table1");
while (r.next()==true) {
    System.out.println(r.getString("column1").toString());  
      ...

13. CachedRowSet slower than ResultSet?    stackoverflow.com

in my java code, i access an oracle database table with an select statement. i receive a lot of rows (about 50.000 rows), so the 'rs.next()' needs some time to process all ...

14. Get ResultSet from Stored Procedure in Oracle from Java    stackoverflow.com

I've been looking through many posts in the forum related to my problem but I nothing helped me, so I'm posting my problem. I have a SP in Oracle (11g) ...

15. How to deal with pagination for a large, non materializable resultset in Oracle and Java    stackoverflow.com

I'm dealing with some sort of problem here. A web application built on java stuff calls a stored procedure in oracle which has as out parameters some varchars and a parameter ...

16. ResultSet not populating with results    stackoverflow.com

I am attempting to pull results from an Oracle database. I have written a query that is correct, and produces accurate results when issued manually in sqlplus. Furthermore, the code works ...





17. How to create Oracle stored procedure and return ResultSet as OUT param...?    coderanch.com

18. Problem in getting multiple resultsets from Oracle Stored Procedure    coderanch.com

Hi java gurus, I'm using Websphere 3.5 standard edition with Oracle 8i as backend. I'm trying to access multiple resultsets thru oracle stored procedure. ----------------------------- PROCEDURE add_Person ( pPersonId IN INTEGER, pCountry OUT tCursor, pPerson OUT tCursor) as BEGIN OPEN pCountry FOR SELECT CTRY_CODE,DESC FROM COUNTRY; OPEN pPerson FOR SELECT * FROM PERSONS WHERE PERSON_ID = pPersonId; END; END; --------------------- This ...

19. Scrollable ResultSet (multipage) - Oracle 7 JDBC 2.0 driver    coderanch.com

20. Bug in ResultSet.getBytes() in Oracle 9i thin driver???    coderanch.com

We are facing some errors while trying to retrieve binary data using byte[] b = ResultSet.getBytes() on a PreparedStatement object. The problem happens from time to time & is consistently reproducable. We are using Oracle 9i thin drivers on a 8.1.7 database. The column type is LONG RAW. The errors are either: 1) Stream closed Exception 2) IOException : Protocol violation ...

21. ResultSets in Oracle does not see own inserts    coderanch.com

22. Error Retreiving a resultset from an oracle stored procedure    coderanch.com

23. Oracle Clob ResultSet Type    coderanch.com

24. getting ResultSet from Oracle procedure    coderanch.com

25. Cannot Insert Colum Into Resultset Oracle    coderanch.com

Hi Friends, Any help regarding this would be welcomed. Please Help me.I am new to J2EE Programming.Our web project which we deploy on Tomcat 5.0.28 works perfectly fine when connected to Sybase ASA Database we have a new client requirement for which we have to connect it using Oracle 9i as the database.For doing the same i installed Oracle 9i(i have ...

26. ResultSet Update problem with Oracle 9i using JDBC    coderanch.com

27. updateable and scrollable resultset for oracle driver    coderanch.com

I created an updateable and scrollable Resultset for Oracle database. I can update a specific column and scroll down and up too. I can insert a row in insert row too. If i commit (its setted to autocommiting to false) the connection then it places the row to table too. But The problem is ; for some reason i can't see ...

28. Resultset in Java using Oracle    coderanch.com

29. How to define ResultSet limit by PL/SQl in Oracle database    coderanch.com

30. Oracle Stored Proc not returning ResultSet    coderanch.com

Connection con = session.connection(); List returnListProc = new ArrayList(); try{ String s = q.getQueryString(); CallableStatement call = con.prepareCall (s); int numberOfInputParams = params.length; for(int i=0; i

31. How to create Multiple Resultset in oracle    coderanch.com

32. Oracle Resultset slow    java-forums.org

I have a problem with an Oracle Resultset using jdbc. It works about once a week when doing a simple long value = results.getLong("value"); the process will hang and start spinning and use up about 75% of the CPU on the server. The only way to get it going again is to kill it and restart. As you can guess the ...

33. oracle update statement within the resultset is not working.pls see code.    java-forums.org

Hi This code below is not updating the table with the date created from the ID obtained from the select clause. I have created 2 statement objects one for select query and one for update ...can some one help me with updating the table for every new date created using the ID. Any help is apprecaited.Thanks in advance. Java Code: try ...

34. Getting problem in retreiving date from resultset from Oracle databse    forums.oracle.com

I tried retreiving both ways : 1> Timestamp ts = rs.getTimestamp(10); which is a column of type date with value 10/09/2007 07:11:16 . String str = ts.toString(); try{ SimpleDateFormat sf = new SimpleDateFormat ("dd-MM-yyyy hh:mm:ss a"); Date dt = sf.parse(str); } catch(ParseException ex){ } But I am getting it as 10-09-2007 00:00:00 I want it to be 10-09-2007 07:11:16 Thanks in ...