deploy prob on jboss 3.0.0alpha (JDBCEntityBridge.loadSelect
ericjee Feb 5, 2002 11:40 PMHi,
I've been going through the message boards and I looked up my error I got when deploying my bean, which is :
java.lang.NullPointerException
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.loadSelectors(
JDBCEntityBridge.java:213)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEnt
ityBridge.java:90)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.init(JDBCStoreManager
.....
Usually people come up with a EJB-QL error( something like I did not have the right case). I cannot see one, can someone find the problem with this XML file I have?
Sorry its so long....
<?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>XMLInsider</display-name>
<!-- ######################################################### 171 -->
<enterprise-beans>
<!-- ******************************************* -->
<display-name>User</display-name>
<ejb-name>User</ejb-name>
UserHome
User
<ejb-class>UserBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Integer</prim-key-class>
<!-- <primkey-field>PKUserId</primkey-field> -->
True
<cmp-version>2.x</cmp-version>
<abstract-schema-name>User</abstract-schema-name>
<cmp-field>
<field-name>PKUserId</field-name>
</cmp-field>
<cmp-field>
<field-name>UserName</field-name>
</cmp-field>
<cmp-field>
<field-name>Password</field-name>
</cmp-field>
<cmp-field>
<field-name>AccountStatus</field-name>
</cmp-field>
<cmp-field>
<field-name>ExpirationDate</field-name>
</cmp-field>
<cmp-field>
<field-name>LockDate</field-name>
</cmp-field>
<ejb-local-ref>
<ejb-ref-name>Address</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>AddressLocalHome</local-home>
AddressLocal
<ejb-link>Address</ejb-link>
</ejb-local-ref>
<ejb-local-ref>
<ejb-ref-name>Reminders</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>RemindersLocalHome</local-home>
RemindersLocal
<ejb-link>Reminders</ejb-link>
</ejb-local-ref>
<ejb-local-ref>
<ejb-ref-name>WebServices</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>WebServicesLocalHome</local-home>
WebServicesLocal
<ejb-link>WebServices</ejb-link>
</ejb-local-ref>
Find by Primary Key
<query-method>
<method-name>findByPrimaryKey</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<ejb-ql>
SELECT DISTINCT OBJECT(u)
FROM User u
WHERE u.PKUserId=?1
</ejb-ql>
<query-method>
<method-name>ejbSelectWebServices</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<result-type-mapping>Remote</result-type-mapping>
<ejb-ql>
SELECT OBJECT(e2b) FROM WebServices e2b WHERE e2b.PKUserId = ?1
</ejb-ql>
<query-method>
<method-name>ejbSelectWebService</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<result-type-mapping>Remote</result-type-mapping>
<ejb-ql>
SELECT OBJECT(e2b) FROM WebServices e2b WHERE e2b.PKUserId = ?1
</ejb-ql>
<query-method>
<method-name>ejbSelectReminders</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<result-type-mapping>Remote</result-type-mapping>
<ejb-ql>
SELECT OBJECT(e2b) FROM Reminders e2b WHERE e2b.PKUserId = ?1
</ejb-ql>
<query-method>
<method-name>ejbSelectReminder</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<result-type-mapping>Remote</result-type-mapping>
<ejb-ql>
SELECT OBJECT(e2b) FROM Reminders e2b WHERE e2b.PKUserId = ?1
</ejb-ql>
<!-- ******************************************* -->
<display-name>Address</display-name>
<ejb-name>Address</ejb-name>
<local-home>AddressLocalHome</local-home>
AddressLocal
<ejb-class>AddressBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Integer</prim-key-class>
<!-- <primkey-field>PKAddressId</primkey-field> -->
True
<cmp-version>2.x</cmp-version>
<abstract-schema-name>Address</abstract-schema-name>
<cmp-field>
<field-name>PKAddressId</field-name>
</cmp-field>
<cmp-field>
<field-name>FKUserId</field-name>
</cmp-field>
<cmp-field>
<field-name>FirstName</field-name>
</cmp-field>
<cmp-field>
<field-name>MiddleInitial</field-name>
</cmp-field>
<cmp-field>
<field-name>LastName</field-name>
</cmp-field>
<cmp-field>
<field-name>AddressFirst</field-name>
</cmp-field>
<cmp-field>
<field-name>AddressSecond</field-name>
</cmp-field>
<cmp-field>
<field-name>AddressThird</field-name>
</cmp-field>
<cmp-field>
<field-name>City</field-name>
</cmp-field>
<cmp-field>
<field-name>State</field-name>
</cmp-field>
<cmp-field>
<field-name>Country</field-name>
</cmp-field>
<cmp-field>
<field-name>PostalCode</field-name>
</cmp-field>
<cmp-field>
<field-name>PhoneNumber</field-name>
</cmp-field>
<cmp-field>
<field-name>FaxNumber</field-name>
</cmp-field>
<cmp-field>
<field-name>Email</field-name>
</cmp-field>
<cmp-field>
<field-name>Position</field-name>
</cmp-field>
Find by Primary Key
<query-method>
<method-name>findByPrimaryKey</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<ejb-ql>
SELECT DISTINCT OBJECT(a)
FROM Address a
WHERE a.PKAddressId=?1
</ejb-ql>
<!-- ******************************************* -->
<display-name>Reminders</display-name>
<ejb-name>Reminders</ejb-name>
<local-home>RemindersLocalHome</local-home>
RemindersLocal
<ejb-class>RemindersBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Integer</prim-key-class>
<!-- <primkey-field>PKReminderId</primkey-field> -->
True
<cmp-version>2.x</cmp-version>
<abstract-schema-name>Reminders</abstract-schema-name>
<cmp-field>
<field-name>PKReminderId</field-name>
</cmp-field>
<cmp-field>
<field-name>FKUserId</field-name>
</cmp-field>
<cmp-field>
<field-name>ReminderSummary</field-name>
</cmp-field>
<cmp-field>
<field-name>ReminderDetail</field-name>
</cmp-field>
<cmp-field>
<field-name>ReminderDateCreated</field-name>
</cmp-field>
<cmp-field>
<field-name>ReminderDateFor</field-name>
</cmp-field>
Find by Primary Key
<query-method>
<method-name>findByPrimaryKey</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<ejb-ql>
SELECT DISTINCT OBJECT(r)
FROM Reminder r
WHERE r.PKReminderId=?1
</ejb-ql>
<!-- ******************************************* -->
<display-name>WebServices</display-name>
<ejb-name>WebServices</ejb-name>
<local-home>WebServicesLocalHome</local-home>
WebServicesLocal
<ejb-class>WebServicesBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Integer</prim-key-class>
<!-- <primkey-field>PKWebServicesId</primkey-field> -->
True
<cmp-version>2.x</cmp-version>
<abstract-schema-name>WebServices</abstract-schema-name>
<cmp-field>
<field-name>PKWebServicesId</field-name>
</cmp-field>
<cmp-field>
<field-name>FKUserId</field-name>
</cmp-field>
<cmp-field>
<field-name>WebServicesSummary</field-name>
</cmp-field>
<cmp-field>
<field-name>WebServicesDetail</field-name>
</cmp-field>
<cmp-field>
<field-name>WebServicesCreationDate</field-name>
</cmp-field>
Find by Primary Key
<query-method>
<method-name>findByPrimaryKey</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<ejb-ql>
SELECT DISTINCT OBJECT(w)
FROM WebServices w
WHERE w.PKWebServicessId=?1
</ejb-ql>
</enterprise-beans>
<!-- ######################################################### -->
<!-- ******************************************* -->
<ejb-relation>
<ejb-relation-name>User has Entity Address</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>User has Address</ejb-relationship-role-name>
One
<relationship-role-source>
<ejb-name>User</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>WebServices</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>Address has User</ejb-relationship-role-name>
One
<relationship-role-source>
<ejb-name>Address</ejb-name>
</relationship-role-source>
<foreign-key-fields>
<foreign-key-field>
<field-name>FKUserId</field-name>
<column-name>FKUserId</column-name>
</foreign-key-field>
</foreign-key-fields>
</ejb-relationship-role>
</ejb-relation>
<!-- ******************************************* -->
<ejb-relation>
<ejb-relation-name>User has Entity Reminders</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>User has Reminder</ejb-relationship-role-name>
One
<relationship-role-source>
<ejb-name>User</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>Reminders</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>Reminders has User</ejb-relationship-role-name>
Many
<relationship-role-source>
<ejb-name>Reminders</ejb-name>
</relationship-role-source>
<foreign-key-fields>
<foreign-key-field>
<field-name>FKUserId</field-name>
<column-name>FKUserId</column-name>
</foreign-key-field>
</foreign-key-fields>
</ejb-relationship-role>
</ejb-relation>
<!-- ******************************************* -->
<ejb-relation>
<ejb-relation-name>User has Entity WebService</ejb-relation-name>
<table-mapping>
<table-name>User_WebServices</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
</table-mapping>
<ejb-relationship-role>
<ejb-relationship-role-name>User has WebService</ejb-relationship-role-name>
<table-key-fields>
<table-key-field>
<field-name>FKUserId</field-name>
<column-name>FKUserId</column-name>
</table-key-field>
</table-key-fields>
One
<relationship-role-source>
<ejb-name>User</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>WebServices</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>WebService has User</ejb-relationship-role-name>
<table-key-fields>
<table-key-field>
<field-name>FKWebServicesId</field-name>
<column-name>FKWebServicesId</column-name>
</table-key-field>
</table-key-fields>
Many
<relationship-role-source>
<ejb-name>WebServices</ejb-name>
</relationship-role-source>
<foreign-key-fields>
<foreign-key-field>
<field-name>FKUserId</field-name>
<column-name>FKUserId</column-name>
</foreign-key-field>
</foreign-key-fields>
</ejb-relationship-role>
</ejb-relation>
<!-- ******************************************* -->
<!-- ######################################################### -->
<assembly-descriptor>
<container-transaction>
<ejb-name>User</ejb-name>
<method-name>*</method-name>
<trans-attribute>Required</trans-attribute>
</container-transaction>
<container-transaction>
<ejb-name>Address</ejb-name>
<method-name>*</method-name>
<trans-attribute>Required</trans-attribute>
</container-transaction>
<container-transaction>
<ejb-name>Reminders</ejb-name>
<method-name>*</method-name>
<trans-attribute>Required</trans-attribute>
</container-transaction>
<container-transaction>
<ejb-name>WebServices</ejb-name>
<method-name>*</method-name>
<trans-attribute>Required</trans-attribute>
</container-transaction>
</assembly-descriptor>
</ejb-jar>
Thanks so much,
Eric Dunn