Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with ODBC data source with JRun4

 
Walter Chen
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am running JRun4 server with an Oracle database. If I set up the ODBC data source with the host IP, SID, port and user ID and password, everything works fine.
Now, since I wanted to have a logon page to authenticate the user and don't want to store the user name/password on the server, I removed the userID/password. After I restarted the server, I got the following exceptions:
04/18 14:23:04 error SQLException occurred in JDBCPool while attempting to conne
ct, please check your username, password, URL, and other connectivity info.
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01017: invali
d username/password; logon denied
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)

And when I try to look the data source, I got the following exception:
javax.naming.NameNotFoundException: No such binding: myOdbc
java.lang.NullPointerException
What should I do?
Thanks,
Walter
 
Walter Chen
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So in a nutshell, what I want to do is simply set up a ODBC data source without storing the user ID and password on the server (in this case JRun4). What is the best way to do this?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic