i am using mysql (5.0.32-Debian_7etch6-log) and i've got a nightly running bulk load php (5.2.6) script (using Zend_DB (1.5.1) via PDO) which does the following: truncating a set of 4 'import' tables bulk inserting data into these 4 'import' tables (re-using ids that have previously been in the tables as well, but i truncated the whole...
I've got the following table: CREATE TABLE `products_quantity` ( `id` int(11) NOT NULL auto_increment, `product_id` varchar(100) NOT NULL, `stock_id` int(11) NOT NULL, `quantity` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `product_id` (`product_id`,`stock_id`), KEY `products_quantity_product_id` (`product_id`), KE...
Hi all, I am facing the following problem and can't find a proper solution. I have a relation A with the attributes id, x (foreign key), y (sequence number) and z (content). Further there is a uniqueness constraint on x-y. That is usually I have tuples like (455, 159, 1, ...), (456, 159, 2, ...), (457, 159, 3, ...), etc. I'm using Hiber...
I have a Vb form that inserts data into multiple tables and maintains the foreign key using a sope_identity. I am using an insert procedure to deal with the insertion. My problem is that why i insert my values in VB and click the insert button the values in the database are duplicated. i need to prevent this from happeing. Any ideas p...
I have a simple domain class Licensee: @Entity @Table(name = "LICENSEE") @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) public class Licensee implements Serializable, Comparable { private Integer id; private String orgName; /* ... */ private Set<Address> address = new HashSet<Address>(); @Id @Column(name ...
i am using the latest IDE for eclipse and have attached the blackberry 5.0 sim. i am a new bb developer and i was wondering if there is any way of integrating java 1.6 classes (or any 3rd party jars) within the blackberry project without getting an error similar to the following: org.apache.axis2.util.Utils$3: Warning!: Duplicate metho...
--Summary (shortened)-- I have a controller that loads a profile object from the corresponding DAO. It updates some properties, many of them sets, and then calls saveOrUpdate (via save in the DAO) to reattach and update the profile object. At seemingly random intervals, we get an org.hibernate.exception.ConstraintViolationException, w...
I recently switched out log4net logging from using config files to being set up programmatically. This has resulted in the nhiberate entries getting repeated 2 or sometimes 3 times. Here's the code. It uses a string which looks something like this "logger1|debug,logger2|info" private void SetupLog4netLoggers() { IAppe...
how would i search through a list with ~5 mil 128bit (or 256, depending on how you look at it) strings quickly and find the duplicates (in python)? i can turn the strings into numbers, but i don't think that's going to help much. since i haven't learned much information theory, is there anything about this in information theory? and si...
Hi, In some special cases you will need a list of textboxes (to deal with n - n associations) whose id is not know before runtime. Something like this : http://screencast.com/t/YjIxNjUyNmU In that particular sample I'm looking to associate a count to some of my 'templates'. in ASP.Net MVC 1 I coded a Dictionary ModelBinder to have a c...
I have a simple table made up of two columns: col_A and col_B. The primary key is defined over both. I need to update some rows and assign to col_A values that may generate duplicates, for example: UPDATE `table` SET `col_A` = 66 WHERE `col_A` = 70 This statement sometimes yields a duplicate key error. I don't want to simply ignore...
When i try to a edit a entry.. its creating a duplicate entry in the database. i have made sure i add an hidden id field when i go to the edit form. Restaurant RestaurantAttribute RestaurantContact these are the models i am using. tried reinitialize the id $this->Restaurant->id = $this->Restaurant->id; strange... in the db the ex...
dear all. i have a form that consist of two textfield and one combobox. i want prevent the duplicate entry data from client side. i get combobox data from DB, like: <select id="line" name="faline" > <?php $sql="SELECT `Line_Name` FROM `prod_sch` WHERE `Line_Name` LIKE 'FA %' GROUP BY `Line_Name` ORDER BY `Line_Name`"; if ($sql) { ...
when the following include is added to my project, xcode fails to find it: import "FBConnect/FBConnect.h" i have added the facebook src directory to the header include path and the user header include path in the project and target settings. when i change the include to #import "FBConnect.h" the file is found, but i get a duplicate sy...