It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to connect to Pervasive DB

Sivakrishna Donepudi Dec 01, 2015

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

2 answers

1 vote
Renato Rudnicki Atlassian Team Dec 01, 2015

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 Dec 01, 2015

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.

1 vote
Alexandra Topoloaga Dec 03, 2015

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

667 views 7 0
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you