|
Re: How to open a database connection [message #157385 is a reply to message #157372] |
Thu, 19 January 2006 20:53 |
|
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
Helping people with OpenOffice using video clips as documentation.
|
|
|
Re: How to open a database connection [message #157732 is a reply to message #157385] |
Mon, 23 January 2006 20:43 |
|
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
Helping people with OpenOffice using video clips as documentation.
|
|
|
Powered by
FUDForum. Page generated in 0.04287 seconds