#6 Lost SID information after restart

[Luc RIOU]

The SID for oracle is store in connections.xml, but after restart jsqsh, this information disapear.
You can see exemple of this probleme.

15:44:43 jarrett</home/lriou/.jsqsh> jsqsh
JSqsh Release 1.2, Copyright (C) 2007-2008, Scott C. Gray
Type \help for available help topics
1> \connect -SADMDEVDB01 -p1528 -sADMD01 -doracle -aOPARADMD01
1> \connect --list
+------------+--------+------------+------+--------+----------+----------+--------+--------+--------+
| Name | Driver | Server | Port | SID | Username | Password | Domain | Class | URL |
+------------+--------+------------+------+--------+----------+----------+--------+--------+--------+
| OPARADMD01 | oracle | ADMDEVDB01 | 1528 | ADMD01 | [NULL] | [NULL] | [NULL] | [NULL] | [NULL] |
+------------+--------+------------+------+--------+----------+----------+--------+--------+--------+
1> \connect OPARADMD01 -Uops$lriou
Password:*********
[OPARADMD01][ops$lriou] 1> select * from global_name;
+--------------+
| GLOBAL_NAME |
+--------------+
| ADMD01.WORLD |
+--------------+
1 row in results(first row: 939ms; total: 972ms)
[OPARADMD01][ops$lriou] 1> \quit
15:47:57 jarrett</home/lriou/.jsqsh> cat connections.xml
<connections>
<connection name="OPARADMD01"
driver="oracle"
server="ADMDEVDB01"
port="1528"
SID="ADMD01"
>
</connection>
</connections>
15:48:04 jarrett</home/lriou/.jsqsh> jsqsh
JSqsh Release 1.2, Copyright (C) 2007-2008, Scott C. Gray
Type \help for available help topics
1> \connect --list
+------------+--------+------------+------+--------+----------+----------+--------+--------+--------+
| Name | Driver | Server | Port | SID | Username | Password | Domain | Class | URL |
+------------+--------+------------+------+--------+----------+----------+--------+--------+--------+
| OPARADMD01 | oracle | ADMDEVDB01 | 1528 | [NULL] | [NULL] | [NULL] | [NULL] | [NULL] | [NULL] |
+------------+--------+------------+------+--------+----------+----------+--------+--------+--------+
1>

[Scott Gray]

This has been fixed in the head release (1.3-SNAPSHOT). If I get a chance I'll try to work on getting an official 1.3 build out, but in the meantime, you can use SVN to pull the source down and built it yourself (you just need 'ant' installed). Then copy the jsqsh.jar that is produced over the jsqsh.jar from the 1.2 release (usually found in ../lib or in /usr/share/jsqsh) and should be good to go