Comments on Hildeberto's Blog: Creating a Connection Pool to PostgreSQL on Glassf...

This is not actually necessary to make the connect...

2011-10-22T10:52:10.775+02:00

This is not actually necessary to make the connection pool work :) Indeed, the URL is useful to create connections from the IDE. Thanks for adding this tip.

Do not forget adding an additional property named ...

2011-10-20T21:55:23.613+02:00

Do not forget adding an additional property named "URL" to the pool.
IDE's address mapping may crash.

jdbc:postgresql://localhost:5432/[database-name]

Very interesting thanks. Just on remark : no JEE -...

2011-09-19T02:07:57.737+02:00

Very interesting thanks. Just on remark : no JEE --> Java EE, best regards

Saved me a lot of time. Especially point 3, I thou...

2011-09-19T02:02:55.055+02:00

Saved me a lot of time.
Especially point 3, I thought too that I got rid of restarting , I lost a time in it. Thanks for the post

Wow! I'm sorry for that. Fixed! Thank you for ...

2011-09-02T09:29:41.251+02:00

Wow! I'm sorry for that. Fixed! Thank you for the feedback.

Hi, great post, thank you. But there's a spell...

2011-09-02T08:55:18.482+02:00

Hi,
great post, thank you.
But there's a spelling mistake in the package name which nearly drove me nuts.
It's of course "postgresql" not "portgresql".

Awesome post dude!!! Saved my work day!!!

2011-08-15T16:33:45.419+02:00

Awesome post dude!!!
Saved my work day!!!

Using Glassfish V3 with Eclipse Helios if you have...

2011-04-21T11:59:26.267+02:00

Using Glassfish V3 with Eclipse Helios if you have problems (ClassNotFoundException) while adding the JDBC Driver use [glassfish_home]/glassfish/lib/ as directory to copy your .jar file.

By the way: Thanks for sharing! :)

I succeeded to get my datasource deployed and read...

2011-01-18T16:50:47.775+01:00

I succeeded to get my datasource deployed and ready in no time. Thanks for sharing your findings.

Hi, well, I'm using Netbeans because of its u...

2010-11-12T14:25:33.269+01:00

Hi,

well, I'm using Netbeans because of its usability and integration with Glassfish, but the connection pooling configuration is independent of the IDE. I'm explaining how I did it in Glassfish. So, it will work for Eclipse or any other IDE as well.

Hey Hildeberto, What IDE are you using for connect...

2010-11-12T14:21:37.406+01:00

Hey Hildeberto, What IDE are you using for connection pooling?

Hey Hildeberto, What IDE are you using for connect...

2010-11-12T14:20:31.976+01:00

Hey Hildeberto, What IDE are you using for connection pooling?

Nice tutorial, thanks a lot. Worked flawlessly! I&...

2010-10-17T21:45:30.184+02:00

Nice tutorial, thanks a lot. Worked flawlessly! I've worked with Glassfish a long time ago in school and your steps were exactly what I needed. Keep up the good work =)

Thank you very much for you help, it's was eas...

2010-10-07T18:47:04.688+02:00

Thank you very much for you help, it's was easy

Hi, thanks for this manual! I just tried it on Gla...

2010-08-25T10:57:10.234+02:00

Hi, thanks for this manual!
I just tried it on Glassfish V2 and
it just worked.

Hi, thank you for nice manual. :)

2010-06-01T10:47:34.343+02:00

Hi, thank you for nice manual. :)

Thanks Hildeberto, that makes the picture much cle...

2010-03-26T02:57:20.603+01:00

Thanks Hildeberto, that makes the picture much clearer,
Best Regards

Hello Andrew, it seems that you developed a standa...

2010-03-25T08:54:19.114+01:00

Hello Andrew, it seems that you developed a standalone application (it runs using the java command: java DBConnection). Is it right? Well, in this case you cannot access this kind of server resource through a standalone application. The application server only provides resources for those applications that are deployed on it. In fact, the application server should execute the application.

It is possible to deploy your code on Glassfish, but you have to do a lot of additional things to be able to see the output of your code, like develop a simple web application.

Therefore, in your specific case, you can access the PostgreSQL server through a conventional database connection only, using the DriveManager. The same way you did in your last example (first comment).

Hi Hildeberto, thank again for the quick response....

2010-03-24T16:10:43.701+01:00

Hi Hildeberto, thank again for the quick response.
As to the JNDI name, yes, it is prefixed with jdbc/: “jdbc/MyTestDB”.
As regards the locations of the server and the client code:
The client resides on my D drive D:\Java\workspace\jdbc\bin\DBConnection.class.
(it originally had nothing to do with application server as it connected to PG/SQL directly through DriverManager, only after I found out that using DataSource is the preferred style did I installed glassfish and rewrote the code to connect do the postgres db through the application server's datasource).
The server is installed on my C drive in the default install dir: C:\glassfishv3
Both the program and the application server are running on the same system (Windows Vista). I am not sure whether that means that the program IS running on the SAME APPLICATION SERVER.
I must admit that I did not make any special connections between the program that I wrote and the glassfish server so I’m not sure whether the program is able to find the JNDI resource that I created in the glassfish.
Please, do say whether my understanding of the above is correct or not.

Is the code running in the same application server...

2010-03-24T10:48:33.531+01:00

Is the code running in the same application server where the JNDI was configured or is it deployed in another server? If not, you will need additional configurations that you can find here: http://www.developer.com/java/ejb/article.php/10931_2215571_4/Locating-Resources-Using-JNDI-Java-Naming-and-Directory-Interface.htm.

When you performed the task 11 of the post, have you defined the JNDI name with the prefix "jdbc/"? If not, do it.

Hildeberto, many thanks for your quick response. U...

2010-03-24T01:09:49.958+01:00

Hildeberto, many thanks for your quick response. Unfortunately changing the initialContext lookup value did not do. Any other ideas what can be wrong? … :|

Hello Andrew, If the connection is working in oth...

2010-03-23T17:58:42.919+01:00

Hello Andrew,

If the connection is working in other ways we have good news. It means that there is minor issues to solve. One of these minor issues might be solved with the code below:

Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("jdbc/MyTestDB");
Connection conn = ds.getConnection();

Basically, instead of using "java:comp/env/jdbc/MyTestDB", use just "jdbc/MyTestDB". Let me know if it is enough to solve the problem.

Hi, I have installed GlassFish v3 on Vista and cre...

2010-03-23T15:57:20.885+01:00

Hi, I have installed GlassFish v3 on Vista and created Pooling DataSource to my PG/SQL database which is located on Unix Ubuntu in Virtual Machine. It does ping OK. I also created JNDI under Resources/JDBC/JDBC Resources named “jdbc/MyTestDB” mapping it with the Pooling DataSource I have previously created.
Now, I have found and adopted in Eclipse (on Vista) a java application code to access that postgres database with the DataSource connection made available through the glassfish server but unfortunately I cannot and get the following error:

javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial

the code that attempts to connect through the DataSource is as follows:

/** Uses JNDI and Datasource (preferred style). */
static Connection getJNDIConnection(){

String DATASOURCE_CONTEXT = "java:comp/env/jdbc/MyTestDB";
Connection conn = null;
try {
Context initialContext = new InitialContext();
//initialContext.
if ( initialContext == null){
log("JNDI problem. Cannot get InitialContext.");
}
DataSource ds = (DataSource)initialContext.lookup(DATASOURCE_CONTEXT);

if (ds != null) {
conn = ds.getConnection();
System.out.println("Connected to db using DataSource");
}
else {
log("Failed to lookup datasource.");
}
}
catch ( NamingException ex ) {
log("Cannot get connection: " + ex);
}
catch(SQLException ex){
log("Cannot get connection: " + ex);
}
return conn;
}

As an aside note I can say that I am able to connect to my postgres db using DriverManager:
private Connection dbConnection;
try {
Class.forName("org.postgresql.Driver").newInstance();
dbConnection = DriverManager.getConnection("jdbc:postgresql://192.168.56.101:5432/testDB", "user","password");
}
catch(Exception x){
System.out.println( "Unable to load the driver class!" + x);
}

I am absolutely new to JEE and Glassfish. Maybe I should configure Glassfish server somehow further and do something extra to make that JNDI name datasource accessible to applications that I run on Vista in Eclipse.
Please, help.