mirkosertic/MogwaiERDesignerNG

Reverse Engineering Postgresql Schema Fails on jsonb Columns

brad-harper opened this issue · 0 comments

Attempting to reverse engineering a Postgresql schema fails on jsonb columns.

java.util.concurrent.ExecutionException: de.erdesignerng.exception.ReverseEngineeringException: Unknown data type jsonb for user_profile.properties
	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
	at java.desktop/javax.swing.SwingWorker.get(SwingWorker.java:613)
	at de.erdesignerng.visual.LongRunningTask.run(LongRunningTask.java:62)
Caused by: de.erdesignerng.exception.ReverseEngineeringException: Unknown data type jsonb for user_profile.properties
	at de.erdesignerng.dialect.JDBCReverseEngineeringStrategy.reverseEngineerTable(JDBCReverseEngineeringStrategy.java:302)
	at de.erdesignerng.dialect.JDBCReverseEngineeringStrategy.updateModelFromConnection(JDBCReverseEngineeringStrategy.java:750)
	at de.erdesignerng.visual.common.ReverseEngineerCommand$2.doWork(ReverseEngineerCommand.java:134)
	at de.erdesignerng.visual.common.ReverseEngineerCommand$2.doWork(ReverseEngineerCommand.java:125)
	at de.erdesignerng.visual.LongRunningTask$1.doInBackground(LongRunningTask.java:52)
	at java.desktop/javax.swing.SwingWorker$1.call(SwingWorker.java:304)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.desktop/javax.swing.SwingWorker.run(SwingWorker.java:343)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:835)

This type has been in PostgreSQL for some time. Is it not supported?