How to show complete column information in derby DB

Asked Mar 10 '23 at 06:28

Active Mar 10 '23 at 08:39

Viewed 30 times

I am unable to see complete certificate in derby database in CLI. I need to check the certificates before I proceed to do other stuffs.

How can I check whole breaking column info of certificates ?

Example:-

-----BEGIN CERTIFICATE----- MIIEwzCCAqsCAQEwDQYJKoZIhvcNAQXXXXYYYYYYYYYgdMxCzAJBgNVBAYTAkRFMRYwFAYD VQQIDA1OaWVkZXJzYWNoc2VuMREwDwYDVQ&

After & there is lots more text.So derby put '&' and hide the long texts

edited Mar 10 '23 at 08:39

asked Mar 10 '23 at 06:28

NoobCoder

[Please do not upload images of code/data/errors/text.](//meta.stackoverflow.com/q/285551) – Olaf Kock Mar 10 '23 at 07:22
What sort of "certificate" are you working with? – Bryan Pendleton Mar 18 '23 at 23:51
@BryanPendleton its X509CertificateHolder, column definition 'clob' in my code. – NoobCoder Mar 21 '23 at 08:05
Have you tried using something like SquirrelSQL to view your data? It has good support for viewing CLOB columns. – Bryan Pendleton Mar 25 '23 at 15:27
@BryanPendleton No idea about this. Although I can see data in Postgres but I need to check same on Derby – NoobCoder Mar 29 '23 at 04:04

0 Answers0