dbeaver / dbeaver/dbeaver

Pervasive JDBC Driver Date Data Type

Open
#34,385 2 comments 0 reactions 0 assignees View on GitHub
environment xf:data xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

When opening a database with a Pervasive SQL Date column, DBeaver doesn't know what to do with it. The column heading symbol is a question mark while the rest are "ABC" and "123". When editing the Date cell with the same formatting (ex: changing 1999-01-01 to 1999-01-02), it gives an error message "Object parameter [1999-01-02] binding not supported".

### DBeaver Version

Community Edition 24.1.0

### Operating System

Windows 11 Pro

### Database and driver

Pervasive PSQL Version 13.31.022
pvjdbc2 Driver

### Steps to reproduce

1. Connect to a Pervasive SQL Database
2. Open a table with a data type Date column
3. Edit the cell with DBeaver and save

### Additional context

Fresh install of DBeaver with Driver Manager for Pervasive SQL Advanced Parameters > Formatting > Date format > YYYY-MM-DD (Also tried YYYY-MM-dd and YYYY-mm-dd)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.