oshai
12/05/2017, 9:52 AMjava.lang.IllegalStateException: can't find primary key of type Int or Long; map['com.outbrain.oen.services.oendblib.dao.ocas.OenCampaignStatusTable.ocas_id']='75191' (where map='{com.outbrain.oen.services.oendblib.dao.ocas.OenCampaignStatusTable.ocas_id=75191}')
tapac
12/05/2017, 9:53 AMoshai
12/05/2017, 9:59 AMINSERT INTO ocas_campaign_status (ocas_advertiser_id, ocas_campaign_id, ocas_is_oen_approved, ocas_off_air_reasons, ocas_on_air)
VALUES (74671871, 1001735852, 1, 'OffAirInAmplify', 0)
ON DUPLICATE KEY UPDATE ocas_campaign_id=VALUES(ocas_campaign_id), ocas_advertiser_id=VALUES(ocas_advertiser_id), ocas_on_air=VALUES(ocas_on_air), ocas_off_air_reasons=VALUES(ocas_off_air_reasons), ocas_is_oen_approved=VALUES(ocas_is_oen_approved)
object OenCampaignStatusTable : Table(name = "ocas_campaign_status") {
val id = integer("ocas_id").autoIncrement().primaryKey()
val ocas_campaign_id = integer("ocas_campaign_id").uniqueIndex().default(0)
val ocas_advertiser_id = integer("ocas_advertiser_id").default(0)
val ocas_on_air = integer("ocas_on_air").default(0) //TODO check boolean
val ocas_off_air_reasons = varchar(name = "ocas_off_air_reasons", length = 255).nullable()
val ocas_is_oen_approved = integer(name = "ocas_is_oen_approved").default(0) //TODO check boolean
val ocas_date = varchar(name = "ocas_date", length = 30).nullable()
tapac
12/05/2017, 10:42 AMoshai
12/05/2017, 10:43 AM