Skip to content

Unformatted error message from introspect when env var contains wrong connection string protocol #5502

@janpio

Description

@janpio

Schema:

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

ENV var DATABASE_URL:

sqlserver:/localhost:1433;database=prisma-demo;user=SA;password=Pr1sm4_Pr1sm4;trustServerCertificate=true;encrypt=true

causes error message:

Prisma schema loaded from prisma/schema.prisma

Introspecting based on datasource defined in prisma/schema.prisma …
Error: Error in datamodel: Diagnostics { errors: [SourceValidationError { message: "The URL for datasource `db` must start with the protocol `postgresql://`.", datasource: "db", span: Span { start: 160, end: 179 } }], warnings: [] }

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions