[jira] [Created] (NETBEANS-3051) Database Explorer cannot run queries using Csv Driver

["Bernard (Jira)" <ji...@apache.org>]

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-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists