by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • 10:23
    mp911de edited #35
  • 10:23

    mp911de on 0.8.x

    Update changelog [#166] (compare)

  • 10:22
    mp911de milestoned #166
  • 10:22
    mp911de labeled #166
  • 10:22
    mp911de opened #166
  • 10:21

    mp911de on 0.8.x

    Update changelog [#293] (compare)

  • 10:15
    mp911de unlabeled #294
  • 10:15
    mp911de commented #298
  • 10:15

    mp911de on 0.8.x

    OffsetTimeCodec Polishing Tweak license header… (compare)

  • 10:15
    mp911de closed #298
  • 10:15
    mp911de closed #294
  • 10:15
    mp911de closed #294
  • 10:15

    mp911de on main

    OffsetTimeCodec Ensure no snapshots get referen… Polishing Tweak license header… and 1 more (compare)

  • 10:04
    mp911de milestoned #294
  • 09:56
    mp911de commented #160
  • 09:25
    mp911de closed #167
  • 09:25

    mp911de on main

    Ensure no snapshots get referen… (compare)

  • 09:25

    mp911de on 0.8.x

    Ensure no snapshots get referen… (compare)

  • 09:24
    mp911de closed #165
  • 09:24

    mp911de on main

    Ensure no snapshots get referen… (compare)

Mark Paluch
@mp911de
Translated to blocking database access, you would ask "How to map relations in JDBC" and there are many answers to your question.
rbrose
@rbrose
But my question is How to map relations in r2dbc
So i need "Best practice of handling relations between tables in Spring Data R2dbc"
Anton Duyun
@Squiry
R2dbc doesn’t cover relations at all.
rbrose
@rbrose
Yes that i know. But an best practice how solve this problem will be nice
So i need write a own Mapper
but don't find good examples
rbrose
@rbrose
Mono<Void> delete = databaseClient.delete()
  .from(Person.class)                       
  .matching(where("firstname").is("John")   
    .and("lastname").in("Doe", "White"))
  .then();
In my project where not founded
How import this Criteria language?
Anton Duyun
@Squiry
I believe it’s spring data part.
Rachana Kulkarni
@rachanark
I am using postgres-r2dbc
insert into test(description) values('My price is $1')
I am not able to make the below query work
It takes $1 as a binding parameter
Is there a way I could make it work?
Anton Duyun
@Squiry
Correct query would be ‘insert into test(description) values($1)’
Rachana Kulkarni
@rachanark
I want the entire string in description "My price is $1", here $1 is not a binding parameter but the price
Anton Duyun
@Squiry
Then provide the entire string as a binding parameter.
Rachana Kulkarni
@rachanark
Can I not make databaseClient.execute(insert into test(description) values('My price is $1')).then() work some way?
Somehow not treat $1 as binding parameter?
Anton Duyun
@Squiry
Oh, I’ve misunderstood you.
Well, you still can provide that string as binding variable.
Greg L. Turnquist
@gregturn
What happens if you escape the "$"?
Rachana Kulkarni
@rachanark
How can I do that? I tried $$,
Anton Duyun
@Squiry
Escaping is not implemented iirc.
Greg L. Turnquist
@gregturn
Forgot about that. Then indeed, you have to do it through binding.
Anton Duyun
@Squiry
And driver makes decision about using simple/extended query based on this
So yeah, you have to use binding.
Rachana Kulkarni
@rachanark
Thanks:)
rbrose
@rbrose
Hello, i changed from ReactiveCrudRepository to ReactiveSortingRepository and get now the error:
Failed to create query for method public abstract reactor.core.publisher.Flux eu.foo.backend.repository.CategoryRepository.findAll(org.springframework.data.domain.Sort)! No property findAll found for type Category!
But can't find the problem
rbrose
@rbrose
public interface CategoryRepository extends ReactiveSortingRepository<Category, Long> {
Mark Paluch
@mp911de
@rbrose please direct your questions at https://gitter.im/spring-projects/spring-data since this channel is focussed on R2DBC SPI and driver development.
rbrose
@rbrose
which questions here allowed?
Mark Paluch
@mp911de
This channel is focussed on R2DBC SPI and driver development. So if you're facing issues with a driver or the specification.
Repositories and DatabaseClient are part of Spring Data
rbrose
@rbrose
ok
Guilherme Tavares
@mguilhermetavares

Hi guys

any idea how to model composite keys with Spring data R2DBC? I haven't found anything mentioned in the ref https://docs.spring.io/spring-data/r2dbc/docs/1.0.x/reference/html/#reference

E.g:

class Foo {
    @Id String foo
    @Id String bar;
}

 client.update()
     .table(Foo.class)
     .using(fooObject)
     .then()
     .thenReturn(foo);

it fails with MappingException

Anton Duyun
@Squiry
You should ask that question in a spring data gitter.
Cory
@lumcory
Hi - did anyone realized Arabba-SR4 pulls in r2dbc-proxy SNAPSHOT?
Greg L. Turnquist
@gregturn
Yes, that's why we released Arabba-SR5 shortly thereafter.
I guess we never got around to blogging it.
Cory
@lumcory
awesome! I searched for awhile for reference but couldn't find. Glad it's planned
Greg L. Turnquist
@gregturn
You can use it today.
Yash Agarwal
@mr-agrwal
hey, how can configure r2dbc-postgres with these parameters ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory?
Anton Duyun
@Squiry
Any sslMode except verify-ca and verify-full will do the same.
3 replies
CloudZou
@CloudZou
@mp911de i have a question about the ReactorNettyClient source code, i don't know why use the parameter concurrency equals 1,why can not other values.
image.png
Mark Paluch
@mp911de
This is to avoid concurrency and to enforce a single-threaded-like behavior. Otherwise, protocol messages would interleave and the protocol would get out of sync.