Welcome to the Java Programming Forums
The professional, friendly Java community. 21,500 members and growing!
The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.
>> REGISTER NOW TO START POSTING
Members have full access to the forums. Advertisements are removed for registered users.
LinkBack URL
About LinkBacks
oracle conection pool
I'm creating a WebApp which need a active connection to Database and i have Oracle 11G for that.
My problem is that i want to access database created in Oracle using application server(Tomcat7)??
I'm using Netbeans. Can we integrate Oracle in NetBeans??
Regards
Last edited by arvindbis; October 26th, 2011 at 09:43 AM. Reason: Providing complete Information
Related threads:
Re: oracle conection pool
Believe me, atleast i couldn't understand what is the problem you are asking for? Be more precise please.
Re: oracle conection pool
i'm creating webapp and it need to access database, for that i just want to create a database connection pool. database is created in oracle 11g. i just don't know how to create that??
regards
Re: oracle conection pool
Hope this will help.Connection connection = null; try { // Load the JDBC driver String driverName = "oracle.jdbc.driver.OracleDriver"; Class.forName(driverName); // Create a connection to the database String serverName = "127.0.0.1"; // Your database host name String portNumber = "1521"; // Communication Port String sid = "mydatabase"; // Database sid String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username = "username"; String password = "password"; connection = DriverManager.getConnection(url, username, password); } catch (ClassNotFoundException e) { // Could not find the database driver } catch (SQLException e) { // Could not connect to the database }
Regards...
Re: oracle conection pool
this method of connection is for the desktop application(i guess). well will try! my problem is that how can i configure the server to create a pool and use!
regards
Re: oracle conection pool
A pool is just that - a pool. Mr.777 code only creates a connection, not a pool. If you wish to create a pool, then just create a List of connections for clients to grab a Connection from. You have provided little information or context to the problem, so it is guessing to provide context beyond this. If this is a webapp, many application containers already provide libraries to create connection pools - do the research on your particular container if this is the case.
Re: oracle conection pool
Also, your problem lies in the wrong code section, most of the poblems here are desktop oriented. So i was unable to guess.
Also, you didn't provide enough information.
Anyways, follow the copeg suggestions.
Good Luck. And better read this...
Re: oracle conection pool
thank you guys.
well i updated my question just have a look!
do i need to create DSN for using it with the Application server??
@copeg --> indeed even i said that in my reply.
Does this isapplication containers already provide libraries to create connection poolswhat you are pointing to??ojdbc14.jar
@mr. 777 -->
well i can't undo that, i created thread here because i thought my problem is something related to JDBC/Databases!!Also, your problem lies in the wrong code section, most of the problems here are desktop oriented. So i was unable to guess.
Also, you didn't provide enough information.
I think there is enough information provided now, well if you feel there is something missing then do a fav. by asking for it?
Regards
Last edited by arvindbis; October 26th, 2011 at 10:04 AM.
Re: oracle conection pool
Actually, I moved your post to this forumwell i can't undo that, i created thread here because i thought my problem is something related to JDBC/Databases!!
Like I said, you can create a pool manually by creating some type of class that manages a list of created connections. See the following link: Chapter 8 Continued: Connection Pooling
What application container are you using?
arvindbis (October 29th, 2011)
Re: oracle conection pool
i think it is Web container, as i'm new in this field therefore not so sure about these. anyway i'm using tomcat 7, do tell me how to know which container is used??
Re: oracle conection pool
There is no problem with any container you use.
You can use any one of your choice or your application requirements.
Reply With Quote