drizzle-team/drizzle-orm · error · Error

No transactions support in Xata Http driver

Error message

No transactions support in Xata Http driver

What it means

Error "No transactions support in Xata Http driver" thrown in drizzle-team/drizzle-orm.

Source

Thrown at drizzle-orm/src/xata-http/session.ts:172

		};
	}

	async queryObjects(query: string, params: unknown[]): Promise<QueryResults<'json'>> {
		const result = await this.client.sql<Record<string, any>>({ statement: query, params });

		return {
			rowCount: result.records.length,
			rows: result.records,
			rowAsArray: false,
		};
	}

	override async transaction<T>(
		_transaction: (tx: XataTransaction<TFullSchema, TSchema>) => Promise<T>,
		// eslint-disable-next-line @typescript-eslint/no-unused-vars
		_config: PgTransactionConfig = {},
	): Promise<T> {
		throw new Error('No transactions support in Xata Http driver');
	}
}

export class XataTransaction<TFullSchema extends Record<string, unknown>, TSchema extends TablesRelationalConfig>
	extends PgTransaction<
		XataHttpQueryResultHKT,
		TFullSchema,
		TSchema
	>
{
	static override readonly [entityKind]: string = 'XataHttpTransaction';

	override async transaction<T>(_transaction: (tx: XataTransaction<TFullSchema, TSchema>) => Promise<T>): Promise<T> {
		throw new Error('No transactions support in Xata Http driver');
	}
}

export interface XataHttpQueryResultHKT extends PgQueryResultHKT {

View on GitHub (pinned to b7862528fd)

Solutions

1. Xata HTTP driver does not support transactions; use the Xata Postgres wire driver or restructure logic to avoid transactions.

When it happens

Trigger: Starting a transaction with the Xata HTTP driver, which does not support transactions.

Common situations: Calling db.transaction() on xata-http; use the Xata Postgres wire driver if transactions are required.

AI-assisted analysis of drizzle-team/drizzle-orm@b7862528fd (2026-08-03). Data as JSON: /data/errors/055af687b5e70e54.json. Report an issue: GitHub.