Name Not Bound Exception

[sravani jetty]

Hi,
I am using Netbeans IDE with JBoss as application server and MySql as Database. I am working on it more than a week and can not able to solve it.
I Placed the mysql-connector-java-5.0.8-bin.jar file in the lib folder and configured the mysql-ds.xml file and placed it in the server\default\deploy
directory. And mysql-ds.xml is as follows

<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/mysql</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/ship</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>root</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->
 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

Name of my project is sample and in sample-war file I wrote a JSP to call the EJB methods. And this is as follows

<%
  
   Context jndicontext=getInitialContext();
   Object ref=jndicontext.lookup("sample/TravelAgentBean/remote");
  TravelAgentRemote dao=(TravelAgentRemote)PortableRemoteObject.narrow(ref,TravelAgentRemote.class);
    Cabin cabin_1=new Cabin();
   cabin_1.setId(1);
   cabin_1.setName("Master Suite");
   cabin_1.setDeckLevel(1);
   cabin_1.setShipId(1);
   cabin_1.setBedCount(3);
   dao.createCabin(cabin_1);
   Cabin cabin_2=dao.findCabin(1);
   out.println("abc");
   out.println(cabin_2.getName());
   out.println(cabin_2.getDeckLevel()); 
%>
 
<%! public static Context getInitialContext() throws NamingException
    {
      Properties p=new Properties();
      p.put(Context.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory");
      p.put(Context.URL_PKG_PREFIXES,"org.jboss.naming :-o	 rg.jnp.interfaces");
      p.put(Context.PROVIDER_URL,"jnp://localhost:1099");
      return new InitialContext(p);
    }
  %>  

I wrote a remote Stateless session bean and an entity bean.
And my persistence.xml file looks as follows
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="titan" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/mysql</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="update"/>
</properties>
</persistence-unit>
</persistence>

When I run the application i got an exception like sample not bound.
When JBoss is started I can see an error in the console. It is
ObjectName: persistence.units:ear=sample2.ear,jar=sample2-ejb.jar,unitName=titan
State: FAILED
Reason: javax.naming.NameNotFoundException: jdbc not bound
I Depend On:
jboss.jca:service=ManagedConnectionFactory,name=jdbc/mysql
Depends On Me:
jboss.j2ee:ear=sample2.ear,jar=sample2-ejb.jar,name=TravelAgentBean,service=EJB3


Thanks
Sravani

[Jaikiran Pai]

<jta-data-source>jdbc/mysql</jta-data-source>

Change it to

 <jta-data-source>[B]java:[/B]jdbc/mysql</jta-data-source>

By default, the datasources are bound to the java: namespace

[sravani jetty]

Hi Jaikiran,
I did that but still it is not working.

Thanks
Sravani