Home » Language IDEs » ServerTools (WTP) » Problems about sql editor and server explorer
| Problems about sql editor and server explorer [message #65868] |
Mon, 17 January 2005 07:58  |
 cheng
Messages: 21
Registered: July 2009 |
Junior Member |
|
|
I am using sql editor in wtp,
I find when I save my sql file,all content are put between:
<?xml version="1.0" encoding="UTF-8"?>
<SQLPage driver="" password="" url="" userid="">
<Statement><![CDATA[
and
]]]]><![CDATA[></Statement>
</SQLPage>
it's OK,
but when I close the editor,and open the file once again,
these are put into my file once again,
and all blank line are turned into two blank lines!!
Now,there are many copies of these text and blank lines in my file!
In server explorer,I am asked for password every time I reconnect
a database,I think the passwords can be saved.
And every time I create a new connection,I have to input the host,
jdbc driver path and so on,I think it will be convenient if
jdbc drivers for every database type are saved,and connection
urls are generated!
When I delete a server in server explorer,I have to close the view
and open it again,or it will be still there!
And I am wondering how to import and export my db servers
in server explorer!
|
|
|
| Re: Problems about sql editor and server explorer [message #66673 is a reply to message #65868] |
Thu, 20 January 2005 19:59  |
Der Ping Chou
Messages: 36
Registered: July 2009 |
Member |
|
|
A lists of good question you have there, my team member Sheila Sholars
will be able to address those related to SQLScrapbook.
We are refreshing our connection wizard contribution so that it would only
require the JDBC class name and URL. The reason that we don't generate
default URL is because that each JDBC driver URL varied from vendor to
vendor.
Sorry, we don't persist password, since from a different perspective,
other users treating it as a serious defect for security bleach.
Delete Server from Server Explorer view was a defect, it will be fix in
our next weeks' refresh.
Part of the value proposition about Open Source for RDB is a complete
SQLModel (UML/EMF), see following link under rdb for details:
http://www.eclipse.org/webtools/wst/components.xml
It also means other contributor will be able to walk through the model and
persist the contents of Server Explorer. You can find out code sample by
reviewing Server Explorer/Working off-line feature. We persist it to a EMF
model file.
Hope this help. Also in above link there is a tutorial doc, which will
assist you to explore our current contribution.
Regards,
Der Ping
cheng wrote:
> I am using sql editor in wtp,
> I find when I save my sql file,all content are put between:
> <?xml version="1.0" encoding="UTF-8"?>
> <SQLPage driver="" password="" url="" userid="">
> <Statement><![CDATA[
> and
> ]]]]><![CDATA[></Statement>
> </SQLPage>
> it's OK,
> but when I close the editor,and open the file once again,
> these are put into my file once again,
> and all blank line are turned into two blank lines!!
> Now,there are many copies of these text and blank lines in my file!
> In server explorer,I am asked for password every time I reconnect
> a database,I think the passwords can be saved.
> And every time I create a new connection,I have to input the host,
> jdbc driver path and so on,I think it will be convenient if
> jdbc drivers for every database type are saved,and connection
> urls are generated!
> When I delete a server in server explorer,I have to close the view
> and open it again,or it will be still there!
> And I am wondering how to import and export my db servers
> in server explorer!
|
|
|
| Re: Problems about sql editor and server explorer [message #67018 is a reply to message #65868] |
Sat, 22 January 2005 18:11 |
Eclipse User |
|
|
|
Originally posted by: igor.shabalov.exadel.com
Cheng! Thank you for feedback, can you tell what version of WTP are you using?
Thank you again,
Igor Shabalov.
cheng wrote:
> I am using sql editor in wtp,
> I find when I save my sql file,all content are put between:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <SQLPage driver="" password="" url="" userid="">
> <Statement><![CDATA[
>
> and
> ]]]]><![CDATA[></Statement>
> </SQLPage>
>
>
> it's OK,
> but when I close the editor,and open the file once again,
> these are put into my file once again,
> and all blank line are turned into two blank lines!!
> Now,there are many copies of these text and blank lines in my file!
>
> In server explorer,I am asked for password every time I reconnect
> a database,I think the passwords can be saved.
> And every time I create a new connection,I have to input the host,
> jdbc driver path and so on,I think it will be convenient if jdbc drivers
> for every database type are saved,and connection urls are generated!
>
> When I delete a server in server explorer,I have to close the view
> and open it again,or it will be still there!
> And I am wondering how to import and export my db servers in server
> explorer!
>
>
>
|
|
|
| Re: Problems about sql editor and server explorer [message #67058 is a reply to message #67018] |
Mon, 24 January 2005 04:19 |
cheng
Messages: 21
Registered: July 2009 |
Junior Member |
|
|
I am using WTP 1.0M2 with wst and jst!
Igor Shabalov wrote:
> Cheng! Thank you for feedback, can you tell what version of WTP are you
using?
> Thank you again,
> Igor Shabalov.
> cheng wrote:
>> I am using sql editor in wtp,
>> I find when I save my sql file,all content are put between:
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <SQLPage driver="" password="" url="" userid="">
>> <Statement><![CDATA[
>>
>> and
>> ]]]]><![CDATA[></Statement>
>> </SQLPage>
>>
>>
>> it's OK,
>> but when I close the editor,and open the file once again,
>> these are put into my file once again,
>> and all blank line are turned into two blank lines!!
>> Now,there are many copies of these text and blank lines in my file!
>>
>> In server explorer,I am asked for password every time I reconnect
>> a database,I think the passwords can be saved.
>> And every time I create a new connection,I have to input the host,
>> jdbc driver path and so on,I think it will be convenient if jdbc drivers
>> for every database type are saved,and connection urls are generated!
>>
>> When I delete a server in server explorer,I have to close the view
>> and open it again,or it will be still there!
>> And I am wondering how to import and export my db servers in server
>> explorer!
>>
>>
>>
|
|
|
| Re: Problems about sql editor and server explorer [message #67064 is a reply to message #66673] |
Mon, 24 January 2005 04:27 |
cheng
Messages: 21
Registered: July 2009 |
Junior Member |
|
|
:)
But the password is in the xml file!
In server explorer,select "Open SQL Scracpbook" and the password
of the selected connected server will be stored in the xml file!
Der Ping Chou wrote:
> A lists of good question you have there, my team member Sheila Sholars
> will be able to address those related to SQLScrapbook.
> We are refreshing our connection wizard contribution so that it would only
> require the JDBC class name and URL. The reason that we don't generate
> default URL is because that each JDBC driver URL varied from vendor to
> vendor.
> Sorry, we don't persist password, since from a different perspective,
> other users treating it as a serious defect for security bleach.
> Delete Server from Server Explorer view was a defect, it will be fix in
> our next weeks' refresh.
> Part of the value proposition about Open Source for RDB is a complete
> SQLModel (UML/EMF), see following link under rdb for details:
> http://www.eclipse.org/webtools/wst/components.xml
> It also means other contributor will be able to walk through the model and
> persist the contents of Server Explorer. You can find out code sample by
> reviewing Server Explorer/Working off-line feature. We persist it to a EMF
> model file.
> Hope this help. Also in above link there is a tutorial doc, which will
> assist you to explore our current contribution.
> Regards,
> Der Ping
> cheng wrote:
>> I am using sql editor in wtp,
>> I find when I save my sql file,all content are put between:
>> <?xml version="1.0" encoding="UTF-8"?>
>> <SQLPage driver="" password="" url="" userid="">
>> <Statement><![CDATA[
>> and
>> ]]]]><
] 
Search
Help
Register
Login
Home
