OSX 10.2.8, Witango 5.0.1.065 server, JDBC from Oracle, Witango 5.5 beta and Witango 5.0.9
part of jdbc.ini
<DataSource ID="name">
<DSN>name</DSN>
<DriverClass>oracle.jdbc.OracleDriver</DriverClass>
<URL>jdbc:oracle:thin:@serverxxx:port:dbSID</URL>
<Properties />
</DataSource>I filled in all the proper data and I can connect to Oracle.
When I log on using a login account that owns schema, I get a secondary menu asking to select the table I want to connect to. If the user does not own any schema, then nothing shows up. (I'm writing this from notes taken while talking to our DBA--that's not me so if I make a technical error.....)
What we would like is for Witango, using JDBC, to give us read access to schema (groups of tables) by public synonym. Is the fact that we can't get these schema a feature of the Oracle JDBC driver or somewhere else? Thanks.
-- Peter Link System Manager, ISSO Innovative Business and Information Services Lawrence Livermore National Laboratory P.O. Box 808, L-664 Livermore, CA 94550 [EMAIL PROTECTED] (925) 423-1230 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
