nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Assets - Import Database Driver not found!

Adam Laskowski_0w3u89

Hi everyone,

in Assets we´re trying to import an external oracle database.

In the import screen when i try to check the test configuration i get an "Driver not found"-Error (see image).

Which driver do i exactly need for this?

I downloaded ojdbc8.jar here and put it in <jira Installation>/lib but it doesn't help.

I did not restart our jira instance though.

Thanks in advance!

Cheers!

Adam

Accepted answers

Marc -Devoteam-

Hi @Adam Laskowski

I'm not that familiar with server/DC configs anymore, but I do remember that a restart is required to make use of a driver.

All comments

Marc -Devoteam-

Hi @Adam Laskowski

I'm not that familiar with server/DC configs anymore, but I do remember that a restart is required to make use of a driver.

Adam Laskowski_0w3u89

@Marc -Devoteam-

thanks a lot, it worked! I restarted all nodes and the connection/test configuration was successful.

Sadly another problem occurs.

After creating an object type i am unable to provide a correct select statement.

This simple select works in DbVisualizer.

The error message (in german) is something like this:

"Error

The database could not be queried with the provided selector SELECT * from ADDRESS."

Can not find anything in the logs (insight-log).

Marc -Devoteam-

Hi @Adam Laskowski

I think you first need to import information from the DB into Assets before you can use them.

See documentation: https://confluence.atlassian.com/servicemanagementserver/database-import-1044784475.html

Adam Laskowski_0w3u89

@Marc -Devoteam-

Thanks again! You´re a lifesaver.

Yes it´s so simple. I just need to add the Schema as written in the docu.

So it´s something like "select * from MySchema.MyTable" and it worked!

In some cases, I still encounter issues. When importing a large table (15+ million rows), everything freezes, not just assets but the entire Jira instance, and I need to restart all nodes. I suspect I need to adjust the SELECT statement to import only specific portions of it. Do you have any ideas?

Anyways you helped me a lot. Thanks again. The Connection to the DB works. This can be closed

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server