Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
I have tried to simplify the issue by Installing Oracle XE locally to
eliminate the remote db.
I am able to connect to the local db with the username and password below.
I assume the ojdbc driver is not on the test classpath.
I'm not sure where to add the driver to the classpath.
I am getting the error
Could not load JDBC driver class [oracle.jdbc.OracleDriver]
jdbc.properties
jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
jdbc.username=SYSTEM
jdbc.password=adminadmin
test-persistence.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;
bean id=propertyConfigurer
class=org.springframework.beans.factory.config.PropertyPlaceholderConfigurer
p:location=classpath:jdbc.properties /
bean id=tttDataSource
class=org.springframework.jdbc.datasource.DriverManagerDataSource
p:driverClassName=${jdbc.driverClassName}
p:url=${jdbc.url}
p:username=${jdbc.username}
p:password=${jdbc.password}
/
bean id=loadTimeWeaver
class=org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver
/
bean id=jpaVendorAdapter
class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter
p:showSql=true
p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform
/
bean id=entityManagerFactory
class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean
p:dataSource-ref=tttDataSource
p:jpaVendorAdapter-ref=jpaVendorAdapter
p:persistenceXmlLocation=test-persistence.xml
/
!-- Transaction manager for a single JPA EntityManagerFactory
(alternative to JTA) --
bean id=transactionManager
class=org.springframework.orm.jpa.JpaTransactionManager
p:dataSource-ref=tttDataSource
p:entityManagerFactory-ref=entityManagerFactory/
!-- checks for annotated configured beans --
context:annotation-config/
!-- Scan for Repository/Service annotations --
context:component-scan base-package=com.gieman.tttracker.dao /
context:component-scan base-package=com.gieman.tttracker.service /
context:component-scan base-package=com.gieman.tttracker.web /
!-- enable the configuration of transactional behavior based on
annotations --
tx:annotation-driven /
/beans
On Mon, Mar 10, 2014 at 7:46 PM, Martin Gainty mgai...@hotmail.com wrote:
MGDavid...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
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.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;
MGright now you list a bunch of xsds for every namespace except p
MGyou *should* have a schemaLocation for xmlns:p
bean id=propertyConfigurer
class
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
/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;
bean id=propertyConfigurer
class=org.springframework.beans.factory.config.PropertyPlaceholderConfigurer
p:location=classpath:jdbc.properties /
bean id=tttDataSource
class=org.springframework.jdbc.datasource.DriverManagerDataSource
p:driverClassName=${jdbc.driverClassName}
p:url=${jdbc.url}
p:username=${jdbc.username}
p:password=${jdbc.password}
/
bean id=loadTimeWeaver
class=org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver
/
bean id=jpaVendorAdapter
class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter
p:showSql=true
p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform
/
bean id=entityManagerFactory
class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean
p:dataSource-ref=tttDataSource
p:jpaVendorAdapter-ref=jpaVendorAdapter
p:persistenceXmlLocation=test-persistence.xml
/
!-- Transaction manager for a single JPA EntityManagerFactory
(alternative to JTA) --
bean id=transactionManager
class=org.springframework.orm.jpa.JpaTransactionManager
p:dataSource-ref=tttDataSource
p:entityManagerFactory-ref=entityManagerFactory/
!-- checks for annotated configured beans --
context:annotation-config/
!-- Scan for Repository/Service annotations --
context:component-scan base-package=com.gieman.tttracker.dao /
context:component-scan base-package=com.gieman.tttracker.service /
context:component-scan base-package=com.gieman.tttracker.web /
!-- enable the configuration of transactional behavior based on
annotations --
tx:annotation-driven /
/beans
On Mon, Mar 10, 2014 at 7:46 PM, Martin Gainty mgai...@hotmail.comwrote:
MGDavid...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
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.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;
MGright now you list a bunch of xsds for every namespace except p
MGyou *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}
MGwe would need to know what jdbc.driverClassName resolves to in
jdbc.properties
MGBTW this is the class that needs to be packaged in your dependency
listed above (ojdbc6-11.2.0.1.jar)
p:url=${jdbc.url}
MGwe would need to know what jdbc.url resolves to in jdbc.properties
p:username=${jdbc.username}
MGwe 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
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
I updated the pom.xml and settings.xml files
dependency
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.2.0.1/version
/dependency
settings xmlns=http://maven.apache.org/SETTINGS/1.0.0;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://maven.apache.org/SETTINGS/1.0.0
http://maven.apache.org/xsd/settings-1.0.0.xsd;
localRepositoryC:/Users/dave/.m2/repository/localRepository
/settings
now the output is
Downloaded:
http://download.eclipse.org/rt/eclipselink/maven.repo/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.pom(0
B at 0.0 KB/sec)
Downloading:
http://download.eclipse.org/rt/eclipselink/maven.repo/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.jar
Downloading:
http://repo.maven.apache.org/maven2/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.jar
BUILD FAILURE
On Tue, Mar 11, 2014 at 3:55 PM, Dave Kennedy davek1...@gmail.com wrote:
I have tried to simplify the issue by Installing Oracle XE locally to
eliminate the remote db.
I am able to connect to the local db with the username and password below.
I assume the ojdbc driver is not on the test classpath.
I'm not sure where to add the driver to the classpath.
I am getting the error
Could not load JDBC driver class [oracle.jdbc.OracleDriver]
jdbc.properties
jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
jdbc.username=SYSTEM
jdbc.password=adminadmin
test-persistence.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;
bean id=propertyConfigurer
class=org.springframework.beans.factory.config.PropertyPlaceholderConfigurer
p:location=classpath:jdbc.properties /
bean id=tttDataSource
class=org.springframework.jdbc.datasource.DriverManagerDataSource
p:driverClassName=${jdbc.driverClassName}
p:url=${jdbc.url}
p:username=${jdbc.username}
p:password=${jdbc.password}
/
bean id=loadTimeWeaver
class=org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver
/
bean id=jpaVendorAdapter
class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter
p:showSql=true
p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform
/
bean id=entityManagerFactory
class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean
p:dataSource-ref=tttDataSource
p:jpaVendorAdapter-ref=jpaVendorAdapter
p:persistenceXmlLocation=test-persistence.xml
/
!-- Transaction manager for a single JPA EntityManagerFactory
(alternative to JTA) --
bean id=transactionManager
class=org.springframework.orm.jpa.JpaTransactionManager
p:dataSource-ref=tttDataSource
p:entityManagerFactory-ref=entityManagerFactory/
!-- checks for annotated configured beans --
context:annotation-config/
!-- Scan for Repository/Service annotations --
context:component-scan base-package=com.gieman.tttracker.dao /
context:component-scan base-package=com.gieman.tttracker.service /
context:component-scan base-package=com.gieman.tttracker.web /
!-- enable the configuration of transactional behavior based on
annotations --
tx:annotation-driven /
/beans
On Mon, Mar 10, 2014 at 7:46 PM, Martin Gainty mgai...@hotmail.comwrote:
MGDavid...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
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
Hallo Dave,
I am not really understand your problem as your report touch multiple
points, so let me do this systematically. Appologies if I state
something obvious:
a) there is no ojdbc driver in the public maven repositories. The JDBC
driver from oracle is propeitary. So I am not sure where you get that
POM from.
b) I am not sure how this is related to netbeans, could you make try to
reproduce this with a minimum sample only using maven on the command
line?
c) if you get class not found errors after the download/search in
repository failed that means the pom is missing, if you get the error
after the pom was found it is most likely a configuration issue.
d) the location where and how you define your dependency in the pom is
responsible where the artifact (if found) is added to the classpath.
There is especially a difference for scope=provided and scope=test
artifaces, but it could also be that the dependency is only defined
local to a specific plugin, and missing to another.
e) the location of your database is not an issue for the dependency
resolving. You might however (what is typical for ojdbc.jar) define a
dependency with a system path to a locally installed (or copied) oracle
artifact (which could be the XE installation dir).
f) I am not sore about your sping/jpa test infrastructure, but you
typically dont have to look at the setup there as long as your Pom
fails to get your dependencies.
Greetings
Bernd
Am Tue, 11 Mar 2014 15:55:59 -0700 schrieb Dave
Kennedy davek1...@gmail.com:
I have tried to simplify the issue by Installing Oracle XE locally to
eliminate the remote db.
I am able to connect to the local db with the username and password
below. I assume the ojdbc driver is not on the test classpath.
I'm not sure where to add the driver to the classpath.
I am getting the error
Could not load JDBC driver class [oracle.jdbc.OracleDriver]
jdbc.properties
jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
jdbc.username=SYSTEM
jdbc.password=adminadmin
test-persistence.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;
bean id=propertyConfigurer
class=org.springframework.beans.factory.config.PropertyPlaceholderConfigurer
p:location=classpath:jdbc.properties /
bean id=tttDataSource
class=org.springframework.jdbc.datasource.DriverManagerDataSource
p:driverClassName=${jdbc.driverClassName}
p:url=${jdbc.url}
p:username=${jdbc.username}
p:password=${jdbc.password}
/
bean id=loadTimeWeaver
class=org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver
/
bean id=jpaVendorAdapter
class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter
p:showSql=true
p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform
/
bean id=entityManagerFactory
class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean
p:dataSource-ref=tttDataSource
p:jpaVendorAdapter-ref=jpaVendorAdapter
p:persistenceXmlLocation=test-persistence.xml
/
!-- Transaction manager for a single JPA EntityManagerFactory
(alternative to JTA) --
bean id=transactionManager
class=org.springframework.orm.jpa.JpaTransactionManager
p:dataSource-ref=tttDataSource
p:entityManagerFactory-ref=entityManagerFactory/
!-- checks for annotated configured beans --
context:annotation-config/
!-- Scan for Repository/Service annotations --
context:component-scan base-package=com.gieman.tttracker.dao /
context:component-scan
base-package=com.gieman.tttracker.service /
context:component-scan base-package=com.gieman.tttracker.web /
!-- enable the configuration of transactional behavior based on
annotations -- tx:annotation-driven /
/beans
On Mon, Mar 10, 2014 at 7:46 PM, Martin Gainty mgai...@hotmail.com
wrote:
MGDavid...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
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
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. Add -X to the call to Maven (mvn -X ...) and pipe the output to a file (mvn -X ... out.txt). Then search the file for ojdbc6 to see where and how the dependency is being brought into your project during the compile and test steps. I'd assume it is not part of your test classpath as you expect it to be. Once you confirm this, you can work on sorting out why. What is the XPath to the dependency node in your pom? Or paste the pom and that -X output at gist, pastebin etc so we can take a look help (please don't email them here). Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
RE: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
MGDavid...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
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.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;
MGright now you list a bunch of xsds for every namespace except p
MGyou *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}
MGwe would need to know what jdbc.driverClassName resolves to in
jdbc.properties
MGBTW this is the class that needs to be packaged in your dependency listed
above (ojdbc6-11.2.0.1.jar)
p:url=${jdbc.url}
MGwe would need to know what jdbc.url resolves to in jdbc.properties
p:username=${jdbc.username}
MGwe 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
RE: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
David did you check the Junit test that ojdbc6 is listed as a dependency? dependencies dependency groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version /dependency /dependencies Martin- Date: Sat, 8 Mar 2014 13:30:59 -0800 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 In the log, there is a reference to 'no dependency information available', but the POM for com.oracle:ojdbc6:jar:11.2.0.1 exists. Any help/suggestions on how to resolve this issue would be appreciated. Verifying availability of C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom from [eclipselink (http://download.eclipse.org/rt/eclipselink/maven.repo/, releases+snapshots), central (http://repo.maven.apache.org/maven2, releases)] The POM for com.oracle:ojdbc6:jar:11.2.0.1 is missing, no dependency information available C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom ?xml version=1.0 encoding=UTF-8? project xmlns=http://maven.apache.org/POM/4.0.0; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation=http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd; modelVersion4.0.0/modelVersion groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version nameOracle JDBC Driver/name descriptionOracle JDBC driver classes for use with JDK1.7/description url http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html /url licenses license nameOracle Technology Network Development and Distribution License Terms/name url http://www.oracle.com/technology/software/htdocs/distlic.html/url /license /licenses organization nameOracle Corporation/name urlhttp://www.oracle.com/url /organization /project On Sat, Mar 8, 2014 at 12:13 PM, Dave Kennedy davek1...@gmail.com wrote: I'm not sure where I need to add a dependency declaration for the ojdbc driver These are the references to oracle pom.xml dependency groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version scopeprovided/scope /dependency src/test/resources/jdbcproperties jdbc.driverClassName=oracle.jdbc.OracleDriver jdbc.url=oracle:thin:@database.com:1521:dbname jdbc.username=name jdbc.password=pass src/test/resources/testingContext.xml bean id=jpaVendorAdapter class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter p:showSql=true p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform / On Sat, Mar 8, 2014 at 11:55 AM, Wayne Fay wayne...@gmail.com wrote: I updated the ojdbc6-11.2.0.1.pom file (see below) and the 'invalid' message did not appear. Good. Now there is an error running JUnit tests: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Most likely you are missing a dependency declaration for the ojdbc driver in the module that threw this error during the JUnit execution. I can PING the database in GlassFish Domain Admin Console and view the Tables and data in Netbeans | Services | Databases What makes you think this has ANYTHING to do Netbeans or Glassfish...? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
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:
bean id=jpaVendorAdapter
class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter
p:showSql=true
p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform
/
pom.xml:
dependency
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.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;
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}
p:url=${jdbc.url}
p:username=${jdbc.username}
p:password=${jdbc.password}
/
bean id=loadTimeWeaver
class=org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver
/
bean id=jpaVendorAdapter
class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter
p:showSql=true
p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform
/
bean id=entityManagerFactory
class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean
p:dataSource-ref=ahmDataSource
p:jpaVendorAdapter-ref=jpaVendorAdapter
p:persistenceXmlLocation=test-persistence.xml
/
!-- Transaction manager for a single JPA EntityManagerFactory
(alternative to JTA) --
bean id=transactionManager
class=org.springframework.orm.jpa.JpaTransactionManager
p:dataSource-ref=ahmDataSource
p:entityManagerFactory-ref=entityManagerFactory/
!-- checks for annotated configured beans --
context:annotation-config/
!-- Scan for Repository/Service annotations --
context:component-scan base-package=dao /
!-- enable the configuration of transactional behavior based on
annotations --
tx:annotation-driven /
/beans
On Sun, Mar 9, 2014 at 5:14 AM, Martin Gainty mgai...@hotmail.com wrote:
David
did you check the Junit test that ojdbc6 is listed as a dependency?
dependencies
dependency
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.2.0.1/version
/dependency
/dependencies
Martin-
Date: Sat, 8 Mar 2014 13:30:59 -0800
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
In the log, there is a reference to 'no dependency information
available',
but the POM for com.oracle:ojdbc6:jar:11.2.0.1 exists.
Any help/suggestions on how to resolve this issue would be appreciated.
Verifying availability of
C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom
from [eclipselink (
http://download.eclipse.org/rt/eclipselink/maven.repo/,
releases+snapshots), central (http://repo.maven.apache.org/maven2,
releases)]
The POM for com.oracle:ojdbc6:jar:11.2.0.1 is missing, no dependency
information available
C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom
?xml version=1.0 encoding=UTF-8?
project
xmlns=http://maven.apache.org/POM/4.0.0;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://maven.apache.org/POM/4.0.0
http://maven.apache.org/maven-v4_0_0.xsd;
modelVersion4.0.0/modelVersion
groupIdcom.oracle/groupId
artifactIdojdbc6/artifactId
version11.2.0.1/version
nameOracle JDBC Driver/name
descriptionOracle JDBC driver classes for use with
JDK1.7/description
url
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
/url
licenses
license
nameOracle Technology Network Development and Distribution
License Terms/name
url
http://www.oracle.com/technology/software/htdocs/distlic.html/url
/license
/licenses
organization
nameOracle Corporation/name
urlhttp://www.oracle.com/url
/organization
/project
On Sat, Mar 8, 2014 at 12:13 PM, Dave
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
debug logging enabled I updated the ojdbc6-11.2.0.1.pom file (see below) and the 'invalid' message did not appear. Now there is an error running JUnit tests: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname I can PING the database in GlassFish Domain Admin Console and view the Tables and data in Netbeans | Services | Databases Error Log . . . [EL Info]: 2014-03-08 11:07:43.435--ServerSession(18008857)--Thread(Thread[main,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5 [EL Config]: connection: 2014-03-08 11:07:43.441--ServerSession(18008857)--Connection(32106576)--Thread(Thread[main,5,main])--connecting(DatabaseLogin( platform=OraclePlatform user name= connector=JNDIConnector datasource name=null )) [EL Severe]: 2014-03-08 11:07:43.446--ServerSession(18008857)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Error Code: 0 [EL Severe]: ejb: 2014-03-08 11:07:43.448--ServerSession(18008857)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Error Code: 0 Mar 08, 2014 11:07:43 AM org.springframework.test.context.TestContextManager beforeTestMethod WARNING: Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@1f86671] to process 'before' execution of test method [public void dao.CustomerDaoTest.testFindAll() throws java.lang.Exception] for test instance [dao.CustomerDaoTest@10dbe25] org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Error Code: 0 at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:428) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:372) at org.springframework.test.context.transaction.TransactionalTestExecutionListener$TransactionContext.startTransaction(TransactionalTestExecutionListener.java:583) at org.springframework.test.context.transaction.TransactionalTestExecutionListener.startNewTransaction(TransactionalTestExecutionListener.java:276) at org.springframework.test.context.transaction.TransactionalTestExecutionListener.beforeTestMethod(TransactionalTestExecutionListener.java:171) at org.springframework.test.context.TestContextManager.beforeTestMethod(TestContextManager.java:348) at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:73) at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83) at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:88) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
I updated the ojdbc6-11.2.0.1.pom file (see below) and the 'invalid' message did not appear. Good. Now there is an error running JUnit tests: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Most likely you are missing a dependency declaration for the ojdbc driver in the module that threw this error during the JUnit execution. I can PING the database in GlassFish Domain Admin Console and view the Tables and data in Netbeans | Services | Databases What makes you think this has ANYTHING to do Netbeans or Glassfish...? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
I'm not sure where I need to add a dependency declaration for the ojdbc driver These are the references to oracle pom.xml dependency groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version scopeprovided/scope /dependency src/test/resources/jdbcproperties jdbc.driverClassName=oracle.jdbc.OracleDriver jdbc.url=oracle:thin:@database.com:1521:dbname jdbc.username=name jdbc.password=pass src/test/resources/testingContext.xml bean id=jpaVendorAdapter class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter p:showSql=true p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform / On Sat, Mar 8, 2014 at 11:55 AM, Wayne Fay wayne...@gmail.com wrote: I updated the ojdbc6-11.2.0.1.pom file (see below) and the 'invalid' message did not appear. Good. Now there is an error running JUnit tests: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Most likely you are missing a dependency declaration for the ojdbc driver in the module that threw this error during the JUnit execution. I can PING the database in GlassFish Domain Admin Console and view the Tables and data in Netbeans | Services | Databases What makes you think this has ANYTHING to do Netbeans or Glassfish...? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
In the log, there is a reference to 'no dependency information available', but the POM for com.oracle:ojdbc6:jar:11.2.0.1 exists. Any help/suggestions on how to resolve this issue would be appreciated. Verifying availability of C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom from [eclipselink (http://download.eclipse.org/rt/eclipselink/maven.repo/, releases+snapshots), central (http://repo.maven.apache.org/maven2, releases)] The POM for com.oracle:ojdbc6:jar:11.2.0.1 is missing, no dependency information available C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom ?xml version=1.0 encoding=UTF-8? project xmlns=http://maven.apache.org/POM/4.0.0; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation=http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd; modelVersion4.0.0/modelVersion groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version nameOracle JDBC Driver/name descriptionOracle JDBC driver classes for use with JDK1.7/description url http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html /url licenses license nameOracle Technology Network Development and Distribution License Terms/name url http://www.oracle.com/technology/software/htdocs/distlic.html/url /license /licenses organization nameOracle Corporation/name urlhttp://www.oracle.com/url /organization /project On Sat, Mar 8, 2014 at 12:13 PM, Dave Kennedy davek1...@gmail.com wrote: I'm not sure where I need to add a dependency declaration for the ojdbc driver These are the references to oracle pom.xml dependency groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version scopeprovided/scope /dependency src/test/resources/jdbcproperties jdbc.driverClassName=oracle.jdbc.OracleDriver jdbc.url=oracle:thin:@database.com:1521:dbname jdbc.username=name jdbc.password=pass src/test/resources/testingContext.xml bean id=jpaVendorAdapter class=org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter p:showSql=true p:databasePlatform=org.eclipse.persistence.platform.database.OraclePlatform / On Sat, Mar 8, 2014 at 11:55 AM, Wayne Fay wayne...@gmail.com wrote: I updated the ojdbc6-11.2.0.1.pom file (see below) and the 'invalid' message did not appear. Good. Now there is an error running JUnit tests: No suitable driver found for oracle:thin:@dataserver.com:1521:dbname Most likely you are missing a dependency declaration for the ojdbc driver in the module that threw this error during the JUnit execution. I can PING the database in GlassFish Domain Admin Console and view the Tables and data in Netbeans | Services | Databases What makes you think this has ANYTHING to do Netbeans or Glassfish...? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
In the log, there is a reference to 'no dependency information available', ... Verifying availability of C:\Users\david.kennedy\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom from [eclipselink (http://download.eclipse.org/rt/eclipselink/maven.repo/, releases+snapshots), central (http://repo.maven.apache.org/maven2, releases)] ... The POM for com.oracle:ojdbc6:jar:11.2.0.1 is missing, no dependency Actually, read the message again: Verifying availability of ...pom file from [repository1, repository2]... The pom is missing Where did this pom file come from? Did you acquire it from the eclipselink repo, or central? Or did you use mvn install:install-file? Or did you put it in that directory manually? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
pom.xml dependency groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version scopeprovided/scope /dependency What is the complete path in the pom.xml file to this dependency node? Use XSLT or post the pom file at pastebin, gist, etc. Also consider changing the scope just for testing purposes. Try compile and/or test instead of provided. Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
What is the complete path in the pom.xml file to this dependency node? Use XSLT or post the pom file at pastebin, gist, etc. Of course I meant, use XPath (syntax) Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
The database and pom are on a remote server, and the downloaded POM is not valid: 'modelVersion' is missing. I don't have control over the server so I cannot change the POM. Is there a way to have maven ignore the modelVersion is missing error? project groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version /project Downloading: http://newco.com/mvn_repository/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.pom Checksum validation failed, no checksums available from the repository for http://newco.com/mvn_repository/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.pom Downloaded: http://newco.com/mvn_repository/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.pom(114 B at 0.2 KB/sec) Writing resolution tracking file .m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom.lastUpdated Writing resolution tracking file .m2\repository\com\oracle\ojdbc6\11.2.0.1\_maven.repositories The POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid, transitive dependencies (if any) will not be available: 1 problem was encountered while building the effective model for com.oracle:ojdbc6:11.2.0.1 'modelVersion' is missing. . . . Internal Exception: java.sql.SQLException: No suitable driver found for oracle:thin:@newco.com:1521:dbname
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
I don't have control over the server so I cannot change the POM. Is there a way to have maven ignore the modelVersion is missing error? Can you not open a ticket/bug somehow to request they fix this file? Or perhaps find a different repository that hosts the (corrected) file? Or worst case, set up your own Nexus server @ work on a box and run your own repo (which is common for users on this list)? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
When the project is built the following message is generated. The POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid, transitive dependencies (if any) will not be available, enable debug logging for more details The POM and repository look to be correct. Any suggestions on how to resolve this issue would be appreciated. pom.xml dependency groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version scopeprovided/scope /dependency maven command mvn install:install-file -Dfile=ojdbc6-11.2.0.1.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.1 -Dpackaging=jar creates the .jar and .pom files C:\Users\me\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.jar C: \Users\me\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.pom project groupIdcom.oracle/groupId artifactIdojdbc6/artifactId version11.2.0.1/version /project
Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid
The POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid, transitive dependencies (if any) will not be available, enable debug logging for more details Did you enable debug logging with -X to see more details? What does it say? Wayne - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
