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>

[13011 byte] By [706580] at [2007-11-25 8:17:25]
# 1

Yes, Sun ONE Application Server 7 supports both.

Please take a look at the following two previous thread to see if you can find help there. One thread talks about ms sql and another thread talks about mysql.

http://softwareforum.sun.com/NASApp/jive/thread.jsp?forum=59&thread=13776

http://softwareforum.sun.com/NASApp/jive/thread.jsp?forum=59&thread=13673

Judy Tang at 2007-7-1 14:25:24 > top of Java-index,Application & Integration Servers,Application Servers...
# 2

Using the previous post I was able to setup the connection pool and resource without a problem. I was able to connect to the datasource fine directly from a jsp.

I'm still getting the following trying to deploy my cmp entity bean:

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 generated the schema in Forte, any idea what would cause this error, I saw a similar error in a thread concerning sybase.

706580 at 2007-7-1 14:25:24 > top of Java-index,Application & Integration Servers,Application Servers...
# 3
The problem could be , the table is existing as lower case Sequence (or sequence) in databasePlease recreate the table with SEQUENCE and create dbschema and deploy againThis may solve the problem
Guest at 2007-7-1 14:25:24 > top of Java-index,Application & Integration Servers,Application Servers...
# 4

Thanks for the help, the migration tool translated all my table names and columns names into caps, lowercasing these babies in the sun-cmp-mappings.xml fixed the problem.

Just for the record, for anyone else who is trying to use mysql, here is what my connection pool looks like in server.xml:

<jdbc-connection-pool steady-pool-size="8" max-pool-size="32" max-wait-time-in-millis="60000" pool-resize-quantity="2" idle-timeout-in-seconds="300" is-isolation-level-guaranteed="false" is-connection-validation-required="false" connection-validation-method="auto-commit" fail-all-connections="false" datasource-classname="org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource" name="jdbcPool">

<property value="jbush" name="DatabaseName"/>

<property value="localhost" name="serverName"/>

<property value="3306" name="port"/>

<property value="root" name="User"/>

<property value="root" name="Password"/>

</jdbc-connection-pool>

706580 at 2007-7-1 14:25:24 > top of Java-index,Application & Integration Servers,Application Servers...