[Ejbca-develop] CADATA table

[Seonman K. <seo...@jp...>]

Hi,

I am looking at the EJBCA code.
I found a little buggy(?) setting for database. (Actually, I am not sure it
is buggy setting or intended one.)
Seeing the table description of CADATA, I found the data row is not enough
for saving the CA data. It is set as varchar(250).

mysql> desc cadata;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| cAId       | int(11)      |      | PRI | 0       |       |
| name       | varchar(250) | YES  |     | NULL    |       |
| subjectDN  | varchar(250) | YES  |     | NULL    |       |
| status     | int(11)      |      |     | 0       |       |
| expireTime | bigint(20)   |      |     | 0       |       |
| data       | varchar(250) | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+

Actually, seeing an entry of the "cadata" table, the data in the "data" row
was truncated like as below:
| 1631242330 | TestCA1 | CN=TestCA1,O=Company,C=JP |      1 | 1418292283000
| <?xml version="1.0" encoding="UTF-8"?>
<java version="1.5.0" class="java.beans.XMLDecoder">
 <object class="java.util.HashMap">
  <void method="put">
   <string>catype</string>
   <int>1</int>
  </void>
  <void method="put">
   <string>certif |

Is it OK even in that case?

I used EJBCA 3.0.4, JBOSS 3.2.6., and mysql 4.1.7.

Regards,
--
Seonman