KARR, DAVID (ATTSI | 9 Jun 00:35 2010
Picon

Could use better diagnostics for permission errors

I may have asked about this a long time ago, but I'm not sure.

I find that when SQuirreL tries to connect to a database that has
fine-grained permissions issues, it writes errors into the log file, but
it's impossible to find out what it's actually failing on (the log entry
doesn't provide any useful hints), and there's no sign in the GUI that
there was any issue.  At this point, I'm not even sure what I'm unable
to see.  It might not be important, but I would like to know what I
don't have access to.

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
Zhou Yun Long (NCSI SZ | 9 Jun 05:59 2010
Picon

decimal fraction missing while dbcopy and source generating

Hi,

 

    Has anybody encountered the missing of decimal fraction when using dbcopy and table source generating?

 

 

 

 

 

Best Regards!

Zhou YunLong

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Robert Manning | 9 Jun 13:05 2010
Picon

Re: decimal fraction missing while dbcopy and source generating

This type of problem can be caused by incorrect metadata from the driver, or could also be a bug in dbcopy.   Please file a bug report here :

https://sourceforge.net/tracker/?atid=393414&group_id=28383

Also, include a source table definition, and some sample data that demonstrates the issue.  Don't forget to let us know there what the source and destination database vendor and versions as well as the jdbc driver versions used were.

Thanks,

Rob

On Tue, Jun 8, 2010 at 11:59 PM, Zhou Yun Long (NCSI SZ) <zyunlong <at> ncsi.com.cn> wrote:

Hi,

 

    Has anybody encountered the missing of decimal fraction when using dbcopy and table source generating?

 

 

 

 

 

Best Regards!

Zhou YunLong


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit.  See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Mansour Al Akeel | 9 Jun 17:50 2010
Picon

Remove source forge country block

Source Forge added a country block to control who can download "Their" software.

Read this.
http://arabcrunch.com/2010/01/following-clintons-internet-freedom-speech-us-based-sourceforge-blocked-syria-sudan-iran-korea-cuba-is-open-source-still-really-open.html

A temporary solution is to remove this country block. This can be done
by the project admin. Here's how to do it:
http://sourceforge.net/blog/some-good-news-SourceForge-removes-blanket-blocking/

A perfect solution is to find another free hosting for this project,
so that everybody can download this product without "discrimination".

Thank you.

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
Robert Manning | 9 Jun 18:46 2010
Picon

Re: Remove source forge country block

Just to be fair, the "discrimination" was brought about because:

"As a US-based web site, SourceForge remains committed to complying
fully with all relevant US laws and regulations, including those
affecting the distribution of software."

One of those laws has to do with export compliance, that says that
dual-purpose (civilian/military) software (e.g. encryption ciphers)
cannot be exported without meeting certain conditions.  In certain
cases one of those conditions is to file paperwork with the government
for notification that the software being exported is dual-purpose or
contains dual-purpose third-party libraries.  Penalties for
non-compliance include fines and jail time.  Since SF probably doesn't
have the staff to determine which projects are in danger of
non-compliance, I'm guessing that SF is attempting to shift the burden
for compliance to project administrators, since they are in a better
position to make that determination.

Rob

On 6/9/10, Mansour Al Akeel <mansour.alakeel <at> gmail.com> wrote:
> Source Forge added a country block to control who can download "Their" software.
>
> Read this.
> http://arabcrunch.com/2010/01/following-clintons-internet-freedom-speech-us-based-sourceforge-blocked-syria-sudan-iran-korea-cuba-is-open-source-still-really-open.html
>
> A temporary solution is to remove this country block. This can be done
> by the project admin. Here's how to do it:
> http://sourceforge.net/blog/some-good-news-SourceForge-removes-blanket-blocking/
>
> A perfect solution is to find another free hosting for this project,
> so that everybody can download this product without "discrimination".
>
> Thank you.
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
Mansour Al Akeel | 9 Jun 20:57 2010
Picon

Re: Remove source forge country block

Rob:
Thank you, and I can see your point. I totally understand the
restrictions on SF. However, a better job notifying the projects admin
can be done. I don't see SF have taken enough efforts trying to work
around this issue. For example they could have added a page to notify
any admin when they login the first time after this block took effect.
This will allow more projects admins to be aware of the situation, then
they can take the measures to ensure the project is qualified to be
exported or not. Failing to take this extra step by notifying
the admins, makes me think they are biased, and the statement saying they are
obligated to block those countries is false. 

On the other hand, source forge have mirrors (contributed) every where especially in
Europe, where these rules don't apply.

Please note that, these products are not exported by the US, since they
were not developed on American soil. They came from everywhere and they
are public domain.  

I think there are many ways not to add this block, or at least to go
around it. This was not the case, and "IS" voilation for open source.

To me, comments on this page are very useful, and they shed some light
on many points. 

http://sourceforge.net/blog/clarifying-sourceforgenets-denial-of-site-access-for-certain-persons-in-accordance-with-us-law/

Thank you again for your opinion. 

On Wed Jun 09,2010 12:46 pm, Robert Manning wrote:
> Just to be fair, the "discrimination" was brought about because:
> 
> "As a US-based web site, SourceForge remains committed to complying
> fully with all relevant US laws and regulations, including those
> affecting the distribution of software."
> 
> One of those laws has to do with export compliance, that says that
> dual-purpose (civilian/military) software (e.g. encryption ciphers)
> cannot be exported without meeting certain conditions.  In certain
> cases one of those conditions is to file paperwork with the government
> for notification that the software being exported is dual-purpose or
> contains dual-purpose third-party libraries.  Penalties for
> non-compliance include fines and jail time.  Since SF probably doesn't
> have the staff to determine which projects are in danger of
> non-compliance, I'm guessing that SF is attempting to shift the burden
> for compliance to project administrators, since they are in a better
> position to make that determination.
> 
> Rob
> 
> 
> 
> 
> On 6/9/10, Mansour Al Akeel <mansour.alakeel <at> gmail.com> wrote:
> > Source Forge added a country block to control who can download "Their" software.
> >
> > Read this.
> > http://arabcrunch.com/2010/01/following-clintons-internet-freedom-speech-us-based-sourceforge-blocked-syria-sudan-iran-korea-cuba-is-open-source-still-really-open.html
> >
> > A temporary solution is to remove this country block. This can be done
> > by the project admin. Here's how to do it:
> > http://sourceforge.net/blog/some-good-news-SourceForge-removes-blanket-blocking/
> >
> > A perfect solution is to find another free hosting for this project,
> > so that everybody can download this product without "discrimination".
> >
> > Thank you.
> >
> > ------------------------------------------------------------------------------
> > ThinkGeek and WIRED's GeekDad team up for the Ultimate
> > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> > lucky parental unit.  See the prize list and enter to win:
> > http://p.sf.net/sfu/thinkgeek-promo
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squirrel-sql-users <at> lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
Robert Manning | 10 Jun 00:17 2010
Picon

Re: Remove source forge country block

Mansour,

Completely agree that notification was lacking and SF failed there.
As far as open source goes, I suppose that US laws effectively
prohibit true open source development of dual-purpose software (e.g.
encryption ciphers) or the use of them.  It is still completely legal
to develop dual-purpose open source code outside of the US and host it
on a server located outside of the US, and re-distribute it anywhere
(US laws don't prohibit importation of dual-purpose software).  It
would be nice not to have to think about these regulations when
developing code, but unfortunately, today, that is where we are.  I
don't believe we have any code that is dual-purpose in SQuirreL, but
ultimately Gerd will have to make the decision to remove the block.
Recently I have been researching the export laws to see if it will
allow us to implement encrypting passwords in our aliases xml file.
It looks like there are some conditions that may not require export
notification, but I am not ready to try that out at this point :)

Rob

On Wed, Jun 9, 2010 at 2:57 PM, Mansour Al Akeel
<mansour.alakeel <at> gmail.com> wrote:
> Rob:
> Thank you, and I can see your point. I totally understand the
> restrictions on SF. However, a better job notifying the projects admin
> can be done. I don't see SF have taken enough efforts trying to work
> around this issue. For example they could have added a page to notify
> any admin when they login the first time after this block took effect.
> This will allow more projects admins to be aware of the situation, then
> they can take the measures to ensure the project is qualified to be
> exported or not. Failing to take this extra step by notifying
> the admins, makes me think they are biased, and the statement saying they are
> obligated to block those countries is false.
>
> On the other hand, source forge have mirrors (contributed) every where especially in
> Europe, where these rules don't apply.
>
> Please note that, these products are not exported by the US, since they
> were not developed on American soil. They came from everywhere and they
> are public domain.
>
> I think there are many ways not to add this block, or at least to go
> around it. This was not the case, and "IS" voilation for open source.
>
> To me, comments on this page are very useful, and they shed some light
> on many points.
>
> http://sourceforge.net/blog/clarifying-sourceforgenets-denial-of-site-access-for-certain-persons-in-accordance-with-us-law/
>
>
>
> Thank you again for your opinion.
>
>
>
> On Wed Jun 09,2010 12:46 pm, Robert Manning wrote:
>> Just to be fair, the "discrimination" was brought about because:
>>
>> "As a US-based web site, SourceForge remains committed to complying
>> fully with all relevant US laws and regulations, including those
>> affecting the distribution of software."
>>
>> One of those laws has to do with export compliance, that says that
>> dual-purpose (civilian/military) software (e.g. encryption ciphers)
>> cannot be exported without meeting certain conditions.  In certain
>> cases one of those conditions is to file paperwork with the government
>> for notification that the software being exported is dual-purpose or
>> contains dual-purpose third-party libraries.  Penalties for
>> non-compliance include fines and jail time.  Since SF probably doesn't
>> have the staff to determine which projects are in danger of
>> non-compliance, I'm guessing that SF is attempting to shift the burden
>> for compliance to project administrators, since they are in a better
>> position to make that determination.
>>
>> Rob
>>
>>
>>
>>
>> On 6/9/10, Mansour Al Akeel <mansour.alakeel <at> gmail.com> wrote:
>> > Source Forge added a country block to control who can download "Their" software.
>> >
>> > Read this.
>> > http://arabcrunch.com/2010/01/following-clintons-internet-freedom-speech-us-based-sourceforge-blocked-syria-sudan-iran-korea-cuba-is-open-source-still-really-open.html
>> >
>> > A temporary solution is to remove this country block. This can be done
>> > by the project admin. Here's how to do it:
>> > http://sourceforge.net/blog/some-good-news-SourceForge-removes-blanket-blocking/
>> >
>> > A perfect solution is to find another free hosting for this project,
>> > so that everybody can download this product without "discrimination".
>> >
>> > Thank you.
>> >
>> > ------------------------------------------------------------------------------
>> > ThinkGeek and WIRED's GeekDad team up for the Ultimate
>> > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
>> > lucky parental unit.  See the prize list and enter to win:
>> > http://p.sf.net/sfu/thinkgeek-promo
>> > _______________________________________________
>> > Squirrel-sql-users mailing list
>> > Squirrel-sql-users <at> lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> >
>

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
squirrel | 12 Jun 01:14 2010

Copying aliases

Good evening folks. I installed squirrel client on another machine. How do
I copy the aliases from my other machines?

Thanks,

Neil

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
Matthew Dahlman | 12 Jun 02:15 2010

Re: Copying aliases

Neil,

On windows the file you want is here:
C:\Documents and Settings\[username]\.squirrel-sql\SQLAliases23.xml

Copy that file over and you should be all set. (Hopefully that info should
be enough to track it down on Linux as well if you use that.)

Regards,
Matt Dahlman
Jaspersoft

-----Original Message-----
From: squirrel [mailto:squirrel <at> neilcamara.com] 
Sent: Friday, 11 June, 2010 16:15
To: squirrel-sql-users <at> lists.sourceforge.net
Subject: [Squirrel-sql-users] Copying aliases

Good evening folks. I installed squirrel client on another machine. How do
I copy the aliases from my other machines?

Thanks,

Neil

--------------------------------------------------------------------------
----
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's
Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit.  See the prize
list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
squirrel | 14 Jun 20:22 2010

Displaying error

I would like my Squirrel SQL client to display error codes in human
readable form and not just the error code.

An example of the error I just saw few minutes ago is

SQLState:  42S22
ErrorCode: 207

I pasted my sql query to isql just to be able to find out what error it is

Invalid column name 'bookcode'.
Msg 207, Level 16, State 4:

Thanks,

Neil

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo

Gmane