column « Statement « Java Database Q&A

1. After insert statement, how do I get column value populated by DB trigger

The primary key is generated by a database trigger for a table. A business object supplies the remainder of the column values. I need to update my business object with the actual primary key that was generated by the DB after the insert. Any suggestions. I'm trying to avoid running a query after the insert to get it.

3. Insert statement for a 70 columns database table

Hi, Do we have to hard-code the column names and indexes in our program? I have a database table which contains 70 columns. And my insert statement is looking like a beast. I am hard-coding the column indexes and column names in my program, although I have it in one place in the form of an enum. Is this how all ...

4. Updating a table column when fireing select statement.

Hi , I have got the following table structure. SQL> DESC SMS_INBOUND; Name Null? Type ----------------------------------------- -------- ---------------------------- MSG_ID NOT NULL NUMBER(20) DNIS NUMBER(10) SHORT_MESSAGE VARCHAR2(200) MOBILE_NUMBER NUMBER(10) RECEIVE_TIME TIMESTAMP(6) READ_FLAG NUMBER(2) Now i want to read 10 messages at particular interval, Lets say i am reading 10 messages using select statement and when to fire the select statement i am ...

5. select statement for three column

6. Set multiple columns using prepare statement

Don't put a comma before the WHERE clause. You're using Access? Then it comes with documentation on the version of SQL it supports. In the long run you might find it easier to track down that documentation and find out the correct syntax for yourself, rather than waiting for answers on a forum.

7. jdbc: invalild column index from statement.execute():

Hi, I have been unable to insert a row of data into the oracle db. The problem seems to be with stmt.setObject(int index, Object o). Here is the code: Connection conn= new Connection(myDB); PreparedStatement stmt = conn.prepareStatement("INSERT INTO AG_GPS_CURRENT VALUES (402128, 0, 0, 0, TO_DATE(?,'DD-MM-YYYY') , 'test'," + " 0, 0 , 0, 0, 0, TO_DATE(?,'DD-MM-YYYY') , 0, 0, 0, 0, ...