Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Connection URL Error

SOLVED
Go to solution
Highlighted
HPSD
Occasional Contributor

JDBC Connection URL Error

Hi,

I am using the CSV JDBC Driver from sourceforge and when I run sd_export, it gives me an error:

Invalid JDBC connection url: jdbc:relique:csv:testdata for user

Here is what the start of my ini file looks like:

[CONNECTION]
TYPE=JDBC

[JDBC]
DRIVER=org.relique.jdbc.csv.CsvDriver
URL=jdbc:relique:csv:testdata
USR=
PWD=

please help!

In the readme file, it says the connection URL is jdbc:relique:csv:csvdir where csvdir is the directory in which the .csv files are found.

What am I doing wrong?

Thanks in advance!
-JT
12 REPLIES
Crist Vandendri
Esteemed Contributor

Re: JDBC Connection URL Error

Hi,

I have the same problem with xlsql.

[JDBC]
URL=jdbc:nilostep:excel:C:/Temp
DRIVER=com.nilostep.xlsql.jdbc.xlDriver

See thread http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=649577

Crist
HPSD
Occasional Contributor

Re: JDBC Connection URL Error

I am using this driver on a unix machine. I am not sure if that makes a difference?

Has anyone solved a "Invalid JDBC connection url" problem before?

Thanks a lot!
-JT
Crist Vandendri
Esteemed Contributor

Re: JDBC Connection URL Error

JT,

My problem is solved. Id did not have all required jars in the classpath for sd_export. Maybe you should have a look at that.

Hope this helps

Crist
Ganesha Sridhar
Esteemed Contributor

Re: JDBC Connection URL Error

Hello JT,

Please check the JDBC you are using is supported by Data Exchange of OVSD.
The Data Exchange guide may help you.

FYI..: We have ODBC on Windows 2000 for Text driver to import data from CSV file to OVSD and it worked fine.

Regards
Ganesha Sridhara
Crist Vandendri
Esteemed Contributor
Solution

Re: JDBC Connection URL Error

Hi JT,

Currently I'm using the Stels CSV driver. This one works on Windows. But since it is a type 4 driver, it should also work on Unix.

[CONNECTION]
TYPE=JDBC

[JDBC]
DRIVER=jstels.jdbc.csv.CsvDriver
URL=jdbc:jstels:csv:C:\Temp\test

Bye

Crist
HPSD
Occasional Contributor

Re: JDBC Connection URL Error

Thanks for the replies!

I got the connection to work. I had to put the jar file in /opt/OV/sd/server/bin directory and the csv file there as well.
The URL that I used was jdbc:relique:csv:/opt/OV/sd/server/bin and I was able to connect to my csv file through the JDBC driver.
HPSD
Occasional Contributor

Re: JDBC Connection URL Error

Hi Crist,

Just wondering, how did you setup your csv database for sd_export to read it properly?

The StelsCSV Driver works the same way as the one I got from sourceforge.

Thanks,
JT
Crist Vandendri
Esteemed Contributor

Re: JDBC Connection URL Error

You need a schema.xml file in the same dir as your source files. In that xml you specify your tables (=files), columns, delimiters,... Have a look at the docs, it is very well explained. In attach you will find an xml that worked for me.

Make sure you look at the doc for sql syntax also. The replace function, for example, is replace_string().

Does this answer your question? If not, let me know.

Crist
Crist Vandendri
Esteemed Contributor

Re: JDBC Connection URL Error

Just some info.

The problem with the sourceforge driver is that it does not support functions (string, date, numeric,...) I find that very limiting. That's why I went looking for another one.
HPSD
Occasional Contributor

Re: JDBC Connection URL Error

Hi Crist,

Thanks. I actually have that file already in the folder where my csv files are located. However, I guess my question is, how does this file get used during the sd_export process from the command line?

Thanks,
JT
Crist Vandendri
Esteemed Contributor

Re: JDBC Connection URL Error

You do not have to do anything. The driver will find it. The name has to be correct though.

Doesn't it work for you?
SameetPatro
Super Collector

How to use "jdbc_url" for connecting with different database.

Hi,

 

I want to connect to QA database from Dev database for executing a function.

I have developed a shell script contains :

#!/bin/sh.
DB_USERNAME = ppm
DB_PASSWORD = ppm_pass
DB_NAME = HPPMC92
SQLFILE_PATH = data/ppm_home/transfers/Deloitte_TestSQL.sql
SQLPLUS $1/$2@$3 @$SQLFILE_PATH
exit;

 

This is only working if i have QA tnsname entry in Dev tnsname.ora.

 

If I remove the QA tnsname entry from Dev tnsname.ora file then  it is not working as while executing shell script it throws error TNS:protocol adaptar error. I understand the issue.

 

But I saw there is JDBC_URL token , can anyone help me out to use the JDBC_URL token to connect different database. without creating an DB Link.

 

Any suggestion would be really helpful.

 

Thanks & Regards,

Sameet Kumar Patro

spatro@deloitte.com

//Add this to "OnDomLoad" event