| How to open a database connection [message #157372] |
Thu, 19 January 2006 14:52  |
Eclipse User |
|
|
|
Hi there,
I'd like to explore the WTP Data Tools (in 1.0 final install, all
standard). The help says
1. Switch to the Data perspective.
But there is no Data Perspective in my Window Menu/List?
Any ideas what I'm missing?
Thanks
K<o>
http://www.conficio.com/ - We produce animated software manuals
|
|
|
|
| Re: How to open a database connection [message #157732 is a reply to message #157385] |
Mon, 23 January 2006 15:43  |
| Eclipse User |
|
|
|
More updates on this,
seems my mistake was to expect ms to put all classes into one jar. If
you select all three ms*.jar then it finds the classes.
Further reading:
http://support.microsoft.com/default.aspx?scid=kb;en-us;313100 how to
construct the jdbc url.
It still is a confusing tool and seems more beta then final release at
this point (1.0M9).
- Connections do sometimes mysteriously double.
- The filters get deleted sometimes by simply disconnecting.
- It is slow to open the tables list (30 seconds for 150 tables on a
remote connection in a LAN).
- The tree is quite deep (keeps many nodes that are singular in the
filter) Would be nice to collapse those like in the Java packages.
- The DataTools need a perspective of their. The small views are in
places where they are too small to see any data.
- The sqlpage scrap pages can only hold one sql statement and only
produce a result table from the last one (what is scrap page on these?)
- The DataOutput has a column on the left with action's success/failure
history. This is useful for what? It seems to me a waste of screen real
estate.
Well it is a start
Kaj
Kaj Kandler wrote:
> Sorry for replying to myself.
>
> I was a bit early in asking.
>
> Kaj Kandler wrote:
>
>> Hi there,
>> I'd like to explore the WTP Data Tools (in 1.0 final install, all
>> standard). The help says
>>
>> 1. Switch to the Data perspective.
>>
>> But there is no Data Perspective in my Window Menu/List?
>
>
> This is only visible from the J2EE Perspective and it is a view, not a
> perspective.
>
> I'm further struggling with the excellent error handling.
>
> 1. I can't finish the wizard w/o getting past the alert "Connection to
> Sql Server failed. com.microsoft.jdbc.sqlserver.SQLServerDriver".
> 2. Don't know what the error is w/o any more details
> 3. Didn't find anything in the logs either
> 4. When I cancel, the content of the wizard seems to be saved anyway
> (the connection is in the tree of the "Database Explorer view")
> 5. However it appears to be saved false. When I re-open the connection,
> it has an old value of the location of the driver class.
>
> Before I forget I actually are still on WTP 1.0M9 (not final).
>
> K<o>
> http://www.conficio.com/ - We produce animated software manuals
|
|
|
Powered by
FUDForum. Page generated in 0.04438 seconds
Home