Cześć, mam problem z łączeniem się do oracla z aplikacji lokalnie na kompie, oracl jest też postawiony lokalnie na kompie. Czy muszę coś ustawić w oracle aby można się było do niego łączyć z aplikacji. Po uruchomieniu programu otrzymuje błąd jak poniżej
System.Exception: Hibernate operation: cannot open connection; uncategorized DataException for SQL []; ErrorCode [<no error code>]; ORA-12154: TNS:could not resolve the connect identifier specified
---> System.Exception: Hibernate operation: cannot open connection; uncategorized DataException for SQL []; ErrorCode [<no error code>]; ORA-12154: TNS:could not resolve the connect identifier specified
---> Spring.Data.UncategorizedAdoException: Hibernate operation: cannot open connection; uncategorized DataException for SQL []; ErrorCode [<no error code>]; ORA-12154: TNS:could not resolve the connect identifier specified
---> System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified
w System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
w System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
w System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
w System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
w System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
w System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
w System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
w System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
w System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
w System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
w System.Data.OracleClient.OracleConnection.Open()
w NHibernate.Connection.DriverConnectionProvider.GetConnection()
w NHibernate.Impl.SessionFactoryImpl.OpenConnection()
--- Koniec śladu stosu wyjątków wewnętrznych ---
w Spring.Data.Support.FallbackExceptionTranslator.Translate(String task, String sql, Exception exception)
w Spring.Data.Support.ErrorCodeExceptionTranslator.Translate(String task, String sql, Exception exception)
w Spring.Data.NHibernate.HibernateAccessor.ConvertAdoAccessException(ADOException ex)
w Spring.Data.NHibernate.Generic.HibernateTemplate.ExecuteFind[T](IFindHibernateCallback1 action, Boolean exposeNativeSession) w Spring.Data.NHibernate.Generic.HibernateTemplate.FindByNamedParam[T](String queryString, String[] paramNames, Object[] values, IType[] types) w Spring.Data.NHibernate.Generic.HibernateTemplate.FindByNamedParam[T](String queryString, String[] paramNames, Object[] values) w WmsTiger.Dao.NHibernate.DaoBase2.Load(String query, String[] names, Object[] values)
w CompositionAopProxy_6ef4e4ea01e2469bb53014340ae1fddf.Load(String query, String[] names, Object[] values)
w CompositionAopProxy_3d51a86156674960a700f8146d6c3070.Load(String query, String[] names, Object[] values)
w WmsTiger.Core.Common.EndUserBO.Account(String name, String password)
w Spring.DynamicReflection.Method_Account_48e960a89d044936a0e4fcdae2847f29.Invoke(Object target, Object[] args)
w Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments)
w Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint()
w Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
w WmsTiger.Core.Security.AuthenticationAdvice.Invoke(IMethodInvocation invocation)
--- Koniec śladu stosu wyjątków wewnętrznych ---
w WmsTiger.Core.Security.AuthenticationAdvice.Invoke(IMethodInvocation invocation)
w Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
w Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors)
w CompositionAopProxy_3c0478777df948b6b4eeaab5b3851804.Account(String name, String password)
w CompositionAopProxy_746dae76d02d4fbea3b918d54dd6b98a.Account(String name, String password)
w WmsTiger.Core.Security.SessionBO.Login(String name, String password, String workstation)
w Spring.DynamicReflection.Method_Login_daa83a60389944a0a5cb5aa1ea0434b9.Invoke(Object target, Object[] args)
w Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments)
w Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint()
w Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
w WmsTiger.Core.Security.AuthenticationAdvice.Invoke(IMethodInvocation invocation)
--- Koniec śladu stosu wyjątków wewnętrznych ---
w WmsTiger.Core.Security.AuthenticationAdvice.Invoke(IMethodInvocation invocation)
w Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
w Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors)
w CompositionAopProxy_94a4b178bd294bb7b9c5f7164c8419cd.Login(String name, String password, String workstation)
w CompositionAopProxy_7ed05f0508584f7cae978528841d0cf7.Login(String name, String password, String workstation)
w SessionBOWS.Login(String name, String password, String workstation)