tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Søren Blidorf <so...@nolas.dk>
Subject SV: Realm & SQL 2000 developer edition
Date Fri, 16 Jan 2004 00:26:46 GMT
I didn't think that there would be a difference, other than stuff like
that. 

Can anybody see something in the Realm that might be wrong?

<Context path="/um" docBase="c:/projects/MY_PROJECT" debug="0"
reloadable="true">
<Realm name="UMRealm" className="org.apache.catalina.realm.JDBCRealm"
debug="99" driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
connectionURL="jdbc:microsoft:sqlserver://MY_PC_NAME;DatabaseName=nolas;
ProgramName=MYREALM;SelectMethod=cursor" connectionName="MYUSER"
connectionPassword="MYPASS" userTable="users" userNameCol="username"
userCredCol="password" userRoleTable="user_roles" roleNameCol="rolename"
/>
</Context>

I am a bit lost so any ideas are very welcome

Soren

-----Oprindelig meddelelse-----
Fra: Mark Thomas [mailto:markt@apache.org] 
Sendt: 16. januar 2004 00:56
Til: 'Tomcat Users List'
Emne: RE: Realm & SQL 2000 developer edition

AFAIK the only difference is that the developer edition is designed to
give poor
performance if you have more than 5 concurrent connections. Otherwise
they
should be the same.

Mark

-----Original Message-----
From: Søren Blidorf [mailto:soren@nolas.dk] 
Sent: Thursday, January 15, 2004 11:04 PM
To: tomcat-user@jakarta.apache.org
Subject: Realm & SQL 2000 developer edition

Does anybody know of any difference between SQL 2000 standard and
Developer edition?

I am having problems with my realm:

<Context path="/um" docBase="c:/projects/MY_PROJECT" debug="0"
reloadable="true">
<Realm name="UMRealm" className="org.apache.catalina.realm.JDBCRealm"
debug="99" driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
connectionURL="jdbc:microsoft:sqlserver://MY_PC_NAME;DatabaseName=nolas;
ProgramName=MYREALM;SelectMethod=cursor" connectionName="MYUSER"
connectionPassword="MYPASS" userTable="users" userNameCol="username"
userCredCol="password" userRoleTable="user_roles" roleNameCol="rolename"
/>
</Context>

I have connection to the database and I get an error if I type in wrong
user/pass. But when signing in I does not seem to be logged on.

Every thing works on win2000 and sql 2000 server standard.


Please help.

Soren


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message