Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Executing unit tests in Jenkins

DanielSagnerJun 2 2016 — edited Jun 9 2016

Hi

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

Comments

IlicAlex
Hi,
TNS_ADMIN used in command prompt is somehow ignored (added comment afterwards: mapped drive used in TNS_ADMIN may not be accessable, use UNC path in TNS_ADMIN instead).
Create TNSNAMES entry through Oracle Net Configuration Assistant.

Test Connection on Linked server must work before any SELECT can work.

To use insert from linked server data change provider options:
Allow inprocess = checked

Restart SQL server windows service and try again.

Best regards,
Alex

Edited by: user4580124 on Dec 15, 2010 1:40 PM

Edited by: user4580124 on Nov 15, 2011 2:56 AM
newbiegal
Thanks Alex. I installed Oracle client 10.2.0.1, created linked server and followed the steps above and it worked. But get the following error for some selects..

SELECT * FROM
testlink..user.table

Invalid data for type "numeric".


I researched on this error that it is fixed in ODAC 10.2.0.2.21. I first installed Oracle client (Oracle10g_client_64bit.zip) and then tried installing ODAC (Oracle 10g Release 2 ODAC 10.2.0.2.21) but get a "runtime error" during the install.. Not sure if I'm missing something...


Please help
IlicAlex
Hi,
Whenever I detect strange behavior of an Oracle installation I first check the paths:
Installation folder and destination paths should not have blanks or empty space characters.
I can tell you for 11g x64 client installation. It does not work if the installation folder contains blank.

Do you have only problem with numeric tables? How about tables with string values only?

Best regards,
Alex
1010089
You get this error because the Oracle data dictionary is case sensitive. Oracle object names are all uppercase by default. The linked-server query must exactly match the case of all referenced Oracle metadata, such as schema and table names. So, the following query works:
SELECT * FROM oradb..SCOTT.DEPT WHERE deptno = 10
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 7 2016
Added on Jun 2 2016
#sql-developer
4 comments
1,345 views