Comments (7)
npetzall
commented on May 26, 2024
3
Just realized you are using 5.0.0, I need to check the sources if the new drivers are supported. (mssql05 is in 5.0.0 version)
Else if possible use 6.0.0-rc1 with -t mssql05
from schemaspy.
npetzall
commented on May 26, 2024
2
@morenoh149 a bit of a long shot, could you test -t mssql05 it should be for mssql 2005 and newer.
Around 2005 they changed the package name for the jdbc driver.
from schemaspy.
morenoh149
commented on May 26, 2024
now I get
databases/schemaSpy » java -jar schemaSpy_5.0.0.jar -t mssql05 -host 1.1.1.1 -port 12345 -db myDB -o outDir -u myUser -p myPass -dp ../sqljdbc42.jar
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mssql05.properties
Gathering schema details...
Failed to retrieve table/view comments: com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
SELECT i_s.TABLE_NAME, s.value AS comments FROM INFORMATION_SCHEMA.Tables i_s INNER JOIN sys.extended_properties s ON s.major_id = OBJECT_ID(i_s.table_catalog + '..' + i_s.table_name) WHERE s.class = 1 AND s.name = 'MS_Description'
17:20:23.579 SEVERE: TDSParser.throwUnexpectedTokenException - ConnectionID:1 ClientConnectionId: 6fe97dee-bb74-4733-9285-39143863d2e6: getNextResult: Encountered unexpected unknown token (0x49)
17:20:23.581 SEVERE: TDSReader.throwInvalidTDSToken - ConnectionID:1 ClientConnectionId: 6fe97dee-bb74-4733-9285-39143863d2e6 got unexpected value in TDS response at offset:45
Failed to retrieve column comments: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
SELECT OBJECT_NAME(c.object_id) AS TABLE_NAME, c.name AS COLUMN_NAME, ex.value AS comments FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 ORDER BY OBJECT_NAME(c.object_id), c.column_id
No tables or views were found in schema 'myUser'.
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.checkClosed(SQLServerDatabaseMetaData.java:126)
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getSchemas(SQLServerDatabaseMetaData.java:1340)
at net.sourceforge.schemaspy.DbAnalyzer.getSchemas(DbAnalyzer.java:319)
at net.sourceforge.schemaspy.SchemaAnalyzer.dumpNoTablesMessage(SchemaAnalyzer.java:483)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:220)
at net.sourceforge.schemaspy.Main.main(Main.java:42)
from schemaspy.
npetzall
commented on May 26, 2024
actually turns out the db is sql server. I'll report back if I get it working.
So its not Microsoft SQL Server? Sometimes known as mssql
Did you try -t mssql05 it has more to do with the drivers you are using than actual version of MS SQL Server. But it would help if you knew the version of SQL Server.
-t [dbType] sets up both which JDBC Driver to use and stuff regarding connecting to it, but also which queries to use to get information about tables, views and stuff.
from schemaspy.
morenoh149
commented on May 26, 2024
it's Microsoft SQL Server 12.00.4232
from schemaspy.
npetzall
commented on May 26, 2024
I downloaded the driver and -t mssql05 should be able to connect.
If the output or generation is incorrect (missing tables, columns, view, comments) let us know so that we can try to create a more up-to-date dbTyp for mssql than 2005.
This will however be done in 6.0.0 version.
from schemaspy.
morenoh149
commented on May 26, 2024
amazing it worked! now I need to figure which schemas I can access!
» java -jar schemaspy-6.0.0-rc1.jar -t mssql05 -host 1.1.1.1 -port 12345 -db database -o outDir -u myUser -p myPass -s Person -dp ../sqljdbc42.jar`
from schemaspy.
Related Issues (20)
- marcelstoer:chore/jar-noteAre there any objections to this PR marked as "important"? HOT 1
- Docker: arm image HOT 1
- Moving GUI components
- GUI does not respond to re-sizing HOT 1
- No relationships image created HOT 6
- Too much information in error.
- Sign snapshots
- Cant get line breaks in Table Comments to work. HOT 6
- I am unable to get comments
- Oracle database - null password given HOT 5
- Driver Error HOT 7
- Failed to parse [schema].meta.xml HOT 5
- Terminating null reference error when generating HTML for Constraints MSSQL HOT 1
- SchemaSpy ERD (relationship tab) is not showing lines between tables HOT 4
- Relationship between Unique Keys and Foreign Key HOT 8
- ERROR - Bad config Schema (-s/-schemas) was not provided and unable to deduce schema, ... HOT 2
- Trying to set trustServerCertificate true in schemaspy.connprops Property in config file does not work HOT 2
- Getting an Exception when running against Oracle database in charset ISO-8859-15 HOT 1
- Feature request: "Comment" as title in relationships.html
- Get `AbstractMethodError` when connect to SQL Server by using `mssql17-jtds` driver. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from schemaspy.