schemaspy-users Mailing List for SchemaSpy
Brought to you by:
johncurrier
Menu
▾
▴
schemaspy-users — Generic discussions for SchemaSpy users
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
(1) |
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
(4) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2007 |
Jan
(2) |
Feb
|
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
(2) |
Apr
(2) |
May
|
Jun
(2) |
Jul
|
Aug
(4) |
Sep
|
Oct
(1) |
Nov
(3) |
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
(1) |
| 2018 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2021 |
Jan
|
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <de...@tu...> - 2021-03-18 14:19:54
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META name=GENERATOR content="MSHTML 11.00.10570.1001"></HEAD> <BODY> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">Dear Purchasing Manager</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">Have a nice day~</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">Glad to hear that you're on the market for 18650 lithium ion batteries and lithium polymer batteries!</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">I am dean from Tuok battery company.We specialize in the batteries for 10 years.</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">And we have KC,UL,CB,CE,UN38.3 certifications for our main batteries.</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">We will provide a high quality & very competitive price for your products.</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">If you want more details from us,pls contact us freely.Looking forward to your reply soon.</SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px"><BR></SPAN></P> <P style="FONT-SIZE: 15px; MARGIN-BOTTOM: 0px; FONT-FAMILY: Arial; WHITE-SPACE: normal; WORD-SPACING: 0px; MARGIN-TOP: 0px; TEXT-TRANSFORM: none; FONT-WEIGHT: 400; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial"><SPAN style="FONT-SIZE: 14px">Best Regards</SPAN></P></BODY></HTML> |
|
From: PureView <hug...@pu...> - 2021-02-24 16:57:57
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META name=GENERATOR content="MSHTML 11.00.9600.18739"></HEAD> <BODY> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face=Calibri>Hello Sir/Madam<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face=Calibri> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face=Calibri>Our factory produce rechargeable fan with Lion battery with multifunction in good quality and low price.<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face=Calibri> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face=Calibri>Please contact with me whatsapp +86 1855226178 for more detail.<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face=Calibri> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face=Calibri>Hugh Chiu</FONT><o:p></o:p></SPAN></P></BODY></HTML> |
|
From: Carlos D. <car...@gm...> - 2020-11-27 16:48:18
|
Hi everyone, Thanks for schemaspy, great tool! I wonder if I can ask for the descriptive statistics of the columns automatically together with the regular output. I saw there is an sql query override possible, but I really would like to add more things on the output. Any ideas? take care, Carlos. -- Carlos Denner dos Santos, PhD |
|
From: John C. <cur...@is...> - 2018-01-24 19:01:10
|
Hey SchemaSpy https://goo.gl/f2g9Na John Currier |
|
From: Rich S. <rsh...@ap...> - 2016-12-26 21:52:23
|
I have tried to apply SchemaSpy to to an existing database here. My
attempts failed despite reading the SchemaSpy web page and following
recommended syntax. Using the required options for postgres the results are
an uninformative generic use response; e.g.,
$ java -jar schemaSpy_5.0.0.jar -t pgsql -db jerrittmine -h localhost -u
rshepard -o development
SchemaSpy generates an HTML representation of a database schema's
relationships.
Usage:
java -jar schemaSpy_5.0.0.jar [options]
-t databaseType type of database - defaults to ora
use -dbhelp for a list of built-in types
-u user connect to the database with this user id
-s schema defaults to the specified user
-p password defaults to no password
-o outputDirectory directory to place the generated output in
-dp pathToDrivers optional - looks for JDBC drivers here before
looking in driverPath in [databaseType].properties.
Go to http://schemaspy.sourceforge.net for a complete list/description
of additional parameters.
Sample usage using the default database type (implied -t ora):
java -jar schemaSpy.jar -db mydb -s myschema -u devuser -p password -o
output
On my Slackware-14.1 system JDBC is located in /usr/lib/jdbc-3.0 so I did
not add it to the command line.
Can you suggest how I can make it work here?
Rich
|
|
From: John C. <cur...@kn...> - 2016-11-30 04:37:53
|
hi SchemaSpy http://uvelicheniechlena.com/dbn/templates/sloth_webmaster.php?lead=1typ82zrw9tggs6 John Currier |
|
From: Karthik K. <gur...@gm...> - 2014-05-05 21:47:14
|
I'm trying to use Oracle thin driver and keep getting errors because schemaSpy tries to create SID instead of the service_name. The property 'connectionSpec' in the properties file seems to be ignored. Has anyone seen this issue? java -jar "C:\schemaSpy.jar" -dp "C:\ojdbc6.jar" -t orathin -u userAbc -p secretpwd-o "C:\outputFolderAbc" connectionSpec=jdbc:oracle:thin:@//myhost1:1521/serviceAbc -host myhost1 -port 1521 I also tried replacing -t orathin with -t orathin_serviceAbc, as suggested in some blogs... but nothing helps. Failed to connect to database URL [jdbc:oracle:thin:@myhost1 :1521:serviceAbc] java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at net.sourceforge.schemaspy.SchemaAnalyzer.getConnection(SchemaAnalyzer.java:582) at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:157) Any help is appreciated. This seems like a popular DB modeling tool, but I'm surprised that it does not work for a simple use case (oracle thin driver with service_name).. ~ thanks, Karthik Karuppannan. |
|
From: Leonid S. <leo...@po...> - 2014-05-01 22:10:13
|
I tried using schemaSpy_5.0.0.jar against MS SQL Server 2005 and got into trouble after running for 10 minutes.
I used sqljdbc4.jar and got the following:
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:13:52.102 SEVERE: TDSParser.throwUnexpectedTokenException - ConnectionID:1 ClientConnectionId: ded17f48-91bd-4eab-a76a-694dc61c3317: getNextResult: Encounte
red unexpected unknown token (0x49)
17:13:52.104 SEVERE: TDSReader.throwInvalidTDSToken - ConnectionID:1 ClientConnectionId: ded17f48-91bd-4eab-a76a-694dc61c3317 got unexpected value in TDS respo
nse 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.m
ajor_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.obj
ect_id), c.column_id
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.checkClosed(SQLServerDatabaseMetaData.java:119)
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getImportedKeys(SQLServerDatabaseMetaData.java:947)
at net.sourceforge.schemaspy.model.Table.connectForeignKeys(Table.java:106)
at net.sourceforge.schemaspy.model.Database.connectTables(Database.java:984)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:83)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:211)
at net.sourceforge.schemaspy.Main.main(Main.java:42)
I also tried using jtds-1.2 and 1.3 drivers but these one did not even find a proper class.
Can you suggest a workaround or as I suspect, SchemaSpy is not supported any longer and we need to find another DB schema visualizer ?
Thankfully yours,
Leo...@po...<mailto:Leo...@po...>
|
|
From: Tomi N/A <he...@gm...> - 2012-07-20 15:23:19
|
Hello, I've been using SchemaSpy with pleasure for years with various databases, but right now I can't connect to a locally hosted PostgreSQL database: $ java -jar /opt/schema\ spy/schemaSpy_5.0.0.jar -t pgsql -db mydb -u postgres -o ~/sspy -host localhost -port 5433 -dp /usr/share/java/postgresql.jar Using database properties: [/opt/schema spy/schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties Failed to connect to database URL [jdbc:postgresql://localhost/mydb] org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) ...(snip)... It appears to make no sense since it is very easy to check that something is, in fact, listening on the specified port using telnet: tnalfir@tasha:~$ telnet localhost 5433 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. I can connect to the database in question using SQL Workbench, which uses the same JDBC driver I use with SchemaSpy, so I know that it is PostgreSQL that is listening on the port and that the the JDBC driver isn't to blame. The only thing that's non-standard is the port (5433 instead of 5432), but I specify it explicitly so I assumed it would not be a problem. Any ideas what the problem might be? Thanks. Cheers, Tomislav |
|
From: Pablo L. <pab...@ho...> - 2011-09-26 10:56:10
|
Ups! forgot to enclose the patches. sorry! El 26/09/2011 12:52, Pablo Leon escribió: > Hi, > > I've been having some problems using schemaSpy with firebird, and after > some research I've found them to be caused by this bug: > http://tracker.firebirdsql.org/browse/JDBC-130 > > I enclose three patches that would help firebird users, and that > shouldn't hurt for other database users (though I haven't tested). Feel > free to incorporate then to schemaspy's source, if you wish. > > > Cheers, > > Pablo León > HORUS > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2dcopy1 > _______________________________________________ > Schemaspy-users mailing list > Sch...@li... > https://lists.sourceforge.net/lists/listinfo/schemaspy-users |
|
From: Pablo L. <pab...@ho...> - 2011-09-26 10:52:19
|
Hi, I've been having some problems using schemaSpy with firebird, and after some research I've found them to be caused by this bug: http://tracker.firebirdsql.org/browse/JDBC-130 I enclose three patches that would help firebird users, and that shouldn't hurt for other database users (though I haven't tested). Feel free to incorporate then to schemaspy's source, if you wish. Cheers, Pablo León HORUS |
|
From: John C. <cur...@ya...> - 2011-05-20 17:14:24
|
JDBC doesn't know anything about roles and therefore doesn't provide any APIs to
query or set them. To provide that support SchemaSpy would require a mechanism
to specify arbitrary SQL to be executed after the connection is established. It
should be possible to implement something like that, but it would require a bit
of thought and work.
John
________________________________
From: "Bohannon, Jerry (SAIC)" <Jer...@bp...>
To: sch...@li...
Sent: Thu, May 19, 2011 5:54:12 PM
Subject: [Schemaspy-users] How can I set an Oracle Role?
I am merely a user in an Oracle database. I am not the schema owner and do not
have the schema password. By default my userid does not have read access to the
schema I want to analyze with SchemaSpy. However, I do have a non-default role
gives me read access to the schema.
In SQL, I do the following:
sqlplus <userid>/<pwd>@<instance>
>set role ILX_DQSA_ADMIN;
After the set role is executed, I can see the tables in the schema.
When I run SchemaSpy, I get this message:
No tables or views were found in schema 'ILX37_GLOBAL'.
The schema exists in the database, but the user you specified (<userid>)
might not have rights to read its contents.
Is there a way to tell SchemaSpy to set the required role after it connects but
before it tries to gather the schema details? |
|
From: Bohannon, J. (SAIC) <Jer...@bp...> - 2011-05-19 22:22:34
|
I am merely a user in an Oracle database. I am not the schema owner and
do not have the schema password. By default my userid does not have read
access to the schema I want to analyze with SchemaSpy. However, I do
have a non-default role gives me read access to the schema.
In SQL, I do the following:
sqlplus <userid>/<pwd>@<instance>
>set role ILX_DQSA_ADMIN;
After the set role is executed, I can see the tables in the schema.
When I run SchemaSpy, I get this message:
No tables or views were found in schema 'ILX37_GLOBAL'.
The schema exists in the database, but the user you specified
(<userid>)
might not have rights to read its contents.
Is there a way to tell SchemaSpy to set the required role after it
connects but before it tries to gather the schema details?
|
|
From: John C. <cur...@ya...> - 2010-11-18 22:40:30
|
Do you have more of the stack trace from the failure? It should give us some
more clues.
John
________________________________
From: Richard Sickler <ric...@av...>
To: "sch...@li..."
<sch...@li...>
Sent: Mon, November 15, 2010 5:22:23 PM
Subject: [Schemaspy-users] Can't connect to MSSQL Express 2005
Hi,
I'm having problems connecting to a MS SQL Express database.
I can get schemaspy to connect to a PostGRESQL database just fine.
I can get Microsoft's SQL Server Management Studio Express to connct to this
MSSQL data base,
but I can't get schemaspy to connect to the MSSQL 2005 Express database.
I have tried many combination of commands and drivers, (MS's sqljdbc4.jar, and
jtds-1.2.5.jar) with no luck.
I have set the ports to use 1433 - although I have had no trouble connecting
with Management Studio.
I have been trying variations of:
java -jar schemaSpy.jar -t mssql05 -db <dbname> -host <hostname> -port 1433 -u
<username> -p <password> -o schemaspy.res -dp sqljdbc4.jar
and similar incantations with jtds-1.2.5.jar.
I keep getting Failed to connect to database URL
[jdbc:sqlserver:/<hostname>:1433;databseName=<dbname>]
Okay, it has to be something that I'm not doing, or not doing correctly, but
darn if I can see it.
Help?
|
|
From: Richard S. <ric...@av...> - 2010-11-16 00:49:38
|
Hi, I'm having problems connecting to a MS SQL Express database. I can get schemaspy to connect to a PostGRESQL database just fine. I can get Microsoft's SQL Server Management Studio Express to connct to this MSSQL data base, but I can't get schemaspy to connect to the MSSQL 2005 Express database. I have tried many combination of commands and drivers, (MS's sqljdbc4.jar, and jtds-1.2.5.jar) with no luck. I have set the ports to use 1433 - although I have had no trouble connecting with Management Studio. I have been trying variations of: java -jar schemaSpy.jar -t mssql05 -db <dbname> -host <hostname> -port 1433 -u <username> -p <password> -o schemaspy.res -dp sqljdbc4.jar and similar incantations with jtds-1.2.5.jar. I keep getting Failed to connect to database URL [jdbc:sqlserver:/<hostname>:1433;databseName=<dbname>] Okay, it has to be something that I'm not doing, or not doing correctly, but darn if I can see it. Help? |
|
From: John C. <cur...@ya...> - 2010-11-01 22:08:30
|
The default database engine in MySQL is MyISAM. It does not support foreign key relationships and, as a result, SchemaSpy won't be able to determine the relationships. InnoDB is another MySQL database engine that fully supports foreign key relationships. John ________________________________ From: Heinrich Stoellinger <hc....@ao...> To: sch...@li... Sent: Sun, October 31, 2010 6:11:42 AM Subject: [Schemaspy-users] No relationships shown Hello, I am using schemaSpy 5.0.0 under Debian-Squeeze and MySQL 5.1. It's certainly a great tool, but no relationships among tables are shown, even though during execution I get the message --------------------------------- Wrote relationship details of 224 tables/views to directory '/applDevelopment/design/documentation' in 22 seconds --------------------------------- Does anybody know what might be wrong? Any help is appreciated. Regards H. Stoellinger Austria -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ Schemaspy-users mailing list Sch...@li... https://lists.sourceforge.net/lists/listinfo/schemaspy-users |
|
From: Heinrich S. <hc....@ao...> - 2010-10-31 11:11:43
|
Hello, I am using schemaSpy 5.0.0 under Debian-Squeeze and MySQL 5.1. It's certainly a great tool, but no relationships among tables are shown, even though during execution I get the message --------------------------------- Wrote relationship details of 224 tables/views to directory '/applDevelopment/design/documentation' in 22 seconds --------------------------------- Does anybody know what might be wrong? Any help is appreciated. Regards H. Stoellinger Austria -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ |
|
From: Alexandre S. <ale...@gm...> - 2010-08-18 21:17:14
|
I like a lot this project! I make post in my blog (portuguse brasil) about schemaspy. Congratulations! On Aug 18, 2010 1:12 PM, "John Currier" <cur...@ya...> wrote: Thanks guys. I hope to put out another release in the near future to get rid of the ads. They've generated very close to zero income so they're really nothing more than an annoyance and clutter. For now you can just use the undocumented -noads option. Thanks, John ------------------------------ *From:* Tim Pizey <ti...@pa...> *To:* sch...@li... *Sent:* Wed, August 18, 2010 2:37:13 AM *Subject:* [Schemaspy-users] Congratulations on version 5.00 release Hi John, congratulations on version 5 release. Tim ---------------------------------------------... ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Schemaspy-users mailing list Sch...@li... https://lists.sourceforge.net/lists/listinfo/schemaspy-users |
|
From: John C. <cur...@ya...> - 2010-08-18 16:12:26
|
Thanks guys. I hope to put out another release in the near future to get rid of the ads. They've generated very close to zero income so they're really nothing more than an annoyance and clutter. For now you can just use the undocumented -noads option. Thanks, John ________________________________ From: Tim Pizey <ti...@pa...> To: sch...@li... Sent: Wed, August 18, 2010 2:37:13 AM Subject: [Schemaspy-users] Congratulations on version 5.00 release Hi John, congratulations on version 5 release. Tim ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Schemaspy-users mailing list Sch...@li... https://lists.sourceforge.net/lists/listinfo/schemaspy-users |
|
From: Tim P. <ti...@pa...> - 2010-08-18 08:37:23
|
Hi John, congratulations on version 5 release. Tim |
|
From: John C. <cur...@ya...> - 2010-08-17 20:34:11
|
I just wanted to let everyone know that I finally got off of my butt and put out an official release. The details are in the release notes (http://schemaspy.sourceforge.net/releaseNotes.html). Thanks for your support, John |
|
From: John C. <cur...@ya...> - 2010-06-02 17:38:32
|
Can you try the latest beta version and try using the JTDS driver? James Eggers had a similar problem and resolved it using that driver.
John
________________________________
From: Tony Scamurra <tsc...@ki...>
To: sch...@li...
Sent: Wed, June 2, 2010 7:00:59 AM
Subject: [Schemaspy-users] Help with SchemaSpy...
Hello,
I have successfully used SchemaSpy with MySQL, but I also
need to run it against an MSSql DB but I get the following error:
Using
database properties:
[schemaSpy_4.1.1.jar]/net/sourceforge/schemaspy/dbTypes/mssql05.properties
Connected
to Microsoft SQL Server - 9.00.4053
Gathering
schema details...
Failed
to retrieve column comments: com.microsoft.sqlserver.jdbc.SQLServerException:
The "variant" data type is not supported.
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 OBJECTP
ROPERTY(c.object_id,
'IsMsShipped')=0 ORDER BY OBJECT_NAME(c.object_id), c.column_id
Jun
2, 2010 8:45:54 AM com.microsoft.sqlserver.jdbc.TDSParser
throwUnexpectedTokenException
SEVERE:
ConnectionID:1: getNextResult: Encountered unexpected unknown token (0x49)
Jun
2, 2010 8:45:54 AM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
SEVERE:
ConnectionID:1 got unexpected value in TDS response at offset:82
com.microsoft.sqlserver.jdbc.SQLServerException:
The connection is closed.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.checkClosed(SQLServerDatabaseMetaData.java:115)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:422)
at net.sourceforge.schemaspy.model.Database.initViews(Database.java:565)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:49)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:164)
at net.sourceforge.schemaspy.Main.main(Main.java:21)
Any help would be greatly appreciated.
Thanks,
Tony
|
|
From: Tony S. <tsc...@ki...> - 2010-06-02 14:34:19
|
Hello,
I have successfully used SchemaSpy with MySQL, but I also need to run it
against an MSSql DB but I get the following error:
Using database properties:
[schemaSpy_4.1.1.jar]/net/sourceforge/schemaspy/dbTypes/mssql05.properties
Connected to Microsoft SQL Server - 9.00.4053
Gathering schema details...
Failed to retrieve column comments:
com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is
not supported.
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 OBJECTP
ROPERTY(c.object_id, 'IsMsShipped')=0 ORDER BY OBJECT_NAME(c.object_id),
c.column_id
Jun 2, 2010 8:45:54 AM com.microsoft.sqlserver.jdbc.TDSParser
throwUnexpectedTokenException
SEVERE: ConnectionID:1: getNextResult: Encountered unexpected unknown token
(0x49)
Jun 2, 2010 8:45:54 AM com.microsoft.sqlserver.jdbc.TDSReader
throwInvalidTDS
SEVERE: ConnectionID:1 got unexpected value in TDS response at offset:82
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServe
rException.java:171)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.checkClosed(SQLServer
DatabaseMetaData.java:115)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDa
tabaseMetaData.java:422)
at
net.sourceforge.schemaspy.model.Database.initViews(Database.java:565)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:49)
at
net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:164)
at net.sourceforge.schemaspy.Main.main(Main.java:21)
Any help would be greatly appreciated.
Thanks,
Tony
|
|
From: John C. <cur...@ya...> - 2010-04-22 20:38:20
|
That's really, really slick. John ________________________________ From: Keith Clarke <kei...@cl...> To: sch...@li... Sent: Wed, April 21, 2010 6:17:54 AM Subject: [Schemaspy-users] Using SchemaSpy with Force.com Fyi, see http://force201.wordpress.com/2010/04/21/extracting-an-erd-from-force-com-using-schemaspy/ for some information on hooking SchemaSpy up to Forc.com. Keith -- ClaimVantage Corp. 5A Sandyford Business Park Sandyford, Dublin 18 (t) +353 1 294 4896 (e) kei...@cl... Specializing in Life & Health Claims Systems Please visit us at www.ClaimVantage.com ------------------------------------------------------------------------------ _______________________________________________ Schemaspy-users mailing list Sch...@li... https://lists.sourceforge.net/lists/listinfo/schemaspy-users |
|
From: Keith C. <kei...@cl...> - 2010-04-21 12:34:22
|
Fyi, see http://force201.wordpress.com/2010/04/21/extracting-an-erd-from-force-com-using-schemaspy/ for some information on hooking SchemaSpy up to Forc.com. Keith -- ClaimVantage Corp. 5A Sandyford Business Park Sandyford, Dublin 18 (t) +353 1 294 4896 (e) kei...@cl... Specializing in Life & Health Claims Systems Please visit us at www.ClaimVantage.com |
5 messages has been excluded from this view by a project administrator.
