• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Bear Bibeault
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Piet Souris
  • salvin francis
  • Stephan van Hulst
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Jj Roberts

Setting up a Datasource in WSAD Test Environment

 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I am trying to set up the datasource in WSAD Test Environment.
I opened the server console , went to the Datasource tab and create d a new DB2 JDBC Provider
Also created a Datasource for this.
Entered the databaseName under resource properties

My question is where should I configure the user id and pasword for logging in to the database?

I didnt, and when trying to run the code I got the following
error

[10/7/05 14:29:35:852 IST] 4f2d0c45 LocalSessionF I org.springframework.orm.hibernate3.LocalSessionFactoryBean Building new Hibernate SessionFactory
[10/7/05 14:29:35:852 IST] 4f2d0c45 Configuration I org.hibernate.cfg.Configuration processing extends queue
[10/7/05 14:29:35:852 IST] 4f2d0c45 Configuration I org.hibernate.cfg.Configuration processing collection mappings
[10/7/05 14:29:35:852 IST] 4f2d0c45 Configuration I org.hibernate.cfg.Configuration processing association property references
[10/7/05 14:29:35:852 IST] 4f2d0c45 Configuration I org.hibernate.cfg.Configuration processing foreign key constraints
[10/7/05 14:29:36:680 IST] 4f2d0c45 ConnectionPro I org.hibernate.connection.ConnectionProviderFactory Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
[10/7/05 14:29:38:712 IST] 4f2d0c45 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -30,082 and SQLState 08001, to a StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "15" ("PROCESSING FAILURE"). SQLSTATE=08001

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:174)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:431)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:432)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:351)
at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(DB2ReusableConnection.java:66)
at COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(DB2PooledConnection.java:183)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:46

I hope the fact that I am using spring to look up my datasource doesnt make a difference.

<bean id="exampleDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName"><value>jdbc/bhffds</value></property>
<property name="resourceRef"><value>false</value></property>
</bean>
 
dhanya kairali
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
:-)
found the solution here.
http://www.webagesolutions.com/knowledgebase/waskb/waskb001/
Thanks!!
 
Look! It's Leonardo da Vinci! And he brought a tiny ad!
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic