Hmmm...
Yes, but a similar message (a warning) about the missing id field was
displayed.
I removed the unsigned property from the id field and now it works!
I don't know if this a quirk of MySQL and if it should be taken into
account by jOOQ but nevertheless it is a very strange behaviour.
Dear
I would like to know the best way to query for a string contains another
string in a case-insensitive manner, and let JOOQ automatically take care
of all escape characters.
JOOQ 3.6 contains predicates for likeIgnoreCase and contains, but not
containsIgnoreCase.
Hello,
I've tried to reproduce this locally:
create table datasets (
id int not null primary key auto_increment,
name varchar(250),
user_email varchar(120),
created_at datetime default current_timestamp
);
-- works
insert into datasets(name, user_email) values('a', 'b');
and then
The CREATE code that corresponds to my tables is:
CREATE TABLE `datasets` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(250) NOT NULL DEFAULT '0',
`user_email` VARCHAR(120) NOT NULL,
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)
Moreover, the id field seems to be defined in the same way in both
Datasets and Logs classes.
That's drives me crazy.
It is like the auto increment doesn't work for the second class.
--
You received this message because you are subscribed to the Google Groups jOOQ
User Group group.
To
And these are the complete servlet functions that are used to add records
into these 2 tables:
protected void log2db(HttpServletRequest request, String action, String
message) {
try {
if(this.conn == null ){
Hi!
I am a quite new jOOQ user and I would appreciate a little help.
I have 2 mysql tables (logs and datasets) that both use as a primary
key a field named id with AUTO_INCREMENT as default value.
https://lh3.googleusercontent.com/-zWEAnwqRUEU/VXAjbOrYkiI/ABA/yz9QOz6wlA0/s1600/logs.png
Hi all!
I'm trying to learn JOOQ and I get some strange behavior with PostgesSQL
money type.
JOOQ codegen generates BigDecimal field in class for money field in DB.
But when I try to select and use that field in WHERE clause, there are
exception.
Here are table definition:
CREATE TABLE user
(
2015-06-04 13:01 GMT+02:00 Alexandros G. spamato...@gmail.com:
Moreover, the id field seems to be defined in the same way in both
Datasets and Logs classes.
That's drives me crazy.
It is like the auto increment doesn't work for the second class.
Does it work when you run the insert
Interesting, looks like you've run into a bug / missing feature. I've
created an issue for this:
https://github.com/jOOQ/jOOQ/issues/4364
In other databases, the money type is more or less just an alias for
decimal. It looks as though in PostgreSQL, it is more. It would make sense
for future
10 matches
Mail list logo
