• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Database Initializatio

 
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Ranchers!!
I need your help in configuring the database in the Sun's Application server 8.0 PE ..
i'm using the Admin Console for connecting the database!!
In that i logged on to the Resources -> JDBC -> Connection Pools

from there i clicked the new button..
and give the following values

Name : test
Resource type : javax.sql.DataSource
Database vendor : oracle
then i clicked next >>

in the next page.. i've given the following

Data Source Class name : oracle.jdbc.pool.OracleDataSource

and clicked next >>
in the next page i've given the following properties

databasenam : megha
user name : scott
password : tiger
port : 1521

After saving the setting when i ping.. to test the connection.. it is shwoing the following error!!
Operation 'pingConnectionPool' failed in 'resources' Config Mbean
i don't know what to do now!!
please help me.. ranchers!!

thanks in advance!!
[ April 11, 2006: Message edited by: Bear Bibeault ]
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't know anything about that product, but I don't see where you have configured the name of the server where Oracle is running.
 
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Megha...
It is very easy..
the thing u want to do is

first log in sun admin console
http://localhost:4848
then.. give user name and passwd
then go to the path like this

Resources -> JDBC -> Connection Pool

first you have to create the connection pool then only u can use it as a JDBC Resource.. ok

now.. click the new button in the connection pool

type like this

name : test
resource type : java.sql.datasource
database vendor : oracle

click next ->
datasource class name = oracle.jdbc.pool.OracleDataSource (this will be default)
click next ->

in the next page..
give following property:
username : scott
pwd : tiget
url :jdbc racle:thin:@<ip address>:<port number>:<database name>
egs is like this
url = jdbc racle:thin:@172.16.0.4:1521 racle (ok)

then click finish..
click ping!! to test the connection
if ping succeeded!! then connection is ok
if showing some error!!
then u have to download the thin driver for oracle from
oracle website
the file name will be class12.zip
download that file.. and save it in
<Appserver Path>/domain/domain1/lib/

then u go to the admin console path...
click the Application Server from the left menu..
go to JVM Settings
and then click the Path settings

there u can see the text area for Classpath Suffix:
in that text area..
u have to give the path.. of the thin driver
in my system i give like this

C:\Sun\AppServer\domains\domain1\lib\classes12.zip

click save!!
again go to the connection pool.. and click ping...
it will be successful..
then go to the JDBC Resource!!
and click new button!!
give the jndi name : jdbc/test
the pool name will be in the combo
and give description!!
click ok..

now.. it is ready for the database programming..

try this out...
all the best

 
Megha Rajeevan
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thank u Mr.Aravind Prasad!!
this is working perfectly!!
thank u very much!!

regards Megha
 
permaculture is a more symbiotic relationship with nature so I can be even lazier. Read tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic