How to connect to Pervasive DB

[Sivakrishna Donepudi]

Hi,

I'm trying to connect Pervasive to create KCF Pro Single Auto complete drop down and not able to proceed ..

I copied jar files to lib folder and prepared below template based on this data  https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration 

<Resource name="easyDB"

          auth="Container" type="javax.sql.DataSource"

          username=“usernmae"

          password=“password"

          driverClassName="com.pervasive.jdbc.v2.Driver"

          url="jdbc:pervasive://IP Address:1583/DB Name?transport=tcp"

 />

But I'm always getting error message " com.pervasive.jdbc.v2.Connection.isValid(I)Z" with return code 500

[Alexandra Topoloaga]

After seeing the stacktrace, we discovered that the jdbc driver does not implement the method isValid, added in jre6.

So, it is not an problem with KCF Pro plugin but with the jdbc, which was, most probably, developed under java 5 and  didn't get updated accordingly to newer versions of java..
Our suggestion is to ask for support the Pervasive team. Maybe they have another jdbc driver available (we have already taken a look at v11 SP3 and it does not fit) or if/when they plan to add one with support for higher versions of java. 

Alexandra

[rrudnicki]

Hello, 

It's a generic error message, given when an unexpected condition was encountered and no more specific message is suitable. With JDBC, that error usually occurs because your JDBC driver implements an older version of the JDBC API than the one included in your JRE or that is incompatible with your JRE/JDK version. 

However, keep in mind pervasive DB isn't supported as you can check on this documentation: https://confluence.atlassian.com/jira/supported-platforms-207488170.html

Even if you are able to setup this connection, you can face other issues due this configuration. 

Cheers, 

Renato Rudnicki

[Sivakrishna Donepudi]

Hi Renato, Thanks for reply. I'm not trying to connect pervasive DB for whole JIRA application, i'm trying to connect to Pervasive DB only for one KCF pro custom field. 1. Copied pervasive JDBC driver .jar files under JARA/lib folder 2. Added this entry for context.xml under JARA/Conf folder <Resource name="easyDB" auth="Container" type="javax.sql.DataSource" username=“usernmae" password=“password" driverClassName="com.pervasive.jdbc.v2.Driver" url="jdbc:pervasive://IP Address:1583/DB name" /> by referring this example https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration 3. Created Sql data source with simple autocomplete script " select job_name from job where job_name like {query} || '%';" It seems to be KCF pro doesn't support Pervasive DB.