#29 How to use in JDeveloper

[Anup]

I have created a datasource successfully in JDEV 11G, and am able to test with a directory. But when I try to either connect to the datasource or use it for a DB ADapter (in 11G these are JCA Adapters) the connection is failing with the error "DatabaseMetaData.getTableTypes() unsupported". How do I get JDEV to show me the folder structure, the files within, OR eventually use the data source in the adapter?

I know that we can write pure java to accomplish this using the examples on your site.

Best Regards,
Anup

[Simon Chenery]

Please checkout the current source code and build csvjdbc.jar.

Use the steps described in the 'Building From Source' section of
http://csvjdbc.sourceforge.net/

The current source code implements java.sql.DatabaseMetadata
methods (including getTableTypes()). The released version does not
include these methods.

You probably also need to set the database connection property
raiseUnsupportedOperationException=false to avoid exceptions
in java.sql.Connection.setAutoCommit() and other JDBC functions
that CsvJdbc does not support:

Properties props = new Properties();
props.put("raiseUnsupportedOperationException", "false");
Connection conn = DriverManager.getConnection("jdbc:relique:csv:" + dir, props);

The project administrators will release a new version of CsvJdbc soon.