Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: avihaimar
  • Content: Threads
  • Order by date
  1. avihaimar

    For how long transaction can be open?

    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
  2. avihaimar

    How to implement a transaction

    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...
  3. avihaimar

    Track changes, Audit and rollback

    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
  4. avihaimar

    associative table or a directly foreign key,what is better?

    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
  5. avihaimar

    How to limit the sql to reurn only 1 result

    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...
  6. avihaimar

    Quote on numeric field in DB2???

    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...
  7. avihaimar

    MySql in solaris is it case sensetive?

    Hey, I run sql command in my java program. The table name is in capital letter. in my sql command i wrote the table name in small letter. The sql command work in mysql on windows,but didnt work on solaris. I understand that there is a differnt behaviour between mysql on solais and window. is...
  8. avihaimar

    How do i get a list of all the catlogs in the database?

    Thank you
  9. avihaimar

    Delete 100,000 records.Lock issues

    I want to delete every hour more than 100,000 records (there is on delete cascade on the reference tables). I decide to delete them in limit of 40000 (is it a good decision ?) I heard that i need to worry about locking (there is no select on this records). Can someone please give the point...
  10. avihaimar

    Delete cascade in many to many relation

    Hey, I have table A and B that has many to many relation (Table C is the many to many) I want that when i delete records from A, the records from C and B will also delete. I set on delete cascade in C table FK (for A and B) but when i delete records from A it delete only A,C. Is there any...
  11. avihaimar

    limit a delete query

    Hey, i have table B with FK to A (many to one) I want to delete big amount of data from A,B (all the data that already read from the table and flaged as readed) since i have the FK i try to delete data from B before delete A i run this query delete from B using B,A where...
  12. avihaimar

    Delete big amount of data

    Hey, I need to delete big amount of data (around 300K). I don’t want that the delete process will disturb to the main process (event record) to run. So i wonder: 1. Is there an option to delete in chunks? 2. Is there a way to delete in background? Can I check if the process or the db is...
  13. avihaimar

    problem with "div" in a "table" does any one know? PLEASE

    hello i have the code below: <html> <body> <table> <div id="div1" style="display :none"> <tr> <td> uuu </td> </tr> </div> </table> </body> </html> i want in table tag to display or not display ( according to some bussnies rules ) a section of some rows. but the tag div dosnt work for me inside...
  14. avihaimar

    i wonder if i copy betrieve files from there db

    And I put them in another computer that doesn’t have a btrieve kernel can I now read these files??? I m a beginner in btrieve so I maybe write stupid question so I m apologize about the
  15. avihaimar

    bagging 4 help. how can i convert btrieve format

    Hello I m student for computer science and in my final project I need to derive reports from btrieve. We don't have any tools and we are working in visual basic. We think to convert the tables that we needs from btrieve format to mdb format but we don't success. I m bagging for any idea or...

Part and Inventory Search

Back
Top