P

Prisma•9mo ago•

19 replies

Simire

prisma 6.7.0 not working in production

i have router v7, prisma and neon application working well in development. i can login and out but when i deploy to netlify i got this error.

schema:

generator client {
provider = "prisma-client"
previewFeatures = ["queryCompiler", "driverAdapters"]
output = "../app/generated/prisma"
}

datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
// directUrl = env("DATABASE_URL_UNPOOLED")
};

prisma client:

import { neonConfig } from "@neondatabase/serverless";
import { PrismaNeon } from "@prisma/adapter-neon";
import ws from "ws";
import dotenv from "dotenv";
import { PrismaClient } from "~/generated/prisma/client";
import { PrismaPg } from '@prisma/adapter-pg'


dotenv.config();
declare global {
/* eslint no-var: off */
var _prisma: PrismaClient | undefined;
}

neonConfig.webSocketConstructor = ws;
const connectionString = ${process.env.DATABASE_URL}${process.env.DATABASE_URL};
// const adapter = new PrismaPg({ connectionString })
// const adapter = new PrismaNeon(pool)
const adapter = new PrismaNeon({ connectionString });
//let prisma = new PrismaClient({adapter})

let prisma: PrismaClient;

if (process.env.NODE_ENV === "production") {
prisma = new PrismaClient({ adapter });
} else {
if (!global._prisma) {
global._prisma = new PrismaClient({ adapter });
// global._prisma.$connect();
}

prisma = global._prisma;
}

export default prisma;