Oracle JDBC works right up till choosing columns!!?? [message #32340] |
Fri, 29 April 2005 17:40 |
Eclipse User |
|
|
|
Originally posted by: ken.casey.wholefoods.com
BIRT _0.0.1
Oracle 9x
I've tried every combo of Oracle library in odaconfig.xml of having
classes12.jar in / out and in / out
<LibraryName>ojdbc14.jar</LibraryName> <!-- oracle -->
<LibraryName>oda-jdbc.jar</LibraryName>
<LibraryName>jtds-0.9.jar</LibraryName> <!-- sqlserver, sybase -->
<LibraryName>mysql-connector-java-3.0.16-ga-bin.jar</LibraryName > <!--
mysql -->
<LibraryName>db2jcc.jar</LibraryName> <!-- derby, db2 -->
<LibraryName>db2jcc_license_cu.jar</LibraryName> <!-- derby, db2 -->
<LibraryName>classes12.jar</LibraryName>
<LibraryName>ifxjdbc.jar</LibraryName> <!-- informix -->
<LibraryName>postgresql-8.0-310.jdbc3.jar</LibraryName> <!-- postgre -->
I can go through setting up a new data source...
tried all these driver classes:
sun.jdbc.odbc.JdbcOdbcDriver (2.1)
net.sourceforge.jtds.jdbc.Driver (0.9)
oracle.jdbc.driver.OracleDriver (1.0)
oracle.jdbc.OracleDriver (1.0)
Use this as my database URL:
jdbc:odbc:smartdev
"test connection" works in all cases
Nwe Data Set. I can see everything as expected in selecting schema, tables
(where I can see the table column names in the visio-like diagram), but when
I get to where I select the columns, there's no list, and the > or >>
buttons do nothing.
|
|
|
Powered by
FUDForum. Page generated in 0.04763 seconds