wood burning stoves 2.0*
The moose likes JDBC and the fly likes Problems with the DataSources. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problems with the DataSources." Watch "Problems with the DataSources." New topic
Author

Problems with the DataSources.

Tina Jain
Greenhorn

Joined: Mar 17, 2006
Posts: 23
Hi everyone,

I am using WSAD version 5.1.2.

I am using Datasources.
I am using a Datasources version 5,

When I am trying to using the Datasources from a servlet, It is working fine, but at the console it is giving me this error


Resource reference jdbc/ds2 could not be located, so default values of the following are used: [Resource-ref settings]

res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]

isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)

[11/1/06 11:53:36:375 CST] 69bb6ae3 WSRdbDataSour I DSRA8203I: Database product name : Oracle
[11/1/06 11:53:36:391 CST] 69bb6ae3 WSRdbDataSour I DSRA8204I: Database product version : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
[11/1/06 11:53:36:406 CST] 69bb6ae3 WSRdbDataSour I DSRA8205I: JDBC driver name : Oracle JDBC driver
[11/1/06 11:53:36:406 CST] 69bb6ae3 WSRdbDataSour I DSRA8206I: JDBC driver version : 9.2.0.1.0
[11/1/06 11:53:36:656 CST] 69bb6ae3 SystemOut O Done


but it is doing what it is suppose to do, I am trying to insert a row into the database it is inserting it into the database.

I am just worried about why this is giving this error.

Thanks for your help in advance.

Have a Nice Day,
Best Regards,
Tina
[ November 01, 2006: Message edited by: Tina Jain ]

If You Cannot Give Anything, At least Give A Smile.
Tina Jain
Greenhorn

Joined: Mar 17, 2006
Posts: 23
I found the error, I had to add the element to the web.xml file


<resource-ref id="ResourceRef_1162404739453">
<res-ref-name>jdbc/ds2</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Application</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problems with the DataSources.