JDBC and IPv6?

Thread view:

spacerook@gmail.com - 12 Apr 2007 17:04 GMT

Has anyone ever made a JDBC connection using an IPv6 URL? I am
setting my URL like so (the address here is fake):

jdbc:mysql://[1111:2222:3333:4444:5555:6666:7777:8888]/mysql

This results in the following error:

Cannot get connection for URL jdbc:mysql://
[1111:2222:3333:4444:5555:6666:7777:8888]/mysql : Illegal connection
port value ':5555:6666:7777:8888]'

I am trying to connect to a MySQL database and am using the MySQL
drivers. The Java program is on a Windows machine, which has IPv6
enabled and can successfully make a IPv6 ping (using ping6) to the
MySQL server. I'm starting Java with -
Djava.net.preferIPv6Addresses=true, which seems to have had no effect.

Reply to this Message

Greg R. Broderick - 12 Apr 2007 20:48 GMT

spacerook@gmail.com wrote in news:1176393880.951063.227550
@n59g2000hsh.googlegroups.com:

> Has anyone ever made a JDBC connection using an IPv6 URL? I am
> setting my URL like so (the address here is fake):
[quoted text clipped - 12 lines]
> MySQL server. I'm starting Java with -
> Djava.net.preferIPv6Addresses=true, which seems to have had no effect.

What happens when you use a fully-qualified domain name that resolves to the
IPv6 IP address via DNS?

I'd also recommend removing the square brackets surrounding the IPv6 address
in the URL.

Cheers!

Signature

---------------------------------------------------------------------
Greg R. Broderick gregb+usenet200612@blackholio.dyndns.org

A. Top posters.
Q. What is the most annoying thing on Usenet?
---------------------------------------------------------------------

Reply to this Message

Gordon Beaton - 13 Apr 2007 07:04 GMT

> I'd also recommend removing the square brackets surrounding the IPv6
> address in the URL.

The square brackets are there to indicate that the URL contains an
IPv6 literal address.

See rfc2732 (http://www.ietf.org/rfc/rfc2732.txt).

/gordon

--

Reply to this Message

spacerook@gmail.com - 13 Apr 2007 15:24 GMT

On Apr 12, 3:48 pm, "Greg R. Broderick" <gregb
+usenet200...@blackholio.dyndns.org> wrote:

> spacer...@gmail.com wrote in news:1176393880.951063.227550
> @n59g2000hsh.googlegroups.com:
[quoted text clipped - 23 lines]
>
> Cheers!

This seems to be morphing into more of a MySQL problem now...

I added an IPv6 address/hostname to my Windows host file. I can use
ping6 on the hostname and it works. Good. But I am now getting a
"Connection Refused" exception when trying to connect to the MySQL
server on the Linux machine.

I tried some experiments on the MySQL Linux box. This command works:

mysql -h 127.0.0.1

But this command gives an error:

mysql -h ::1
"Unknown MySQL Server host '::1'"

I think if I can get that second statement to work (i.e. get the MySQL
server to recognize IPv6 addresses), my problem will be solved.

Reply to this Message

CsuElites - 13 Apr 2007 16:39 GMT

> > > jdbc:mysql://[1111:2222:3333:4444:5555:6666:7777:8888]/mysql

Today ,for the first time ,i konw the format of IPV6 address.Thanks!

Reply to this Message

a24900@googlemail.com - 12 Apr 2007 22:39 GMT

On Apr 12, 6:04 pm, spacer...@gmail.com wrote:

> Has anyone ever made a JDBC connection using an IPv6 URL? I am
> setting my URL like so (the address here is fake):
>
> jdbc:mysql://[1111:2222:3333:4444:5555:6666:7777:8888]/mysql

My understanding is that mysql's jdbc driver can't handle the numeric
IPv6 address (postgress has a patched driver which can). mysql should
work with a domain name, resolved to an IPv6 address. You don't have
to put the IPv6 address into a DNS server to get it resolved. Putting
the mapping into the local "hosts" file (on systems with a resolver
which uses the file, too) should do.

Reply to this Message

JDBC and IPv6?

Free Magazines