users@glassfish.java.net

Cannot write BIGINT to MySql database

From: Gerh17 <gerhard.kersten_at_acando.de>
Date: Thu, 22 Oct 2009 02:52:47 -0700 (PDT)

I have created a database wsdl, based on a MySql database. Using the insert
method, everything is OK ... but only the BIGINT column never is written.
The wizard has created an xsd:long data type, but changing this to xsd:int
or xsd:string doesn't change anyting.

There is no error message in the server.log:

[#|2009-10-22T10:37:57.692+0200|INFO|sun-appserver2.1|sun-database-binding.org.glassfish.openesb.databasebc.OutboundMessageProcessor|_ThreadID=40;_ThreadName=pool-5-thread-1;Context=context;|Executing
SQL....insert into logs
(cat,httpCode,rsp,timeMillis,mess,net,id,time,spl,dir,partner,httpMess,cpo,host,inq,pnr,code,url,cic,ip,qtr,mfr,qtn,service,inv,msgtype,ctn)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|#]

[#|2009-10-22T10:37:57.724+0200|INFO|sun-appserver2.1|sun-database-binding.org.glassfish.openesb.databasebc.JDBCDenormalizer|_ThreadID=40;_ThreadName=pool-5-thread-1;Context=context;|Populating
Prepared Statement|#]

The type definition is:

          <xsd:element name="timeMillis">
            <xsd:complexType>
              <xsd:simpleContent>
                <xsd:extension base="xsd:long">
                  <xsd:attribute name="isNull"
type="xsd:boolean"></xsd:attribute>
                </xsd:extension>
              </xsd:simpleContent>
            </xsd:complexType>
          </xsd:element>

Any ideas? Maybe a mapping issue between Java and MySql BIGINT?

Gerhard

-- 
View this message in context: http://www.nabble.com/Cannot-write-BIGINT-to-MySql-database-tp26007266p26007266.html
Sent from the java.net - glassfish users mailing list archive at Nabble.com.