Bernard created NETBEANS-3051: --------------------------------- Summary: Database Explorer cannot run queries using Csv Driver Key: NETBEANS-3051 URL: https://issues.apache.org/jira/browse/NETBEANS-3051 Project: NetBeans Issue Type: Bug Components: db - Show Data Affects Versions: 11.1 Environment: Windows 7, Java 12 Reporter: Bernard
It is possible to establish a connection using this driver. It is also possible to see the tables in the Database Explorer tree for a connection. However, running a query fails with a connection error. How to reproduce: Open and build the attached project. This loads the following dependency into your local repository: <dependency> <groupId>org.xbib.jdbc</groupId> <artifactId>jdbc-driver-csv</artifactId> <version>1.2.0</version> </dependency> Run the project to verify that the connection works as expected. This should have loaded the driver into your local repository like: C:\Users\user\.m2\repository\org\xbib\jdbc\jdbc-driver-csv\1.2.0\jdbc-driver-csv-1.2.0.jar In Database explorer, add the driver with driver file as above: Databases|Drivers|New Driver|Add| For JDBC URL, add the directory from the project JdbcCsvSample\src\test\resources\csv: Add a connection: Connect using ... JDBC URL: like jdbc:xbib:csv:C:/JdbcCsvSample/src/test/resources/csv Connection Properties: line.separator, \r\n Test connection. The test must work, as it works on my system. After the new connection is added, In Database Explorer, on that connection, under Tables, the "SYMBOL" table is visible. Right click on "SYMBOL" and select "View Data..." This fails with [1:1] Failed in 0 s. [Exception, Error code 0, SQLState null] Unable to Connect to database : DatabaseConnection[name='jdbc:xbib:csv:C:/JdbcCsvSample/src/test/resources/csv [ on Default schema]'] Line 1, column 1 -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists