Skip to main content

Connection Pool for Oracle DB in Glassfish v3?

12 replies [Last post]
dxxvi
Offline
Joined: 2006-07-24
Points: 0

I tried to create a connection pool for an Oracle database (Oracle 10g XE and Oracle 11g R2). For the Oracle 10g XE, I put the ojdbc14.jar in the $GLASSFISH_HOME/glassfish/domains/domain1/lib. Then I created a connection pool with all the information that you can see in the attached image. An error occurred when i tried to ping the database.

Does anybody know how to fix that?

Thank you.

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
sm157516
Offline
Joined: 2005-03-28
Points: 0

Which version of GlassFish are you using? Also, do you see any messages in the server.log.

dxxvi
Offline
Joined: 2006-07-24
Points: 0

I'm using v3 (stated in the topic subject) which was downloaded on Oct 8. I don't see any error message in the log file. All of them are info messages about the fact that I created a new connection pool.

sm157516
Offline
Joined: 2005-03-28
Points: 0

There were some issues fixed in V3 on oct 5th, related to the parsing of additional properties. They are

https://glassfish.dev.java.net/issues/show_bug.cgi?id=9786
https://glassfish.dev.java.net/issues/show_bug.cgi?id=8400

If you turn on the FINEST logging, you would see some error messages in the server.log. If you so find any issue, you could file a bug in the issue tracker.

sm157516
Offline
Joined: 2005-03-28
Points: 0

Please set the resource-adapter log level in the domain_dir/config/logging.properties to FINEST.

Arun Gupta

FWIW, here is a blog entry that explains to create JDBC Resource for the
sample HR database in Oracle using GlassFish v3:

http://blog.arungupta.me/2009/10/totd-108-java-ee-6-web-application-jsf-...

This is using build 63.

-Arun

glassfish@javadesktop.org wrote:
> Please set the resource-adapter log level in the domain_dir/config/logging.properties to FINEST.
> [Message sent by forum member 'sm157516' (shalini.muthukrishnan@sun.com)]
>
> http://forums.java.net/jive/thread.jspa?messageID=367438
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

--
Need Application Server ? Download from http://glassfish.org
Blog: http://blog.arungupta.me

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

dxxvi
Offline
Joined: 2006-07-24
Points: 0

Thanks, Arun.

Summary: if you want to use the GUI to create a connection pool for an Oracle DB, remember to delete all properties except Url, User and Password.

sm157516
Offline
Joined: 2005-03-28
Points: 0

Hi Dxxvi,

Thats an incorrect conclusion. There is no need to delete all other properties while trying to create a jdbc connection pool. I tried the same configuration with b67 of V3 and was able to ping successfully. Please try this build and report if you do have any issues. There were a few issues with parsing of the datasource properties that were fixed in this build.

jcllings
Offline
Joined: 2009-07-20
Points: 0

Agreed. I seem to be having similar problems and removing the extra properties did not change anything.

nasradu8
Offline
Joined: 2009-09-03
Points: 0
nasradu8
Offline
Joined: 2009-09-03
Points: 0

Sorry.. reply on the wrong thread.

matthiasfraass
Offline
Joined: 2004-07-14
Points: 0

Maybe the "ONSConfiguration" property mustn't be NULL.
Try to remove that one (and all subsequent properties with Exceptions).

I think you only need username, password, URL and maybe DataSourceName.

dxxvi
Offline
Joined: 2006-07-24
Points: 0

I removed the ONSConfiguration property and there was new error message (can be seen in the attached image). What is the DataSourceName you mentioned?
In Glassfish v2, I need only username, password and url.