Assets - Import Database Driver not found!

[Adam Laskowski]

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

[Marc - Devoteam · Accepted solution]

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]

@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]

@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 :)