aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes urgent!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "urgent!!" Watch "urgent!!" New topic
Author

urgent!!

asheet anand
Ranch Hand

Joined: Nov 15, 2000
Posts: 83
hi,
I am working on j2ee.I want to make a connection to sql database
using a session bean.Could you please tell me a simple program
and simple steps in deployment.
thanks
asheet
Peter Gragert
Ranch Hand

Joined: Jan 16, 2001
Posts: 424
Get the 'petStore' example (blueprint from sun). It has help for installation and shows how to use 'only' j2ee and cloudscape.
Nidhi Madan
Greenhorn

Joined: May 09, 2001
Posts: 9
Hi Asheet,
First of all go to your default.properties file in your config folder under your j2sdkee1.2.1 and put the statement in rem where
you are connecting with the cloudscape , i.e
#jdbc.datasources=jdbc/Cloudscape|jdbc:cloudscape:rmi:CloudscapeDB;create=true
and then instead of this write the following statement
jdbc.datasources=jdbc/sql|jdbc dbc:<write the user dsn name here in which you create a database in which you want your tables to be stored>;create=true
now save this file an start your j2ee server again.
While deploying your example inthe codede refrence name give jdbc/databasename and the jndi name as jdbc/sql and the other jndi name give it what you are giving in your lookup call in the client.
if you are not able to get through it. mail me back again , i'll send you the small coded example as an attachment. send me your personal mail id as sending attachment is not possible here.
Hope it works for you
 
wood burning stoves
 
subject: urgent!!