Connecting Java Web Application to Oracle Database

Question

<bean id="dataSource"
        class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName"
                  value="????????????????????" />        
     <property name="url"
                  value="???????????????????????"/>
        <property name="username" value="root" />
        <property name="password" value="" />
    </bean>

I am not able to figure out what should go in driver class name value and url vale. I have downloaded Oracle sql developer and oracle 11 g.But i am not sure how to configure it to my java application

driverClassName should be "oracle.jdbc.driver.OracleDriver" and the url should be "jdbc:oracle:thin:@<HOST>:1521:<SID>" — sasankad
– sasankad, Commented Jan 21, 2015 at 5:15

unknown · Accepted Answer · 2015-01-21 05:17:06Z

1

Driver class name:- oracle.jdbc.driver.OracleDriver
URL :- jdbc:oracle:thin:@(hostname):(port number):(database name)

<bean id="dataSource"
        class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName"
                  value="oracle.jdbc.driver.OracleDriver" />        
     <property name="url"
                  value="jdbc:oracle:thin:@(hostname):(port number):(database name)"/>
        <property name="username" value="root" />
        <property name="password" value="" />
</bean>

answered Jan 21, 2015 at 5:17

unknown

5,04510 gold badges49 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3678399 Over a year ago

As i am new to this,can u pls tel me which jars i need to install and if oracle sql developer is enough..and if we need oracle 11g

ERK · Accepted Answer · 2015-01-21 05:25:34Z

1

Your qustion is not clear if you are using Spring framework there are two type of Data source handling technique

Method 1 you need to configure data source in your application server

 <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="java:jboss/datasources/OracleDS" />
		<property name="cache" value="false"/>
    	<property name="lookupOnStartup" value="false"/>
        <property name="proxyInterface" value="javax.sql.DataSource"/>
	</bean>

Method 2

 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
		<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:OMQA" />
		<property name="username" value="root" />
		<property name="password" value="password" />
	</bean>

answered Jan 21, 2015 at 5:25

ERK

4067 silver badges27 bronze badges

3 Comments

user3678399 Over a year ago

Hi. I am using Spring framework, So i want to know how can i configure oracle database . what jars and database i shd use

ERK Over a year ago

go to this link and dowload realated jar link

ERK Over a year ago

this online tutorial might be help to you [link]mkyong.com/spring/maven-spring-jdbc-example

Collectives™ on Stack Overflow

Connecting Java Web Application to Oracle Database

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related