Hi,

I've been using JBoss for a couple of weeks now, (to replace J2EE RI 1.2.1)
and I've been very impressed with its performance and reliability (not to
mention the fact it is Open Source).  I am having a couple of interesting
problems that I'd like some feedback on:

Has anyone tried using JTurbo 2 with JBoss 2.3 (latest source)?  I have
found that JTurbo does not support:

        setObject(1, new Long(123), java.sql.Types.Decimal);

which means that the standard Jaws behaviour to create Decimal types for
Longs does not work out of the box.
        <mapping>
        <java-type>java.lang.Long</java-type>
            <jdbc-type>DECIMAL</jdbc-type>
            <sql-type>DECIMAL(20)</sql-type>
      </mapping>

I have changed the jdbc-type to BIGINT and this works okay.  This is not
really a problem with JBoss but interesting to note.  SQL Server 2000
supports BIGINT so the problem does not manifest itself.

The second problem is to do with Oracle and column names.  We have an Entity
Bean with a property "Date".  Unfortunately, the default behaviour for JAWS
is to use the name of the property without quoting it, resulting in a create
statement as follows:
        
        CREATE TABLE TestBeanCMPTable (Date NUMBER(19)).

Executing this gives CREATE "ORA-00904: invalid column name" as Date is a
reserved keyword.  However quoting this (as J2EE 1.2.1 does) overcomes this.
What do people think about JBoss/JAWS having this behavior by default, will
it cause problems with out databases?  Seems to work find for Cloudscape,
Oracle and SQL Server 6.5/7/2k.  My current fix is to specify the name of
the table and columns in the jaws.xml.

Thanks,

Theo

--
Theo Harper                                  Direct: +44 (0)1252 556755
Principal Technical Architect             Reception: +44 (0)1252 556000
Systems Union Holdings                          Fax: +44 (0)1252 556001
http://www.systemsunion.com         mailto:[EMAIL PROTECTED]

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to