Would like to support the service connection url as opposed to the SID - (have
an oracle instance that is addressed via service id and not the SID
is there a way to support the service id in the connection url (the 1st method
via the 2nd) it appears that I cannot construct the URL using the serviceid.
// String url = "jdbc:oracle:thin:@//server.local:1521/prod";
// String url = "jdbc:oracle:thin:@server.local:1521:prodsid";
Can you access your database using a test JDBC program and the Oracle JDBC
driver, using the first URL? If you can, SchemaCrawler will be able to acces
your database using that URL too, since SchemaCrawler uses JDBC and the Oracle
I'll construct the test java code right now and let you know - I'm trying this
with the sc.cmd / sc.sh command line programs, and they don't appear to have
options that support the service id calls, (no SID).
Once you have the JDBC URL, you can construct your own SchemaCrawler command-
line. There is a variation of the SchemaCrawler command-line that accepts a
URL. At this point, you will not be using sc.cmd/ sc.sh, but calling the Java
executable directly, with the Oracle driver on the classpath.
kewl - I was able to connect with the jdbc service syntax
con = java.sql.DriverManager.getConnection(url);
Can I just change the sc.sh invocation to call the with the URL / driver
Try constructing a plain Java command-line first, taking a look at what is in
sc.sh. Then you can put the Java command line that you constructed into sc.sh
I'm reading thru the examples - and it looks like what I want to do it change
the properties file to run a particular invocation as I describe above
can I just make this
I'm going to try and see what happens (I can't infer how the other variables
are used from this config file.)
ok - i"m working it - ty.
You should not need to change the properties files - there is a flavor of the
command line that takes a URL and the JDBC driver class name.
got it - using the schemacrawler-8.2-distrib did the following
1) copy the oracle jdbc driver into ./lib
2) use the url version of the command line
worked great - thank you very much.
Excellent. Thanks for sharing this.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.