List:MySQL and Java« Previous MessageNext Message »
From:Mark Matthews Date:January 20 2003 6:03pm
Subject:Re: JDBC Interface for Embedded Server ?
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tim Endres wrote:
>>1. It will probably be slower than just embedding a 'normal' MySQL 
>>server with your application, because of JNI call overhead.
> 
> 
> Mark,
> 
> When you say this, do you mean to embed a MySQL server and connect
> to it using JDBC? Do you know anyone who has done this?

Yes. I've heard of people doing it, but I don't have a list of names or 
anything :)

You can manage server startup/shutdown via Runtime.exec(), and you can 
manage system shutdown alone with the MiniAdmin class that comes with 
the driver.

The only thing you have to watch out for would be a mysql server already 
installed. It would be possible to write a little port-scanner in Java 
in your installer that just looks for port 3306 listening, and if not, 
then leave the MySQL config file alone, otherwise re-write the 'my.cnf' 
file to use some other port, and configure your software to use the same 
port.

	-Mark

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+LDnXlyjUJM+7nP4RApE0AJ9YSAKfB+0qhzmiYQ1dtG2NtLL43wCfaDQl
gCw0XhctitYrwWg0kzG2c+Y=
=3eB0
-----END PGP SIGNATURE-----

Thread
JDBC Interface for Embedded Server ?Peter Schäfer20 Jan
  • Re: JDBC Interface for Embedded Server ?Mark Robson20 Jan
  • Re: JDBC Interface for Embedded Server ?raffi@dcit.com20 Jan
    • Re: JDBC Interface for Embedded Server ?Mark Matthews20 Jan
      • Re: JDBC Interface for Embedded Server ?Tim Endres20 Jan
        • Re: JDBC Interface for Embedded Server ?Mark Matthews20 Jan
          • RE: JDBC Interface for Embedded Server ?Peter Schäfer20 Jan
            • Re: JDBC Interface for Embedded Server ?Mark Matthews20 Jan
      • Re: JDBC Interface for Embedded Server ?raffi@dcit.com21 Jan
        • Re: JDBC Interface for Embedded Server ?Mark Matthews21 Jan
      • JDBC RealmFrank Daly27 May
RE: JDBC Interface for Embedded Server ?Peter Schäfer20 Jan