Go to the j2sdkee1.2.1 installation directory and then to config folder.
Look out for default.properties file. Open it in a text editor and set the
following
jdbc.drivers=Name of the driver
jdbc.datasources=URL to connect to the database
example to connect to the SQL Server
jdbc.drivers=com.jnetdirect.jsql.JSQLDriver
jdbc.datasources=jdbc/Sequel|jdbc:JSQLConnect://192.168.46.69:1433/database=
SongFinder

Restart the J2EE server and in your bean code, write as follows

Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/Sql");
conn = ds.getConnection();

Here jdbc/Sql is the name of the JNDI lookup.

See that in the jdbc.datasources the JNDI name is specified as jdbc/Sequel.
These both can be same. While deploying your application, in the resource
reference add the datasource and specify the jndi names.

-----Original Message-----
From: Carlos Otero Barros [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 28, 2001 1:43 PM
To: [EMAIL PROTECTED]
Subject: Using other databases with Sun Reference Implementation


Does anybody knows how to configure and bind other databases than Cloudscape
with Sun Reference Implementation?

Thanks

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to