1 Reply Latest reply on Jul 27, 2003 11:35 PM by pauster007

    Can't load Postgre

    pauster007 Newbie

      here is my exception:

      2003-07-28 11:55:55,370 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TenderConfigEJB] Loading standardjbosscmp-jdbc.xml : file:/G:/jboss-3.2.1/server/default/conf/standardjbosscmp-jdbc.xml
      2003-07-28 11:55:55,580 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TenderConfigEJB] jar:file:/G:/jboss-3.2.1/server/default/tmp/deploy/server/default/deploy/Entity.jar/33.Entity.jar!/META-INF/jbosscmp-jdbc.xml found. Overriding defaults
      2003-07-28 11:55:55,891 ERROR [org.jboss.ejb.EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasource-mapping PostgreSQL 7.3.3 not found
      at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:399)
      at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:258)
      at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:737)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:430)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:372)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      at java.lang.reflect.Method.invoke(Native Method)
      at


      XML Descriptors:
      jbosscmp-jdbc

      <jbosscmp-jdbc>

      <!-- java:/DefaultDS
      <datasource-mapping>Hypersonic SQL</datasource-mapping> -->
      java:/PostgresDS
      <datasource-mapping>PostgreSQL 7.3.3</datasource-mapping>
      <create-table>true</create-table>
      <remove-table>false</remove-table>
      <read-only>false</read-only>
      <read-time-out>30000</read-time-out>
      <row-locking>false</row-locking>
      <pk-constraint>true</pk-constraint>
      <fk-constraint>false</fk-constraint>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
      <read-ahead>
      on-load
      <page-size>1000</page-size>
      <eager-load-group>*</eager-load-group>
      </read-ahead>
      <list-cache-max>1000</list-cache-max>


      <enterprise-beans>

      <ejb-name>TenderConfigEJB</ejb-name>
      <!-- <create-table>true</create-table>
      <remove-table>true</remove-table>
      <pk-constraint>true</pk-constraint> -->
      <table-name>TenderConfig</table-name>
      <cmp-field>
      <field-name>tndrCfgDataType</field-name>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(64)</sql-type>
      </cmp-field>
      <cmp-field>
      <field-name>tndrCfgDesc</field-name>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(64)</sql-type>
      </cmp-field>
      <cmp-field>
      <field-name>tndrCfgName</field-name>
      <not-null/>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(64)</sql-type>
      </cmp-field>
      <cmp-field>
      <field-name>tndrType</field-name>
      <jdbc-type>INTEGER</jdbc-type>
      <sql-type>INTEGER</sql-type>
      </cmp-field>
      <cmp-field>
      <field-name>tndrID</field-name>
      <not-null/>
      <jdbc-type>INTEGER</jdbc-type>
      <sql-type>INTEGER</sql-type>
      </cmp-field>
      <cmp-field>
      <field-name>tndrCfgValue</field-name>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(64)</sql-type>
      </cmp-field>

      </enterprise-beans>
      </jbosscmp-jdbc>


      ejb-jar.xml

      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
      <ejb-jar>
      <display-name>Ejb1</display-name>
      <enterprise-beans>

      <display-name>TenderConfigEJB</display-name>
      <ejb-name>TenderConfigEJB</ejb-name>
      <local-home>com.uniserv.comn.controller.ejb.entity.tenderconfig.LocalTenderConfigHome</local-home>
      com.uniserv.comn.controller.ejb.entity.tenderconfig.LocalTenderConfig
      <ejb-class>com.uniserv.comn.controller.ejb.entity.tenderconfig.TenderConfigEJB</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>com.uniserv.comn.controller.ejb.entity.tenderconfig.TenderConfigPK</prim-key-class>
      False
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>TenderConfig</abstract-schema-name>
      <cmp-field>
      no description
      <field-name>tndrCfgDataType</field-name>
      </cmp-field>
      <cmp-field>
      no description
      <field-name>tndrCfgDesc</field-name>
      </cmp-field>
      <cmp-field>
      no description
      <field-name>tndrCfgName</field-name>
      </cmp-field>
      <cmp-field>
      no description
      <field-name>tndrType</field-name>
      </cmp-field>
      <cmp-field>
      no description
      <field-name>tndrID</field-name>
      </cmp-field>
      <cmp-field>
      no description
      <field-name>tndrCfgValue</field-name>
      </cmp-field>
      <security-identity>

      <use-caller-identity/>
      </security-identity>
      <resource-ref>
      <res-ref-name>jdbc/Postgre</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      <res-sharing-scope>Shareable</res-sharing-scope>
      </resource-ref>


      <query-method>
      <method-name>findAll</method-name>
      <method-params/>
      </query-method>
      <ejb-ql>SELECT DISTINCT OBJECT (o) FROM TenderConfig o</ejb-ql>



      <display-name>TerminalSessionFacadeEJB</display-name>
      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      com.uniserv.comn.controller.ejb.session.terminalfacade.TerminalSessionFacadeHome
      com.uniserv.comn.controller.ejb.session.terminalfacade.TerminalSessionFacade
      <ejb-class>com.uniserv.comn.controller.ejb.session.terminalfacade.TerminalSessionFacadeEJB</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Container</transaction-type>
      <ejb-local-ref>
      <ejb-ref-name>ejb/TenderConfigEJB</ejb-ref-name>
      <ejb-ref-type>Entity</ejb-ref-type>
      <local-home>com.uniserv.comn.controller.ejb.entity.tenderconfig.LocalTenderConfigHome</local-home>
      com.uniserv.comn.controller.ejb.entity.tenderconfig.LocalTenderConfig
      <!-- <ejb-link>ejb-jar-ic.jar#TenderConfigEJB</ejb-link> -->
      <ejb-link>TenderConfigEJB</ejb-link>
      </ejb-local-ref>
      <security-identity>

      <use-caller-identity/>
      </security-identity>

      </enterprise-beans>
      <assembly-descriptor>
      <method-permission>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>LocalHome</method-intf>
      <method-name>findByPrimaryKey</method-name>
      <method-params>
      <method-param>com.uniserv.comn.controller.ejb.entity.tenderconfig.TenderConfigPK</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getPrimaryKey</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrType</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>LocalHome</method-intf>
      <method-name>remove</method-name>
      <method-params>
      <method-param>java.lang.Object</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrID</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTenderConfigVO</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>LocalHome</method-intf>
      <method-name>findAll</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getEJBLocalHome</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgDesc</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrType</method-name>
      <method-params>
      <method-param>int</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>LocalHome</method-intf>
      <method-name>create</method-name>
      <method-params>
      <method-param>com.uniserv.comn.model.TenderConfigVO</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>isIdentical</method-name>
      <method-params>
      <method-param>javax.ejb.EJBLocalObject</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgName</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgDataType</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrCfgDesc</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>remove</method-name>
      <method-params/>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrCfgDataType</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrCfgValue</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>


      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgValue</method-name>
      <method-params/>

      </method-permission>
      <method-permission>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Home</method-intf>
      <method-name>remove</method-name>
      <method-params>
      <method-param>java.lang.Object</method-param>
      </method-params>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>getHandle</method-name>
      <method-params/>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>addTenderConfig</method-name>
      <method-params>
      <method-param>com.uniserv.comn.model.TenderConfigVO</method-param>
      </method-params>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Home</method-intf>
      <method-name>remove</method-name>
      <method-params>
      <method-param>javax.ejb.Handle</method-param>
      </method-params>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Home</method-intf>
      <method-name>getHomeHandle</method-name>
      <method-params/>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>getPrimaryKey</method-name>
      <method-params/>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Home</method-intf>
      <method-name>getEJBMetaData</method-name>
      <method-params/>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>remove</method-name>
      <method-params/>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Home</method-intf>
      <method-name>create</method-name>
      <method-params/>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>isIdentical</method-name>
      <method-params>
      <method-param>javax.ejb.EJBObject</method-param>
      </method-params>


      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>getEJBHome</method-name>
      <method-params/>

      </method-permission>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTenderConfigVO</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrID</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgName</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrType</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrType</method-name>
      <method-params>
      <method-param>int</method-param>
      </method-params>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrCfgDataType</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgDataType</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrCfgValue</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgDesc</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>remove</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>getTndrCfgValue</method-name>
      <method-params/>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TenderConfigEJB</ejb-name>
      <method-intf>Local</method-intf>
      <method-name>setTndrCfgDesc</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      <container-transaction>

      <ejb-name>TerminalSessionFacadeEJB</ejb-name>
      <method-intf>Remote</method-intf>
      <method-name>addTenderConfig</method-name>
      <method-params>
      <method-param>com.uniserv.comn.model.TenderConfigVO</method-param>
      </method-params>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      </assembly-descriptor>
      </ejb-jar>



      what seems to be the problem?