List:MySQL and Java« Previous MessageNext Message »
From:Frank Daly Date:May 27 2003 4:31pm
Subject:JDBC Realm
View as plain text  
Hi

I'm using windows NT4, Tomcat 4, Java 1.4.1, Mysql 4 and the mysql jdbc
driver 3.0.7 stable.  I've put the driver into the
Catalina_home\common\lib directory

I've added the following to the Catalina_home\conf\server.xml file


      <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
             driverName="org.gjt.mm.mysql.Driver"
          connectionURL
"jdbc:mysql://localhost:3306/tomcatusers?user=test&amp;password=test"

              userTable="users" userNameCol="user_name"
userCredCol="user_pass"
          userRoleTable="user_roles" roleNameCol="role_name" />

However the page doesn't show.  Is there something I'm missing?

Frank

-----Original Message-----
From: Mark Matthews [mailto:mark@stripped] 
Sent: 20 January 2003 15:42
To: raffi@stripped
Cc: Peter Schäfer; java@stripped
Subject: Re: JDBC Interface for Embedded Server ?

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

raffi@stripped wrote:
> I would definitely do whatever I can to assist in such a project. I 
> think it would be great.

I can also help (with some internals) to get this going. However, 
there's a couple of things you should know:

1. It will probably be slower than just embedding a 'normal' MySQL 
server with your application, because of JNI call overhead.
2. There will be threading issues.
3. You will have to maintain a multi-platform codebase if you want this 
to become popular enough to have a following.

It might make more sense to re-factor Connector/J a bit, and have 
'pluggable' backends...sockets, etc. As it stands now, you should just 
be able to re-work the MysqlIO class a little bit and plug in your calls

to libmysqld there.

	-Mark


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

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

     __  ___     ___ ____  __
    /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
   / /|_/ / // /\ \/ /_/ / /__ 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+LBi3tvXNTca6JD8RAksnAJ46QqmieRu4vHA04Z9bVNdhnO5s+wCeICTY
DnmByq5pdP5eeIB4500v6E8=
=o4Q3
-----END PGP SIGNATURE-----


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

To request this thread, e-mail <java-thread4913@stripped>
To unsubscribe, e-mail <java-unsubscribe-fdaly=cit.ie@stripped>


-------------------Legal
Disclaimer---------------------------------------

The above electronic mail transmission is confidential and intended only
for the person to whom it is addressed. Its contents may be protected by
legal and/or professional privilege. Should it be received by you in
error please contact the sender at the above quoted email address. Any
unauthorised form of reproduction of this message is strictly
prohibited. The Institute does not guarantee the security of any
information electronically transmitted and is not liable if the
information contained in this communication is not a proper and complete
record of the message as transmitted by the sender nor for any delay in
its receipt.

------------------------------------------------------------------------
----------------


-------------------Legal  Disclaimer---------------------------------------

The above electronic mail transmission is confidential and intended only for the person to
whom it is addressed. Its contents may be protected by legal and/or professional
privilege. Should it be received by you in error please contact the sender at the above
quoted email address. Any unauthorised form of reproduction of this message is strictly
prohibited. The Institute does not guarantee the security of any information
electronically transmitted and is not liable if the information contained in this
communication is not a proper and complete record of the message as transmitted by the
sender nor for any delay in its receipt.

----------------------------------------------------------------------------------------

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