Query « oracle « Java Database Q&A





1. Why isn't querying a JDBC-compliant database from Oracle as easy as pie?    stackoverflow.com

Ok, so it's almost as easy as pie already. But it really should be as easier than it is. I think I should be able to connect to another database just by ...

2. Java library or code sample to parse CTXCAT query syntax (for Oracle CATSEARCH)    stackoverflow.com

I am interested in pre-parsing a user's input via Java for valid CTXCAT syntax before it is used to search against an Oracle CATSEARCH implementation (http://www.oracle.com/technology/products/text/htdocs/ctxcat_primer.html). The reason being is ...

3. Concurrent queries on a given JDBC connection?    stackoverflow.com

I'm seeing OraclePreparedStatement executeQuery() exhibit serialization. That is, I have two queries that I want to run concurrently against an Oracle database, using the same connection. However, the OraclePreparedStatement ...

4. How to convert Oracle "TIME" to JDBC Time in query?    stackoverflow.com

Oracle doesn't support the TIME datatype, but you can use DATE to store a TIME. My problem:

select to_date('2009-06-30', 'YYYY-MM-DD') as "DATE",
       to_date('16:31:59', 'HH24:MI:SS') as "TIME"
from dual
yields:
DATE ...

5. JDBC: How can I query by time in Oracle?    stackoverflow.com

I have this JDBC SQL query:

select *
from table
where TX_DATE = {d '2009-01-05'} and TX_TIME = {t '15:23:39'}
This returns some rows. Note that, since Oracle has no TIME type, both columns are ...

6. Simulation of long-running Oracle DB query    stackoverflow.com

What is the simplest (preferably without any new table creation) way of running a database query which takes long time (at least several minutes) in Oracle DB?

7. What locale should I use for case-insensitive queries from Java?    stackoverflow.com

The classic way to query an SQL database case-insensitively from Java is as follows:

String name = ...;  // get the user's input (case is unknown)
String sql = "select * from ...

8. How is Oracle's JDBC query timeout implemented?    stackoverflow.com

I was curious as to how the Oralce JDBC thin client implement query timeout. This can be set by calling java.sql.Statement's setQueryTimeout(int seconds) method. Is this implemented in the driver itself on the client ...

9. (Design Idea) Best Practise to reserve record for multi-process workflow engine    stackoverflow.com

I'm designing multiple process to query job from database. Each job wake up once per minute to query task and send to workflow system. I need advice about which best way to mask ...





10. JDBC query to Oracle    stackoverflow.com

We are planning to migrate our DB to Oracle.We need to manually check each of the embedded SQL is working in Oracle as few may follow different SQL rules.Now my need ...

11. Oracle: where can I query java grants?    stackoverflow.com

I need to check the current user's java grants, something similar to what has been set by:

dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect');
Can this be done without system privs from the current account? ...

12. How to handle massive data query and control the time within 1 sec?    stackoverflow.com

I am thinking through a problem, if I get a table, and the data in it keep growing, thousand, million, billion ....
One day, I think even a simple query it will ...

13. Java web application & database design    stackoverflow.com

I have developed a work flow web application in Java with an Oracle backend. The workflow requires the user to complete a series of checklists.
I started the project using 2 tables ...

14. how to check if a value exists in table or not in java?    stackoverflow.com

can any one suggest me that how can i check if value entered by user is exist in some specific table or not through javaCode? Thanks in advance!!!

15. Oracle - Berkeley DB XML Java API - XML query to get attribute values at multiple level    stackoverflow.com

Evaluating Berkeley DB with Java APIs. Following is one of my test XML data:

<master>
    <env name="development">
        <server name="tomcat1" ip="122.122.123.1">
   ...

16. Optimize the speed on performing "select" query in a big loop    stackoverflow.com

I'm performing a simple 'select' query in a Java loop as what is shown below. The size of the List can grow up to 10000+. How can I improve the query ...





17. Oracle DB query data_length(what's it return)    stackoverflow.com

I am running some queries on an Oracle DB from my java program. Once a certain table is selected this query runs and returns some traits for the user. A simplified version ...

18. Save result of XSQL query to a file in Java    stackoverflow.com

I want to Save result of an XSQL query to a file using Java. Does any one know a way to do this?

19. Oracle DB Query Runs in sqlDev but not in Java Program    stackoverflow.com

I have been messing with Oracle DB queries that run from my JAVA app. I can successfully get them all to run in sqldeveloper. But when I am trying to execute ...

20. The obsession of Java Socket and Oracle    stackoverflow.com

all. First,forgive my poor English. I suppose my Android client to post data to the TCP server that I created with using the java NIO . So the TCP Server can get data from ...

21. Query view joining two tables over dblink does not work the first time    stackoverflow.com

I have a oracle 10g database A and B connected over a dblink and a view (rvs_duedate_view) which joins a table A.rvsduedate and B.rlstatus. Within a junit test I insert data ...

22. Query returning values from Oracle and no records when run from Java    stackoverflow.com

This query is returning the record with Min Create time Stamp for the Person Pers_ID when I run it in SQL Developer and the same query is not returning any value ...

23. Need advice on fixing my JAVA query statement?    stackoverflow.com

My JAVA script consists of 2 JAVA classes: RMS, queryRMS In the RMS class I call the method in the queryRMS class RMS Java Class (I left out the start execution part, below ...

24. JDBC oracle newbie query    coderanch.com

Hello everyone, I am a new user to both JDBC and Oracle and am unable to proceed with the following queries. It would be helpful if someone can assist me with the same. The schema for a store is: user (uid, addr) region (rid, rname) shop (sid, rid) category (cid, cname) product (pid, cid, pname, cost) transaction (tid, uid, sid, date) ...

25. How to pass values to a Oracle query with a IN clause    coderanch.com

Hi, May be the String that you are setting to the prepared statement would be treated as one String arguement..so the final Query would look like SELECT * FROM test WHERE a IN (' '0515','0514','0516' '); // Note the Quotes I dont know if this should actually result in an SQLException. try using SELECT * FROM test WHERE a IN (?,?,?); ...

26. Querying Oracle for information between a time period    coderanch.com

Hi, I would like to query Oracle 9i database to get information from a table between a given time period. My code passes me two Strings, which I convert into date (using SimpleDateFormat). One of these strings correspond to "Start Date" and the other one refers to "End Date". E.g, Start Date can be "11/23/2004" and End Date can be "12/23/2004". ...

27. Oracle Query    coderanch.com

Select the count of each using count(*) in the SQL query and then add the results which can also be done in the same SQL statement. Depending on your grouping requirements though, you might get duplicates (for example if the same parent reference appears in both child tables). Again, your requirements would dictate how to proceed, but if you need the ...

28. how to access MSAccess and Oracle in one query    coderanch.com

Welcome to JavaRanch. While with some DBs it is possible to retrieve data from two of them in the same query, there is no way to do that if you have two different kinds of databases. You will have to write two queries. It is possible to come up with a transaction that spans two different kinds of databases, but not ...

29. using :new in oracle JDBC Query    coderanch.com

30. Oracle driver query    coderanch.com

31. Querying Oracle with Java for To_Date    coderanch.com

I am attempting to query an oracle DB with Java. I'm brand new to Java so just learning, learning about Oracle too. I would like the results to be all entries that are before and including 7/6/2006, regardless of the time. But the oracle field is a date & time field. This is the baseline query I am attempting to modify. ...

32. Querying Oracle with Java for To_Date    coderanch.com

I am attempting to query an oracle DB with Java. I'm brand new to Java so just learning, learning about Oracle too. I would like the results to be all entries that are before and including 7/6/2006, regardless of the time. But the oracle field is a date & time field. This is the baseline query I am attempting to modify. ...

33. Problem with Oracle Query    coderanch.com

34. query in oracle    coderanch.com

35. Oracle update query question    coderanch.com

Probably not the ideal forum to post this, but I know you tend to get quick resulst here so I thought I'd give it a go. I have a tabel where I need to update a column, but I can only find the ID of that record by search a second table. Basically the pseudo code query is... Update table1 status='Effective' ...

36. Oracle Query is not running    coderanch.com

SQL> ed Wrote file afiedt.buf 1 merge 2 into expertise t1 3 using (select 5 expertise,1 emp_id from dual) t2 4 on (t1.emp_id = t2.emp_id and t1.expertise = t2.expertise) 5* when not matched then insert(expertise,emp_id) values(t2.expertise,t2.emp_id) SQL> / 1 row merged. SQL> ed Wrote file afiedt.buf 1 merge 2 into expertise t1 3 using (select 5 expertise,1 emp_id from dual) t2 ...

37. Can't access Oracle Schema for query    coderanch.com

I have a sales database with a customers table, but when I do a "select * from customers", Oracle tells me the table or view does not exist. Huh? If I go into SQL*PLUS and connect to sales ("Successful"), then do a SELECT * FROM CAT, I see the tables in the sales database (schema), including the customers table. The only ...

38. Query works with Oracle but not with java/jdbc    coderanch.com

Hello, has anyone seen a problem similar to this? I'm executing the following procedure with a PreparedStatement (no ? parameters). The section with 'VA' and current_date [or (stat_cd = 'VA' and updt_dts < current_date - 30/1440))] doesn't work - however the query works perfectly if I run it using SQLDeveloper or Toad for Oracle! Any ideas? Thanks. SELECT crte_dts, crte_usr_id, dm_3pty_ref_num, ...

39. Oracle Queries performace    coderanch.com

Hi I would like to know how we can imrove oracle queries performance. For example i have following sample queries which i need to optimize. 1) select count(0) totalCount from analyst_call_log rl,analyst_team at, (select associate_id from associate)creted_by_detail where rl.added_by_assoc_id = creted_by_detail.associate_id and at.associate_id = rl.added_by_assoc_id and at.team_id = rl.team_id and rl.confidential != 'Y' and rl.analyst_call_log_id in(select ac.analyst_call_log_id from analyst_call_log_contact ac where ...

40. A query regarding using GROUP BY using Oracle as DataBase    coderanch.com

HI , Can anybody give me a clear idea on using GROUP BY Syntax : Here is the sample syntax , which i am currently using : SELECT column_name, SUM(AMOUNT) FROM TRANSTABLE WHERE column_name operator value GROUP BY column_name Please let me know what is the column name that should be supplied in case of column_name (In first Line of Query) ...

41. oracle query with date question    java-forums.org

42. Querying in JDBC to oracle DB    java-forums.org

Hi, I have done a JDBC connection to an oracle database and trying to run update and select statements using prepared statements. The Problem is when i write a select * from tablename; i am getting the correct result but when i do select * from tablename where columnname=? and preparedStatement.setString(1, value.toUpperCase); i am getting 0 rows when i did a ...

43.  in an oracle query    java-forums.org

44. querying an Oracle database using Java    forums.oracle.com

Basically I'm developing a system which uses an artificial neural network to predict diagnoses for patients. The patients will select their symptoms in the form of checkboxes. I was just wondering how you would go about querying a database using the checkbox label. E.g., JCheckBox btn = new JCheckBox("Nausea", false); So when this checkbox is clicked the database is queried to ...

45. Issue in Querying Oracle Database    forums.oracle.com