wbExport - JDBC source details

Skip to first unread message


Jan 22, 2023, 7:26:40 AMJan 22
to SQL Workbench/J - DBMS independent SQL tool

Is there way to add source JDBC details (e.g. JDBC URL) also in wbExport output (e.g. Excel, HTML) file ?
e.g.  -infoSheet parameter is to capture source SQL in case of -- ods, xslm, xls, xlsx

Purpose is to know source (track) env while looking at generated files of wbExport.
While working on multiple env. on daily basis, its very hard to recollect source env. info after few weeks / months for exported file. 
And JDBC URL  may change over period of time while regenerating files using wbExport.


Thomas Kellerer

Jan 22, 2023, 11:56:23 AMJan 22
to sql-wo...@googlegroups.com
Well, the text/CSV format cannot store this information.

I would probably create a directory structure that resembles the source of each export e.g.


and so on.

The XML format contains this information by default in the header:

<jdbc-driver>PostgreSQL JDBC Driver</jdbc-driver>

Something like that could indeed be added to the infosheet.

> --
> You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbenc...@googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/ae18a99f-6f08-4295-ac00-05a829c6d45an%40googlegroups.com <https://groups.google.com/d/msgid/sql-workbench/ae18a99f-6f08-4295-ac00-05a829c6d45an%40googlegroups.com?utm_medium=email&utm_source=footer>.
Reply all
Reply to author
0 new messages