Discussoes de Programacao e Tecnologia

Conexão com JNDI em JBoss 5.0

2 respostas
leohunther
leohunther

Prezados,
Estou com o seguinte problema para conectar JNDI.
Meu context.xml está no META_INF da aplicação:

meu context:

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/slnBuscaSigera">
  <Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/acervotve" password="teste" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://192.168.0.20:1433/AcervoTVE" username="teste"/>
</Context>

Código para chamar o Connection

acervoRowSet = new CachedRowSetXImpl();
			InitialContext ctx = new InitialContext();
			DataSource db = (DataSource)ctx.lookup("java:jdbc/acervotve");
			Connection con = db.getConnection();

O erro acontece na linha:
DataSource db = (DataSource)ctx.lookup(“java:jdbc/acervotve”);

servidor JBOSS 5.0
Eclipse Ganymed
SQL SERVER 2000
usando jdbc: jtds-1.2.2.jar

Grato!

erro:

15:02:20,579 ERROR [STDERR] javax.naming.NameNotFoundException: jdbc not bound
15:02:20,579 ERROR [STDERR] 	at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
15:02:20,579 ERROR [STDERR] 	at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
15:02:20,579 ERROR [STDERR] 	at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
15:02:20,579 ERROR [STDERR] 	at org.jnp.server.NamingServer.lookup(NamingServer.java:396)
15:02:20,579 ERROR [STDERR] 	at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:713)
15:02:20,579 ERROR [STDERR] 	at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:673)
15:02:20,579 ERROR [STDERR] 	at javax.naming.InitialContext.lookup(Unknown Source)
15:02:20,579 ERROR [STDERR] 	at br.org.tvbrasil.dao.FiltroAcervoDAO.teste(FiltroAcervoDAO.java:112)
15:02:20,579 ERROR [STDERR] 	at br.org.tvbrasil.managedbeans.Index.entrar(Index.java:38)
15:02:20,579 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:02:20,579 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
15:02:20,579 ERROR [STDERR] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
15:02:20,579 ERROR [STDERR] 	at java.lang.reflect.Method.invoke(Unknown Source)
15:02:20,595 ERROR [STDERR] 	at org.apache.el.parser.AstValue.invoke(AstValue.java:170)
15:02:20,595 ERROR [STDERR] 	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
15:02:20,595 ERROR [STDERR] 	at org.apache.myfaces.el.convert.MethodExpressionToMethodBinding.invoke(MethodExpressionToMethodBinding.java:75)
15:02:20,595 ERROR [STDERR] 	at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:57)
15:02:20,595 ERROR [STDERR] 	at javax.faces.component.UICommand.broadcast(UICommand.java:141)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)
15:02:20,595 ERROR [STDERR] 	at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
15:02:20,595 ERROR [STDERR] 	at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103)
15:02:20,595 ERROR [STDERR] 	at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76)
15:02:20,595 ERROR [STDERR] 	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:151)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:390)
15:02:20,595 ERROR [STDERR] 	at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:517)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:02:20,595 ERROR [STDERR] 	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
15:02:20,595 ERROR [STDERR] 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
15:02:20,595 ERROR [STDERR] 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
15:02:20,595 ERROR [STDERR] 	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
15:02:20,595 ERROR [STDERR] 	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
15:02:20,595 ERROR [STDERR] 	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:02:20,595 ERROR [STDERR] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
15:02:20,595 ERROR [STDERR] 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
15:02:20,595 ERROR [STDERR] 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
15:02:20,595 ERROR [STDERR] 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
15:02:20,595 ERROR [STDERR] 	at java.lang.Thread.run(Unknown Source)
Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

2 Respostas

leohunther
leohunther

Tem que configurar mais alguma coisa?

R
romualdo.tio

Ola, sou novo aqui no forum e já gostaria de tirar uma duvida.
Tenho uma aplicação em flex, java, e com banco sql server. A conexão com o banco é feita atravez de um JNDI.
Segue as linhas do arquivo:

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: mssql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->

<!-- ======================================================================–>

<!-- New ConnectionManager setup for Microsoft SQL Server 2000  driver     -->

<!-- You may download the latest Microsoft JDBC driver from <em>Microsoft</em>    -->

<!-- <a href="http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-">http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-</a>

FILES/027/001/779/msdncompositedoc.xml&frame=true -->
<!-- ===================================================================== -->

<datasources>

<local-tx-datasource>

<jndi-name>nomeDoArquivo</jndi-name>

<connection-url>jdbc:jtds:sqlserver://nomeDaMaquina:1433/nomeDoBanco;tds=8.0</connection-url>

<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

<user-name>sa</user-name>

<password></password>

</local-tx-datasource>

</datasources>

Acontece que para conexão com o banco sql server 2005 é preciso ser adicionado mais alguma linha de comando neste arquivo.
Algum sabe o que precisa ser adicionado?
Grato.

Criado 23 de março de 2009
Ultima resposta 28 de out. de 2009
Respostas 2
Participantes 2

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura O que é Python? — um guia completo para iniciar nessa linguagem de programação Acesse agora o guia sobre Python e inicie sua jornada nessa linguagem de programação: o que é e para que serve, sua sintaxe e como iniciar nela!
Casa do Codigo Engenharia de Prompt para Devs: Um guia para aprender a... Por Ricardo Pupo Larguesa — Casa do Codigo