DataSource em um Stateless EJB 2

Programação Java
#1

Pessoal,

Estou apanhando um pouco disso e já se esgotaram as idéias e pesquisas.

Não consigo acessar fazer o lookup do DataSource em um Stateless ou então acesso e me é exibido o erro: java.sql.SQLException: Table not found in statement [SELECT * FROM teste], consigo acessar por um servlet dentro do meu war mas no ejb não vai.

Segue os arquivos.

ejb-jar.xml

<?xml version="1.0" encoding="UTF-8"?>
<ejb-jar 
	xmlns="http://java.sun.com/xml/ns/j2ee" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/ejb-jar_2_1.xsd"
	version="2.1">

	<display-name>j2eemodel-ti-ejb</display-name>

	<enterprise-beans>
		<session>
			<display-name>Stateless</display-name>
			<ejb-name>Stateless</ejb-name>
			<local-home>j2eemodel.ti.ejb.LocalHome</local-home>
			<local>j2eemodel.ti.ejb.Local</local>
			<ejb-class>j2eemodel.ti.ejb.Bean</ejb-class>
			<session-type>Stateless</session-type>
			<transaction-type>Container</transaction-type>
			<resource-ref>
				<res-ref-name>jdbc/j2eemodel-ds</res-ref-name>
				<res-type>javax.sql.DataSource</res-type>
				<res-auth>Container</res-auth>
			</resource-ref>
		</session>
	</enterprise-beans>
	
</ejb-jar>

jboss.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS 4.2//EN" "http://www.jboss.org/j2ee/dtd/jboss_4_2.dtd">
<jboss>
	<enterprise-beans>
		<session>
			<ejb-name>Stateless</ejb-name>
			<local-jndi-name>j2eemodel/ti/stateless</local-jndi-name>
			<resource-ref>
				<res-ref-name>jdbc/j2eemodel-ds</res-ref-name>
				<resource-name>java:comp/jdbc/j2eemodel-ds</resource-name>
			</resource-ref>
		</session>
	</enterprise-beans>
</jboss>

Apesar de não utilizar cmp, coloquei para testes, mas não adiantou.
jbosscmp-jdbc.xml

<?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE jbosscmp-jdbc PUBLIC
      "-//JBoss//DTD JBOSSCMP-JDBC 4.2//EN"
      "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_2.dtd">
<jbosscmp-jdbc>
	<defaults>
		<datasource>java:comp/jdbc/j2eemodel-ds</datasource>
	</defaults>
</jbosscmp-jdbc>

Método do Bean que faz a invocação:

try {
			Context ctx = new InitialContext();
			DataSource ds = (DataSource) ctx
					.lookup("java:comp/env/jdbc/j2eemodel-ds");
			Connection cnn = ds.getConnection();
			Statement stmt = cnn.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM teste");

			while (rs.next())
				System.out.println("<br />&quot; + rs.getString(1));

			rs.close();
			stmt.close();
			cnn.close();
		} catch (Exception ex) {
			ex.printStackTrace();
		}

E o DataSource:
j2eemodel-ds.xml

&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
&lt;datasources&gt;
  &lt;local-tx-datasource&gt;
    &lt;jndi-name&gt;jdbc/j2eemodel&lt;/jndi-name&gt;
    &lt;connection-url&gt;jdbc:mysql://localhost:3306/j2eemodel&lt;/connection-url&gt;
    &lt;driver-class&gt;com.mysql.jdbc.Driver&lt;/driver-class&gt;
    &lt;user-name&gt;???&lt;/user-name&gt;
    &lt;password&gt;???&lt;/password&gt;
    &lt;exception-sorter-class-name&gt;org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter&lt;/exception-sorter-class-name&gt;
    
    &lt;metadata&gt;
       &lt;type-mapping&gt;mySQL&lt;/type-mapping&gt;
    &lt;/metadata&gt;
  &lt;/local-tx-datasource&gt;
&lt;/datasources&gt;

Valeu!!!

#2

Caramba,

Deu trabalho, mas consegui.

O problema era a tag resource-name no arquivo jboss.xml

Acabei colocando-a, pois estava dando erro ao tentar pegar a conexão, mas agora tirando-a funcionou.

#3