topic Re: Help connecting to a pervasive database in Talend Studio

Help connecting to a pervasive database

Pager — Wed, 06 Feb 2019 19:44:15 GMT

NewBie here!

I need some help setting up a connection to a pervasive database, I have an ODBC connection setup, but I don't see a option for odbc under the DB Type. So how do you create a connect to a pervasive database? Any help would be greatly appreciated!

Re: Help connecting to a pervasive database

vapukov — Wed, 06 Feb 2019 23:58:56 GMT

Talend Studio is Java application and does not work with ODBC, instead, you need use JDBC drivers

you need check Pervasive site for download proper jdbc drivers and manually setup JDBC connection in Talend

sample of connection properties would be similar to - https://www.dbvis.com/features/pervasive-database-drivers/

Re: Help connecting to a pervasive database

Pager — Fri, 08 Feb 2019 13:18:24 GMT

Thanks for the reply!

I search the web and could not find a jdbc driver for pervasive, can anyone point me to a url where I can download jdbc drivers for pervasive database?

Re: Help connecting to a pervasive database

vapukov — Fri, 08 Feb 2019 13:22:50 GMT

Google + DbSchema will help you 🙂

https://www.dbschema.com/jdbc-drivers/PervasiveJdbcDriver.zip

Re: Help connecting to a pervasive database

Pager — Fri, 08 Feb 2019 19:43:51 GMT

Hey vapukov,

Thanks For the zip files, I'm having a problem getting the pvjdbc2.jar file installed. I think I'm doing this right, I went under "Show views" then selected Modules, and then selected the import external jars, found my file. I can see it installed in the list of modules, but as soon as I refresh the install goes away, looks like talend is not saving the install file. I'm using Talend v7.1 any ideas?

Thanks again for your help.

talend.PNG

Re: Help connecting to a pervasive database

Anonymous — Sun, 10 Feb 2019 01:27:24 GMT

Hi Pager
Use tJDBCxxx component and specify the jar file in the Drivers table.

Regards
Shong

Re: Help connecting to a pervasive database

BlueOctopus — Fri, 28 Jun 2019 10:25:47 GMT

Hi,

I have DBVIS installed and the connection is working fine. However when I try to access the data via Talend, I'm unable to do so.

Here the steps I followed:

via modules, installed 2 jars, needed for the database connection (identical ones to the ones used in DBVIS)

When I add in the database connection, the Pervasive driver is not showing up, which is strange ( but not an issue, seems to me)

I just add in the pervasive connection as a basic JDBC connection, similar to the syntax used on the DBVIS...

And I add in the drivers manually as shown in the below screenshot. No username and password are required in DBVIS, but still not working.

The error is connection failure. You must change the database setting, but which setting do I need to change?

In the detail it states:

Connection failure. You must change the Database Settings.
java.lang.reflect.InvocationTargetException
..
Caused by: java.lang.ClassNotFoundException: com.pervasive.pscs.Manager
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 24 more

Can someone help me out, please?

Thanks in advance.

Re: Help connecting to a pervasive database

Pager — Fri, 28 Jun 2019 13:44:56 GMT

This is how I have my pervasive db connection setup. Hope this helps.

Re: Help connecting to a pervasive database

BlueOctopus — Mon, 01 Jul 2019 07:46:54 GMT

Hi,

thanks for your help. It seems that I missed a component, which isn't needed for dbvisualizer.

My connection is now successful on testing, but on saving (finish) I get following error:

What am I doing wrong?

Re: Help connecting to a pervasive database

BlueOctopus — Tue, 02 Jul 2019 09:26:58 GMT

It seems that there was a stability issue on saving the connection. I retried and now it saves seemingly correctly.

Re: Help connecting to a pervasive database

Anonymous — Wed, 18 Dec 2019 15:08:45 GMT

Hi everyone!

I got really big problems with Pervasive DB, because i lost drivers and now can't connect to database, cause i can't find these drivers on internet.

If somebody has these drivers, can you please send it to me?

Here or gorval92@mail.ru

That's what i need:

Pervasive JDBC Driver 2.2
pvjdbc2.jar
pvjdbc2x.jar

I will be really grateful for this, thank you!