[Knut Erik Ballestad]

I am using the DB explorer towards a MS SQL Server 2000 database.

If I try to open the DBExplorer perspective, connect to the DB, and theb performs a query, the DBExplorer will ‘lock up’ the database, so that it is not possible to perform e.g. a database restore.

Is this behaviour intentional?
– If so why? – and is this something you would consider changing?

[Haris Peco]

keb ,

It is because sql server (and sybase probably) lock table when you read data.MyEclipse read ‘row increment size’ (fetch size) rows in one moment and you can read more data with actions in result view (you have 2 actions ‘retrieve more rows’ and ‘retrieve all rows’).Result set is opened until you read all rows (or read ‘rows per result set limit’).

You have more solutions for your problems :

– call ‘retrieve all rows’ after executing query and MyEclipse will read all rows (untili limit if you have it) and close statement and you can continue normal works
– increase ‘row increment size’ (max is 1000) in Windows – Preferences – MyEclipse – Database explorer (or from action in Result View – after this you will not lock table <= 1000 rows, but for bigger tables you will must call ‘retrieve all rows’.This solution is not too good for slow remote database and it is better that you load data
in less chunks.
– set ‘rows per result set’ to <= increment size and you needn’t call ‘retrieve all rows’, but you will be able see only ‘increment size rows’

We can’t set that MyEclipse retrieve all rows, because tables with a lot rows (>10000 or 10000) can throw ‘out of memory’ exception, special when you can execute more queries in sql editor.It can be very slow for slow remote database, for example.
Other final solution is constraint total number of rows, but it isn’t good, too.

Please, tell us if you have better idea and we will try implement , but we have to care that it work in different environment (local, remote, different databases etc)

Thanks
Peco

[lingamgoud]

Hi,
Iam Using Ecllipse 3.1.
Is it possible to get DBExplorer Perspective in Ecllipse 3.1.
I Yes How can I get.

[Brian Fernandes]

Lingamgoud,
You need to download MyEclipse 4.1.1 for Eclipse 3.1. The 5.0 series will only work on E3.2.

Brian.

[Author]

Posts