squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] syntax highlight plugin & behavior of the editor

[Gerd W. <bir...@t-...>]

Hi Thomas

SMETS Thomas wrote:
> Just a few simple remarks :
> _ The bluish color (turquoise in french) used as default color to colorize columns 
>   and table names is really hard to view. I beleive most people using Oracle 
>   would prefere to see colorizing doen with the Toad default colors ... (?) 
These are defaults of older versions. I guess you already used SQuirreL 
before 2.0 rc1 was released. You may try out the following: Go to your 
home directory and see if you can find the .squirrel-sql directory 
there. Rename the syntax directory in .squirrel-sql/plugins. Then 
SQuirreL won't find your old editor preferences anymore and you will see 
the defaults of 2.0 rc1. See if you like these better.


> _ The message on the usage of the NetBean editor is cryptic as I never used netbeans.
>   Sorry for being an Eclipse "afficionados"
Same as above. The Netbeans editor is default of 2.0 rc1.

> _ It would be nice to be able to jump from the Object <--> SQL tabs 
>   with a simple key-stroke.
Try out the latest weekly build. Both tabs (SQL and Objects) will have a 
mnemonic. Alt+Q will bring you back to the SQL Editor. You may also like 
the new 'View in Object tree' feature of the SQL editor. It is available 
through the tools popup (Ctrl+t), the right mouse menu or the Ctrl+b 
short cut. If the cursor placed for example on a table name this 
function will open the Object tree and the table will be selected.

Gerd

Re: [Squirrel-sql-users] Re: oracle plugin with 2.0rc1

[Hari K. D. <har...@gm...>]

On 8/10/05, Rob Manning <Rob...@co...> wrote:
> Hari Krishna Dara wrote:
>=20
> >
> >>Error ocured initializing plugin: oracle
> >>java.lang.NullPointerException
> >>        at net.sourceforge.squirrel_sql.client.gui.mainframe.MainFrame.=
addToToolBar(MainFrame.java:589)
> >>        at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.ini=
tialize(OraclePlugin.java:169)
> >>        at net.sourceforge.squirrel_sql.client.plugin.PluginManager.ini=
tializePlugins(PluginManager.java:463)
> >>        at net.sourceforge.squirrel_sql.client.Application.executeStart=
upTasks(Application.java:596)
> >>        at net.sourceforge.squirrel_sql.client.Application.startup(Appl=
ication.java:184)
> >>        at net.sourceforge.squirrel_sql.client.Main.main(Main.java:61)
> >>
> >>
> In the code on the trunk, OraclePlugin.java:169 appears to be a comment :=
-)
>=20
> Which makes me wonder - are you using SQuirreL 2.0RC1 ?  If so then you
> should make sure
> you get oracle-0.13-for-2.0.zip from here:
>=20
> http://sourceforge.net/project/showfiles.php?group_id=3D28383&package_id=
=3D64864&release_id=3D246228
>=20
> I just installed it and it seems to work without exception for me.
>=20
> Rob Manning
>=20

Yes, mine clearly says "SQuirreL SQL Client Version 2.0 rc 1", and I
got both the oracle plugin for 2.0 and the squirrel installable at the
same time. I will try downloading both again just in case something
went wrong.

Thanks,
Hari

Re: [Squirrel-sql-users] Re: oracle plugin with 2.0rc1

[Rob M. <Rob...@co...>]

Hari Krishna Dara wrote:

>
>>Error ocured initializing plugin: oracle
>>java.lang.NullPointerException
>>        at net.sourceforge.squirrel_sql.client.gui.mainframe.MainFrame.addToToolBar(MainFrame.java:589)
>>        at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.initialize(OraclePlugin.java:169)
>>        at net.sourceforge.squirrel_sql.client.plugin.PluginManager.initializePlugins(PluginManager.java:463)
>>        at net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:596)
>>        at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:184)
>>        at net.sourceforge.squirrel_sql.client.Main.main(Main.java:61)
>>    
>>
In the code on the trunk, OraclePlugin.java:169 appears to be a comment :-)

Which makes me wonder - are you using SQuirreL 2.0RC1 ?  If so then you 
should make sure
you get oracle-0.13-for-2.0.zip from here:

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=64864&release_id=246228

I just installed it and it seems to work without exception for me.

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

[Squirrel-sql-users] oracle plugin with 2.0rc1

[Fabrice G. <Fab...@hc...>]

I've the same problem than Hari Krishna Dara.
I trid to install the oracle-0.13.zip (doesn't work at all) or the  oracle-=
0.13-for-2.0.zip (better but impossible to open the SQL editor).
Thank's to who would help us...

Squirrel-sql is a very smart product !





Fabrice Gonnon

Responsable Groupe Qualit=E9-Outils-M=E9thodes

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

H=F4pitaux Universitaires de Gen=E8ve
Direction d' informatique de gestion (DIG)
24, rue Micheli-du-Crest
CH 1211 GENEVE 14

Tel: +41.22.372.61.74
Bal: fab...@hc...



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

**********************************************************************

[Squirrel-sql-users] syntax highlight plugin & behavior of the editor

[SMETS T. <Tho...@po...>]

Ckp1c3QgYSBmZXcgc2ltcGxlIHJlbWFya3MgOgpfIFRoZSBibHVpc2ggY29sb3IgKHR1cnF1b2lz
ZSBpbiBmcmVuY2gpIHVzZWQgYXMgZGVmYXVsdCBjb2xvciB0byBjb2xvcml6ZSBjb2x1bW5zIAog
IGFuZCB0YWJsZSBuYW1lcyBpcyByZWFsbHkgaGFyZCB0byB2aWV3LiBJIGJlbGVpdmUgbW9zdCBw
ZW9wbGUgdXNpbmcgT3JhY2xlIAogIHdvdWxkIHByZWZlcmUgdG8gc2VlIGNvbG9yaXppbmcgZG9l
biB3aXRoIHRoZSBUb2FkIGRlZmF1bHQgY29sb3JzIC4uLiAoPykgCl8gVGhlIG1lc3NhZ2Ugb24g
dGhlIHVzYWdlIG9mIHRoZSBOZXRCZWFuIGVkaXRvciBpcyBjcnlwdGljIGFzIEkgbmV2ZXIgdXNl
ZCBuZXRiZWFucy4KICBTb3JyeSBmb3IgYmVpbmcgYW4gRWNsaXBzZSAiYWZmaWNpb25hZG9zIgpf
IEl0IHdvdWxkIGJlIG5pY2UgdG8gYmUgYWJsZSB0byBqdW1wIGZyb20gdGhlIE9iamVjdCA8LS0+
IFNRTCB0YWJzIAogIHdpdGggYSBzaW1wbGUga2V5LXN0cm9rZS4KClR4IGZvciB0aGUgZXhjZWxs
ZW50IHdvcmssCgpcVCwKCgoKLS0KZS4gOiBkdXZlbGJpZXItdHNtZXRzQHlhaG9vLmNvbQoKClNU
UklDVExZIFBFUlNPTkFMIEFORCBDT05GSURFTlRJQUwNClRoaXMgbWVzc2FnZSBtYXkgY29udGFp
biBjb25maWRlbnRpYWwgYW5kIHByb3ByaWV0YXJ5IG1hdGVyaWFsIGZvciB0aGUgc29sZSB1c2Ug
b2YgdGhlIGludGVuZGVkIHJlY2lwaWVudC4gQW55IHJldmlldyBvciBkaXN0cmlidXRpb24gYnkg
b3RoZXJzIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRl
ZCByZWNpcGllbnQgcGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVsZXRlIGFsbCBjb3Bp
ZXMuDQoNCkRpdCBiZXJpY2h0IGlzIGVua2VsIGJlc3RlbWQgdm9vciBkZSBhYW5nZWR1aWRlIG9u
dHZhbmdlcnMgZW4ga2FuIHZlcnRyb3V3ZWxpamtlIGluZm9ybWF0aWUgYmV2YXR0ZW4uIEFscyB1
IG5pZXQgZGUgb250dmFuZ2VyIGJlbnQsIGRhbiBtYWcgdSBkZSBpbmhvdWQgdmFuIGRpdCBiZXJp
Y2h0IG5pZXQgYmVrZW5kbWFrZW4gbm9jaCBrb3Bpw6tyZW4uIEFscyB1IGRpdCBiZXJpY2h0IHBl
ciB2ZXJnaXNzaW5nIG9udHZhbmdlbiBoZWVmdCwgZ2VsaWV2ZSBlciBkZSBhZnplbmRlciBvZiBE
ZSBQb3N0IG9ubWlkZGVsbGlqayB2YW4gb3AgZGUgaG9vZ3RlIHRlIGJyZW5nZW4gZW4gaGV0IGJl
cmljaHQgdmVydm9sZ2VucyB0ZSB2ZXJ3aWpkZXJlbi4NCg0KQ2UgbWVzc2FnZSBlc3QgdW5pcXVl
bWVudCBkZXN0aW7DqSBhdXggZGVzdGluYXRhaXJlcyBpbmRpcXXDqXMgZXQgcGV1dCBjb250ZW5p
ciBkZXMgaW5mb3JtYXRpb25zIGNvbmZpZGVudGllbGxlcy4gU2kgdm91cyBuJ8OqdGVzIHBhcyBs
ZSBkZXN0aW5hdGFpcmUsIHZvdXMgbmUgZGV2ZXogcGFzIHLDqXbDqWxlciBsZSBjb250ZW51IGRl
IGNlIG1lc3NhZ2Ugb3UgZW4gcHJlbmRyZSBjb3BpZS4gU2kgdm91cyBhdmV6IHJlw6d1IGNlIG1l
c3NhZ2UgcGFyIGVycmV1ciwgdmV1aWxsZXogZW4gaW5mb3JtZXIgbCdleHDDqWRpdGV1ciwgb3Ug
TGEgUG9zdGUgaW1tw6lkaWF0ZW1lbnQsIGF2YW50IGRlIGxlIHN1cHByaW1lci4K

[Squirrel-sql-users] Re: oracle plugin with 2.0rc1

[Hari K. D. <har...@gm...>]

Sorry, I conclueded too early. If I have the plugin installed, the
workspace gets hidden (no internal frame) and it has some weird
behavior. Clicking on oracle plugin toolbar buttons seem to work
though. Am I missing some setup? Any help is appreciated.

Thank you,
Hari

On 8/8/05, Hari Krishna Dara <har...@gm...> wrote:
> I installed the 0.13 version of oracle plugin (develop), since the
> current stable one is not compatible with 2.0rc1. I get the below NPE
> during the startup. I basically had the toolbar disabled, so that was
> cuasing the exception. When I enabled the toolbar and restarted, it
> seemed to startup fine.
>=20
> Thanks,
> Hari
>=20
> Error ocured initializing plugin: oracle
> java.lang.NullPointerException
>         at net.sourceforge.squirrel_sql.client.gui.mainframe.MainFrame.ad=
dToToolBar(MainFrame.java:589)
>         at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.initi=
alize(OraclePlugin.java:169)
>         at net.sourceforge.squirrel_sql.client.plugin.PluginManager.initi=
alizePlugins(PluginManager.java:463)
>         at net.sourceforge.squirrel_sql.client.Application.executeStartup=
Tasks(Application.java:596)
>         at net.sourceforge.squirrel_sql.client.Application.startup(Applic=
ation.java:184)
>         at net.sourceforge.squirrel_sql.client.Main.main(Main.java:61)
>

Re: [Squirrel-sql-users] how to connect to an informix db

[Rob M. <Rob...@co...>]

Luca Lazzarotti wrote:

> Hi,
> I read the help and the tutorial, but still I am not able to connect 
> to my DB.
> I use the JDBC ODBC bridge driver (since there is no informix dirver) 
> I don't know how to enter the info on the alias window
> I found an old messages saying to use something similar to:
> jdbc:informix-sqli://10.1.160.10:1526/alchimia:informixserver=ol_alchi_mass 
>
> but I cannot get this to work
>
> Any idea?

Luca,

I found a link to download the "IBM Informix" driver here:

http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-07-26+16%3A37%3A17.740493R&cat=database&fam=&s=c&S_TACT=104CBW71&S_CMP=

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] This week's snapshot - delayed

[Rob M. <Rob...@co...>]

Rob Manning wrote:

>
> The file upload mechanism on SourceForge isn't working.  Until it is, 
> I won't be able
> to post the snapshots for this week on the site.  I've filed a support 
> request with SF
> which you can review (if interested) here :
>
> http://sourceforge.net/tracker/index.php?func=detail&aid=1253128&group_id=1&atid=200001 
>
>
> I'll send another email when the snapshots are available on SourceForge.

The snapshot is now available in the usual place :

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128

I'm not sure what my problem was with command-line anon-ftp usage was 
(it still seems broken),
but FileZilla (http://sourceforge.net/projects/filezilla/) was able to 
overcome the issue.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

[Squirrel-sql-users] This week's snapshot - delayed

[Rob M. <Rob...@co...>]

The file upload mechanism on SourceForge isn't working.  Until it is, I 
won't be able
to post the snapshots for this week on the site.  I've filed a support 
request with SF
which you can review (if interested) here :

http://sourceforge.net/tracker/index.php?func=detail&aid=1253128&group_id=1&atid=200001

I'll send another email when the snapshots are available on SourceForge.

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] Drop Table

[Rob M. <Rob...@co...>]

Rob Manning wrote:

> Voorhoeve, R. wrote:
>
>> Hi,
>>
>> In Squirrel there is the availability to drop a table when you right 
>> mouse click on a table, first option.
>> Is there a possibility to change the "drop" item to the third or 
>> fourth option.
>>  
>>
> Hello,
>
> I see how this could be a problem :)  Another approach would be to 
> have a configuration
> setting that controls whether or not to prompt the user for drops 
> ("Are you sure you want to
> drop this table?").  That would also help prevent accidental drops.

Silly me.  That's the current behavior :)

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] Drop Table

[Rob M. <Rob...@co...>]

Voorhoeve, R. wrote:

>Hi,
>
>In Squirrel there is the availability to drop a table when you right mouse click on a table, first option.
>Is there a possibility to change the "drop" item to the third or fourth option.
>  
>
Hello,

I see how this could be a problem :)  Another approach would be to have 
a configuration
setting that controls whether or not to prompt the user for drops ("Are 
you sure you want to
drop this table?").  That would also help prevent accidental drops. 

Gerd, 

What's your opinion on this?

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

[Squirrel-sql-users] Drop Table

[Voorhoeve, R. <RVo...@de...>]

Hi,

In Squirrel there is the availability to drop a table when you right =
mouse click on a table, first option.
Is there a possibility to change the "drop" item to the third or fourth =
option.

Thanks Roderik=20

Re: [Squirrel-sql-users] how to connect to an informix db

[Rob M. <Rob...@co...>]

Luca Lazzarotti wrote:

> Hi,
> I read the help and the tutorial, but still I am not able to connect 
> to my DB.
> I use the JDBC ODBC bridge driver (since there is no informix dirver) 
> I don't know how to enter the info on the alias window
> I found an old messages saying to use something similar to:
> jdbc:informix-sqli://10.1.160.10:1526/alchimia:informixserver=ol_alchi_mass 
>
> but I cannot get this to work
>
> Any idea?

WebLogic has a JDBC (type 4) driver for Informix (I think it's of 
DataDirect origin)
IBM - strangely enough - *sells* a JDBC driver (They own Informix now so 
they can
do whatever they want with it - just that most database vendors provide 
JDBC drivers
for free) :

http://www-306.ibm.com/software/data/informix/tools/jdbc/

I've haven't tried ODBC in years, so I doubt I'd be of much help to 
you.  As I recall,
you need to define an ODBC data source using Microsoft's ODBC 
configuration tools (I can't
even remember what they are called). Then use the Sun JDBC-ODBC bridge 
driver to
connect to the ODBC data source by whatever name you gave it.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] how to connect to an informix db

[Luca L. <lla...@do...>]

Hi,
I read the help and the tutorial, but still I am not able to connect to 
my DB.
I use the JDBC ODBC bridge driver (since there is no informix dirver) I 
don't know how to enter the info on the alias window
I found an old messages saying to use something similar to:
jdbc:informix-sqli://10.1.160.10:1526/alchimia:informixserver=ol_alchi_mass
but I cannot get this to work

Any idea?

thanks
Luca



Rob Manning wrote:
> Luca Lazzarotti wrote:
> 
>> Hi,
>> I need to connect to an informix db
>> Can you please explain me how to do it?
> 
> 
> Hi Luca,
> 
> In the "Help" section in Squirrel you should look at "How to connect to 
> a database".
> 
> There is also a great tutorial here:  
> http://squirrel-sql.sourceforge.net/kulvir/tutorial.html
> 
> If you still have problems after reading those, let us know.
> 
> Rob
> 
> 
> CollabraSpace - Revolutionary Collaboration
> Visit us at http://www.collabraspace.com
> This message has been scanned for viruses by
> ClamAV v0.83
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] how to connect to an informix db

[Rob M. <Rob...@co...>]

Luca Lazzarotti wrote:

> Hi,
> I need to connect to an informix db
> Can you please explain me how to do it?

Hi Luca,

In the "Help" section in Squirrel you should look at "How to connect to 
a database".

There is also a great tutorial here:  
http://squirrel-sql.sourceforge.net/kulvir/tutorial.html

If you still have problems after reading those, let us know.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

[Squirrel-sql-users] how to connect to an informix db

[Luca L. <lla...@do...>]

Hi,
I need to connect to an informix db
Can you please explain me how to do it?

host is 10.1.160.10
dbserver is ol_alchi_mass
db is alchimia
port is 1526

I do not know which information I have to enter in the drivers and alias 
windows.

Thanks
Luca

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hey Rob,
>
>Thanks for all the extra info!  Funny how I had a 8.1.7 thin driver
>failing to connect to a 10.1.0.X.X oracle db even though the
>compatibility FAQ stated that it can! :)
>  
>
Indeed, I noticed that.  It would be nice if their driver handled newer 
version incompatibility a
little more gracefully ( like how about saying the version of the driver 
is older than what the
database server allows ). 

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] Importing BLOBs

[Rob M. <Rob...@co...>]

SMETS Thomas wrote:

>2.0RC1 seems fine to import the BLOB Robert ! ! ! 
>Here attached a snapshot where the GUI  seems a bit ectic still :(
>  
>
Glad to hear that 2.0RC1 is working out ok for you.  If your are 
referring to the BLOB import
making the GUI a little unresponsive - yes I have seen this and agree 
that it could use a little
work.(Not sure how I'd alter it at the moment)

>All the blue rectangles are covering customer specific informations.... 
>Greaaaaaaaaaaaaaaat JOB, though !!!
>  
>
Thank you, but I can't take all of the credit - it's a community 
effort.  There are many that have
contributed to make SQuirreL a nice IDE (Integrated Database Environment). 
I'm just as thankful to the others as yourself :-)

Cheers,

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

Rob Manning wrote:

> George,
>
> I'm glad you found the problem.  In general, Oracle says you may use a 
> newer driver to connect
> to a older version of it's database server.  I think going forward 
> won't work in some cases. So now we definitely know that 8i -> 10g is 
> a no go :)
> Rob

As a followup to my previous post, I found an Oracle driver 
compatibility FAQ which outlines the following:


Which JDBC drivers support which versions of Oracle Database?

    * JDBC 8.1.7 drivers can talk to RDBMS
          o 10.1.0
          o 9.2.0
          o 9.0.1
          o 8.1.7
          o 8.1.6
          o 8.1.5
          o 8.0.6
          o 8.0.5
          o 8.0.4
          o 7.3.4.
    * JDBC 9.0.1 drivers can talk to RDBMS
          o 10.1.0
          o 9.2.0
          o 9.0.1
          o 8.1.7
          o 8.1.6
          o 8.1.5
          o 8.0.6
          o 8.0.5
          o 8.0.4
          o 7.3.4
    * JDBC 9.2.0 drivers can talk to RDBMS
          o 10.1.0
          o 9.2.0
          o 9.0.1
          o 8.1.7
    * JDBC 10.1.0 drivers can talk to RDBMS
          o 10.1.0
          o 9.2.0
          o 9.0.1
          o 8.1.7
    * JDBC 10.2.0 drivers can talk to RDBMS
          o 10.2.0
          o 10.1.0
          o 9.2.0
          o 9.0.1
          o 8.1.7

Note that there is a known bug (#1725012) when using JDBC 8.1.7 thin 
driver to connect to a 9.0.1 RDBMS - applying the corresponding JDBC 
patch solves this known bug.

The following versions of the Oracle JDBC drivers are no longer supported.

    * JDBC 7.3.4 drivers can talk to RDBMS 7.3.4.
    * JDBC 8.0.4 drivers can talk to RDBMS 8.0.4 and 7.3.4.
    * JDBC 8.0.5 drivers can talk to RDBMS 8.0.5, 8.0.4 and 7.3.4.
    * JDBC 8.0.6 drivers can talk to RDBMS 8.0.6, 8.0.5, 8.0.4 and 7.3.4.
    * JDBC 8.1.5 drivers can talk to RDBMS 8.1.5, 8.0.6, 8.0.5, 8.0.4
      and 7.3.4.
    * JDBC 8.1.6 drivers can talk to RDBMS 8.1.6, 8.1.5, 8.0.6, 8.0.5,
      8.0.4 and 7.3.4.

Note: The ADT features in 8.1.5 driver and above only works for 8.1.5 
database and above.

A related question is about versions NOT listed here. If its not listed 
here, its probably not supported. You should verify with your support 
channel that you are still on a supported version of Oracle. For 
example, a lot of people have asked about 8.0.3 - support for which was 
discontinued long ago. People still using 8.0.3 need to contact their 
support channels for upgrade info (some of these upgrades are free!).


How is that for a definitive answer :-)
Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hi Rob,
>
>Updated my thin driver for 10g and it work now! thx!
>
>george
>  
>
George,

I'm glad you found the problem.  In general, Oracle says you may use a 
newer driver to connect
to a older version of it's database server.  I think going forward won't 
work in some cases. 
So now we definitely know that 8i -> 10g is a no go :) 

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hi Rob,
>
>I get an exception trace. Not sure what is goin on though.  My oracle
>thin driver setup seems correct, my login data seems correct.  Just
>can't connect.
>
>Below is the stack trace I get (see attachment also).  Any help would
>be appreciated.
>
>thank you,
>George
>
>
>java.lang.ArrayIndexOutOfBoundsException: 7
>
>	at oracle.security.o3logon.C0.r(C0)
>
>	
>
There's some other folks having this issue, and it seems to happen in 
apps other than Squirrel. 
See:

http://groups-beta.google.com/group/weblogic.developer.interest.jdbc/browse_thread/thread/7a5425d2be6081ea/e3a9852854cc370b?lnk=st&q=ArrayIndexOutOfBoundsException+Oracle+10+oracle.security.o3logon&rnum=1&hl=en#e3a9852854cc370b

Are you positive that you have the jdbc driver that applies to your 
version of the database? (If Oracle, it's probably best to
use the one from the server - $ORACLE_HOME/jdbc/lib/classesxx.zip)

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] Importing BLOBs

[Rob M. <Rob...@co...>]

SMETS Thomas wrote:

>JDBC log does not show any trace but the logs well.
>See below
>  
>
I don't currently have access to a 10g server, but as I've said it works 
fine for me on 9i.  Perhaps you would
care to test something for me - if not no worries.  If you remove the 
TIMESTAMP columns, or replace them
with DATE columns instead, does it still throw the same exception?

>The only thing I should do is download the latest RC as I am working with the 1.2rc6,instead of the 2.0rc1 like you do Robert.
>
>Are the plugins still valid ... ?
>I found colorizing VERY useful :)
>  
>
The "standard" plugins (that is, the plugins which are considered 
stable) are shipped with the installer now,
which is available here:

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=22079&release_id=336780

The Syntax Highlighting plugin is responsible for the color in the SQL 
editor tab.  It's considered "standard",
and should be installed for you when you install 2.0RC1.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

RE: [Squirrel-sql-users] Importing BLOBs

[SMETS T. <Tho...@po...>]

DQpKREJDIGxvZyBkb2VzIG5vdCBzaG93IGFueSB0cmFjZSBidXQgdGhlIGxvZ3Mgd2VsbC4NClNl
ZSBiZWxvdw0KDQpUaGUgb25seSB0aGluZyBJIHNob3VsZCBkbyBpcyBkb3dubG9hZCB0aGUgbGF0
ZXN0IFJDIGFzIEkgYW0gd29ya2luZyB3aXRoIHRoZSAxLjJyYzYsaW5zdGVhZCBvZiB0aGUgMi4w
cmMxIGxpa2UgeW91IGRvIFJvYmVydC4NCg0KQXJlIHRoZSBwbHVnaW5zIHN0aWxsIHZhbGlkIC4u
LiA/DQpJIGZvdW5kIGNvbG9yaXppbmcgVkVSWSB1c2VmdWwgOikNCg0KDQoNClxULA0KDQoNCg0K
amF2YS5zcWwuU1FMRXhjZXB0aW9uOiBPUkEtMDE4NDM6IG5vdCBhIHZhbGlkIG1vbnRoDQoNCiAg
ICAgICAgYXQgb3JhY2xlLmpkYmMuZGJhY2Nlc3MuREJFcnJvci50aHJvd1NxbEV4Y2VwdGlvbihE
QkVycm9yLmphdmE6MTM0KQ0KICAgICAgICBhdCBvcmFjbGUuamRiYy50dGM3LlRUSW9lci5wcm9j
ZXNzRXJyb3IoVFRJb2VyLmphdmE6Mjg5KQ0KICAgICAgICBhdCBvcmFjbGUuamRiYy50dGM3Lk9h
bGw3LnJlY2VpdmUoT2FsbDcuamF2YTo1NzMpDQogICAgICAgIGF0IG9yYWNsZS5qZGJjLnR0Yzcu
VFRDN1Byb3RvY29sLmRvT2FsbDcoVFRDN1Byb3RvY29sLmphdmE6MTg5MSkNCiAgICAgICAgYXQg
b3JhY2xlLmpkYmMudHRjNy5UVEM3UHJvdG9jb2wuZmV0Y2goVFRDN1Byb3RvY29sLmphdmE6MTE5
OCkNCiAgICAgICAgYXQgb3JhY2xlLmpkYmMuZHJpdmVyLk9yYWNsZVN0YXRlbWVudC5kb0V4ZWN1
dGVRdWVyeShPcmFjbGVTdGF0ZW1lbnQuamF2YToyNDAwKQ0KICAgICAgICBhdCBvcmFjbGUuamRi
Yy5kcml2ZXIuT3JhY2xlU3RhdGVtZW50LmRvRXhlY3V0ZVdpdGhUaW1lb3V0KE9yYWNsZVN0YXRl
bWVudC5qYXZhOjI2NzIpDQogICAgICAgIGF0IG9yYWNsZS5qZGJjLmRyaXZlci5PcmFjbGVTdGF0
ZW1lbnQuZXhlY3V0ZVF1ZXJ5KE9yYWNsZVN0YXRlbWVudC5qYXZhOjU3MikNCiAgICAgICAgYXQg
bmV0LnNvdXJjZWZvcmdlLnNxdWlycmVsX3NxbC5jbGllbnQuc2Vzc2lvbi5tYWlucGFuZWwub2Jq
ZWN0dHJlZS50YWJzLnRhYmxlLkNvbnRlbnRzVGFiLmdldFdhcm5pbmdPbkN1cnJlbnREDQp0YShD
b250ZW50c1RhYi5qYXZhOjU0MCkNCiAgICAgICAgYXQgbmV0LnNvdXJjZWZvcmdlLnNxdWlycmVs
X3NxbC5mdy5kYXRhc2V0dmlld2VyLkRhdGFTZXRWaWV3ZXJFZGl0YWJsZVRhYmxlUGFuZWwuY2hh
bmdlVW5kZXJseWluZ1ZhbHVlQXQoRGF0YVNlDQpWaWV3ZXJFZGl0YWJsZVRhYmxlUGFuZWwuamF2
YToxOTIpDQogICAgICAgIGF0IG5ldC5zb3VyY2Vmb3JnZS5zcXVpcnJlbF9zcWwuZncuZGF0YXNl
dHZpZXdlci5NeVRhYmxlTW9kZWwuc2V0VmFsdWVBdChNeVRhYmxlTW9kZWwuamF2YToxNDIpDQog
ICAgICAgIGF0IG5ldC5zb3VyY2Vmb3JnZS5zcXVpcnJlbF9zcWwuZncuZ3VpLlNvcnRhYmxlVGFi
bGVNb2RlbC5zZXRWYWx1ZUF0KFNvcnRhYmxlVGFibGVNb2RlbC5qYXZhOjEyNikNCiAgICAgICAg
YXQgamF2YXguc3dpbmcuSlRhYmxlLnNldFZhbHVlQXQoSlRhYmxlLmphdmE6MTc5NCkNCiAgICAg
ICAgYXQgbmV0LnNvdXJjZWZvcmdlLnNxdWlycmVsX3NxbC5mdy5kYXRhc2V0dmlld2VyLkRhdGFT
ZXRWaWV3ZXJUYWJsZVBhbmVsJE15SlRhYmxlLnNldFZhbHVlQXQoRGF0YVNldFZpZXdlclRhYmxl
DQphbmVsLmphdmE6Mjc3KQ0KICAgICAgICBhdCBuZXQuc291cmNlZm9yZ2Uuc3F1aXJyZWxfc3Fs
LmZ3LmRhdGFzZXR2aWV3ZXIuQ2VsbERhdGFQb3B1cCQxLmFjdGlvblBlcmZvcm1lZChDZWxsRGF0
YVBvcHVwLmphdmE6MjQ2KQ0KICAgICAgICBhdCBqYXZheC5zd2luZy5BYnN0cmFjdEJ1dHRvbi5m
aXJlQWN0aW9uUGVyZm9ybWVkKEFic3RyYWN0QnV0dG9uLmphdmE6MTc4NikNCiAgICAgICAgYXQg
amF2YXguc3dpbmcuQWJzdHJhY3RCdXR0b24kRm9yd2FyZEFjdGlvbkV2ZW50cy5hY3Rpb25QZXJm
b3JtZWQoQWJzdHJhY3RCdXR0b24uamF2YToxODM5KQ0KICAgICAgICBhdCBqYXZheC5zd2luZy5E
ZWZhdWx0QnV0dG9uTW9kZWwuZmlyZUFjdGlvblBlcmZvcm1lZChEZWZhdWx0QnV0dG9uTW9kZWwu
amF2YTo0MjApDQogICAgICAgIGF0IGphdmF4LnN3aW5nLkRlZmF1bHRCdXR0b25Nb2RlbC5zZXRQ
cmVzc2VkKERlZmF1bHRCdXR0b25Nb2RlbC5qYXZhOjI1OCkNCiAgICAgICAgYXQgamF2YXguc3dp
bmcucGxhZi5iYXNpYy5CYXNpY0J1dHRvbkxpc3RlbmVyLm1vdXNlUmVsZWFzZWQoQmFzaWNCdXR0
b25MaXN0ZW5lci5qYXZhOjI0NSkNCiAgICAgICAgYXQgamF2YS5hd3QuQ29tcG9uZW50LnByb2Nl
c3NNb3VzZUV2ZW50KENvbXBvbmVudC5qYXZhOjUxMDApDQogICAgICAgIGF0IGphdmEuYXd0LkNv
bXBvbmVudC5wcm9jZXNzRXZlbnQoQ29tcG9uZW50LmphdmE6NDg5NykNCiAgICAgICAgYXQgamF2
YS5hd3QuQ29udGFpbmVyLnByb2Nlc3NFdmVudChDb250YWluZXIuamF2YToxNTY5KQ0KICAgICAg
ICBhdCBqYXZhLmF3dC5Db21wb25lbnQuZGlzcGF0Y2hFdmVudEltcGwoQ29tcG9uZW50LmphdmE6
MzYxNSkNCiAgICAgICAgYXQgamF2YS5hd3QuQ29udGFpbmVyLmRpc3BhdGNoRXZlbnRJbXBsKENv
bnRhaW5lci5qYXZhOjE2MjcpDQogICAgICAgIGF0IGphdmEuYXd0LkNvbXBvbmVudC5kaXNwYXRj
aEV2ZW50KENvbXBvbmVudC5qYXZhOjM0NzcpDQogICAgICAgIGF0IGphdmEuYXd0LkxpZ2h0d2Vp
Z2h0RGlzcGF0Y2hlci5yZXRhcmdldE1vdXNlRXZlbnQoQ29udGFpbmVyLmphdmE6MzQ4MykNCiAg
ICAgICAgYXQgamF2YS5hd3QuTGlnaHR3ZWlnaHREaXNwYXRjaGVyLnByb2Nlc3NNb3VzZUV2ZW50
KENvbnRhaW5lci5qYXZhOjMxOTgpDQogICAgICAgIGF0IGphdmEuYXd0LkxpZ2h0d2VpZ2h0RGlz
cGF0Y2hlci5kaXNwYXRjaEV2ZW50KENvbnRhaW5lci5qYXZhOjMxMjgpDQogICAgICAgIGF0IGph
dmEuYXd0LkNvbnRhaW5lci5kaXNwYXRjaEV2ZW50SW1wbChDb250YWluZXIuamF2YToxNjEzKQ0K
ICAgICAgICBhdCBqYXZhLmF3dC5XaW5kb3cuZGlzcGF0Y2hFdmVudEltcGwoV2luZG93LmphdmE6
MTYwNikNCiAgICAgICAgYXQgamF2YS5hd3QuQ29tcG9uZW50LmRpc3BhdGNoRXZlbnQoQ29tcG9u
ZW50LmphdmE6MzQ3NykNCiAgICAgICAgYXQgamF2YS5hd3QuRXZlbnRRdWV1ZS5kaXNwYXRjaEV2
ZW50KEV2ZW50UXVldWUuamF2YTo0NTYpDQogICAgICAgIGF0IGphdmEuYXd0LkV2ZW50RGlzcGF0
Y2hUaHJlYWQucHVtcE9uZUV2ZW50Rm9ySGllcmFyY2h5KEV2ZW50RGlzcGF0Y2hUaHJlYWQuamF2
YToyMDEpDQogICAgICAgIGF0IGphdmEuYXd0LkV2ZW50RGlzcGF0Y2hUaHJlYWQucHVtcEV2ZW50
c0ZvckhpZXJhcmNoeShFdmVudERpc3BhdGNoVGhyZWFkLmphdmE6MTUxKQ0KICAgICAgICBhdCBq
YXZhLmF3dC5FdmVudERpc3BhdGNoVGhyZWFkLnB1bXBFdmVudHMoRXZlbnREaXNwYXRjaFRocmVh
ZC5qYXZhOjE0NSkNCiAgICAgICAgYXQgamF2YS5hd3QuRXZlbnREaXNwYXRjaFRocmVhZC5wdW1w
RXZlbnRzKEV2ZW50RGlzcGF0Y2hUaHJlYWQuamF2YToxMzcpDQogICAgICAgIGF0IGphdmEuYXd0
LkV2ZW50RGlzcGF0Y2hUaHJlYWQucnVuKEV2ZW50RGlzcGF0Y2hUaHJlYWQuamF2YToxMDApDQpT
UUxFeGNlcHRpb246IFNRTFN0YXRlKDIyMDA4KSB2ZW5kb3IgY29kZSgxODQzKQ0KamF2YS5zcWwu
U1FMRXhjZXB0aW9uOiBPUkEtMDE4NDM6IG5vdCBhIHZhbGlkIG1vbnRoDQoNCiAgICAgICAgYXQg
b3JhY2xlLmpkYmMuZGJhY2Nlc3MuREJFcnJvci50aHJvd1NxbEV4Y2VwdGlvbihEQkVycm9yLmph
dmE6MTM0KQ0KICAgICAgICBhdCBvcmFjbGUuamRiYy50dGM3LlRUSW9lci5wcm9jZXNzRXJyb3Io
VFRJb2VyLmphdmE6Mjg5KQ0KICAgICAgICBhdCBvcmFjbGUuamRiYy50dGM3Lk9hbGw3LnJlY2Vp
dmUoT2FsbDcuamF2YTo1NzMpDQogICAgICAgIGF0IG9yYWNsZS5qZGJjLnR0YzcuVFRDN1Byb3Rv
Y29sLmRvT2FsbDcoVFRDN1Byb3RvY29sLmphdmE6MTg5MSkNCiAgICAgICAgYXQgb3JhY2xlLmpk
YmMudHRjNy5UVEM3UHJvdG9jb2wuZmV0Y2goVFRDN1Byb3RvY29sLmphdmE6MTE5OCkNCiAgICAg
ICAgYXQgb3JhY2xlLmpkYmMuZHJpdmVyLk9yYWNsZVN0YXRlbWVudC5kb0V4ZWN1dGVRdWVyeShP
cmFjbGVTdGF0ZW1lbnQuamF2YToyNDAwKQ0KICAgICAgICBhdCBvcmFjbGUuamRiYy5kcml2ZXIu
T3JhY2xlU3RhdGVtZW50LmRvRXhlY3V0ZVdpdGhUaW1lb3V0KE9yYWNsZVN0YXRlbWVudC5qYXZh
OjI2NzIpDQogICAgICAgIGF0IG9yYWNsZS5qZGJjLmRyaXZlci5PcmFjbGVTdGF0ZW1lbnQuZXhl
Y3V0ZVF1ZXJ5KE9yYWNsZVN0YXRlbWVudC5qYXZhOjU3MikNCiAgICAgICAgYXQgbmV0LnNvdXJj
ZWZvcmdlLnNxdWlycmVsX3NxbC5jbGllbnQuc2Vzc2lvbi5tYWlucGFuZWwub2JqZWN0dHJlZS50
YWJzLnRhYmxlLkNvbnRlbnRzVGFiLmdldFdhcm5pbmdPblByb2plY3RlDQpVcGRhdGUoQ29udGVu
dHNUYWIuamF2YTo1OTQpDQogICAgICAgIGF0IG5ldC5zb3VyY2Vmb3JnZS5zcXVpcnJlbF9zcWwu
ZncuZGF0YXNldHZpZXdlci5EYXRhU2V0Vmlld2VyRWRpdGFibGVUYWJsZVBhbmVsLmNoYW5nZVVu
ZGVybHlpbmdWYWx1ZUF0KERhdGFTZQ0KVmlld2VyRWRpdGFibGVUYWJsZVBhbmVsLmphdmE6MjEx
KQ0KICAgICAgICBhdCBuZXQuc291cmNlZm9yZ2Uuc3F1aXJyZWxfc3FsLmZ3LmRhdGFzZXR2aWV3
ZXIuTXlUYWJsZU1vZGVsLnNldFZhbHVlQXQoTXlUYWJsZU1vZGVsLmphdmE6MTQyKQ0KICAgICAg
ICBhdCBuZXQuc291cmNlZm9yZ2Uuc3F1aXJyZWxfc3FsLmZ3Lmd1aS5Tb3J0YWJsZVRhYmxlTW9k
ZWwuc2V0VmFsdWVBdChTb3J0YWJsZVRhYmxlTW9kZWwuamF2YToxMjYpDQogICAgICAgIGF0IGph
dmF4LnN3aW5nLkpUYWJsZS5zZXRWYWx1ZUF0KEpUYWJsZS5qYXZhOjE3OTQpDQogICAgICAgIGF0
IG5ldC5zb3VyY2Vmb3JnZS5zcXVpcnJlbF9zcWwuZncuZGF0YXNldHZpZXdlci5EYXRhU2V0Vmll
d2VyVGFibGVQYW5lbCRNeUpUYWJsZS5zZXRWYWx1ZUF0KERhdGFTZXRWaWV3ZXJUYWJsZQ0KYW5l
bC5qYXZhOjI3NykNCiAgICAgICAgYXQgbmV0LnNvdXJjZWZvcmdlLnNxdWlycmVsX3NxbC5mdy5k
YXRhc2V0dmlld2VyLkNlbGxEYXRhUG9wdXAkMS5hY3Rpb25QZXJmb3JtZWQoQ2VsbERhdGFQb3B1
cC5qYXZhOjI0NikNCiAgICAgICAgYXQgamF2YXguc3dpbmcuQWJzdHJhY3RCdXR0b24uZmlyZUFj
dGlvblBlcmZvcm1lZChBYnN0cmFjdEJ1dHRvbi5qYXZhOjE3ODYpDQogICAgICAgIGF0IGphdmF4
LnN3aW5nLkFic3RyYWN0QnV0dG9uJEZvcndhcmRBY3Rpb25FdmVudHMuYWN0aW9uUGVyZm9ybWVk
KEFic3RyYWN0QnV0dG9uLmphdmE6MTgzOSkNCiAgICAgICAgYXQgamF2YXguc3dpbmcuRGVmYXVs
dEJ1dHRvbk1vZGVsLmZpcmVBY3Rpb25QZXJmb3JtZWQoRGVmYXVsdEJ1dHRvbk1vZGVsLmphdmE6
NDIwKQ0KICAgICAgICBhdCBqYXZheC5zd2luZy5EZWZhdWx0QnV0dG9uTW9kZWwuc2V0UHJlc3Nl
ZChEZWZhdWx0QnV0dG9uTW9kZWwuamF2YToyNTgpDQogICAgICAgIGF0IGphdmF4LnN3aW5nLnBs
YWYuYmFzaWMuQmFzaWNCdXR0b25MaXN0ZW5lci5tb3VzZVJlbGVhc2VkKEJhc2ljQnV0dG9uTGlz
dGVuZXIuamF2YToyNDUpDQogICAgICAgIGF0IGphdmEuYXd0LkNvbXBvbmVudC5wcm9jZXNzTW91
c2VFdmVudChDb21wb25lbnQuamF2YTo1MTAwKQ0KICAgICAgICBhdCBqYXZhLmF3dC5Db21wb25l
bnQucHJvY2Vzc0V2ZW50KENvbXBvbmVudC5qYXZhOjQ4OTcpDQogICAgICAgIGF0IGphdmEuYXd0
LkNvbnRhaW5lci5wcm9jZXNzRXZlbnQoQ29udGFpbmVyLmphdmE6MTU2OSkNCiAgICAgICAgYXQg
amF2YS5hd3QuQ29tcG9uZW50LmRpc3BhdGNoRXZlbnRJbXBsKENvbXBvbmVudC5qYXZhOjM2MTUp
DQogICAgICAgIGF0IGphdmEuYXd0LkNvbnRhaW5lci5kaXNwYXRjaEV2ZW50SW1wbChDb250YWlu
ZXIuamF2YToxNjI3KQ0KICAgICAgICBhdCBqYXZhLmF3dC5Db21wb25lbnQuZGlzcGF0Y2hFdmVu
dChDb21wb25lbnQuamF2YTozNDc3KQ0KICAgICAgICBhdCBqYXZhLmF3dC5MaWdodHdlaWdodERp
c3BhdGNoZXIucmV0YXJnZXRNb3VzZUV2ZW50KENvbnRhaW5lci5qYXZhOjM0ODMpDQogICAgICAg
IGF0IGphdmEuYXd0LkxpZ2h0d2VpZ2h0RGlzcGF0Y2hlci5wcm9jZXNzTW91c2VFdmVudChDb250
YWluZXIuamF2YTozMTk4KQ0KICAgICAgICBhdCBqYXZhLmF3dC5MaWdodHdlaWdodERpc3BhdGNo
ZXIuZGlzcGF0Y2hFdmVudChDb250YWluZXIuamF2YTozMTI4KQ0KICAgICAgICBhdCBqYXZhLmF3
dC5Db250YWluZXIuZGlzcGF0Y2hFdmVudEltcGwoQ29udGFpbmVyLmphdmE6MTYxMykNCiAgICAg
ICAgYXQgamF2YS5hd3QuV2luZG93LmRpc3BhdGNoRXZlbnRJbXBsKFdpbmRvdy5qYXZhOjE2MDYp
DQogICAgICAgIGF0IGphdmEuYXd0LkNvbXBvbmVudC5kaXNwYXRjaEV2ZW50KENvbXBvbmVudC5q
YXZhOjM0NzcpDQogICAgICAgIGF0IGphdmEuYXd0LkV2ZW50UXVldWUuZGlzcGF0Y2hFdmVudChF
dmVudFF1ZXVlLmphdmE6NDU2KQ0KICAgICAgICBhdCBqYXZhLmF3dC5FdmVudERpc3BhdGNoVGhy
ZWFkLnB1bXBPbmVFdmVudEZvckhpZXJhcmNoeShFdmVudERpc3BhdGNoVGhyZWFkLmphdmE6MjAx
KQ0KICAgICAgICBhdCBqYXZhLmF3dC5FdmVudERpc3BhdGNoVGhyZWFkLnB1bXBFdmVudHNGb3JI
aWVyYXJjaHkoRXZlbnREaXNwYXRjaFRocmVhZC5qYXZhOjE1MSkNCiAgICAgICAgYXQgamF2YS5h
d3QuRXZlbnREaXNwYXRjaFRocmVhZC5wdW1wRXZlbnRzKEV2ZW50RGlzcGF0Y2hUaHJlYWQuamF2
YToxNDUpDQogICAgICAgIGF0IGphdmEuYXd0LkV2ZW50RGlzcGF0Y2hUaHJlYWQucHVtcEV2ZW50
cyhFdmVudERpc3BhdGNoVGhyZWFkLmphdmE6MTM3KQ0KICAgICAgICBhdCBqYXZhLmF3dC5FdmVu
dERpc3BhdGNoVGhyZWFkLnJ1bihFdmVudERpc3BhdGNoVGhyZWFkLmphdmE6MTAwKQ0KU1FMRXhj
ZXB0aW9uOiBTUUxTdGF0ZSgyMjAwOCkgdmVuZG9yIGNvZGUoMTg0MykNCg0KDQoKClNUUklDVExZ
IFBFUlNPTkFMIEFORCBDT05GSURFTlRJQUwNClRoaXMgbWVzc2FnZSBtYXkgY29udGFpbiBjb25m
aWRlbnRpYWwgYW5kIHByb3ByaWV0YXJ5IG1hdGVyaWFsIGZvciB0aGUgc29sZSB1c2Ugb2YgdGhl
IGludGVuZGVkIHJlY2lwaWVudC4gQW55IHJldmlldyBvciBkaXN0cmlidXRpb24gYnkgb3RoZXJz
IGlzIHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNp
cGllbnQgcGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVsZXRlIGFsbCBjb3BpZXMuDQoN
CkRpdCBiZXJpY2h0IGlzIGVua2VsIGJlc3RlbWQgdm9vciBkZSBhYW5nZWR1aWRlIG9udHZhbmdl
cnMgZW4ga2FuIHZlcnRyb3V3ZWxpamtlIGluZm9ybWF0aWUgYmV2YXR0ZW4uIEFscyB1IG5pZXQg
ZGUgb250dmFuZ2VyIGJlbnQsIGRhbiBtYWcgdSBkZSBpbmhvdWQgdmFuIGRpdCBiZXJpY2h0IG5p
ZXQgYmVrZW5kbWFrZW4gbm9jaCBrb3Bpw6tyZW4uIEFscyB1IGRpdCBiZXJpY2h0IHBlciB2ZXJn
aXNzaW5nIG9udHZhbmdlbiBoZWVmdCwgZ2VsaWV2ZSBlciBkZSBhZnplbmRlciBvZiBEZSBQb3N0
IG9ubWlkZGVsbGlqayB2YW4gb3AgZGUgaG9vZ3RlIHRlIGJyZW5nZW4gZW4gaGV0IGJlcmljaHQg
dmVydm9sZ2VucyB0ZSB2ZXJ3aWpkZXJlbi4NCg0KQ2UgbWVzc2FnZSBlc3QgdW5pcXVlbWVudCBk
ZXN0aW7DqSBhdXggZGVzdGluYXRhaXJlcyBpbmRpcXXDqXMgZXQgcGV1dCBjb250ZW5pciBkZXMg
aW5mb3JtYXRpb25zIGNvbmZpZGVudGllbGxlcy4gU2kgdm91cyBuJ8OqdGVzIHBhcyBsZSBkZXN0
aW5hdGFpcmUsIHZvdXMgbmUgZGV2ZXogcGFzIHLDqXbDqWxlciBsZSBjb250ZW51IGRlIGNlIG1l
c3NhZ2Ugb3UgZW4gcHJlbmRyZSBjb3BpZS4gU2kgdm91cyBhdmV6IHJlw6d1IGNlIG1lc3NhZ2Ug
cGFyIGVycmV1ciwgdmV1aWxsZXogZW4gaW5mb3JtZXIgbCdleHDDqWRpdGV1ciwgb3UgTGEgUG9z
dGUgaW1tw6lkaWF0ZW1lbnQsIGF2YW50IGRlIGxlIHN1cHByaW1lci4K

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hi,
>
>I just downloaded squirrelSql and I can't connect to my oracle 10g
>instance.  The faq states that it connects to oracle 8, but that's
>hella old.  That can't be right.  Or maybe it is?  Can someone shed
>some light?
>  
>
I use it regularly to connect to Oracle 9i.  What happens when you 
attempt to connect?
Do you have an exception stack trace at the bottom of the log 
(Windows->View SQuirreL Logs)?

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] Importing BLOBs

[Rob M. <Rob...@co...>]

SMETS Thomas wrote:

>Dear,
>  
>
<snip>

>I then get the following error :
>	ORA-01842 : not a invalid month  ? ? ?
>
>Can someone tell me what the problem is ???
>  
>
Hello,

I executed the following SQL with the latest Squirrel snapshot 
(available on SF tomorrow) :

create table MY_TABLE (
    ID                NUMBER,
    NR                NUMBER  , 
    BODY              BLOB ,    
    DESCRIPTION       VARCHAR2(50),
    CREATED_BY        VARCHAR2(7),
    CREATED_ON        TIMESTAMP(6),
    LAST_UPDATED_BY   VARCHAR2(7),
    LAST_UPDATED_ON   TIMESTAMP(6)   
)

insert into MY_TABLE
    (ID, NR, BODY, DESCRIPTION, CREATED_BY, CREATED_ON, LAST_UPDATED_BY, 
LAST_UPDATED_ON)
values (21, 2, null, 'Test', 'TEST', SYSDATE, 'TEST', SYSDATE);

Including the attached file (first 100 lines of a jpg- 
copy_tables_short.jpg)

I don't receive any errors (see attached screenshot - blob_screenshot.jpg)

According to http://ora-01842.ora-code.com/ the error code you are 
getting is from Oracle :

*ORA-01842:* 	quarter must be between 1 and 4
*Cause:* 	An invalid value was specified for the quarter of the year in 
a date. The quarter (Q) must be between 1 and 4.
*Action:* 	Enter a value for quarter between 1 and 4.



I'm using Oracle 9i.  Did you have an exception in your log file?

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83