В weblogic настроено соединение с ms sql.
JNDI - sdoadmin
Name - JDBC Data Source-0
user - sdoadmin
portNumber - 1433
databaseName - SDO
serverName - admin-pc
Помогите, пожалуйста, в приложении, которое находится на сервере, настроить соединение с sql.
При следующем коде в сервлете ничего не выходит:
Context ctx=null;
Connection conn=null;
try{
ctx=new InitialContext();
conn=DriverManager.getConnection("jdbc:weblogic:sqlserver://admin-pc:1433") ;
out.println("<hr/>"+conn.getMetaData().getDatabaseProductVersion());
}
catch (Exception e) {
e.printStackTrace();
}

[03:24:22 PM] [Deployer:149193]Operation "deploy" on application "forum" has failed on "TestServer".
[03:24:22 PM] [Deployer:149034]An exception occurred for task [Deployer:149026]deploy application forum on TestServer.: java.lang.ClassNotFoundException: oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener.
[03:24:22 PM] weblogic.management.DeploymentException: java.lang.ClassNotFoundException: oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener
[03:24:22 PM] Deployment cancelled.
[03:24:22 PM] ---- Deployment incomplete ----.
[03:24:22 PM] Remote deployment failed (oracle.jdevimpl.deploy.common.Jsr88RemoteDeployer)

Я так понимаю, ошибка где то на сервере, но как устранить?

Sherst,
<?xml version="1.0" encoding="UTF-8" ?>
<weblogic-application xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=" http://xmlns.oracle.com/weblogic/weblogic-application http://xmlns.oracle.com/weblogic/weblogic-application/1.1/weblogic-application.xsd"
xmlns=" http://xmlns.oracle.com/weblogic/weblogic-application">
<application-param>
<param-name>jps.credstore.migration</param-name>
<param-value>OVERWRITE</param-value>
</application-param>
<application-param>
<param-name>jps.policystore.migration</param-name>
<param-value>OVERWRITE</param-value>
</application-param>
<listener>
<listener-class>oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener</listener-class>
</listener>
<module>
<name>TestDataBase</name>
<type>JDBC</type>
<path>META-INF/TestDataBase-jdbc.xml</path>
</module>
</weblogic-application>

Sherst, из weblogic-application удалил:
<listener>
<listener-class>oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener</listener-class>
</listener>
пересобрал, передеплоил, не работает(может что то забыл?)

Sherst,перезапустил, прежняя

В Forum.ear/META-INF/weblogic-application/xml
<?xml version="1.0" encoding="UTF-8" ?>
<weblogic-application xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=" http://xmlns.oracle.com/weblogic/weblogic-application http://xmlns.oracle.com/weblogic/weblogic-application/1.1/weblogic-application.xsd"
xmlns=" http://xmlns.oracle.com/weblogic/weblogic-application">
<application-param>
<param-name>jps.credstore.migration</param-name>
<param-value>OVERWRITE</param-value>
</application-param>
<application-param>
<param-name>jps.policystore.migration</param-name>
<param-value>OVERWRITE</param-value>
</application-param>
<listener>
</listener>
<module>
<name>TestDataBase</name>
<type>JDBC</type>
<path>META-INF/TestDataBase-jdbc.xml</path>
</module>
</weblogic-application>

[06:12:17 PM] Building...
[06:12:17 PM] Deploying 3 profiles...
[06:12:17 PM] Wrote EJB Module to C:\Users\доктор\JDeveloper\mywork\Forum\model\deploy\model.jar
[06:12:18 PM] Wrote Web Application Module to C:\Users\доктор\JDeveloper\mywork\Forum\view\deploy\view.war
[06:12:18 PM] Wrote Enterprise Application Module to C:\Users\доктор\JDeveloper\mywork\Forum\deploy\forum.ear
[06:12:18 PM] Deploying Application...
[06:12:18 PM] [Deployer:149193]Operation "deploy" on application "forum" has failed on "TestServer".
[06:12:18 PM] [Deployer:149034]An exception occurred for task [Deployer:149026]deploy application forum on TestServer.: java.lang.ClassNotFoundException: oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener.
[06:12:18 PM] weblogic.management.DeploymentException: java.lang.ClassNotFoundException: oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener
[06:12:18 PM] Deployment cancelled.
[06:12:18 PM] ---- Deployment incomplete ----.
[06:12:18 PM] Remote deployment failed (oracle.jdevimpl.deploy.common.Jsr88RemoteDeployer)

Sherstdoctor2008,

Скорее всего вам надо будет добавить файл
в classpath web logica...



появились изменения
[08:07:19 PM] Building...
[08:07:20 PM] Deploying 3 profiles...
[08:07:20 PM] Wrote EJB Module to C:\Users\доктор\JDeveloper\mywork\Forum\model\deploy\model.jar
[08:07:20 PM] Wrote Web Application Module to C:\Users\доктор\JDeveloper\mywork\Forum\view\deploy\view.war
[08:07:21 PM] Wrote Enterprise Application Module to C:\Users\доктор\JDeveloper\mywork\Forum\deploy\forum.ear
[08:07:21 PM] Deploying Application...
[08:07:23 PM] weblogic.management.DeploymentException: java.lang.ClassNotFoundException: oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener
[08:07:23 PM] Deployment cancelled.
[08:07:23 PM] ---- Deployment incomplete ----.
[08:07:23 PM] Remote deployment failed (oracle.jdevimpl.deploy.common.Jsr88RemoteDeployer)

Sherst, перезагружал, файл другой версии(не критично?)
C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.jps_12.1.2\jps-wls.jar

Всем спасибо, разобрался. Надо изменить настройки безопастности и синхронизации.

Может быть кто-нибудь захочет помочь:



EJB Exception: : javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: java.sql.SQLException: User: sdoadmin, failed to be authenticated. Error Code: 0 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:614) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:186) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:278) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:304) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:282) at weblogic.persistence.TransactionalEntityManagerProxyImpl.newPersistenceContext(TransactionalEntityManagerProxyImpl.java:71) at weblogic.persistence.BasePersistenceContextProxyImpl.getPersistenceContext(BasePersistenceContextProxyImpl.java:175) at weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:106) at weblogic.persistence.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:82) at weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:92) at com.sun.proxy.$Proxy136.createNamedQuery(Unknown Source) at ru.test.model.ForumFace.findPersonByLoginAndPassword(ForumFace.java:38) at ru.test.model.ForumFace.getPerson(ForumFace.java:25) at ru.test.model.ForumFace_vqxeio_ForumWorkImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:33) at ru.test.model.ForumFace_vqxeio_ForumWorkImpl.getPerson(Unknown Source) at ru.test.forum.LoginCheck.doPost(LoginCheck.java:34) at javax.servlet.http.HttpServlet.service(HttpServlet.java:751) at javax.servlet.http.HttpServlet.service(HttpServlet.java:844) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:341) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at ru.test.util.FilterCharset.doFilter(FilterCharset.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3367) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3333) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57) at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2220) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2146) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2124) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1564) at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:295) at weblogic.work.ExecuteThread.run(ExecuteThread.java:254) Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: java.sql.SQLException: User: sdoadmin, failed to be authenticated. Error Code: 0 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:309) at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:690) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:215) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:554) ... 38 more Caused by: java.sql.SQLException: java.sql.SQLException: User: sdoadmin, failed to be authenticated. at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:278) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:416) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:393) at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:132) ... 42 more Caused by: java.sql.SQLException: User: sdoadmin, failed to be authenticated. at weblogic.jdbc.common.internal.RmiDataSource.getSubject(RmiDataSource.java:473) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:407) ... 44 more


Заранее благодарен.