MG>David...all comments prefixed by MG> > Date: Sun, 9 Mar 2014 10:10:43 -0700 > Subject: Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is > invalid > From: davek1...@gmail.com > To: users@maven.apache.org > > Martin, > I'm not sure where you mean to check that ojdbc6 is listed as a dependency. > I am trying to convert the project from using MySql to Oracle, > so I might not have configured everything correctly. > > This is in the testingContext.xml file:
MG> <!-- assume p namespace resolves <?xml version="1.0" encoding="UTF-8"?> > <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance" > xmlns:p=http://www.springframework.org/schema/p --> MG> > <bean id="jpaVendorAdapter" > > class="org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter" > p:showSql="true" > > p:databasePlatform="org.eclipse.persistence.platform.database.OraclePlatform" > /> > > pom.xml: > <dependency> > <groupId>com.oracle</groupId> > <artifactId>ojdbc6</artifactId> > <version>11.2.0.1</version> > </dependency> > > testingContext.xml: > <?xml version="1.0" encoding="UTF-8"?> > <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance" > xmlns:p="http://www.springframework.org/schema/p" > xmlns:context="http://www.springframework.org/schema/context" > xmlns:tx="http://www.springframework.org/schema/tx" > xsi:schemaLocation=" > http://www.springframework.org/schema/beans > http://www.springframework.org/schema/beans/spring-beans-3.0.xsd > http://www.springframework.org/schema/context > http://www.springframework.org/schema/context/spring-context-3.0.xsd > http://www.springframework.org/schema/tx > http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"> MG>right now you list a bunch of xsds for every namespace except p MG>you *should* have a schemaLocation for xmlns:p > <bean id="propertyConfigurer" > > class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" > p:location="classpath:jdbc.properties" /> > > <bean id="ahmDataSource" > > class="org.springframework.jdbc.datasource.DriverManagerDataSource" > p:driverClassName="${jdbc.driverClassName}" MG>we would need to know what jdbc.driverClassName resolves to in jdbc.properties MG>BTW this is the class that needs to be packaged in your dependency listed above (ojdbc6-11.2.0.1.jar) > p:url="${jdbc.url}" MG>we would need to know what jdbc.url resolves to in jdbc.properties > p:username="${jdbc.username}" MG>we would need to know what jdbc.username resolves to in jdbc.properties "We do these things..not because they are easy..but because they are hard"...JFK