Stack Overflow
Stack Overflow

Questions tagged [hxtt]

8 questions
4
votes
1 answer

How to simulate group_concat in plain sql

I am using the hxtt sql driver for csv files. It only supports plain sql. is there a way to simulate group concat using plain sql statements?
Luke101
  • 63,072
  • 85
  • 231
  • 359
1
vote
0 answers

Accessing remote Excel data sheets through JDBC connects successfully in case of wrong credential

I am connecting to remote excel file using jdbc driver: Class.forName(JDBC_DRIVER); System.out.println("Connecting to database..."); conn = DriverManager.getConnection("jdbc:excel:smb://username:pass@host/path/Data.xlsx"); …
Lusi
  • 391
  • 9
  • 28
1
vote
0 answers

HXTT excel driver connection issue

I am using HXTT excel driver to get data from an excel file. The data directory is not in the Windows machine where the Java program should run, but instead those Excel files are in IMB machine. Let's say my excel file on IBM is in…
Lusi
  • 391
  • 9
  • 28
0
votes
0 answers

Is there any difference between FTP and SFTP regarding content cache mechanism

We are using hxtt jdbc driver to load files from server What is HXTT CSV driver : hxtt driver is used treat file as database tables allow user to fetch the data using SQL Queries Example : Employee.csv file having following record EmpID,…
Suraj Kudale
  • 39
  • 8
0
votes
0 answers

Experiencing weird issue while making FTP connection using hxtt diver

I am trying to access one file via FTP using hxtt driver, but I am able to make a connection. If I pass username and password in URL it is successful, but I get an exception if I pass username and password separately in properties file. Please see…
Suraj Kudale
  • 39
  • 8
0
votes
0 answers

Differences between hxtt and ucanaccess

I know both work. I know ucanaccess is open source. I just wonder if there are any benefits in still using hxtt. I have some corruption issues with hxtt, so I'm trying to understand if it's a good approach to completely switch over to ucanaccess.…
George Sofianos
  • 440
  • 1
  • 7
  • 17
0
votes
0 answers

Extract OU info from database using a query

We have a column that looks like this CN=1245657,OU=TestOU,OU=East,OU=NorthPole,OU=Cali,OU=Computers,DC=test2,DC=Test1,DC=Test5 As you can see the string above has 5 OUs. The amount of OUs can range from 0 to 5 in the string. We need to make…
Luke101
  • 63,072
  • 85
  • 231
  • 359
-1
votes
1 answer

Escaping comma inside double quotes in sql

I have a csv file which contains a column with values inside the double quotes. Few of the values inside the double quotes also contains commas(Example "Alexandar, the Third"). I am using the below hxtt properties to read the file from the location…
Archita
  • 1