Recent content by avihaimar

Hey, I want that my client will open a transaction for a non limit time. Can i confiugre the MySQl to not close open transaction due to timeout? Thank you

Thank you. I need to support in update, delete... and i can lock this records.

The client change the data but i have to persist those changes to the DB for the following reasons: 1. to get an id in oder to have the ability to manage those objects and the references between objects. 2. in order to not lost those changes in case that the server crash. 3. some data changes...

Hey, I want to implement transaction mechanism. Think about world document each change saved in a temporal workspace and at the end the user can press on save and the changes apply to the original document or close and the document will not be changed. My client can do a lot of changes to the...

Hey, does any one can have me some references or advices on how to control on changes in the DB, audit them and have the ability to rollback. My application is in Java Thank you

Hey, I am working with hibernate and i want to map my Objects to tables structre. There is two ways to map relation: 1. with associative table 2. directly foreign key (i mean without associative table) Can you please explain what are the advantages for each way? Thank you

I need a generic solution. currently i solved it by setting stmt.setMaxRows(1), but i read that it dosnt gurrenty better performance .

Hey, My application give the user the ability to create a virtual view. The user insert a query - "selcet product_id from product" and we show him the structre of this virtual view. In order to get the column types i run this query than get the "ResultSetMetaData" ( by getMetaData() ) and...

You are funny. :) So, what is your suggetion?

Thank you, but all i need is only to extract those records.

i try this: Select * FROM WCSADM.CATENTRY WHERE CHAR(CATENTRY_ID)='1000000'; and it work for me. what about performance? what about other DB? what about timestamp? what you think about using in PrepareStatement (and using setObject ) Thank you, You are great

Thank you guys. The business case: I have table that contain chages that where done on tables. So i have : table_name,column_name,column_value once in a while there is a thread that extract all this changes. it prepare the following sql - for each table: select * from table_name where...

I am looking for a generic solution. Somthing that will support in all variables (without know their type) and for all data base. Please, if you dont know an answer dont say - so dont do this. let other people that know some tricks to help!

This is the problem! i dont know the column type . i just append column name with value. in most data bases its ok to wrap in singe quote value of numeric type, but DB2 dosnt allow it.

Hey, I am building a dynamic query. i create a select on some table fields and i append the where clause like this - ... Column_A = 'value' AND COLUMN_B = 'value' ... i dont know the table and the columns types from ahead, so i wrap the value with single quote. Almost all Data Base support...