You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Deepesh <de...@yahoo.co.in> on 2005/11/12 06:51:51 UTC

error in connecting to database

Hi,

 I am having an application [.jar]

 This contains a BMP entity Bean

 The problem is that i am not able to connect to the
database. I am trying to invoke this bean from a
client java program.

 The database is postgresql and geronimo version is
M5.

 The database connection is making in the bean class.

  The database plan is as below.

 <connector
    
xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"
     version="1.5"
     configId="PostDS"
     parentId="org/apache/geronimo/Server" >
<dependency>
 <uri>postgresql/postgresql.jar</uri> 

</dependency>  
  <resourceadapter>
    <outbound-resourceadapter>
      <connection-definition>
           <connectionfactory-interface>
            javax.sql.DataSource
           </connectionfactory-interface>
        <connectiondefinition-instance>
          <name>PostDS</name>
          <config-property-setting name="UserName">
            postgres
          </config-property-setting>
          <config-property-setting name="Password">
            postgres
          </config-property-setting>
          <config-property-setting name="Driver">
            org.postgresql.Driver
          </config-property-setting>
          <config-property-setting
name="ConnectionURL">
          jdbc:postgresql@10.239.32.76:5432:test 
          </config-property-setting>
          <config-property-setting
name="CommitBeforeAutocommit">
            true
          </config-property-setting>
          <config-property-setting
name="ExceptionSorterClass">
           
org.tranql.connector.NoExceptionsAreFatalSorter
          </config-property-setting>
          <connectionmanager>
                
<local-transaction></local-transaction>
                   <single-pool>
                  <max-size>10</max-size>
                  <min-size>0</min-size>
                 
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                 
<idle-timeout-minutes>30</idle-timeout-minutes>
                  <match-one></match-one>
                  </single-pool>
          </connectionmanager>
         
<global-jndi-name>jdbc/SavingsAccountDB</global-jndi-name>
        </connectiondefinition-instance>
      </connection-definition>
    </outbound-resourceadapter>
  </resourceadapter>
</connector>


The openejb-jar.xml is as below

?xml version="1.0"?>
<openejb-jar
xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  
xmlns:naming="http://geronimo.apache.org/xml/ns/naming"
  
xmlns:sys="http://geronimo.apache.org/xml/ns/deployment"
   parentId="org/apache/geronimo/SystemJMS"
   configId="savings">

<enterprise-beans>
 <entity>
  <ejb-name>SavingsAccountBean</ejb-name>
<jndi-name>SavingsAccountEJB</jndi-name>
<resource-ref>
<ref-name>jdbc/SavingsAccountDB</ref-name>
    <resource-link>PostDS</resource-link>  
</resource-ref> 
</entity>
</enterprise-beans>
</openejb-jar>

the Database look up is as below


private final static String dbName =
"java:comp/env/jdbc/SavingsAccountDB";



Properties props = new Properties();
             
props.setProperty("java.naming.factory.initial",
                 
"org.openejb.client.RemoteInitialContextFactory");
             
props.setProperty("java.naming.provider.url","localhost:4201");
             
props.setProperty("java.naming.security.principal",
"system");
             
props.setProperty("java.naming.security.credentials",
"manager");

              Context ic = new InitialContext(props);

              DataSource ds = (DataSource)
ic.lookup(dbName);

            con = ds.getConnection();

The stack trace is as below 

javax.ejb.EJBException: ejbCreate: Unable to connect
to database. null
        at
SavingsAccountBean.ejbCreate(SavingsAccountBean.java:104)
        at
SavingsAccountBean$$FastClassByCGLIB$$2fb7ad24.invoke(<generated>)
        at
org.openejb.entity.bmp.BMPCreateMethod.execute(BMPCreateMethod.java:118)
        at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java:72)
        at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(ComponentContextInterceptor.java:56)
        at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInterceptor.java:81)
        at
org.openejb.entity.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:136)
        at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:140)
        at
org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
        at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)
        at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
        at
org.openejb.server.ejbd.EjbRequestHandler.invoke(EjbRequestHandler.java:297)
        at
org.openejb.server.ejbd.EjbRequestHandler.doEjbHome_CREATE(EjbRequestHandler.java:342)
        at
org.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:205)
        at
org.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:150)
        at
org.openejb.server.ejbd.EjbServer.service(EjbServer.java:87)
        at
org.openejb.server.ejbd.EjbServer$$FastClassByCGLIB$$d379d2ff.invoke(<generated>)
        at
net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
        at
org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethodInvoker.java:38)
        at
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:118)
        at
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:760)
        at
org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:57)
        at
org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperationInvoker.java:36)
        at
org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(ProxyMethodInterceptor.java:96)
        at
org.activeio.xnet.ServerService$$EnhancerByCGLIB$$21b2f92c.service(<generated>)
        at
org.activeio.xnet.ServicePool$2.run(ServicePool.java:67)
        at
org.activeio.xnet.ServicePool$3.run(ServicePool.java:90)
        at
org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:138)
        at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown
Source)
        at java.lang.Thread.run(Thread.java:534)


can any one tell that what is wrong with this.

Regards

Deepesh



		
__________________________________________________________ 
Enjoy this Diwali with Y! India Click here http://in.promos.yahoo.com/fabmall/index.html

Re: error in connecting to database

Posted by Aaron Mulder <am...@alumni.princeton.edu>.
To connect to a database, an EJB doesn't need all the properties junk
you've got (that's used by clients trying to connect to a remote VM). 
In an EJB, just use this:

private final static String dbName = "java:comp/env/jdbc/SavingsAccountDB";
DataSource ds = (DataSource)new InitialContext().lookup(dbName);

Aaron

On 11/12/05, Deepesh <de...@yahoo.co.in> wrote:
> Hi,
>
>  I am having an application [.jar]
>
>  This contains a BMP entity Bean
>
>  The problem is that i am not able to connect to the
> database. I am trying to invoke this bean from a
> client java program.
>
>  The database is postgresql and geronimo version is
> M5.
>
>  The database connection is making in the bean class.
>
>   The database plan is as below.
>
>  <connector
>
> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"
>      version="1.5"
>      configId="PostDS"
>      parentId="org/apache/geronimo/Server" >
> <dependency>
>  <uri>postgresql/postgresql.jar</uri>
>
> </dependency>
>   <resourceadapter>
>     <outbound-resourceadapter>
>       <connection-definition>
>            <connectionfactory-interface>
>             javax.sql.DataSource
>            </connectionfactory-interface>
>         <connectiondefinition-instance>
>           <name>PostDS</name>
>           <config-property-setting name="UserName">
>             postgres
>           </config-property-setting>
>           <config-property-setting name="Password">
>             postgres
>           </config-property-setting>
>           <config-property-setting name="Driver">
>             org.postgresql.Driver
>           </config-property-setting>
>           <config-property-setting
> name="ConnectionURL">
>           jdbc:postgresql@10.239.32.76:5432:test
>           </config-property-setting>
>           <config-property-setting
> name="CommitBeforeAutocommit">
>             true
>           </config-property-setting>
>           <config-property-setting
> name="ExceptionSorterClass">
>
> org.tranql.connector.NoExceptionsAreFatalSorter
>           </config-property-setting>
>           <connectionmanager>
>
> <local-transaction></local-transaction>
>                    <single-pool>
>                   <max-size>10</max-size>
>                   <min-size>0</min-size>
>
> <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
>
> <idle-timeout-minutes>30</idle-timeout-minutes>
>                   <match-one></match-one>
>                   </single-pool>
>           </connectionmanager>
>
> <global-jndi-name>jdbc/SavingsAccountDB</global-jndi-name>
>         </connectiondefinition-instance>
>       </connection-definition>
>     </outbound-resourceadapter>
>   </resourceadapter>
> </connector>
>
>
> The openejb-jar.xml is as below
>
> ?xml version="1.0"?>
> <openejb-jar
> xmlns="http://www.openejb.org/xml/ns/openejb-jar"
>
> xmlns:naming="http://geronimo.apache.org/xml/ns/naming"
>
> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment"
>    parentId="org/apache/geronimo/SystemJMS"
>    configId="savings">
>
> <enterprise-beans>
>  <entity>
>   <ejb-name>SavingsAccountBean</ejb-name>
> <jndi-name>SavingsAccountEJB</jndi-name>
> <resource-ref>
> <ref-name>jdbc/SavingsAccountDB</ref-name>
>     <resource-link>PostDS</resource-link>
> </resource-ref>
> </entity>
> </enterprise-beans>
> </openejb-jar>
>
> the Database look up is as below
>
>
> private final static String dbName =
> "java:comp/env/jdbc/SavingsAccountDB";
>
>
>
> Properties props = new Properties();
>
> props.setProperty("java.naming.factory.initial",
>
> "org.openejb.client.RemoteInitialContextFactory");
>
> props.setProperty("java.naming.provider.url","localhost:4201");
>
> props.setProperty("java.naming.security.principal",
> "system");
>
> props.setProperty("java.naming.security.credentials",
> "manager");
>
>               Context ic = new InitialContext(props);
>
>               DataSource ds = (DataSource)
> ic.lookup(dbName);
>
>             con = ds.getConnection();
>
> The stack trace is as below
>
> javax.ejb.EJBException: ejbCreate: Unable to connect
> to database. null
>         at
> SavingsAccountBean.ejbCreate(SavingsAccountBean.java:104)
>         at
> SavingsAccountBean$$FastClassByCGLIB$$2fb7ad24.invoke(<generated>)
>         at
> org.openejb.entity.bmp.BMPCreateMethod.execute(BMPCreateMethod.java:118)
>         at
> org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java:72)
>         at
> org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(ComponentContextInterceptor.java:56)
>         at
> org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInterceptor.java:81)
>         at
> org.openejb.entity.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:136)
>         at
> org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:140)
>         at
> org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
>         at
> org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)
>         at
> org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
>         at
> org.openejb.server.ejbd.EjbRequestHandler.invoke(EjbRequestHandler.java:297)
>         at
> org.openejb.server.ejbd.EjbRequestHandler.doEjbHome_CREATE(EjbRequestHandler.java:342)
>         at
> org.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:205)
>         at
> org.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:150)
>         at
> org.openejb.server.ejbd.EjbServer.service(EjbServer.java:87)
>         at
> org.openejb.server.ejbd.EjbServer$$FastClassByCGLIB$$d379d2ff.invoke(<generated>)
>         at
> net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
>         at
> org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethodInvoker.java:38)
>         at
> org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:118)
>         at
> org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:760)
>         at
> org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:57)
>         at
> org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperationInvoker.java:36)
>         at
> org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(ProxyMethodInterceptor.java:96)
>         at
> org.activeio.xnet.ServerService$$EnhancerByCGLIB$$21b2f92c.service(<generated>)
>         at
> org.activeio.xnet.ServicePool$2.run(ServicePool.java:67)
>         at
> org.activeio.xnet.ServicePool$3.run(ServicePool.java:90)
>         at
> org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:138)
>         at
> EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown
> Source)
>         at java.lang.Thread.run(Thread.java:534)
>
>
> can any one tell that what is wrong with this.
>
> Regards
>
> Deepesh
>
>
>
>
> __________________________________________________________
> Enjoy this Diwali with Y! India Click here http://in.promos.yahoo.com/fabmall/index.html
>