[JBoss-user] [JCA/JBoss] - Postgres & JBoxx 3.2.3: jdbc not bound

[abcolson]

I am using JBoss 3.2.3 and trying to configure a Postgres data source for use with an 
Entity bean called "Question".

I am getting Question bean deployment exceptions like:

org.jboss.deployment.DeploymentException: Error: can't find data source: 
jdbc/PostgresDS; - nested throwable: (javax.naming.Name
NotFoundException: jdbc not bound)

However, as I have read the forums and documentation, everything seems to be in order 
and I can't figure out why.  Here are my config files:

ejb-jar:
         <resource-ref >
            <res-ref-name>jdbc/PostgresDS</res-ref-name>
            <res-type>javax.sql.DataSource</res-type>
            <res-auth>Container</res-auth>
         </resource-ref>

jboss.xml:
         <resource-ref>
            <res-ref-name>jdbc/PostgresDS</res-ref-name>
            <jndi-name>java:/PostgresDS</jndi-name>
         </resource-ref>

postgres-ds.xml


  <local-tx-datasource>
    <jndi-name>PostgresDS</jndi-name>
    <connection-url>jdbc:postgresql://horse:5432/NNT</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <user-name>dbadmin</user-name>
    wizzard
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->
        <new-connection-sql>SELECT 'INITIAL DB CONNECTION WORKED'</new-connection-sql>

        <!-- sql to call on an existing pooled connection when it is obtained from pool
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->
        <check-valid-connection-sql>SELECT 'VALID CONNECTION FROM 
POOL'</check-valid-connection-sql>

  </local-tx-datasource>



jmx-console output:

     java:comp namespace of the Question bean:
       +- env
       |   +- jdbc
       |   |   +- PostgresDS[link -> java:/PostgresDS]

AND

     java: Namespace
       +- SecurityProxyFactory
       +- PostgresDS


Thanks for any ideas.
Tony

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836020#3836020

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836020


-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user