I can't seem to get past this. I can't figure another argument to provide. It connects fine, but then gievs and error and stops on:
InvalidConfigurationException: Unexpected named parameter ':table')' found in SQL 'select
rowcnt row_count from systabstats where id = object_id(':table') and indid in (0,1)''
Any insight appreciated. Thanks.
The full session (lightly censored - the user/password is for the dbo of that database):
>java -jar schemaSpy_4.1.1.jar -dp .\jconn3.jar -db pin -s dbo -u XXX -p XXXXXX -t sybase -host XXXXXX -port XXXX -o C:\SchemaSpy\sybase1\cas\
Using database properties:
[schemaSpy_4.1.1.jar]/net/sourceforge/schemaspy/dbTypes/sybase.properties
Connected to Adaptive Server Enterprise - Adaptive Server Enterprise/15.0.2/EBF 15958 ESD#
6/P/Sun_svr4/OS 5.8/ase1502/2537/32-bit/FBO/Thu Oct 2 03:54:19 2008
Gathering schema details...
InvalidConfigurationException: Unexpected named parameter ':table')' found in SQL 'select
rowcnt row_count from systabstats where id = object_id(':table') and indid in (0,1)'
Unexpected named parameter ':table')
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There was a problem in the way that the customized SQL was being parsed. Try the latest beta version at http://schemaspy.sourceforge.net/schemaSpy.jar and let me know if that resolves the issue.
Thanks,
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can't seem to get past this. I can't figure another argument to provide. It connects fine, but then gievs and error and stops on:
InvalidConfigurationException: Unexpected named parameter ':table')' found in SQL 'select
rowcnt row_count from systabstats where id = object_id(':table') and indid in (0,1)''
Any insight appreciated. Thanks.
The full session (lightly censored - the user/password is for the dbo of that database):
>java -jar schemaSpy_4.1.1.jar -dp .\jconn3.jar -db pin -s dbo -u XXX -p XXXXXX -t sybase -host XXXXXX -port XXXX -o C:\SchemaSpy\sybase1\cas\
Using database properties:
[schemaSpy_4.1.1.jar]/net/sourceforge/schemaspy/dbTypes/sybase.properties
Connected to Adaptive Server Enterprise - Adaptive Server Enterprise/15.0.2/EBF 15958 ESD#
6/P/Sun_svr4/OS 5.8/ase1502/2537/32-bit/FBO/Thu Oct 2 03:54:19 2008
Gathering schema details...
InvalidConfigurationException: Unexpected named parameter ':table')' found in SQL 'select
rowcnt row_count from systabstats where id = object_id(':table') and indid in (0,1)'
Unexpected named parameter ':table')
PS - same result when using jconn2.jar and sybase2.
There was a problem in the way that the customized SQL was being parsed. Try the latest beta version at http://schemaspy.sourceforge.net/schemaSpy.jar and let me know if that resolves the issue.
Thanks,
John
It sure does. Wow. It's one thing to see a demo db displayed - and quite another to see one's own. Nice piece of work, there, John!
Roger Reid
Thanks Roger. Let me know if you think of a new feature that'd make it better.
John