I want to store a Vector<Vector<Object>> in mysql database. What is the best data Tpye that i can use in mysql and java to store and retrieve the datas.
You can either do one of to thing..
 If you know what the vector sizes are, create a table within mysql for the vector vector where the mysql table is the same size.
 create a table with a field that has a data type "BLOB". Save the vector vector as a binary string to this BLOB field. I recommend you use a unique ID to associate the BLOB with an identifier.
fpsasm: one of the reasons to use Vector, is because you don't know up front what the size will be, and the size can change.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.