Best unofficial Apache Server developers community

Answers

How to use MySQL "Statement.RETURN_GENERATED_KEYS" in Oracle to retrieve key values?

⇧

⇩

34 views

I have the following MySQL query specified within a JSP. I want to figure out an equivelant query that I can run properly against Oracle Database as I am migrating my project from MySQL to Oracle DB.

Primary key of this "clips" table is "clip_id" which is actually not included in this query. In Oracle I created a sequence and trigger on "clip_id" because its value is supposed to auto-increment.

stmt.executeUpdate("INSERT INTO clips " +
        "(camera_id, num_recording, num_references, block_id_start,  
                    block_duration ) " +
        "VALUES ("+camera_id + ","+"1, " +
            "1,"+block_id_start + "," +
            block_duration + ");",
            Statement.RETURN_GENERATED_KEYS);

        rs = stmt.getGeneratedKeys();

        if( rs.next() )
        {
            clip_id = rs.getInt(1);
        }

Any comment or advice is appreciated.Thanks.

mysql oracle return-value data-retrieval

asked June 13, 2011 5:33 pm CDT

Jonathan O'Neil

posted via StackOverflow

1 Answers

⇧

⇩

To make my comment an answer:

Use the RETURNING INTO clause, see here.

answered June 14, 2011 11:20 pm CDT

tbone

Your answer

Similar discussion threads

Retrieve SQL of a mapped statement
November 24, 2010 09:14:47 AM
Hi all, we would like to write a small wrapper around myBatis SQLSession that catches a possible exception, and only when an exception occurs the whole statement (SQL code and parameters) should be written to the log. I am quite lost because I can…

java API to retrieve max, min and unique values in MongoDB
January 12, 2011 08:37:40 PM
Hi, What is the simplest Java API to retrieve the max, min and unique values in MongoDB collections? I was looking for something like the SQL "SELECT max( ) FROM" for the Servlet but didn't get any. It sounds as a very straightforward requirement…

Retrieve the column values of a record without knowing the names
February 18, 2011 01:15:09 AM
Hello, I've got the following function and I want to access the fields values of my record by index. The problem is that my select is retrieving each record line with all values and not each one of each row on my view... How can I solve this…

Retrieve the column values of a record without knowing the names
February 16, 2011 10:18:38 AM
Hello, I've got the following function and I want to access the fields values of my record by index. The problem is that my select is retrieving each record line with all values and not each one of each row on my view... How can I solve this…

Retrieve values mechanism from an HBASE table+PHP+REST
March 15, 2011 12:52:51 AM
Hello Experts, I have a doubt regarding the value retrieving mechanism from hbase table. I have a table like, .................................................................. Row key= Keyword column family=url value=priority I have thousands…

Setting and using cell timestamp values to retrieve data
March 1, 2011 05:23:49 PM
Hi, I have a test table where i have set all cells in it to have only one version (VERSIONS => 1). I was thinking of using the timestamp value with the row key + column(s) to retrieve data using getRowWithColumnsTs (Thrift Perl API). When…

How to retrieve values of 'array' field using C library (libpq)
February 9, 2011 02:16:16 AM
Hi. I use libpq in my program. And I can retrieve int and symbolic fields as simple as int unameFN, moneyFN... char *unamePTR, *moneyPTR... unameFN = PQfnumber(res, "uname"); moneyFN = PQfnumber(res, "money"); unamePTR = PQgetvalue(res, 0,…

Getting null values in an update statement
April 26, 2011 12:41:09 PM
I want to perform an UPDATE to a field in a table. Such a field is of type numeric, does not allow null values and has a default value of 0 (zero). The situation I am facing is that the records that do not meet the update criteria are set to null…

C# : How to add multiple values to an array in a single Update() statement
February 12, 2011 11:25:37 AM
I want to add multiple new items to an array property in a single Update() method, but this code fails : var oQuery = Query.EQ( "_id", ObjectId.Parse( _id)); var oUpdate = Update.AddToSet( "colours", "red").AddToSet( "colours", "green").AddToSet(…

Stomp:perl script "retrieve the values of the properties of the header"
July 19, 2010 09:31:52 AM
Hello, i use a perl script "stomp" to consume message from my broker. my $can_read = $stomp->can_read({ timeout => "5" }); if ( $can_read ) { # There is a message to collect. my $frame =…

Updated: (DERBY-2261) Questionable use of word "statement" in VALUES expression of Derby R
January 13, 2011 03:17:09 PM
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-2261:

Problems with connections pool in Tomcat 6.0.18 6.0.20 + MySQL 5.1 + mysql-connector 5.1.x
January 27, 2011 01:47:26 AM
Hi all, I have a problem with: Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6 I configured the connection in tomcat like this: <Resource driverClassName="com.mysql.jdbc.Driver" …

Bug? LIMIT in compound statement with UNION ALL seems to affect only the first SELECT statement if i
October 6, 2010 11:23:05 AM
Hi, everyone, This looks like a bug to me: --sql: CREATE TABLE t(a INTEGER); INSERT INTO "t" VALUES(1); INSERT INTO "t" VALUES(2); INSERT INTO "t" VALUES(3); INSERT INTO "t" VALUES(4); SELECT * FROM ( SELECT a FROM t WHERE a<=2 …

PATCH/puppet 05/18] moved the require statement just after the confine statement
May 19, 2011 01:18:47 AM
From: Joel Rosario <cirq### @gmail.com> Signed-off-by: James Turnbull <jam### @lovedthanlost.net> --- Local-branch: tickets/master/6693 lib/puppet/provider/group/groupadd_win.rb | 3 +-- lib/puppet/provider/user/useradd_win.rb | …

MySql overload: auth mysql + cache?
March 24, 2011 07:42:41 AM
Hello all, I'm facing a major issue on one of my DB after an application upgrade that switch to AuthMysql for a subversion server authentication My DB server is overloaded by tons of: > SELECT user.unix_pw, length(user.unix_pw) FROM user,…

Populating mySql DataStore from Mysql table
April 8, 2011 01:37:19 AM
I am trying to populate a datastore that uses Mysql persistence with a Mysql table. For that I have done the following: 1. Changed server.properties 2. Created a data store and named its persistence as mysql 3. included a mysql connector in…

Created: (CXF-3166) URITemplate should skip empty or null values when assigning values to template v
December 5, 2010 07:09:40 AM
URITemplate should skip empty or null values when assigning values to template variables

sysctl default values overridden by custom app values
January 6, 2011 09:38:34 AM
I am pretty new to puppet and am trying to POC different scenarios I would envision we would use this product for. One scenario I ran into is setting a default kernel.sem value into /etc/sysctl.conf on linux systems that can be overridden by a…

Dynamic values for report template values?
April 3, 2011 09:41:07 PM
Hi, Does anyone know if it's possible to change the value of things like report_contact and report_hostname per user (really, just per virtual domain)? Maybe it's possible to insert those settings into the user configurations? Even if so, is…

Closed: (DIRSERVER-1380) Apache DS sending values in response to "no values" query
May 26, 2010 05:44:57 AM
[ https://issues.apache.org/jira/browse/DIRSERVER-1380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Emmanuel Lecharny closed DIRSERVER-1380.

Questions and Answers are licensed under cc-wiki license.

How to use MySQL "Statement.RETURN_GENERATED_KEYS" in Oracle to retrieve key values?

1 Answers

Your answer

Join with account you already have