This could be an Oracle 8.1.7 naming configuration. What machine types are you using? If TOAD is running on the same machine that Tomcat is running, then you must be doing WinTel.
I would recommend, 1. Check the /etc/hosts (*nix) or c:\winnt\system32\drivers\etc\hosts (wintel) on "myhost"-Server. 2. Then check the /etc/hosts (or wintel location) on the other server. For simplicitiy, if you can ping the FQDN of the Oracle server from both servers, then you can rule out the Oracle configuration issues. With 8.1.7, you need to either have a DNS entry for the FQDN of the Oracle server (not servicename or SID), or run Oracle Names, or manually enter it in the local server's or workstation's "hosts" file. - Greg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 7:54 AM To: [EMAIL PROTECTED] Subject: No data from Oracle Hello, i have some problem with Tomcat. If i run Tomcat on "myhost"-Server, everything functioned correctly, but if i run Tomcat on any other server, become no data transferred from DB, but user autorization works. Other programs, like TOAD, works however correctly on each server. Can you tell me, what is wrong in configuration and may be i must configure something else? I use Tomcat 4.0.6, Oracle 8.1.7. Realm configuration in file $TOMCAT/conf/server.xml: <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@myhost:1521:mydb202" connectionName="mydb" connectionPassword="mydb" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name" digest="MD5"/> Configuration in $TOMCAT/webapps/oms/WEB-INF/web.xml <datasources> <jdbc name="mydb"> <auto-commit>false</auto-commit> <pool-controller min="5" max="10"/> <dburl>jdbc:oracle:thin:@myhost:1521:mydb202</dburl> <user>mydb</user> <password>mydb</password> </jdbc> </datasources> Thank you for answer. Diese E-Mail enth�lt vertrauliche und/oder rechtlich gesch�tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt�mlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
