1. What should be the correct/better approach for locking a record in table? stackoverflow.comActually, the problem is like this:- |
2. db2 jdbc driver does not release table locks stackoverflow.comsituation: 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.comWhen I try to using eclipselink to implement the concurrent event in the DB2.I added an annotation @Version in the entity class: |
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.comHi 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, ... |
7. insertion of Packed decimal data into Db2 table from Java coderanch.com |
8. How to read DB2 session tables coderanch.comHi 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.comSeems 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.comHey 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.comHi 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 ... |