META-INF.jbosscmp-jdbc.xml.old Maven / Gradle / Ivy
The newest version!
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<jbosscmp-jdbc>
<defaults>
<datasource>jdbc/TradeDataSource</datasource>
<datasource-mapping>${jboss.mapping}</datasource-mapping>
</defaults>
<enterprise-beans>
<entity>
<ejb-name>QuoteEJB</ejb-name>
<table-name>QuoteEJB</table-name>
<cmp-field>
<field-name>open</field-name>
<column-name>open1</column-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(14,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>change</field-name>
<column-name>change1</column-name>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
</cmp-field>
<cmp-field>
<field-name>low</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(14,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>price</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(14,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>high</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(14,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>volume</field-name>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
</cmp-field>
<cmp-field>
<field-name>companyName</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>symbol</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
</entity>
<entity>
<ejb-name>OrderEJB</ejb-name>
<cmp-field>
<field-name>price</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(10,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>orderFee</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(14,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>completionDate</field-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</cmp-field>
<cmp-field>
<field-name>orderType</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>orderStatus</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>quantity</field-name>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
</cmp-field>
<cmp-field>
<field-name>openDate</field-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</cmp-field>
<cmp-field>
<field-name>orderID</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<!-- cmp-field>
<field-name>account_accountid</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER(4)</sql-type>
</cmp-field>
<cmp-field>
<field-name>quote_symbol</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>holding_holdingid</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER(4)</sql-type>
</cmp-field> -->
</entity>
<entity>
<ejb-name>AccountEJB</ejb-name>
<cmp-field>
<field-name>logoutCount</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<cmp-field>
<field-name>loginCount</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<cmp-field>
<field-name>accountID</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<cmp-field>
<field-name>balance</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC</sql-type>
</cmp-field>
<cmp-field>
<field-name>openBalance</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC</sql-type>
</cmp-field>
<cmp-field>
<field-name>creationDate</field-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</cmp-field>
<cmp-field>
<field-name>lastLogin</field-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</cmp-field>
<!-- cmp-field>
<field-name>profile_userid</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field> -->
</entity>
<entity>
<ejb-name>AccountProfileEJB</ejb-name>
<cmp-field>
<field-name>address</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>passwd</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>userID</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>email</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>creditCard</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
<cmp-field>
<field-name>fullName</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field>
</entity>
<entity>
<ejb-name>HoldingEJB</ejb-name>
<cmp-field>
<field-name>purchasePrice</field-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(14,2)</sql-type>
</cmp-field>
<cmp-field>
<field-name>holdingID</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<cmp-field>
<field-name>quantity</field-name>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
</cmp-field>
<cmp-field>
<field-name>purchaseDate</field-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</cmp-field>
<!-- Xcmp-field>
<field-name>account_accountID</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<cmp-field>
<field-name>quote-symbol</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field> -->
</entity>
<entity>
<ejb-name>KeyGenEJB</ejb-name>
<!-- cmp-field>
<field-name>keyval</field-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</cmp-field>
<cmp-field>
<field-name>keyname</field-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(250)</sql-type>
</cmp-field> -->
</entity>
</enterprise-beans>
<relationships>
<ejb-relation>
<ejb-relation-name>Account-Orders</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>AccountEJB</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>accountID</field-name>
<column-name>ACCOUNT_ACCOUNTID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>Order-Has-Account</ejb-relationship-role-name>
<key-fields></key-fields>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>Account-AccountProfile</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>Account-Has-AccountProfile</ejb-relationship-role-name>
<key-fields></key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>AccountProfileEJB</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>userID</field-name>
<column-name>PROFILE_USERID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>Account-Holdings</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>AccountEJB</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>accountID</field-name>
<column-name>ACCOUNT_ACCOUNTID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>Holding-Has-Account</ejb-relationship-role-name>
<key-fields></key-fields>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>Quote-Holdings</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>Holding-Has-Quote</ejb-relationship-role-name>
<key-fields></key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>QuoteEJB</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>symbol</field-name>
<column-name>QUOTE_SYMBOL</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>Quote-Orders</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>Order-Has-Quote</ejb-relationship-role-name>
<key-fields></key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>QuoteEJB</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>symbol</field-name>
<column-name>QUOTE_SYMBOL</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>Order-Holding</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>Order-Has-Holding</ejb-relationship-role-name>
<key-fields/>
<!-- key-field><field-name>orderID</field-name><column-name>ORDERID2</column-name></key-field></key-fields>
-->
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>HoldingEJB</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>holdingID</field-name>
<column-name>HOLDING_HOLDINGID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>
</relationships>
</jbosscmp-jdbc>