to
make sure I would not be in bad shape if sometime in the future I needed to
change to a scheme more like Twitter Snowflake.
On Monday, January 12, 2015 at 3:48:34 PM UTC-8, Robert DiFalco wrote:
I have a couple of comments with regards to inserting records.
With JPA I have a sequence generator
Hi, things are going mostly amazing with jOOQ. Even though it may be 6
years old it is a breath of fresh air in the face of complex Spring and JPA
based applications.
So I'm creating my own Transaction abstraction on top of jOOQ that
reference counts transactions in the same thread instead of
Is anyone using JOOQ on heroku and with heroku postgres? Here's my
issue...and it may just be more of a maven question.
So I can just git push heroku master and it pushes all my source and kicks
off a maven build. This SHOULD invoke my flyway migration and then generate
JOOQ source. But now I
Understood and no worries on my end.
On Monday, January 19, 2015 at 9:50:17 AM UTC-8, Lukas Eder wrote:
2015-01-16 16:08 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
For now I just created a wrapper around DSLContext that has
transactionResult like methods annotated
I have several tables that I use for login in PostgreSQL. Does jOOQ have
any convenience methods that will allow me to set synchronous_commit='off'
for inserts to these tables? What I want to avoid is an extra round trip to
the database just to call set synchronous_commit='off' .
I'm thinking
that would still create a server round-trip...
2015-01-19 19:05 GMT+01:00 Robert DiFalco robert.difa...@gmail.com:
I have several tables that I use for login in PostgreSQL. Does jOOQ have
any convenience methods that will allow me to set synchronous_commit='off'
for inserts to these tables? What I
Heroku:
database_urlpostgres://${db.username}:${db.password}@${db.host}:${db.port}/${db.databa
Cheers
Lukas
2015-01-15 1:09 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
Is anyone using JOOQ on heroku and with heroku postgres? Here's my
issue...and it may just be more
I have a POJO that clients of my application send me. This is used to
either INSERT or UPDATE a user. Since I had some translation to do I, maybe
not so cleverly, thought I could save some copy-and-paste by writing a
method to add values to a StoreQuery. That way I wouldn't care if it was an
Forget this, the issue was with me IDE.
On Wednesday, January 14, 2015 at 10:11:06 AM UTC-8, Robert DiFalco wrote:
I have a POJO that clients of my application send me. This is used to
either INSERT or UPDATE a user. Since I had some translation to do I, maybe
not so cleverly, thought I
if all relevant information would be contained
and available from this Google Groups discussion.
Cheers,
Lukas
2015-01-09 18:01 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
As you suspected, there was something wrong with my timing code. Here's
a more formal comparison
own
org.jooq.Binding implementation:
http://www.jooq.org/doc/latest/manual/code-generation/custom-data-type-bindings
Let me know if that's what you meant.
2015-01-28 18:19 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
When creating a custom type (say I create one to convert
/521799
So, +1 for a https://github.com/rdifalco/jOOQ-tools repository! :)
Cheers
Lukas
2015-01-27 18:27 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
Is there a GitHUB project or does anyone have a simple configuration to
transform all appropriate Postgresql date and time
Is there a GitHUB project or does anyone have a simple configuration to
transform all appropriate Postgresql date and time classes to Java 8 Time
classes? Before I recreated the wheel I figured I'd see if anyone has this
already.
I'm guessing something like:
DATE - LocalData
-codegen-3.5.0.xsd) to XML and/or Java. Thus,
there isn't a lot of magic involved. Hope this helps,
Cheers,
Lukas
2015-01-09 18:15 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
Thanks Lukas, this makes a lot of sense. However, I could not find from
the examples how
benchmark when I get a chance, right
now the benchmark is intermixed into my server with a lot of proprietary
stuff in it.
On Thursday, January 8, 2015 at 11:12:49 AM UTC-8, Robert DiFalco wrote:
Thanks for the information! I have some type questions but I'll tack them
onto the other thread.
I
I will try to put one together tomorrow morning PST. I could very well be doing
something wrong.
Sent from my iPhone
On Jan 8, 2015, at 11:15 PM, Lukas Eder lukas.e...@gmail.com wrote:
2015-01-09 1:03 GMT+01:00 Robert DiFalco robert.difa...@gmail.com:
I just did a little performance
into the
Configuration class.
On Thursday, January 8, 2015 at 10:38:12 PM UTC-8, Lukas Eder wrote:
2015-01-08 18:57 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
I'm hoping the community can help me better understand type converters so
that I can more efficiently (and simply) use JOOQ
is 9.14% faster than JOOQ
-- JOOQ-NP is 4.33% faster than JOOQ
-- JOOQ-RS is 0.29% faster than JOOQ
On Thursday, January 8, 2015 at 11:15:13 PM UTC-8, Lukas Eder wrote:
2015-01-09 1:03 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
I just did a little performance
,
Lukas
2015-01-08 23:50 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
I'm having a problem with Immutable POJOs. Well, not Immutable but with
a constructor annotated with @ConstuctorProperties. As I'm typing this I'm
wonder if getters can overwrite constructor names. But here's
There seems to be a bug in the field to POJO mapping. Typically, with Java
Beans, if you have a value named firstName it will find the setter
setFirstName. Consider JSON parsing libraries like JSON or GSON.
Unfortunately, with JOOQ, it will only look for setfirstName,
setfirstname, or
I have a dynamic query builder, it may join a couple of tables and let the
user select what fields show up in the returned Record. Some of these
fields may use default converters and others may use more complex
conversation (like the string result of a CASE being turned into an Enum).
What's
I'm having a problem with Immutable POJOs. Well, not Immutable but with a
constructor annotated with @ConstuctorProperties. As I'm typing this I'm
wonder if getters can overwrite constructor names. But here's the issue I'm
having:
I have a query returning one Numeric identity field and three
Fantastic work! Has this been posted to Maven?
On Tuesday, February 10, 2015 at 10:45:30 AM UTC-8, Lukas Eder wrote:
Version 3.5.2 - February 10, 2015
This is a patch release with some useful fixes for the 3.5
I'm hoping the community can help me better understand type converters so
that I can more efficiently (and simply) use JOOQ.
It would be GREAT to have a document that provides an overview of all the
places where type conversion takes place and how to customize each one --
maybe there is a blog
AM UTC-8, Lukas Eder wrote:
2015-01-08 18:41 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
I'm reposting part of this from an email thread. I have a complex dynamic
query where I ultimately map from a ResultSet instead of using Record.
Lukas was curious why I was using
/
enhance the current DefaultRecordMapper:
http://www.jooq.org/doc/latest/manual/sql-execution/fetching/pojos-with-recordmapper-provider/
Cheers,
Lukas
2015-01-06 23:14 GMT+01:00 Robert DiFalco robert@gmail.com
javascript::
There seems to be a bug in the field to POJO mapping
Does this have a fix for reading the version from the @Generator annotation
in the generator code?
On Wednesday, June 3, 2015 at 7:47:43 AM UTC-7, Lukas Eder wrote:
Version 3.6.2 - June 03, 2015
This is a patch
time.
Hope this helps,
Lukas
2015-06-01 18:09 GMT+02:00 Robert DiFalco robert.difa...@gmail.com:
I'm really enjoying using JOOQ but I have a question about static queries
that I use over and over again.
I'm not sure why I need to parse these every time they are executed
because they never
I'm really enjoying using JOOQ but I have a question about static queries
that I use over and over again.
I'm not sure why I need to parse these every time they are executed because
they never change. I was thinking that in my DAO constructor I would just
create them once with #getSQL and then
to keep the expect timeout as short as possible so they will run
fast.
Thanks for the input.
On Mon, Jun 1, 2015 at 10:01 AM, Lukas Eder lukas.e...@gmail.com wrote:
2015-06-01 18:37 GMT+02:00 Robert DiFalco robert.difa...@gmail.com:
Thanks, yeah I read that. What I'm doing now seems to work
not generating beans or
anything like that.
On Mon, Jun 1, 2015 at 10:25 AM, Lukas Eder lukas.e...@gmail.com wrote:
2015-06-01 19:06 GMT+02:00 Robert DiFalco robert.difa...@gmail.com:
Yes, exactly that is the problem. Yeah it was just like three lines of
code to move the sqlContext.select
schema_version/schemaVersionProvider
I've added an issue to document this in the manual:
https://github.com/jOOQ/jOOQ/issues/4348
Cheers,
Lukas
2015-06-02 16:22 GMT+02:00 Robert DiFalco robert.difa...@gmail.com:
Interesting, I'll look into those classes to see what they do.
One thing
generation would be to use jOOQ's XMLDatabase, or
implement your own org.jooq.util.Database from jOOQ meta, that is optimised
for your specific schema. Let me know if that sounds like an option to you,
and I'll explain more
2015-06-01 22:38 GMT+02:00 Robert DiFalco robert@gmail.com
javascript
the generated code of your schema look like?
2015-06-02 16:50 GMT+02:00 Robert DiFalco robert.difa...@gmail.com:
Hmmm...I added that property to the database section and every time I run
mvn test I get this output (and it regenerates).
[INFO] Generating schemata : Total: 1
[INFO
Robert DiFalco robert.difa...@gmail.com:
This?
@Generated(
value = {
http://www.jooq.org;,
jOOQ version:3.6.1,
schema version:public_2.2
},
date = 2015-06-02T14:47:42.719Z,
comments = This class is generated by jOOQ
)
On Tue, Jun 2, 2015 at 7:51 AM, Lukas
For some reason I can't find the straight ahead way to do this:
ListMyRecord records =
dslContext
.select()
.from(MYRECORD)
.join(MYRECORD_DETAIL).on(MYRECORD.ID.eq(MYRECORD_DETAIL.MYRECORD_ID))
.where(MYRECORD_DETAIL.DATA.in(foo, bar))
Ah, okay, I think I found it. I'm trying this:
DSL.field(now() at time zone 'UTC', SQLDataType.TIMESTAMP)
On Wed, Jul 22, 2015 at 11:24 AM, Robert DiFalco robert.difa...@gmail.com
wrote:
Okay, I am trying to write an expression like this in jOOQ.
FROM devices d
WHERE extract(hour from now
.
On Thursday, July 16, 2015 at 1:46:55 PM UTC-7, Robert DiFalco wrote:
I'm about to do some schema changes to include time intervals (not
date-time intervals), but before I go to far I was wondering if JOOQ had
anything special to craft queries like this:
select ...
from devices d
where (now
Okay, I am trying to write an expression like this in jOOQ.
FROM devices d
WHERE extract(hour from now() at time zone 'UTC' + d.utc_offset)
BETWEEN 10 AND 22;
The field d.utc_offset is an Day to Second Interval.
I understand that JOOQ does not allow me to write the extract(hour from
, 2015 at 2:16 AM, Lukas Eder lukas.e...@gmail.com wrote:
Hello Robert,
2015-07-17 0:01 GMT+02:00 Robert DiFalco robert.difa...@gmail.com:
Also I just created a new column with type INTERVAL for PostgreSQL. The
datatype that JOOQ generated was Object. Is that correct? I would have
expected
Sorry, one last question. I'm still not sure why if I made a column defined
as INTERVAL DAY TO SECOND why doesn't JOOQ generate Java code using they
JOOQ type DayToSecond?
On Fri, Jul 17, 2015 at 7:51 AM, Robert DiFalco robert.difa...@gmail.com
wrote:
Thanks Lukas, I haven't played with data
that jooq
returns for MyRecord#getIntervalField) I get a Cannot translate null
SqlException.
On Fri, Jul 17, 2015 at 8:20 AM, Robert DiFalco robert.difa...@gmail.com
wrote:
Sorry, one last question. I'm still not sure why if I made a column
defined as INTERVAL DAY TO SECOND why doesn't JOOQ generate
I'm about to do some schema changes to include time intervals (not
date-time intervals), but before I go to far I was wondering if JOOQ had
anything special to craft queries like this:
select ...
from devices d
where (now() at time zone 'UTC' + make_interval(hours :=
d.utc_offset_hours))::time
Also I just created a new column with type INTERVAL for PostgreSQL. The
datatype that JOOQ generated was Object. Is that correct? I would have
expected a Java Interval or a DayToSecond subclass.
On Thu, Jul 16, 2015 at 1:46 PM, Robert DiFalco robert.difa...@gmail.com
wrote:
I'm about to do some
It there a utility in JOOQ to convert a Java Bean field name like
"phoneNumber" to the Field name of "phone_number"? Actually, just
getting the Field by "phoneNumber" would be great too.
Thanks
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group"
at go the other way round, i.e. from "phone_number"
>> to "phoneNumber". I'm think that Spring might have such utilities, though.
>> And Jackson also does:
>> http://stackoverflow.com/q/10519265/521799
>>
>> Hope this helps,
>> Lukas
>>
and an absent value that has been
parsed from JSON.
R.
On Wed, Sep 16, 2015 at 5:31 AM, Lukas Eder <lukas.e...@gmail.com> wrote:
>
>
> 2015-09-15 17:52 GMT+02:00 Robert DiFalco <robert.difa...@gmail.com>:
>
>> Thanks Lukas, unfortunately it does not handle Optiona
om/jOOQ/jOOQ/issues/2520, the "RecordUnmapper"
>
> 2015-09-14 22:19 GMT+02:00 Robert DiFalco <robert@gmail.com
> >:
>
>> Underlying this, it would be nice to have a fluent interface using a
>> non-JOOQ Java Bean that can translate from bean fields to database
What's the best way to use jOOQ to generate a local database? I tried this
and get some errors in MySQL. The jOOQ code is generated from a MySQL db.
sql.ddl(DefaultCatalog.DEFAULT_CATALOG).stream().forEach(sql::execute);
So I'm probably using the wrong syntax (maybe order of DDL queries)? Or
Well, it's hard to say anything bothers me, this is such a great API. I'm
just not fond of having many ways to do the same thing. It particularly
makes it hard for my new developers, and so I'm looking to give them
direction. For example to collect identities from a joined query I can
collect
With all the different ways to do the same thing in JOOQ it's often
difficult to find the best approach. I'm trying to write up our basic jOOQ
idioms. In doing so I was wondering if their is any difference between
these two variants?
List results = select.fetch(this::toMyObject);
And:
One of the problems I had with the JOOQ transaction approach is that I
could not enforce that users only make SQL calls through a transaction. I
solved it by making this little class.
class Transactor {
private final DSLContext ctx;
Transactor(DSLContext ctx) {
this.ctx = ctx;
into a series of smaller actions which I put into
> subroutines and I want to make sure those happen in the same transaction.
>
>
>> On Friday, February 23, 2018 at 3:53:23 PM UTC-8, Robert DiFalco wrote:
>> One of the problems I had with the JOOQ transaction approac
53 matches
Mail list logo