Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of dev.kamdar@gmail.com
 designates 72.14.220.156 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=eTmwbgcPMBCPMpO/2uzZMazDL5eii8cY2pAnyWk3jhtnKHaNOO5Vh1saDWLbFGGMAFxLbhzelupHMrNt/L6153Q2S5GPr9ywqGf6xVszRFC0TOz0rXmiTWOHyJwVliZeIzJNnfzwBVo66mZoHAQAwdleNkPOlrKYqz+X+IiOL7o=
Message-ID: <554abf880805012158s6b644df4t91a8f5f783a12493@mail.gmail.com>
Date: Fri, 2 May 2008 10:28:06 +0530
From: "Devang kamdar" <dev.kamdar@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Cannot Use DROP in ALTER Table in NetBeans 6.0.1 (Derby
 Integrated)
In-Reply-To: <4819C0BD.6050600@sun.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4054_25446923.1209704286198"
References: <554abf880805010317t399a523cqb0018e4ff803912f@mail.gmail.com>
	 <4819C0BD.6050600@sun.com>

------=_Part_4054_25446923.1209704286198
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks for the response Rick.

I am not able to verify from the IDE.
However, I checked the release notes online for NetBeans and it says, under
tested drivers
*Tested Drivers*

NetBeans IDE 6.0 has been tested with the following databases and drivers.
  Driver
 Version
 Example URL
 JavaDB Derby 10.3.1.4 jdbc:derby://localhost:1527/sample (Network)
Oracle Oracle
Database 10g Release 2 (10.2.0.3) jdbc:oracle:thin:@//localhost:1521:ora9i
PostgreSQL 8.2 Build 506 jdbc:postgresql://
jbrave-pc1.sfbay.sun.com:5432/postgres MySQL MySQL Connector/J 5.0.7Here is
the link to NB Release notes:
http://www.netbeans.org/community/releases/60/relnotes.html#sql-db

Does this mean, its running 10.3.1.4 version of Derby(Java DB)?

If I am not interpreting it correctly, is there a concrete way of checking,
which version of Derby am I running?

Also, if I am running an older version that is not supporting the DROP
command, is there a way, I can integrate the newer version of JAVA-DB in NB?

Cos NB is giving me a very easy and nice interface to work with Java DB and
makes creating and populating tables much faster.
OR
as an alternative, are there any GUIs available to work with bare JAVA-DB
database like toad?

Please let me know your suggestions.

Thanks
Dev.

On Thu, May 1, 2008 at 6:38 PM, Rick Hillegas <Richard.Hillegas@sun.com>
wrote:

> Hi Dev,
>
> Do you know what version of Derby you are using with Netbeans? Column
> dropping and renaming were added to Derby in release 10.3.1.4.
>
> Hope this helps,
> -Rick
>
>
> Devang kamdar wrote:
>
>> Hi,
>>
>> I am trying to get started with Derby and Netbeans
>> I am not able to use the DROP command.
>>
>> Getting following error in NetBeans (Derby Integrated)
>> Error code -1, SQL state 42X01: Syntax error: Encountered "DROP" at line
>> 2, column 1.
>> Line 1, column 1
>>
>> Here is the SQL statement:
>> ALTER TABLE TRAN
>> DROP COLUMN TRAN_DESC
>>
>> Also, is there a way to rename a column?
>> Right now I am trying to DROP it and ADD it again.
>> I am just creating the DB, so there is no data at present and this seems
>> reasonable work-around.
>> But what if my DB is populated? If I Drop the column, I will loose all the
>> data?
>> Is there a viable alternative?
>>
>> Please let me know.
>>
>> Thanks
>> Dev.
>>
>
>

------=_Part_4054_25446923.1209704286198
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks for the response Rick.<br><br>I am not able to verify from the IDE.<br>However, I checked the release notes online for NetBeans and it says, under tested drivers<br><b>Tested Drivers</b> 
<p>NetBeans IDE 6.0 has been tested with the following databases and 
drivers.<br></p>
<table border="0" cellpadding="1" width="50%">
<tbody>
<tr>
<th scope="col">
<div align="left">Driver</div></th>
<th scope="col">
<div align="left">Version</div></th>
<th scope="col">
<div align="left">Example URL </div></th></tr>
<tr>
<td>JavaDB</td>
<td>Derby <a href="http://10.3.1.4">10.3.1.4</a></td>
<td><code>jdbc:derby://localhost:1527/sample</code> (Network)</td></tr>
<tr>
<td>Oracle</td>
<td>Oracle Database 10g Release 2 (<a href="http://10.2.0.3">10.2.0.3</a>)</td>
<td><code>jdbc:oracle:thin:@//localhost:1521:ora9i</code> </td></tr>
<tr>
<td>PostgreSQL</td>
<td>8.2 Build 506</td>
<td><code>jdbc:postgresql://<a href="http://jbrave-pc1.sfbay.sun.com:5432/postgres">jbrave-pc1.sfbay.sun.com:5432/postgres</a></code></td></tr>
<tr>
<td>MySQL</td>
<td>MySQL Connector/J 5.0.7</td></tr></tbody></table>Here is the link to NB Release notes:<br><a href="http://www.netbeans.org/community/releases/60/relnotes.html#sql-db">http://www.netbeans.org/community/releases/60/relnotes.html#sql-db</a><br>
<br>Does this mean, its running <a href="http://10.3.1.4">10.3.1.4</a> version of Derby(Java DB)?<br><br>If I am not interpreting it correctly, is there a concrete way of checking, which version of Derby am I running?<br>
<br>Also, if I am running an older version that is not supporting the DROP command, is there a way, I can integrate the newer version of JAVA-DB in NB? <br>Cos NB is giving me a very easy and nice interface to work with Java DB and makes creating and populating tables much faster.<br>
OR<br>as an alternative, are there any GUIs available to work with bare JAVA-DB database like toad?<br><br>Please let me know your suggestions.<br><br>Thanks<br>Dev.<br><br><div class="gmail_quote">On Thu, May 1, 2008 at 6:38 PM, Rick Hillegas &lt;<a href="mailto:Richard.Hillegas@sun.com">Richard.Hillegas@sun.com</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Dev,<br>
<br>
Do you know what version of Derby you are using with Netbeans? Column dropping and renaming were added to Derby in release <a href="http://10.3.1.4" target="_blank">10.3.1.4</a>.<br>
<br>
Hope this helps,<br><font color="#888888">
-Rick</font><div><div></div><div class="Wj3C7c"><br>
<br>
Devang kamdar wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
I am trying to get started with Derby and Netbeans<br>
I am not able to use the DROP command.<br>
<br>
Getting following error in NetBeans (Derby Integrated)<br>
Error code -1, SQL state 42X01: Syntax error: Encountered &quot;DROP&quot; at line 2, column 1.<br>
Line 1, column 1<br>
<br>
Here is the SQL statement:<br>
ALTER TABLE TRAN<br>
DROP COLUMN TRAN_DESC<br>
<br>
Also, is there a way to rename a column?<br>
Right now I am trying to DROP it and ADD it again.<br>
I am just creating the DB, so there is no data at present and this seems reasonable work-around.<br>
But what if my DB is populated? If I Drop the column, I will loose all the data?<br>
Is there a viable alternative?<br>
<br>
Please let me know.<br>
<br>
Thanks<br>
Dev.<br>
</blockquote>
<br>
</div></div></blockquote></div><br>

------=_Part_4054_25446923.1209704286198--