Only 48 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!



  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle 8.1.7+J2EE+WINDOWS 2000+stupid doubt + urgent+please help  RSS feed

 
Preety Agarwal
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all
My environment is as mentioned in the topic. How do i get my things to work.
Where do i down load my drivers. How do I set up the envirronment variables. I keep getting the message SET J2EE HOME before running the script.
Stupid doubt:
What is the difference between Oracle HTTP server and J2EE Server
 
Amy Zeng
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1.Include the JDBC driver in the CLASSPATH in %J2EE_HOME%\bin\userconfig.bat
Uncomment the following line in %J2EE_HOME%\bin\userconfig.bat, and add your drive archive file name:
Set J2EE_CLASSPATH=.;d:\orant\jdbc\lib\classes12.zip;
Note: You should remove the driver .zip files from the CLASSPATH environment variable if you already have.
2.Add Oracle to default.properties
You need to set the jdbc.drivers and jdbc.datasources properties to refer to the Oracle DB. If you have a standard version of Oracle installed on your machine and you are using the default ORCL database, sid is arcl:
jdbc.drivers=oracle.jdbc.driver.OracleDriver
jdbc.datasources=jdbc/AccountDB|jdbc racle:thin:
@localhost:1521:arcl
arcl is my sid, jdbc/Account is my logic database name, my code should be:
private String dbName = "java:comp/env/jdbc/AccountDB";
NOTE: The second and third lines above, setting jdbc.datasources, must be on a single line in the default.properties file.
3. Set up user permissions
when you deploy for each enterprise bean Resource Reference tab, the username is set to scott and the password is set to tiger, if it is session, you need to type in JNDI name. If it is entity bean, the JNDI name would should automatically show.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!