R2DBC/r2dbc

Community Chat • https://r2dbc.io • Arabba-SR3 (0.8.x releases) available

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

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.

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.

Where communities thrive

People

Repo info

Activity