Hi, I'm having difficulty test-driving datavision. I'm running Oracle 8.1.7
on Redhat Linux (7.1? whatever's latest -- we just upgraded the linux os a
couple of weeks ago), with the jdbc driver in classes12.zip. I'm able to get
a connection, but when I doubleclick on "All Database Fields" in the field
popup, I get no tables. Also, under Database/Table Linker, all the pulldowns
are blank -- no fields, no table names, nothing.
To verify my connection, I wrote a trivial program using the same jdbc
driver to connect to the same database, and it's able to retrieve records,
traverse recordsets, etc., so I know it's not a driver problem. I'm running
version 0.3.0 of datavision. My client machine is win98, and I'm connecting
through SecureCRT, which port-forwards the normal port 1501 as port 9901.
But, as I say, I've tested this connection in my own java program, which
works just fine with port forwarding.
Frankly, I'm stumped. Any idea why I can't seem to get any metadata about
the database schema? There are plenty of tables and views defined, and I'm
logging in as the schema owner so it's not a permissions problem either.
Here's the test code that succeeds:
/** begin test code **/
public class Test
public static void main(String args)
Test test = new Test();
Driver driver = new OracleDriver();
Connection connection =
"DekWeb", "****"); //password commented out
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM Style");
System.out.println("style: " + resultSet.getObject("style"));
System.out.println("name: " + resultSet.getObject("name"));
catch (SQLException e)
System.out.println("exception connecting: " + e.getMessage());
catch (Exception e)
System.out.println("other exception: " + e.getMessage());
/** end of test code **/
Pretty straightforward stuff, traverses a table named Style, works like a
champ. This is exactly the same connect string, with exactly the same
OracleDriver class, yet datavision sees no tables.
Any ideas? I'm excited about datavision, and want to see it do its thing.
I've looked at the layout engine code, and creating an xsl:fo layout engine
should be very straightforward, once I iron out the kinks to basic
Thanks for your help,
They that can give up essential liberty
to obtain a little temporary safety,
deserve neither liberty nor safety.