#13 Ingres Support

[Anonymous]

Would it be possiable to get db support for Ingres in
the near future. I believe there to be an open source
jdbc connector of sorts. That said Ingres is strange
in the way it handles Dates and a couple of other
things. I believe they have another layer between the
jdbc. Anyways I'd be willing to put up a couple of
dollars to get the work done. I tested the program for
the first time today and managed to create some awesome
results on the mysql stuff I have. I've got to create
an ERD shortly and a Data Dictionary for 1865 Tables on
a IngresDB (r2.5 Patch 73?) and this would help out ohh
so Much!.

Regards...

[John Currier]

Logged In: YES
user_id=1264584

The tool that I'm using to graph the relationships
(Graphviz's dot) seems to choke at about 400-500 tables, so
SchemaSpy won't be able to give you the 'big picture' view
of your relationships. Even if it could, the image would be
so massive that it wouldn't be useable/unreadable. You'll
still be able to see the details of the individual table
relationships as long as you don't have some insane number
of tables all referencing one column (dot seems to blow up
at around 220 tables referencing one table).

Do you know the details of the Ingres JDBC driver? It's
simple to configure once the driver class and connection
spec are known. You, of course, would have to test it since
I don't have an Ingres database.

John

[Nobody/Anonymous]

Logged In: NO

I can point to links for the information. I understand what
needs to be done just not sure how to do it. Java is foreign
and so is jdbc when it comes to ingres. I can however work
with your software. I've managed to fix some font issues in
Ubuntu and get grafviz working enuf to draw the relationship
(erd) of the one innodb table I'm using on a mysql db.

http://opensource.ca.com/projects/ingres/files/z4.ingreshibernate

and

http://www.iua.org.uk/conference/presentations/200105_1520_1.ppt

have lots of info on it. I just can not find a
ca.edbc.jdbc.EdbcDriver file to use and well not sure I
would know how to get schemaspy to use it anyways.

[John Currier]

Logged In: YES
user_id=1264584

I can't access the CA stuff without being their customer.

You'll need to create an ingres.properties file
(mysql.properties out of the .jar would probably be a decent
starting point). It'll need:

driver=ca.edbc.jdbc.EdbcDriver

connectionSpec needs to be set to something like:
connectionSpec=jdbc:edbc://<host>:<port>/<database>-<server_class>

but I have no idea what server_class is (nor if it's
actually required). If you google for
ca.edbc.jdbc.EdbcDriver you'll hopefully find some hits that
match the database configuration that you've got.

Once you've got it working please post the results so I can
include them in SchemaSpy.

Thanks,
John

[John Currier]

Logged In: YES
user_id=1264584

Did you ever find the EdbcDriver? It'll usually be in a
.zip or .jar (leave it there). You'll need to use -cp to
point to the .jar(s) or .zip(s) that contain the file named
ca/edbc/jdbc/EdbcDriver.class.

John

[John Currier]

Tagged as 'pending' due to inactivity / lack of response.

[SourceForge Robot]

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

[Todamok]

Hi, I'd like to revive a discussion on Ingres support.
I have two Ingres server connections for testing:
1. one via native JDBC driver from Actian (owner of Ingres) - http://esd.actian.com/
2. another via JDBC-ODBC bridge - http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html

Regards,
Luke