Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed Forums > Databases > Firebird SQL Development
Reload this Page

SchemaSpy.jar


Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 5th, 2011, 07:06 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
SchemaSpy.jar
I try to analyse a database with this:

http://schemaspy.sourceforge.net/

Does somebody have this working on Firebird?

How?

Thanks.
Reply With Quote
  #2  
Old February 5th, 2011, 05:13 PM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,683 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 34 m 7 sec
Reputation Power: 284
What is your problem?
Show us the error message or whatever you are getting.
Reply With Quote
  #3  
Old February 6th, 2011, 04:42 AM
mariuz's Avatar
mariuz mariuz is offline
Bug Hunter
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 309 mariuz User rank is Sergeant (500 - 2000 Reputation Level)mariuz User rank is Sergeant (500 - 2000 Reputation Level)mariuz User rank is Sergeant (500 - 2000 Reputation Level)mariuz User rank is Sergeant (500 - 2000 Reputation Level)mariuz User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Day 9 h 38 m 4 sec
Reputation Power: 22
Talking
Quote:
Originally Posted by rapgame
I try to analyse a database with this:

http://schemaspy.sourceforge.net/

Does somebody have this working on Firebird?

How?

Thanks.


It should work with firebird , from what i have seen is listed in the supported databases
__________________
My home page: http://www.firebirdsql.org and work place :http://www.reea.net
Reply With Quote
  #4  
Old February 6th, 2011, 08:10 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
I am running ubuntu Lucid (10.4).

This Java tool has to connect with the Firebird database.

So I type:

Code:
# java -jar schemaSpy_5.0.0.jar -t firebird -db employee.fdb -s schema -u SYSDBA -p bliep -o /home/user/firebird/ -port 3050 -host localhost


The computer complains:

Using database properties:
Code:
  [schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/firebird.properties
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver

Failed to load driver 'org.firebirdsql.jdbc.FBDriver'
These entries don't point to valid files/directories: [/usr/java/tools/firebird/jaybird-full-2.0.1.jar, ;c, jdbc
                                                                                                                irebirdjaybird-full-2.0.1.jar]

Use the -dp option to specify the location of the database
drivers for your database (usually in a .jar or .zip/.Z).


So how-to resolve this.

Which Java jdbc driver do you use?

Another way to formulate this question:

I hava a Java program, how to communicate with Firebird.
Last edited by rapgame : February 6th, 2011 at 08:12 AM.
Reply With Quote
  #5  
Old February 6th, 2011, 08:23 AM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,683 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 34 m 7 sec
Reputation Power: 284
You need to specify the location of the JDBC driver's jar file:
Code:
java -jar schemaSpy_5.0.0.jar -cp /path/to/jaybird-full-2.1.6-java6.jar -t firebird -db employee.fdb -s schema -u SYSDBA -p masterkey -o /home/stage/rrap/firebird/ -port 3050 -host localhost
Reply With Quote
  #6  
Old February 6th, 2011, 08:58 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
Thanks!

so

#whereis jaybird-full-2.1.6

jaybird:


# apt-get install jaybird-full-2.1.6

failed, no such package.


Jaybird is not available for Ubuntu?
Where to get this Jaybird?
How to install this?
Reply With Quote
  #7  
Old February 6th, 2011, 09:12 AM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,683 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 34 m 7 sec
Reputation Power: 284
Quote:
Originally Posted by rapgame
Where to get this Jaybird?
How to install this?

Jaybird is the JDBC driver for Firebird
You can download it from the Firebird Homepage:
http://www.firebirdsql.org/index.php?op=devel&sub=jdbc

Simply copy the .jar file into a convenient directory.
Last edited by shammat : February 6th, 2011 at 09:21 AM.
Reply With Quote
  #8  
Old February 6th, 2011, 09:48 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
Wait a minute...

A jar is a compressed folder.

Like a zip folder.

Right?

Does Linux accept .zip instead of .jar files?

( I still get the error).

I actually found this all ready, but only zip folders and not the .jar ...

Thanks (again)
Reply With Quote
  #9  
Old February 6th, 2011, 09:53 AM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,683 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 34 m 7 sec
Reputation Power: 284
1) Download the ZIP file
2) unzip it
3) Copy the file jaybird-full-2.1.6.jar into a convenient directory
4) specify the full path to the .jar file when starting schema spy.
Reply With Quote
  #10  
Old February 6th, 2011, 09:56 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
Code:
 [schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/firebird.properties
Gathering schema details......16:55:18.875 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.firebirdsql.jdbc.field.TypeConvertionException: Types.ARRAY: SQL type for this field is not yet supported.
16:55:18.877 WARNING: Table.initColumnAutoUpdate - SQL: select * from "PROJ_DEPT_BUDGET" where 0 = 1
....16:55:18.919 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.firebirdsql.jdbc.field.TypeConvertionException: Types.ARRAY: SQL type for this field is not yet supported.
16:55:18.920 WARNING: Table.initColumnAutoUpdate - SQL: select * from "JOB" where 0 = 1
org.firebirdsql.jdbc.FBSQLException: The resultSet is closed
	at org.firebirdsql.jdbc.AbstractResultSet.getField(AbstractResultSet.java:642)
	at org.firebirdsql.jdbc.AbstractResultSet.getString(AbstractResultSet.java:701)
	at org.firebirdsql.jdbc.AbstractDatabaseMetaData.getPrimaryKeys(AbstractDatabaseMetaData.java:3689)
	at net.sourceforge.schemaspy.model.Table.initPrimaryKeys(Table.java:235)
	at net.sourceforge.schemaspy.model.Table.<init>(Table.java:90)
	at net.sourceforge.schemaspy.model.Database$TableCreator.createImpl(Database.java:1003)
	at net.sourceforge.schemaspy.model.Database$ThreadedTableCreator$1.run(Database.java:1044)
...(0sec)
Writing/graphing summary...java.lang.NullPointerException
	at net.sourceforge.schemaspy.DbAnalyzer.getImpliedConstraints(DbAnalyzer.java:68)
	at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:288)
	at net.sourceforge.schemaspy.Main.main(Main.java:42)


Thanks, but

and no information in the generated folders

Do you get this too?
Last edited by rapgame : February 6th, 2011 at 10:11 AM.
Reply With Quote
  #11  
Old February 6th, 2011, 10:34 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
I think a jar is always a zip

But a zip is not always a jar.

I found another jar:
Code:
#java -jar /home/java/schemaSpy_5.0.0.jar -t firebird -db /var/lib/firebird/2.1/data/employee.fdb -s schema -u SYSDBA -p blala -o /home/firebird/ -port 3050 -host localhost -dp /home/firebird/bla/jaybird-full-2.1.5.jar



Code:
Using database properties:
  [/home/schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/firebird.properties
Gathering schema details......17:29:54.985 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.firebirdsql.jdbc.field.TypeConvertionException: Types.ARRAY: SQL type for this field is not yet supported.
.17:29:54.987 WARNING: Table.initColumnAutoUpdate - SQL: select * from "PROJ_DEPT_BUDGET" where 0 = 1
.17:29:55.004 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.firebirdsql.jdbc.field.TypeConvertionException: Types.ARRAY: SQL type for this field is not yet supported.
17:29:55.004 WARNING: Table.initColumnAutoUpdate - SQL: select * from "JOB" where 0 = 1
......(0sec)
Writing/graphing summary..............(0sec)
Writing/diagramming details...........(2sec)
Wrote relationship details of 11 tables/views to directory '/home//firebird' in 3 seconds.
View the results by opening /home//firebird/index.html


Lots of thanks, it works!
Last edited by rapgame : February 6th, 2011 at 01:40 PM.
Reply With Quote
  #12  
Old February 6th, 2011, 12:27 PM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
Sometimes you have to add -dbThreads 1

Because of multiple connections.

Code:
#java -jar /home/java/schemaSpy_5.0.0.jar -t firebird -db /var/lib/firebird/2.1/data/employee.fdb -s schema -u SYSDBA -p blala -o /home/firebird/ -port 3050 -host localhost -dp /home/firebird/jaybird-full-2.1.5.jar -dbThreads 1


Why are those multiple connection issues never the case with MySQL and PostgreSQL?
Last edited by rapgame : February 6th, 2011 at 01:41 PM.
Reply With Quote
  #13  
Old February 7th, 2011, 09:55 AM
john.currier john.currier is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2011
Posts: 1 john.currier User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 m 30 sec
Reputation Power: 0
I've updated firebird.properties to indicate that it's single-threaded. Note that Oracle and MS SQL Server also have JDBC metadata services that don't support queries from multiple threads.

John
Reply With Quote
  #14  
Old February 8th, 2011, 01:45 AM
rapgame rapgame is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2009
Posts: 74 rapgame User rank is Private First Class (20 - 50 Reputation Level)rapgame User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 14 h 12 m 41 sec
Reputation Power: 4
Thanks,

This is the kind of feedback and support I really appreciate.

Long live opensource and their contributors.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > SchemaSpy.jar

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap