table « db2 « Java Database Q&A





1. What should be the correct/better approach for locking a record in table?    stackoverflow.com

Actually, the problem is like this:-
i am having a table, say Payments. I have provided few GUI for searching, viewing and editing the record. Now if the user is trying to ...

2. db2 jdbc driver does not release table locks    stackoverflow.com

situation: We have a web service running on tomcat accessing DB2 database on AS400, we are using JTOPEN drivers for JNDI connections handled by tomcat. For handling transactions and access to ...

3. how to skip search the system table when using the eclipselink timestamp optimistic clock    stackoverflow.com

When I try to using eclipselink to implement the concurrent event in the DB2.I added an annotation @Version in the entity class:

@Version
    @Column(name = "LAST_MNT_TS")
    ...

4. Querying A DB2 Table Last Update Date    coderanch.com

5. DB2 JDBC Temporary table.    coderanch.com

6. DB2 Insert Problem - Invalid Table State    coderanch.com

Hi All, I am trying to insert some records into a table using the Universal JDBC Driver. When I go to execute the prepared statement I get the following error: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -7008, SQLSTATE: 55019, SQLERRMC: TABLE1 ;LIBRARY ;3 SQL State 55019 is 'The table is in an invalid state for the operation.' From the info I've found, ...

8. How to read DB2 session tables    coderanch.com

Hi All, My application connects to DB2 installed in mainframe to process some date based on the inputs given. The mainframe programme does the processing and will store the results in DB2 global session tables. Then I will invoke a DB2 stored procedure which will read this session table for further processing and gives the final result. The problem here is ...

9. Loading file data into a DB2 table using java    coderanch.com

Seems like a batch job. Use prepared statements for better performance. Don't read full flat file at a stretch. Instead read only sufficient information to create a record in db2. Depending on the problem you can maintain transaction level at record level or file level. For record level after each record insert you need to commit. Else a single commit after ...





10. Storing Java "class type" in db2 table?    dbforums.com

Hey all, In my application I will need to call various external applications, all in Java. in order to do this, users will be able to customize which aplication and the parameters used to dynamically call it. Therefore the values for creating the dynamic method invocation are stored in a database table. But i am having a problem - i need ...

11. Drop table colounm in db2 with java Statement    dbforums.com

Hi Ive got a table with loads of data that has to be converted, for this to work I have to add a temorary coloumn to the table do some stuff and then drop the coloumn again. This all has to happen inside Java code. When adding the coloumn and doing what I have to everything works fine, bus as soon ...