4 Replies Latest reply on Jun 9, 2016 9:13 AM by DanielSagner

Executing unit tests in Jenkins

DanielSagner Jun 2, 2016 1:05 PM

Is anyone here running unit tests in a Build/CI tool like Jenkins/Hudson?

I am getting the error

Connection not found: unit_test_repos

I am testing it on my Windows7 PC with local installations of both SQL Developer and Jenkins. When I run:

Call D:\sqldeveloper\sqldeveloper\bin\sdcli unittest -run -test -name MY_TEST -repo unit_test_repos -db my_user

from command line it runs just fine: "Command Completed". But when I copy/paste the same line in Jenkins build step "Execute Win batch commmand" it fails with the above error.

SQLDev connection unit_test_repos is "Basic" (no TNS, no nothing) with saved password.

I am logged as a Windows domain user, so I even created the same user in Jenkins (using active_directory plugin) thinking that's the reason for Jenkins not recognising the connection, but no luck.

I read that in the case of Jenkins running on separate build server SQLDev needs to be installed there too, but in my case everything is on the same machine.

Any advices?

Thank you

Daniel

1. Re: Executing unit tests in Jenkins

thatJeffSmith-Oracle Jun 2, 2016 1:57 PM (in response to DanielSagner)

so if you run the GUI on your jenkins machine, do you see the MY_TEST connection in the connection panel?
Like Show 0 Likes(0)

Actions
2. Re: Executing unit tests in Jenkins

DanielSagner Jun 3, 2016 6:07 AM (in response to thatJeffSmith-Oracle)

Hi Jeff
thank you for responding.

My understanding was that unit_test_repos and my_user (owner of procedure to be tested) are SQL Developer "connections", and I have them in the Connections panel. But MY_TEST is a test, not connection (?), So I see it in the Unit Test panel under the node Unit Tests - unit_test_repos (Admin) -> Tests -> MY_TEST. Did I completely missed the point?
Like Show 0 Likes(0)

Actions
3. Re: Executing unit tests in Jenkins

thatJeffSmith-Oracle Jun 3, 2016 9:40 AM (in response to DanielSagner)

no, i misread the string
Call D:\sqldeveloper\sqldeveloper\bin\sdcli unittest -run -test -name MY_TEST -repo unit_test_repos -db my_user

I mean to ask about unit_test_repos, sorry
Like Show 0 Likes(0)

Actions
4. Re: Executing unit tests in Jenkins

DanielSagner Jun 9, 2016 9:13 AM (in response to thatJeffSmith-Oracle)

Just a follow-up:

.msi installer automatically installs Jenkins as a windows service, which is very convenient, but this service does not recognize SQL Developer connections. I stopped/disabled it and started Jenkins from console: java –jar jenkins.war and it became aware of connections and tests are now executed as expected.

I even tried to change Jenkins windows service properties Logon As: <the same user that created connections> but it didn't work. So I'll have to get used to have a Command Prompt window open all the time. No big deal.
Like Show 0 Likes(0)

Actions

Go to original post