IJ-tool getting cursor-keys work on Solaris (bash)

[Ma...@de.equens.com]

Hi to all,

I am using ij-tool just for look up. It works great on windows. When I
use it on a bash-shell (Solaris) the cursor-keys do not work, but I get
some strange letters typed like this:

"ij>  select ^[[A^[[B^[[C^[[D

It seems that those keys are not defined in some way. They work with in
the bash shell itself though.

What has to be done, so it works, including history of the commands used
within ij-session?

 

 

Thanks for hints in advance and best regards

 

Malte

Re: IJ-tool getting cursor-keys work on Solaris (bash)

[Myrna van Lunteren <m....@gmail.com>]

On Mon, May 9, 2011 at 7:39 AM,  <Ma...@de.equens.com> wrote:
>>>> I am using *ij-tool* just for look up. It works great on windows.
>>>> When I use it on a bash-shell (Solaris) the *cursor-keys* do
>>>> not work, but I get some strange letters typed like this:
>>>>
>>>> *"ij> select ^[[A^[[B^[[C^[[D*
>>>>
>>>> It seems that those keys are not defined in some way. They work with
>>>> in the bash shell itself though.
>>>>
>>>> What has to be done, so it works, including history of the commands
>>>> used within ij-session?
>>>
>>> I don't know if anyone has ever solved this. I have heard some
>>> discussions in the
>>> past about trying to use JLine (http://jline.sourceforge.net/), but I
>>> don't think
>>> I ever heard whether those attempts were successful or not.
>>
>>There's a wiki page describing various approaches, including how to set
>>up JLine:
>>
>>http://wiki.apache.org/db-derby/CommandHistoryInIj
>>
>>I usually run ij in a comint buffer in Emacs, and that works pretty
>>well.
>>
>>--
>>Knut Anders
>
> But how come that it works for windows?
>

It's odd, apparently on windows it accidentally is able to use the OS
(command line window) history...But it's the same code, so not sure
why it works (only) there. I've noticed that if you exit ij, change
directories, go back and start ij again, (at least I think that's the
sequence of events), the history stops working on windows too.

There's been a bug logged to get history working in ij, and some
attempt has been made to fix this, but it hasn't gone anywhere, see
https://issues.apache.org/jira/browse/DERBY-1447.
See also a (much) earlier thread;
http://www.mail-archive.com/derby-user@db.apache.org/msg07199.html

Myrna

AW: IJ-tool getting cursor-keys work on Solaris (bash)

[Ma...@de.equens.com]

>>> I am using *ij-tool* just for look up. It works great on windows.
>>> When I use it on a bash-shell (Solaris) the *cursor-keys* do
>>> not work, but I get some strange letters typed like this:
>>>
>>> *"ij> select ^[[A^[[B^[[C^[[D*
>>>
>>> It seems that those keys are not defined in some way. They work with
>>> in the bash shell itself though.
>>>
>>> What has to be done, so it works, including history of the commands
>>> used within ij-session?
>>
>> I don't know if anyone has ever solved this. I have heard some
>> discussions in the
>> past about trying to use JLine (http://jline.sourceforge.net/), but I
>> don't think
>> I ever heard whether those attempts were successful or not. 
>
>There's a wiki page describing various approaches, including how to set
>up JLine:
>
>http://wiki.apache.org/db-derby/CommandHistoryInIj
>
>I usually run ij in a comint buffer in Emacs, and that works pretty
>well.
>
>-- 
>Knut Anders

But how come that it works for windows?

Re: IJ-tool getting cursor-keys work on Solaris (bash)

[Knut Anders Hatlen <kn...@oracle.com>]

Bryan Pendleton <bp...@gmail.com> writes:

>> I am using *ij-tool* just for look up. It works great on windows.
>> When I use it on a bash-shell (Solaris) the *cursor-keys* do
>> not work, but I get some strange letters typed like this:
>>
>> *"ij> select ^[[A^[[B^[[C^[[D*
>>
>> It seems that those keys are not defined in some way. They work with
>> in the bash shell itself though.
>>
>> What has to be done, so it works, including history of the commands
>> used within ij-session?
>
> I don't know if anyone has ever solved this. I have heard some
> discussions in the
> past about trying to use JLine (http://jline.sourceforge.net/), but I
> don't think
> I ever heard whether those attempts were successful or not.

There's a wiki page describing various approaches, including how to set
up JLine:

http://wiki.apache.org/db-derby/CommandHistoryInIj

I usually run ij in a comint buffer in Emacs, and that works pretty
well.

-- 
Knut Anders

Re: IJ-tool getting cursor-keys work on Solaris (bash)

[Bryan Pendleton <bp...@gmail.com>]

> I am using *ij-tool* just for look up. It works great on windows. When I use it on a bash-shell (Solaris) the *cursor-keys* do
> not work, but I get some strange letters typed like this:
>
> *"ij> select ^[[A^[[B^[[C^[[D*
>
> It seems that those keys are not defined in some way. They work with in the bash shell itself though.
>
> What has to be done, so it works, including history of the commands used within ij-session?

I don't know if anyone has ever solved this. I have heard some discussions in the
past about trying to use JLine (http://jline.sourceforge.net/), but I don't think
I ever heard whether those attempts were successful or not.

I think it would be great to get something to work, but I don't know of anything
built-in to the Derby ij tool itself.

For my own purposes, I tend to use a tool like SQL Squirrel, which has a nice
SQL editing window built-in.

thanks,

bryan