Hi everyone! My question: I need both dataProxy an...
# orm-help
o
Hi everyone! My question: I need both dataProxy and interactiveTransactions, how can I do it? Or is there analog to $transaction call?
n
Hey Oleg 👋 unfortunately this is not possible. The Data Proxy is accessed via HTTP from your
PrismaClient
instance and manages the TCP connection to the DB:
PrismaClient <-http-> Data Proxy <-tcp-> DB
. Since interactive transactions only work via TCP, it’s a technical limitation of the Data Proxy that it doesn’t allow for interactive transactions. This is documented here: https://www.prisma.io/docs/concepts/data-platform/data-proxy Edit: I just learned from the Engineering team that we are planning to enable interactive transactions on the Data Proxy in the future, so never mind my comment about the technical limitation 😅 However, as of now this is not possible.
o
Ok, thanks for reply! But is it possible without Prisma help? For example establish one more connection to db and do what I want?
n
For example establish one more connection to db and do what I want?
Yes, I’d say that this is always an option but in that case the connection won’t go through the Data Proxy any more since that only works with Prisma Client.