Re: JDBC driver / JBoss

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greg Matthews wrote:

Mark,

Version was 3.51.05.

Hmmm, that looks like an ODBC driver version. MySQL Connector/J has two branches right now 2.0.x and 3.0.x, seeing as how you're using named pipes, you must be using 3.0.x something.

& works ok. It now seems that it might be related to me trying to use
the NamedPipeSocketFactory. When I use leave these properties out of the
datasource url everything works ok.

socketFactory=com.mysql.jdbc.NamedPipeSocketFactory
namedPipePath=/mysql/pipe

[snip]

Other variations of namedPipePath, like c:/mysql/pipe also fail, and yes,
there is a directory called c:\mysql

If you haven't changed the named-pipe path (and I doubt you have), leave it off. The driver will use the default. You also need to have started your MySQL server with --enable-named-pipe and you need to be running the mysqld-nt.exe or mysqld-max-nt.exe binary for your server.

See

http://www.mysql.com/doc/en/Windows_prepare_environment.html

and

http://www.mysql.com/doc/en/Windows_running.html

Any help much appreciated,

Greg.

PS. Using the standard IP-based connection (i.e. not named-pipes) seems to
kick MS Sql Servers arse in terms of speed.

That's nice to hear :) Considering that in my testing named pipes are even faster (at least on XP), you should look forward to great performance once you get everything running.

Please let me know if you need any further assistance.

Thanks, and Happy New Year!

-Mark


- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+DlRGtvXNTca6JD8RAoInAJ9WSz/9+ib44fXhIsd+WjEBZ5UfLQCfcjoo
7Vdwx5WGgZElpVV3Gz0CksA=
=Vdq/
-----END PGP SIGNATURE-----


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php