Ребят, помогите заставить работать этого зверька.
Вот как я его запускаю:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
C:\Users\Maya>java -jar "C:\Users\Maya\Documents\schemaSpy\schemaSpy_5.0.0.jar" -dp "D:\Distr\java_libs\jtds-1.3.1-dist\jtds-1.3.1.jar" -t mssql-jtds -db DW -host SRV-DBMSSQLPRD1 -port 1433 -u rep_user -p ******* -connprops "C:/Users/Maya/Documents/schemaSpy/schemaSpyGUI20090302/pro
perties/mssql-jtds.properties" -o "C:/Users/Maya/Documents/schemaSpy/schemaSpyGUI20090302/rep_user_DW_"
Using database properties:
[C:\Users\Maya\Documents\schemaSpy\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mssql-jtds.properties
Gathering schema details...
Failed to retrieve table/view comments: java.sql.SQLException: Invalid object name 'sysproperties'.
SELECT i_s.TABLE_NAME, s.value AS comments FROM INFORMATION_SCHEMA.Tables i_s INNER JOIN sysproperties s ON s.id = OBJECT_ID(i_s.table_catalog + '..' + i_s.table_name) WHERE s.type = 3 AND s.name = 'MS_Description'
Failed to retrieve column comments: java.sql.SQLException: Invalid object name 'sysproperties'.
SELECT i_s.TABLE_NAME, i_s.COLUMN_NAME, s.value AS comments FROM INFORMATION_SCHEMA.COLUMNS i_s INNER JOIN sysproperties s ON s.id = OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME) AND s.smallid = i_s.ORDINAL_POSITION AND s.name = 'MS_Description' WHERE OBJECTPROPERTY(OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i
_s.TABLE_NAME), 'IsMsShipped')=0
No tables or views were found in schema 'rep_user'.
The schema does not exist in the database.
Make sure that you specify a valid schema with the -s option and that
the user specified (rep_user) can read from the schema.
Note that schema names are usually case sensitive.
15 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
db_accessadmin db_backupoperator db_datareader db_datawriter db_ddladmin db_denydatareader db_denydatawriter db_owner db_securityadmin dbo guest imb INFORMATION_SCHEMA sys tmp
These schemas contain tables/views that user 'rep_user' can see:
INFORMATION_SCHEMA dbo imb sys
В файле, как рассказано
тут сделаны соответствующие замены.
Не понятно почему он лезет за свойствами вот сюда
[C:\Users\Maya\Documents\schemaSpy\schemaSpy_5.0.0.jar] /net/sourceforge/schemaspy/dbTypes/mssql-jtds.properties
Кто нибудь сталкивался с подобной проблемой? (слэши на обратные в путях (-connprops C:/Users/Maya/Documents/schemaSpy/schemaSpyGUI20090302/pro
и -o)менять пыталась, результат аналогичный)
