aspose file tools*
The moose likes BEA/Weblogic and the fly likes Connection pool problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Connection pool problem" Watch "Connection pool problem" New topic
Author

Connection pool problem

Mary Cole
Ranch Hand

Joined: Dec 02, 2000
Posts: 362
Hi All,
I am creating a oracle connectionpool using weblogic5.1
All the parameters in the weblogic properties file are passed correctly.
When I start the weblogic server I get an error saying
ORA 24327 -need explicit attach before authenticatin a user.
Pl help me where I am wrong or any settings I have to make
Thanx in advance
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Mary, I am moving this to the WebLogic forum as you are more likely to get a response there.


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
sandy gupta
Ranch Hand

Joined: Jan 30, 2001
Posts: 228
Seems like your database will not allow remote connectivity to the database ... try to log on from the sql plus screen and see if u can log in using the same login name , pass, and the host string and if yes contact your DBA for the problem...
HTH
Sahil


Adios
sandy gupta
Ranch Hand

Joined: Jan 30, 2001
Posts: 228
I Case the db is remote, modify the tnsnames.ora appropriately
hanumanth reddy
Ranch Hand

Joined: Jun 12, 2000
Posts: 118

U need to set up Connection pooling in the properties file and see tha u have permission to connect to the database
see jdbc documentation for more help


<a href="http://www.jobklub.com" target="_blank" rel="nofollow">http://www.jobklub.com</a><br /> 'Add Job To Life'
zhljgh
Greenhorn

Joined: Mar 02, 2001
Posts: 4
Hi, which database driver you use, is oci or thin? if thin, you
'd better select the compatible driver to the Oracle Database, if oci, you must set the config right.
Jim Baiter
Ranch Hand

Joined: Jan 05, 2001
Posts: 532
I got into a battle with this using the Weblogic drivers. When I switched and used the Oracle drivers, (classes12.zip), I had no problem.
Originally posted by Mary, Cole:
Hi All,
I am creating a oracle connectionpool using weblogic5.1
All the parameters in the weblogic properties file are passed correctly.
When I start the weblogic server I get an error saying
ORA 24327 -need explicit attach before authenticatin a user.
Pl help me where I am wrong or any settings I have to make
Thanx in advance

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection pool problem