Does this work?

Thor_2.0 · 09-09-2009, 12:03 PM

Hi,

I'm (still) @ the same project - and am accessing a database...

The acces itself is ok, but I set up a DefaultTableModel to be transmitted over the network - the model is Serialised, so I assume this is ok.

Ik "shape" the model by first asdding cols to it:

Quote:

for(iCounter=0; iCounter<iColCount;iCounter++)
{
myU = new UHLDR();
myU = (UHLDR)alstFields.get(iCounter);
tcCol = new TableColumn();
tcCol.setIdentifier(myU.getID());
tcCol.setPreferredWidth(myU.getColW());
tcCol.setWidth(myU.getColW());
tcCol.setHeaderValue(myU.getColH());
modelR.addColumn(tcCol);
}

The holder "myU" has width and header as structural data from the base, these are all stored in an ArrayList.

After that, I run a second SQL to fill the model with data using addRow(vector);

Then, I'd like to send it over, the client gets a null ... hence my "cry 4 F1"...

So, in short:
- does it work to set up a model and send it over the "wire"
- can cols be added this way? (yes - I did this before, but for all the hair on my head, I dont know how I did that...)

Tnx!!

Thor

Thor_2.0 · 09-09-2009, 12:30 PM

Scrap this question - in one simple line: can a tablemodel (abstract, default, ...) be send over the network?

Of course my code fails, I add a col the wrong way, addColumn can only add a column with a NAME as param, not a colums in it whole...

Sorry about a dumm question...

Thor

jlinkels · 09-09-2009, 07:55 PM

Maybe this is a stupid question, but what if you'd use mysqldump to create a text file, send it over the network and read it back into MySQL?

Somehow I seem to remember that you were using PostgresQL (but I am too lazy to look it up), hopefully PostgresQL has a similair dump/restore function?

jlinkels