[jboss-user] [JCA] - javax.naming.NameNotFoundException: Name jdbc is not bound in this Context

[Shinan Kassam]

Shinan Kassam [http://community.jboss.org/people/skassam] created the discussion

"javax.naming.NameNotFoundException: Name jdbc is not bound in this Context"

To view the discussion, visit: http://community.jboss.org/message/543473#543473

--------------------------------------------------------------
I have a jndi resource setup and working correctly. I was using JDBCRealm but now that I have my datasource setup I'd like to use DatasourceRealm.

I get "javax.naming.NameNotFoundException: Name jdbc is not bound in this Context" error when trying to login

context.xml:

<Context>
   <Realm debug="99"
 className="org.apache.catalina.realm.DataSourceRealm"
 dataSourceName="jdbc/MyDb"
 userTable="usrsec"
      userNameCol="usrsec_userid"
      userCredCol="usrsec_pswd"
      userRoleTable="usrsec" roleNameCol="usrsec_level"
 />
<Valve className="flex.messaging.security.TomcatValve"/>
</Context>
 

jboss-web.xml:

<jboss-web>
 <resource-ref>
 <res-ref-name>jdbc/MyDb</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <jndi-name>java:jdbc/MyDb</jndi-name> 
 <res-auth>Container</res-auth>
 </resource-ref>
</jboss-web>


Part of my web.xml:
<resource-ref> 
 <description>DB Connection</description>
 <res-ref-name>jdbc/MyDb</res-ref-name> 
 <res-type>javax.sql.DataSource</res-type> 
 <res-auth>Container</res-auth> 
 </resource-ref> 

database-ds.xml:

<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/MyDb</jndi-name>
    <!-- Sybase jConnect URL for the database. 
    NOTE: The hostname and port are made up values. The optional
          database name is provided, as well as some additinal Driver
          parameters.
    -->
    <connection-url>jdbc:ianywhere:DRIVER=SQL Anywhere 10;UID=xxx;PWD=xxx;ENG=HostServer;LINKS=tcpip(HOST=10.6.1.99;DoBroadcast=None)</connection-url>
    <driver-class>ianywhere.ml.jdbcodbc.jdbc3.IDriver</driver-class>
    <user-name>xxx</user-name>
    <password>xxx</password>
 
 <!--pooling parameters-->
    <min-pool-size>1</min-pool-size>
    <max-pool-size>5</max-pool-size>
 
    <!--<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>-->
        <!-- sql to call when connection is created -->              

        <!-- sql to call on an existing pooled connection when it is obtained from pool -->
        <check-valid-connection-sql>SELECT dbInfo_id FROM dbInfo</check-valid-connection-sql>

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>Sybase</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/543473#543473]

Start a new discussion in JCA at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100517/464632fc/attachment.html