There used to be a problem in the mySQL type mappings that mapped
java.lang.String to a VARCHAR(256), when mySQL only supports a max of 255
characters in a VARCHAR. I had to change this manually in the jaws.xml to
get it to work, otherwise the table would not get created.
Another mySQL problem you might see will happen if you try to use their
transactional tables. Right now, they require a primary key with these
tables, but (at least last time I tried), jBoss does not create the table
using the PRIMARY KEY directive, so the create would fail. The only way I
know of to get out of this is to create the table yourself.
-Charles
----- Original Message -----
From: "Daniel Schulze" <[EMAIL PROTECTED]>
To: "jBoss" <[EMAIL PROTECTED]>
Sent: Wednesday, October 11, 2000 11:17 AM
Subject: Re: [jBoss-User] Someone experienced with jBoss/mySQL ?
> I m on it.
>
> Give me 2 hours...
>
> \Daniel
>
>
> On Wed, 11 Oct 2000, Bjarne Olsen wrote:
> > Hi !
> > This morning I have successfully deployed my first Entity-Bean with
jBoss
> > using a Hypersonic SQL DB. When I tried to move to mySQL - having read
the
> > jaws docu - jBoss did not want to talk with mySQL for 3 hours.
> >
> > I think I have found problem now: Although the line
> >
> > <create-table>true</create-table>
> >
> > is in my jaws.xml file jBoss did not create the table. When i created it
> > manually everything worked from then on.
> >
> > Does anybody have the same problem ? Maybe a jBoss-Bug ?
> >
> > Bye
> > Bjarne
> >
> >
> > ====
> > Bye the way: I still get a NullPointerException when deploying my
> > jar-file, but this does not matter, jBoss deploys it anyway
> > here is my jaws.xml file:
> >
> > <?xml version="1.0" encoding="Cp1252"?>
> >
> > <jaws>
> > <datasource>MySQL</datasource>
> > <type-mapping>mySQL</type-mapping>
> > <type-mappings>
> > <type-mapping>
> > <name>mySQL</name>
> > <mapping>
> > <java-type>java.sql.TimeStamp</java-type>
> > <jdbc-type>TIMESTAMP</jdbc-type>
> > <sql-type>TIMESTAMP</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Long</java-type>
> > <jdbc-type>BIGINT</jdbc-type>
> > <sql-type>BIGINT</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Character</java-type>
> > <jdbc-type>CHAR</jdbc-type>
> > <sql-type>CHAR</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Short</java-type>
> > <jdbc-type>INTEGER</jdbc-type>
> > <sql-type>INTEGER</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Double</java-type>
> > <jdbc-type>DOUBLE</jdbc-type>
> > <sql-type>DOUBLE</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Boolean</java-type>
> > <jdbc-type></jdbc-type>
> > <sql-type>BIT</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Byte</java-type>
> > <jdbc-type>TINYINT</jdbc-type>
> > <sql-type>TINYINT</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Object</java-type>
> > <jdbc-type>BLOB</jdbc-type>
> > <sql-type>BLOB</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Float</java-type>
> > <jdbc-type>FLOAT</jdbc-type>
> > <sql-type>FLOAT</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.util.Date</java-type>
> > <jdbc-type>DATE</jdbc-type>
> > <sql-type>DATE</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.String</java-type>
> > <jdbc-type>VARCHAR</jdbc-type>
> > <sql-type>VARCHAR(256)</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Integer</java-type>
> > <jdbc-type>INTEGER</jdbc-type>
> > <sql-type>INTEGER</sql-type>
> > </mapping>
> > </type-mapping>
> > </type-mappings>
> > <enterprise-beans>
> > <entity>
> > <ejb-name>EJBEntityTest</ejb-name>
> > <table-name>EJBEntityTest</table-name>
> > <create-table>true</create-table>
> > <remove-table>false</remove-table>
> > <tuned-updates>false</tuned-updates>
> > <read-only>false</read-only>
> > <time-out>300</time-out>
> > <cmp-field>
> > <field-name>thekey</field-name>
> > <column-name>thekey</column-name>
> > <sql-type>VARCHAR(256)</sql-type>
> > <jdbc-type>VARCHAR</jdbc-type>
> > </cmp-field>
> > <cmp-field>
> > <field-name>value</field-name>
> > <column-name>value</column-name>
> > <sql-type>INT</sql-type>
> > <jdbc-type>INT</jdbc-type>
> > </cmp-field>
> > </entity>
> > </enterprise-beans>
> > </jaws>
> >
> >
> >
> >
> > --
> > Sent through GMX FreeMail - http://www.gmx.net
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Problems?: [EMAIL PROTECTED]
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
