Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes BEA/Weblogic and the fly likes weblogic and jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "weblogic and jdbc" Watch "weblogic and jdbc" New topic
Author

weblogic and jdbc

John Gregory
Ranch Hand

Joined: Oct 05, 2006
Posts: 115
I'm trying to create a datasource in weblogic 9.2. I get to a
screen where I can test my datasource, but I got an exception
thrown due to an inability to find the mysql*.jar file containing
the driver. Can anyone tell me where this file goes? Presently,
I think I moved it to BEA_HOME/common/lib

I am running weblogic on a dell 1721 laptop with Ubuntu 7.X OS.
Are there any environment variables that need to be set in my
.cshrc file?

Thanks,

John
Misha Ver
Ranch Hand

Joined: Mar 03, 2008
Posts: 470
Did you update web logic classpath to include the location of the JDBC driver classes?
John Gregory
Ranch Hand

Joined: Oct 05, 2006
Posts: 115
No, I haven't. I'll try that and see what happens.

Thanks,

John
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
Normally, you would place the JAR file in /APP-INF/lib.


SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Misha Ver
Ranch Hand

Joined: Mar 03, 2008
Posts: 470
Originally posted by Roger Chung-Wee:
Normally, you would place the JAR file in /APP-INF/lib.


Why? I keep them in WL_HOME\server\lib folder
John Gregory
Ranch Hand

Joined: Oct 05, 2006
Posts: 115
I did read somewhere in the WL Documentation
that it should go in the ~/server/lib folder, I
just can't remember where I read it!

Thanks to those who responded.

John
Misha Ver
Ranch Hand

Joined: Mar 03, 2008
Posts: 470
Probably here http://edocs.bea.com/wls/docs91/jdbc_admin/third_party_drivers.html
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
Hi,

my suggestion is to place the driver files under ${DOMAIN_HOME}/lib this will place the jar automatically on the classpath of all servers created for this domain.
Kevin Smither
Ranch Hand

Joined: Oct 22, 2007
Posts: 30
Marcos is absolutely right. Put it int he /lib directory of the domain. The server classpath will be automatically adjusted to include these files!
John Gregory
Ranch Hand

Joined: Oct 05, 2006
Posts: 115
All,

Ok, thanks. I'll try that and get back after I do.
I figured it would go in some lib folder, but there
were a couple so I wasn't sure.

John
 
jQuery in Action, 2nd edition
 
subject: weblogic and jdbc