Subscribe to RSS

Question 1

Question 2

This is very straight problem but I haven't figured out any solution yet. Scenario is I have 2 table in my DB. Source of 2nd table is dependent on 1st table's SOURCE_URL(can be more than 255 char so I ...

Question 3

I have a data model where I need a String column to be indexed by the backing database: @Entity public class A { // ... @Column(length=2048) @Index(name="strFieldIndex") private ...

Question 4

This is part of my model: @Entity public class Entry { @Id @GeneratedValue private long identifier; @ElementCollection @Column(nullable = false) private Map<String, String> ...

Question 5

The current column is a VARCHAR(255) NOT NULL, so how do I change it to TEXT NOT NULL? NOTE: The column intended to be changed its property type is a UNIQUE KEY combination of another column. E.g. ...

Question 6

I am trying to create an index on a particular text string using Hibernate annotations. What I am currently doing is: @Index(name="guid_index") @Column(length=1400) private String myGUID; However, ...

Question 7

I am having trouble getting the right hibernate annotations to use on a Map with an enumerated class as a key. Here is a simplified (and extremely contrived) example. public class Thing { public ...

Question 8

How would I do the following (interested only in how to do UNIQUE (title, description)) in phpMyAdmin?: CREATE TABLE `myData` ( id serial primary key, title varchar(255) not null, ...

Question 9

I have a table with a primary key that is a varchar(255). Some cases have arisen where 255 characters isn't enough. I tried changing the field to a text, but I get the following error: BLOB/TEXT ...

Question 10

I'm trying to add a composite primary key to a class and having a bit of trouble. Here are the classes. class User { private long id; ... } class Token { private User user; private ...

Question 11

I am working to use django's ContentType framework to create some generic relations for a my models; after looking at how the django developers do it at django.contrib.comments.models I thought I ...

Question 12

I'm creating a table to hold items from rss feeds and I need to create a column 'description'. I selected the datatype as TEXT with no limit set with no index on this column. This is the error I'm ...

Question 13

I am trying to add a spatial index to a table column named Location of type BLOB. If I try this: ALTER TABLE route ADD SPATIAL INDEX(Location); I get: Error: BLOB/TEXT column 'Location' used ...

Question 14

I'm using MySQL fulltext indexes in a Rails 2.3.2 App. I added the index via native SQL in my migration. But there is a known issue causing problems with the schema.rb. Rails doesn't understand ...

Collectives™ on Stack Overflow

syntax for trigger before insert [closed]

Problem in using TEXT field in mysql Table

Hibernate @Index error on long string columns

Mapping a @Lob valued Map

MySQL: How to alter varchar(255) UNIQUE column to UNIQUE Text NOT NULL?

Applying an Index to a Blob/Longtext field

What are the hibernate annotations used to persist a Map with an enumerated type as a key?

MySQL: How to make data unique for several rows in a table?

MySQL error: key specification without a key length

@IdClass with non primative @Id

Errors creating generic relations using content types (object_pk)

Unable to create column in MySQL database with datatype of TEXT

Error creating spatial index on MySql BLOB column

MySQL Fulltext index with Rails 2.3.2 (migration problem)

Hot Network Questions