Skip to main content

Creating DataSource in GlassFish v. 2.1

I will show you how to create a DataSource in GlassFish version 2.1 because there were a lot of properties and I had a lot of problems when I've try to register datasource in glassfish for the first time.

1) You have to download JDBC driver for your database. For example I will use MySQL and I will use Connector/J driver that you can download from mysql official web site.

2) Place the JDBC driver in for example D:\glassfishv21\domains\domain1\lib\ext for example my driver is mysql-connector-java-5.0.4.jar

3) Start the domain for example domain1 (asadmin start-domain domain1)

4) go to http://localhost:4848 and login as admin. By default the username is 'admin' and the password is 'adminadmin'

5) go to Resources/JDBC/Connection Pools



-First we will create a connection pool. Click the 'NEW' button



-Than you must type:
- Name: of the connection pool for example MySQL Lessson
- Resource Type: javax.sql.ConnectionPoolDataSource
- Database Vendor: MySQL



-Press 'Next'
-On the Next step scroll down you will see a list of properties. The important for you (you must select this checkboxes) are: 'user','password','url'. If some of this is missing for example there is no 'url' if the vendor is Oracle you can add it using the Add property button.
- user : root
- password : rootpassword
- url : jdbc:mysql://localhost:3306/lesson?autoReconnect=true&characterEncoding=utf8



-When you fill this 3 properties you must press 'Save'
-Than select again your datasource and press 'Ping' to see is everything correct



You are now ready to create your DataSource that will use this connection pool.

6)go to Resources/JDBC/JDBC Resources



- Press 'New'
- Type some jndi name of the resource that you will use latter in your project(s)
- Choose PoolName to be the pool that you have just created.



Now we have DataSource that we can use from any Enterprise/Web Application.
In the next lesson I will create Java EE 5 application using JPA, EJB, JSF using eclipse and this app will use this datasource.

Comments

Unknown said…
Thank you so much, this is very helpful for those of us moving from Tomcat to Glassfish... Ahh if only Tomcat had a nice interface...
jNayden said…
:) btw the Tomcat admin application is not so bad. :) it is very easy to add JNDI datasource and JNDI variables without writing xml :)
So you can check it :)
Creating Oracle datasource in Glassfish Filed under: glassfish, j2ee, java, oracle — broersa @ 6:57 pm Glassfish doesn’t include the oracle drivers out of the box. To use these you need a jar file from oracle. You can download it from: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html I used ojdbc6.jar. Copied the file to /lib directory and restart the the server: asadmin stop-domain domain1 asadmin start-domain domain1 After this a connection pool must be created. Login to the admin console of glassfish. Open the resources – JDBC – Connection Pools and select new. Fill in the connection pool name, select javax.sql.ConnectionPoolDataSource and Oracle and click next.. Fill in the properties user, password en url
Tnx. This tutorial helped alot.

Popular posts from this blog

Hibernate Generic DAO.

When you use Hibernate and DAO pattern it is a good idea to use a Generic Base Dao. The fallowing code snippet contains GenericDAO that is a base class for all my DAO classes. This GenericDAO uses HibernateDaoSupport from Spring for its implementation if you want you can use JpaDaoSupport or JdbcDaoSupport in your projects. My Generic DAO interface looks like this : package org.joke.myproject.dao.base; import java.io.Serializable; import java.util.List; /** * @author Naiden Gochev * @param <E> * @param <PK> */ public interface GenericDao<E,PK  extends Serializable> {     PK save(E newInstance);     void update(E transientObject);     void saveOrUpdate(E transientObject);     void delete(E persistentObject);     E findById(PK id);     List<E> findAll();     List<E> findAllByProperty(String propertyName,Object value); } All method names are very common so I don't

Patching a Maven library with your custom class.

Sometimes you use a library that has a bug. Or maybe it doesn’t has a bug but you want to change something. Of course if it is an open source you can get the sources… build them … with your change and so on. However this first takes a lot of time and second you need the sources. What you usually want .. is to just replace one class.. or few classes with something custom… maybe add a line .. or remove a line and so on. Yesterday… I had an issue with jboss-logging. The version I was using was 3.2.0Beta1 and it turns out that using this version and log4j2 2.0 final basically meant that no log is send to log4j2. The reason was a null pointer exception that was catched in jboss logging class called Log4j2Logger. The bug I submitted is here https://issues.jboss.org/browse/JBLOGGING-107 and it was fixed at the same day. However I will use it as an example since I didn’t knew when this will be fixed.. and I didn’t want to wait till it is fixed. So I was thinking what I want.. to take the j

Use Multiple JVM versions on Mac OS and Linux

Linux Download multiple Java versions and put them into /opt/ If you already have some JDK from ubuntu repo or etc not a big deal, just fix the paths bellow Register them as alternatives sudo update-alternatives --install /usr/bin/java java /opt/java-8-oracle/bin/java 1081 sudo update-alternatives --install /usr/bin/java java /opt/sap-machine-jdk-11.0.3/bin/java 1080 Edit your ~/.bashrc file alias java11='sudo update-alternatives --set java /opt/sapmachine-jdk-11.0.3/bin/java;export JAVA_HOME=/opt/sapmachine-jdk-11.0.3/' alias java8='sudo update-alternatives --set java /opt/java-8-oracle/bin/java;export JAVA_HOME=/usr/lib/java-8-oracle/' SAVE and start a new bash terminal execute java8 to use java8 java11 to use java11 the latest version you have set stays as system wide, but the JAVA_HOME is not :( you can put java8 or java11 as a last line in the bashrc but since it is sudo it will always require password when start and is not gr