{"action":"created","issue":{"url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli/issues/88","repository_url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli","labels_url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli/issues/88/labels{/name}","comments_url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli/issues/88/comments","events_url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli/issues/88/events","html_url":"https://github.com/utPLSQL/utPLSQL-cli/issues/88","id":339439999,"node_id":"MDU6SXNzdWUzMzk0Mzk5OTk=","number":88,"title":"Trouble when connect user/pswd@TNSName","user":{"login":"SebGt","id":28985083,"node_id":"MDQ6VXNlcjI4OTg1MDgz","avatar_url":"https://avatars1.githubusercontent.com/u/28985083?v=4","gravatar_id":"","url":"https://api.github.com/users/SebGt","html_url":"https://github.com/SebGt","followers_url":"https://api.github.com/users/SebGt/followers","following_url":"https://api.github.com/users/SebGt/following{/other_user}","gists_url":"https://api.github.com/users/SebGt/gists{/gist_id}","starred_url":"https://api.github.com/users/SebGt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SebGt/subscriptions","organizations_url":"https://api.github.com/users/SebGt/orgs","repos_url":"https://api.github.com/users/SebGt/repos","events_url":"https://api.github.com/users/SebGt/events{/privacy}","received_events_url":"https://api.github.com/users/SebGt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"pesse","id":8362976,"node_id":"MDQ6VXNlcjgzNjI5NzY=","avatar_url":"https://avatars1.githubusercontent.com/u/8362976?v=4","gravatar_id":"","url":"https://api.github.com/users/pesse","html_url":"https://github.com/pesse","followers_url":"https://api.github.com/users/pesse/followers","following_url":"https://api.github.com/users/pesse/following{/other_user}","gists_url":"https://api.github.com/users/pesse/gists{/gist_id}","starred_url":"https://api.github.com/users/pesse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pesse/subscriptions","organizations_url":"https://api.github.com/users/pesse/orgs","repos_url":"https://api.github.com/users/pesse/repos","events_url":"https://api.github.com/users/pesse/events{/privacy}","received_events_url":"https://api.github.com/users/pesse/received_events","type":"User","site_admin":false},"assignees":[{"login":"pesse","id":8362976,"node_id":"MDQ6VXNlcjgzNjI5NzY=","avatar_url":"https://avatars1.githubusercontent.com/u/8362976?v=4","gravatar_id":"","url":"https://api.github.com/users/pesse","html_url":"https://github.com/pesse","followers_url":"https://api.github.com/users/pesse/followers","following_url":"https://api.github.com/users/pesse/following{/other_user}","gists_url":"https://api.github.com/users/pesse/gists{/gist_id}","starred_url":"https://api.github.com/users/pesse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pesse/subscriptions","organizations_url":"https://api.github.com/users/pesse/orgs","repos_url":"https://api.github.com/users/pesse/repos","events_url":"https://api.github.com/users/pesse/events{/privacy}","received_events_url":"https://api.github.com/users/pesse/received_events","type":"User","site_admin":false}],"milestone":null,"comments":8,"created_at":"2018-07-09T13:02:17Z","updated_at":"2018-07-10T06:57:27Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nWhen I use utPLSQL-cli (for the first time, before I used utplsql-sql-cli)  I receive this error :\r\n```\r\njava.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier  \"db_test_dev\"\r\n\tat oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)\r\n\tat oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)\r\n\tat oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)\r\n\tat oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)\r\n\tat oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)\r\n\tat com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117)\r\n\tat com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:375)\r\n\tat com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:204)\r\n\tat com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:445)\r\n\tat com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516)\r\n\tat com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:116)\r\n\tat com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)\r\n\tat org.utplsql.cli.ConnectionInfo.getConnection(ConnectionInfo.java:34)\r\n\tat org.utplsql.cli.RunCommand.run(RunCommand.java:149)\r\n\tat org.utplsql.cli.Cli.main(Cli.java:33)\r\nCaused by: oracle.net.ns.NetException: could not resolve the connect identifier  \"db_test_dev\"\r\n\tat oracle.net.resolver.NameResolver.resolveName(NameResolver.java:181)\r\n\tat oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:431)\r\n\tat oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:693)\r\n\tat oracle.net.ns.NSProtocol.connect(NSProtocol.java:251)\r\n\tat oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)\r\n\tat oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)\r\n\t... 14 more\r\n```\r\n\r\nCommand line is :\r\n`V:\\utPLSQL-cli\\bin\\utplsql run test_usr/test_pswd@db_test_dev -f=ut_xunit_reporter -o=tpkg_result.xml -p=test_usr.tpkg_one`\r\n\r\nWhen I do the same with `test_usr/test_pswd@10.1.1.1:1550:db_t_dev` it is working fine.\r\n\r\nORACLE_HOME variable is set as suggested in the doc.\r\nDis you have an idea ?\r\nThanks"},"comment":{"url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli/issues/comments/403720678","html_url":"https://github.com/utPLSQL/utPLSQL-cli/issues/88#issuecomment-403720678","issue_url":"https://api.github.com/repos/utPLSQL/utPLSQL-cli/issues/88","id":403720678,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMzcyMDY3OA==","user":{"login":"SebGt","id":28985083,"node_id":"MDQ6VXNlcjI4OTg1MDgz","avatar_url":"https://avatars1.githubusercontent.com/u/28985083?v=4","gravatar_id":"","url":"https://api.github.com/users/SebGt","html_url":"https://github.com/SebGt","followers_url":"https://api.github.com/users/SebGt/followers","following_url":"https://api.github.com/users/SebGt/following{/other_user}","gists_url":"https://api.github.com/users/SebGt/gists{/gist_id}","starred_url":"https://api.github.com/users/SebGt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SebGt/subscriptions","organizations_url":"https://api.github.com/users/SebGt/orgs","repos_url":"https://api.github.com/users/SebGt/repos","events_url":"https://api.github.com/users/SebGt/events{/privacy}","received_events_url":"https://api.github.com/users/SebGt/received_events","type":"User","site_admin":false},"created_at":"2018-07-10T06:57:27Z","updated_at":"2018-07-10T06:57:27Z","author_association":"NONE","body":"Hi @pesse,\r\nThanks for your time.\r\nI changed my ORACLE_HOME :\r\n\r\n```\r\nV:\\Tools\\UnitTests\\Jenkins\\utPLSQL-cli\\bin>echo %ORACLE_HOME%\r\nY:\\dev\\ORACLE\r\n```\r\n\r\nhere is my tnsnames.ora :\r\n\r\n```\r\nDB_TEST_DEV.WORLD  =\r\n  (DESCRIPTION =\r\n    (ADDRESS_LIST =\r\n      (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 15.3.2.22)(Port = 1555))\r\n    )\r\n    (CONNECT_DATA =\r\n      (SID = DB_DEV)\r\n    )\r\n  )\r\n```\r\n\r\nI still have the issue.\r\n\r\nDo you think that the suffix \".WORLD\" in tnsnames can cause the issue?\r\n\r\nI tried to use DB_TEST_DEV.WORLD in connection string but I have this error:\r\n```\r\nV:\\Tools\\UnitTests\\Jenkins\\utPLSQL-cli\\bin>utplsql run test_usr/test_pswd@db_test_dev.world\"\r\n\r\njava.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: \"host:port:sid\"\r\n        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)\r\n        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)\r\n        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)\r\n        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)\r\n        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)\r\n        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117)\r\n        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:375)\r\n        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:204)\r\n        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:445)\r\n        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516)\r\n        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:116)\r\n        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)\r\n        at org.utplsql.cli.ConnectionInfo.getConnection(ConnectionInfo.java:34)\r\n        at org.utplsql.cli.RunCommand.run(RunCommand.java:116)\r\n        at org.utplsql.cli.Cli.main(Cli.java:29)\r\nCaused by: oracle.net.ns.NetException: Invalid connection string format, a valid format is: host:port:sid\"\r\n        at oracle.net.resolver.AddrResolution.resolveSimple(AddrResolution.java:498)\r\n        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:437)\r\n        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:693)\r\n        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:251)\r\n        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)\r\n        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)\r\n        ... 14 more\r\n```\r\n\r\n\r\nThanks again."}}
{"actor":{"display_login":"SebGt"}}