db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Van Couvering" <da...@vancouvering.com>
Subject Re: securityMechanism for network client - can't make it work
Date Fri, 15 Jun 2007 21:17:00 GMT
Hi, Bernt.

>From derby.log:

Apache Derby Network Server - 10.2.2.0 - (485682) started and ready to
accept connections on port 1527 at 2007-06-15 18:54:04.161 GMT

client URL (from SquirrelSQL):

jdbc:derby://localhost:1527/travel;create=true;securityMechanism=8

On 6/15/07, Bernt M. Johnsen <Bernt.Johnsen@sun.com> wrote:
> Hi, Are you sure you use Derby 10.2.1.6 or newer? The error response
> seems to indicate an earlier version.
>
> Bernt
>
>
> >>>>>>>>>>>> David Van Couvering wrote (2007-06-15
12:12:38):
> > OK, I'm completely flummoxed.  I am trying to use strong password
> > mechanism instead of password in the clear, in an attempt to try and
> > write up how to do basic security in Derby.
> >
> > I read the docs, and they talk about setting the securityMechanism
> > property on the URL.  But it doesn't actually have an example.  I have
> > tried:
> >
> > "jdbc:derby://localhost:1527;securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY"
> > java.lang.NumberFormatException: For input string:
> > "STRONG_PASSWORD_SUBSTITUTE_SECURITY"
> >       at
> > java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >       at java.lang.Integer.parseInt(Integer.java:456)
> >       at java.lang.Short.parseShort(Short.java:120)
> >       at java.lang.Short.parseShort(Short.java:78)
> >       at org.apache.derby.jdbc.ClientBaseDataSource.parseShort(Unknown
> >       Source)
> >       at
> > org.apache.derby.jdbc.ClientBaseDataSource.getSecurityMechanism(Unknown
> > Source)
> > => NumberFormatException
> >
> > "jdbc:derby://localhost:1527;securityMechanism=0x08"
> >
> > java.lang.NumberFormatException: For input string: "0x08"
> >       at
> > java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >       at java.lang.Integer.parseInt(Integer.java:456)
> >       at java.lang.Short.parseShort(Short.java:120)
> >       at java.lang.Short.parseShort(Short.java:78)
> >       at org.apache.derby.jdbc.ClientBaseDataSource.parseShort(Unknown
> >       Source)
> >       at
> > org.apache.derby.jdbc.ClientBaseDataSource.getSecurityMechanism(Unknown
> > Source)
> > "jdbc:derby://localhost:1527;securityMechanism=8"
> >
> > => security mechanism '8' not supported
> >
> > So, can someone tell me what I'm actually supposed to do here?
> >
> > Thanks,
> >
> > David
>
> --
> Bernt Marius Johnsen, Database Technology Group,
> Staff Engineer, Technical Lead Derby/Java DB
> Sun Microsystems, Trondheim, Norway
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2.2 (GNU/Linux)
>
> iD8DBQFGcv3elFBD9TXBAPARAoDTAJ9f/W/gfzNTB0AfSUPAZ0KspR38bwCgg97s
> FJaErlONnU6w4H/V+cQorH0=
> =1uMg
> -----END PGP SIGNATURE-----
>
>

Mime
View raw message