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
