This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Websphere and the fly likes Configuring WAS 6.1 data source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Configuring WAS 6.1 data source" Watch "Configuring WAS 6.1 data source" New topic
Author

Configuring WAS 6.1 data source

P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
I am trying to configuring Oracle database as the datasource in WAS 6.1.
when i enter

Oracle data source properties
URL as

i am getting a error message


The field, URL, does not contain a valid value.
Anant Rao
Ranch Hand

Joined: Nov 12, 2004
Posts: 126
Here is an example of the URL from the infocenter.

URL : The URL that indicates the database from which the data source obtains connections. Example: jdbc racle:thin:@myServer:1521:myDatabase, where myServer is the server name, 1521 is the port it is using for communication, and myDatabase is the database name.

http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/topic/com.ibm.websphere.nd.doc/info/ae/ae/rdat_minreqoracle.html

Anant
P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
I tried the URL
jdbc: racle:thin:@localhost:1521: RCL

and gave the username and password in JAAS - J2C authentication data
i getting some ather error When Testing Connection


My system Config :Windows XP Sp2, WAS6.1, Oracle 11g
Duc Vo
Ranch Hand

Joined: Nov 20, 2008
Posts: 254
Did you set the Webphere variable ORACLE_JDBC_DRIVER_PATH in the Environment -> Websphere Variables to point to a directory having your oracle driver?


“Everything should be as simple as it is, but not simpler.” Albert Einstein
P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
I have set the ORACLE_JDBC_DRIVER_PATH


WAS_INSTALL_ROOT = C:\Program Files\IBM\SDP70\runtimes\base_v61
ORACLE_JDBC_DRIVER_PATH= ${WAS_INSTALL_ROOT}/oracle/lib
Class path = ${ORACLE_JDBC_DRIVER_PATH}/ojdbc5.jar

still as the same problem

com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA8050W: Unable to find the DataStoreHelper class specified: com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
Duc Vo
Ranch Hand

Joined: Nov 20, 2008
Posts: 254
Maybe this web page can help you.
P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
still having the problem but different one

[12/5/08 8:16:24:718 IST] 00000022 ServletWrappe E SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet: DataSourceConn. Exception thrown : java.lang.NullPointerException
at org.conn.DataSourceConn.doGet(DataSourceConn.java:63)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1439)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)

[12/5/08 8:16:24:828 IST] 00000022 ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl initialize FFDC0009I: FFDC opened incident stream file C:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_4ba84ba8_08.12.05_08.16.24_0.txt
[12/5/08 8:16:24:984 IST] 00000022 ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file C:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_4ba84ba8_08.12.05_08.16.24_0.txt
[12/5/08 8:16:25:000 IST] 00000022 LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called.
[12/5/08 8:16:25:031 IST] 00000022 WebApp E [Servlet Error]-[DataSourceConn]: java.lang.NullPointerException
at org.conn.DataSourceConn.doGet(DataSourceConn.java:63)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1439)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)

[12/5/08 8:16:24:671 IST] 00000022 SystemErr R javax.naming.NameNotFoundException: Context: skylark-03c9270Node01Cell/nodes/skylark-03c9270Node01/servers/server1, name: jdbc/raclespatial: First component in name raclespatial not found. [Root exception is org.omg.CosNaming.NamingContextPackage.NotFound: IDL mg.org/CosNaming/NamingContext/NotFound:1.0]
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.processNotFoundException(CNContextImpl.java:4730)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(CNContextImpl.java:1907)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(CNContextImpl.java:1862)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.lookupExt(CNContextImpl.java:1552)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.lookup(CNContextImpl.java:1354)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:172)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at javax.naming.InitialContext.lookup(InitialContext.java:363)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at org.conn.DataSourceConn.init(DataSourceConn.java:36)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:190)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.init(ServletWrapper.java:317)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:346)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1439)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
[12/5/08 8:16:24:671 IST] 00000022 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
[12/5/08 8:16:24:687 IST] 00000022 SystemErr R Caused by: org.omg.CosNaming.NamingContextPackage.NotFound: IDL mg.org/CosNaming/NamingContext/NotFound:1.0
at com.ibm.ws.naming.ipcos.WsnOptimizedNamingImpl.do_resolve_complete_info(WsnOptimizedNamingImpl.java:543)
at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(WsnOptimizedNamingImplBase.java:2215)
at com.ibm.WsnOptimizedNaming._NamingContextStub.resolve_complete_info(_NamingContextStub.java:536)
at com.ibm.ws.naming.jndicos.CNContextImpl.cosResolve(CNContextImpl.java:4351)
at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(CNContextImpl.java:1901)
at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(CNContextImpl.java:1862)
at com.ibm.ws.naming.jndicos.CNContextImpl.lookupExt(CNContextImpl.java:1552)
at com.ibm.ws.naming.jndicos.CNContextImpl.lookup(CNContextImpl.java:1354)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:172)
at javax.naming.InitialContext.lookup(InitialContext.java:363)
at org.conn.DataSourceConn.init(DataSourceConn.java:36)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:190)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.init(ServletWrapper.java:317)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:346)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1439)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)

[12/5/08 8:16:24:703 IST] 00000022 SystemErr R at com.ibm.ws.naming.ipcos.WsnOptimizedNamingImpl.do_resolve_complete_info(WsnOptimizedNamingImpl.java:543)
[12/5/08 8:16:24:703 IST] 00000022 SystemErr R at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(WsnOptimizedNamingImplBase.java:2215)
[12/5/08 8:16:24:703 IST] 00000022 SystemErr R at com.ibm.WsnOptimizedNaming._NamingContextStub.resolve_complete_info(_NamingContextStub.java:536)
[12/5/08 8:16:24:703 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.cosResolve(CNContextImpl.java:4351)
[12/5/08 8:16:24:703 IST] 00000022 SystemErr R at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(CNContextImpl.java:1901)
[12/5/08 8:16:24:703 IST] 00000022 SystemErr R ... 28 more
Duc Vo
Ranch Hand

Joined: Nov 20, 2008
Posts: 254
Originally posted by P Sathish Kumar:
still having the problem but different one

It seems to be different problem now. It said the JNDI name is incorrect. What name did you use?
What name did you set up?
Also, did you test the connection on the Data sources page? i.e. select the datasource then click "Test Connection"
P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
JNDI name for the data source is
jdbc/OracleSpatial

Here is the servlet code that call this datasource
P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
There was as mismatch of the JNDI name. i corrected it still i am getting the some ather problem
J2CA0036E: An exception occurred while invoking method setDataSourceProperties on com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by resource jdbc/OracleSpatial : java.lang.NoSuchMethodError: oracle/jdbc/driver/OracleLog.setLogVolume(I)V
P Sathish Kumar
Greenhorn

Joined: Sep 08, 2007
Posts: 14
The TestConnection in the Datasource config is working fine.
i have given the wrong JNDI name in the Servlet i corrected it. still i am getting some problem
J2CA0036E: An exception occurred while invoking method setDataSourceProperties on com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by resource jdbc/OracleSpatial : java.lang.NoSuchMethodError: oracle/jdbc/driver/OracleLog.setLogVolume(I)V
Duc Vo
Ranch Hand

Joined: Nov 20, 2008
Posts: 254
The problem seems to be with the library file now. Please check the following:
(1) Do you have any other ojdbc library file in the class path? (i.e. in folder WEB-INF/lib or folder lib/ext of the server). Or at best, use the classpath viewer in admin console of Websphere for the deloyed module and check for the library file. If you find any, remove them.
(2) Make sure you use the correct version of the ojdbc library file as mentioned in the link I sent earlier.

Hope it help!
Cheers,
Peter DeGregorio
Greenhorn

Joined: Jul 11, 2002
Posts: 9

Two other possible causes:
1. Data source custom property oracle9iLogTraceLevel must be blank
2. WebSphere AS service pack level must include IBM's fix for problem of using 9i methods against 10g/11g database
 
jQuery in Action, 2nd edition
 
subject: Configuring WAS 6.1 data source
 
Similar Threads
question with GC
Tomcat and Oracle, will i transfer any file?
Problem with database connect
Oracle DB Connectivity & Master Configuration
configuring datasource in struts-config.xml