We have MySQL 4.0.17, mySQL Connector/J 3.0.10 and J2EE 1.3.1 installed on our server. When inserting values from a CMP Entity Bean the column order ends up alphabeticly inside mySQL.

Here is our insert-query:

INSERT INTO kunde (kundenr, firmaetternavn, fornavn, badresse, bpostnr, bpoststed, padresse, ppostnr, ppoststed, telefon, faks, epost) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)

Here is our kunde-table:

Kunde(kundenr, firmaetternavn, fornavn, badresse, bpostnr, bpoststed, padresse, ppostnr, ppoststed, telefon, faks, epost)

After a insert-query the kunde-table looks like this:

KUNDENR FIRMAETTERNAVN FORNAVN etc.
----------------------------------------------------------------------------
[badresse-value] [bpostnr-value] [bpostste-value] etc.
[badresse-value] [bpostnr-value] [bpostste-value] etc.


Does anyone know what could be the cause of this problem!
Sorry for my bad english.