support for mysql or ms sql server ?
Does sunone support mysql or ms sql server, I keep getting the following when I try to deploy an entity bean using either database.
Deployment Error -- Error while running ejbc -- Fatal Error from EJB Compiler -- -- java.lang.RuntimeException: The schema file sequence, does not contain a table named SEQUENCE
I'm using the dbschema generated by Forte, is there some hand editing I need to do to get it to work? I'm still confused why this schema is necessary, never had to go through such an annoying process with IAS or weblogic.
Here's my schema:
<?xml version="1.0" encoding="UTF-8" ?>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.SchemaElement" ID="com.sun.forte4j.modules.dbmodel.SchemaElement113759">
<versionNo>2</versionNo>
<impl>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.SchemaElementImpl" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.SchemaElementImpl14130741">
<element>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.SchemaElement113759"/>
</element>
<_catalog>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier13872011">
<name>jbush</name>
</OBJECT>
</_catalog>
<_username>dbo</_username>
<_driverName>i-net SPRINTA 2000</_driverName>
<_driverVersion>3.04</_driverVersion>
<_url>jdbc:inetdae7:149.24.18.160:1433?jbush</_url>
<_name>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier10703853">
<name>seq</name>
</OBJECT>
</_name>
<_driver>com.inet.tds.TdsDriver</_driver>
<tables>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection1698697">
<_elms>
<ARRAY SIZE="1" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.TableElement">
<ROW ROW="0">
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.TableElement" ID="com.sun.forte4j.modules.dbmodel.TableElement-64018320">
<impl>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl14348553">
<table>sequence</table>
<columns>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection7791938">
<_elms>
<ARRAY SIZE="2" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.ColumnElement">
<ROW ROW="0">
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.ColumnElement" ID="com.sun.forte4j.modules.dbmodel.ColumnElement1290031433">
<declaringTable>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.TableElement-64018320"/>
</declaringTable>
<impl>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.ColumnElementImpl" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.ColumnElementImpl431013">
<_precision>
<OBJECT CLASS="java.lang.Integer" ID="java.lang.Integer255">
<value>255</value>
</OBJECT>
</_precision>
<element>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.ColumnElement1290031433"/>
</element>
<_scale>
<OBJECT/>
</_scale>
<_name>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier13059074">
<name>name</name>
</OBJECT>
</_name>
<_isNullable>false</_isNullable>
<_type>12</_type>
<_length>
<OBJECT REFERENCE="java.lang.Integer255"/>
</_length>
</OBJECT>
</impl>
</OBJECT>
</ROW>
<ROW ROW="1">
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.ColumnElement" ID="com.sun.forte4j.modules.dbmodel.ColumnElement-1947358447">
<declaringTable>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.TableElement-64018320"/>
</declaringTable>
<impl>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.ColumnElementImpl" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.ColumnElementImpl4332208">
<_precision>
<OBJECT CLASS="java.lang.Integer" ID="java.lang.Integer10">
<value>10</value>
</OBJECT>
</_precision>
<element>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.ColumnElement-1947358447"/>
</element>
<_scale>
<OBJECT CLASS="java.lang.Integer" ID="java.lang.Integer0">
<value>0</value>
</OBJECT>
</_scale>
<_name>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier15083736">
<name>_index</name>
</OBJECT>
</_name>
<_isNullable>false</_isNullable>
<_type>4</_type>
<_length>
<OBJECT REFERENCE="java.lang.Integer10"/>
</_length>
</OBJECT>
</impl>
</OBJECT>
</ROW>
</ARRAY>
</_elms>
<_template>
<ARRAY SIZE="0" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.ColumnElement">
</ARRAY>
</_template>
<owner>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl14348553"/& gt;
</owner>
</OBJECT>
</columns>
<element>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.TableElement-64018320"/>
</element>
<_name>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier8623087">
<name>sequence</name>
</OBJECT>
</_name>
<isTable>true</isTable>
<keys>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection6518090">
<_elms>
<ARRAY SIZE="1" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.KeyElement">
<ROW ROW="0">
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.UniqueKeyElement" ID="com.sun.forte4j.modules.dbmodel.UniqueKeyElement-1935265242">
<_associatedIndex>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.IndexElement" ID="com.sun.forte4j.modules.dbmodel.IndexElement-1935265242">
<declaringTable>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.TableElement-64018320"/>
</declaringTable>
<impl>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.IndexElementImpl" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.IndexElementImpl6639084">
<columns>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection15936586">
<_elms>
<ARRAY SIZE="1" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.ColumnElement">
<ROW ROW="0">
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.ColumnElement1290031433"/>
</ROW>
</ARRAY>
</_elms>
<_template>
<ARRAY SIZE="0" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.ColumnElement">
</ARRAY>
</_template>
<owner>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl14348553"/& gt;
</owner>
</OBJECT>
</columns>
<element>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.IndexElement-1935265242"/>
</element>
<_name>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier14601066">
<name>PK__sequence__65370702</name>
</OBJECT>
</_name>
<tei>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl14348553"/& gt;
</tei>
<_unique>true</_unique>
</OBJECT>
</impl>
</OBJECT>
</_associatedIndex>
<declaringTable>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.TableElement-64018320"/>
</declaringTable>
<impl>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.UniqueKeyElementImpl" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.UniqueKeyElementImpl16555948">
<columns>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection15874598">
<_elms>
<ARRAY SIZE="1" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.ColumnElement">
<ROW ROW="0">
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.ColumnElement1290031433"/>
</ROW>
</ARRAY>
</_elms>
<_template>
<ARRAY SIZE="0" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.ColumnElement">
</ARRAY>
</_template>
<owner>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.UniqueKeyElementImpl1655594 8"/>
</owner>
</OBJECT>
</columns>
<element>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.UniqueKeyElement-1935265242"/>
</element>
<_name>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier5692381">
<name>PK__sequence__65370702</name>
</OBJECT>
</_name>
<_primary>true</_primary>
</OBJECT>
</impl>
</OBJECT>
</ROW>
</ARRAY>
</_elms>
<_template>
<ARRAY SIZE="0" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.KeyElement">
</ARRAY>
</_template>
<owner>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl14348553"/& gt;
</owner>
</OBJECT>
</keys>
<indexes>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection" ID="com.sun.forte4j.modules.dbmodel.jdbcimpl.DBElementsCollection12944408">
<_elms>
<ARRAY SIZE="1" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.IndexElement">
<ROW ROW="0">
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.IndexElement-1935265242"/>
</ROW>
</ARRAY>
</_elms>
<_template>
<ARRAY SIZE="0" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.IndexElement">
</ARRAY>
</_template>
<owner>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.TableElementImpl14348553"/& gt;
</owner>
</OBJECT>
</indexes>
</OBJECT>
</impl>
</OBJECT>
</ROW>
</ARRAY>
</_elms>
<_template>
<ARRAY SIZE="0" CLASS="PRIMITIVE" ROWCLASS="com.sun.forte4j.modules.dbmodel.TableElement">
</ARRAY>
</_template>
<owner>
<OBJECT REFERENCE="com.sun.forte4j.modules.dbmodel.jdbcimpl.SchemaElementImpl14130741"/ >
</owner>
</OBJECT>
</tables>
<_databaseProductVersion>8.0.194</_databaseProductVersion>
<_schema>
<OBJECT CLASS="com.sun.forte4j.modules.dbmodel.DBIdentifier" ID="com.sun.forte4j.modules.dbmodel.DBIdentifier8165687">
<name></name>
</OBJECT>
</_schema>
<_databaseProductName>Microsoft SQL Server</_databaseProductName>
</OBJECT>
</impl>
</OBJECT>

