The Code:
ResultSet rs = null;
try {
conn = getConnection();
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while (rs.next()) {
...
|
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 ... |
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 ... |
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 ...
|
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 ... |
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 ... |
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 ... |
|
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 ... |
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 ... |
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 ... |
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 ... |
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());
...
|
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 ... |
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) ... |
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 ... |
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 ... |
|
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 ... |
|
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 ... |
|
|
|
|
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 ... |
|
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 ... |
|
|
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 |
|
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 ... |
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 ... |
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 ... |