Table column comments not appearing

[schemaspy]

Table column comments not appearing

[npetzall]

If I didn't do anything with the database setup.
Comments should be available in the internal representation of the database.
I haven yet produced any html or such.

[svha1de]

If I run with the -nohtml option, I get the XML representation, but it does not contain the comments either.
Comments as seen in SQLDeveloper:

No remark in XML:

For completeness, the XML model as well is attached

orcl.CEMDB.xml.zip

[svha1de]

If I run the V5 schemaspy with the -nohtml option, it does pick up the remarks

Again, XML model is attached
orcl.CEMDB-schemaspy-5.xml.zip

Thanks a lot for looking into the matter, highly appreciated!

[npetzall]

@rafalkasa @svha1de
This seems to have been fixed since rc1.
I backported my oracle test to rc1.
ShouldBePopulatedWithTableTest OK
ShouldBePopulatedWithTableTestAndHaveColumnName OK
ShouldBePopulatedWithTableTestAndHaveColumnNameWithComment Failed

(edit: my test was wrong)

[npetzall]

Hmm, got it working in rc1 by changing my test.
I only test -s argument, and it works as far as the Database Model getting populated correctly.
(edit: remarks are written in the XML)

@svha1de Are you using -s, -schemas, -schemata or -all and with what arguments?

[svha1de]

My complete command line looks like this:
java -jar schemaspy-6.0.0-rc1.jar -t orathin -host ora12c.local -port 1521 -db orcl -u CEMDB -p stmsfmw1 -o bug -dp ojdbc6dms.jar;dms.jar;ojdl.jar;orai18n.jar -hq -gv "c:\Program Files (x86)\Graphviz2.38" -norows -loglevel fine -nohtml

[npetzall]

@svha1de could try adding -s CEMDB

[svha1de]

Excellent! This does the trick!

You rock! Thanks a lot for helping with this (and for picking up this great tool for further development)

[npetzall]

I'll dubbel check that this is solved later in 6.0.0 else we have a new usecase to handle @rafalkasa

[anilchaurasiya]

I am unable to get comment in the documentation while using SchemaSpy as highlighted in this screenshot.
Provide the solution for this issue.
I am using this command :
java -jar schemaspy-6.1.0.jar -configFile ./Schemaspy.properties -o Output

[npetzall]

@anilchaurasiya create a new issue this is 5 years old. In new issue please provide database engine and versions.

[anilchaurasiya]

@npetzall I unable resolve this issue please help me with solution , how to get comments added in the comment section while creating documentation using schemaspy.

[anilchaurasiya]

@npetzall I am using PostgreSQL v11.8.

[npetzall]

@anilchaurasiya create a new issue, this is 5 years old and it's oracle and not postgresql.