Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid

2014-03-11 Thread Dave Kennedy
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
 
 
 

Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid

2014-03-11 Thread Dave Kennedy
With  mvn -X

Could not find metadata
org.eclipse.persistence:javax.persistence:2.1.0-SNAPSHOT/maven-metadata.xml
in local (C:\Users\dave\.m2\repository)
Skipped remote update check for
org.eclipse.persistence:javax.persistence:2.1.0-SNAPSHOT/maven-metadata.xml,
locally cached metadata up-to-date.
com.gieman:task-time-tracker:war:1.0
   org.eclipse.persistence:javax.persistence:jar:2.1.0-SNAPSHOT:provided
   org.eclipse.persistence:eclipselink:jar:2.5.1:provided
  org.eclipse.persistence:commonj.sdo:jar:2.1.1:provided

org.eclipse.persistence:org.eclipse.persistence.jpa.modelgen.processor:jar:2.5.1:provided

org.eclipse.persistence:org.eclipse.persistence.core:jar:2.5.1:provided

org.eclipse.persistence:org.eclipse.persistence.asm:jar:2.5.1:provided
  org.eclipse.persistence:org.eclipse.persistence.jpa:jar:2.5.1:provided

org.eclipse.persistence:org.eclipse.persistence.antlr:jar:2.5.1:provided

org.eclipse.persistence:org.eclipse.persistence.jpa.jpql:jar:2.5.1:provided
   javax:javaee-web-api:jar:7.0:provided
   ch.qos.logback:logback-classic:jar:1.0.13:compile
  ch.qos.logback:logback-core:jar:1.0.13:compile
  org.slf4j:slf4j-api:jar:1.7.5:compile
   junit:junit:jar:4.11:test
  org.hamcrest:hamcrest-core:jar:1.3:test
   com.oracle:ojdbc6:jar:11.2.0.1:compile
   org.springframework:spring-context:jar:3.2.4.RELEASE:compile
  org.springframework:spring-aop:jar:3.2.4.RELEASE:compile
  org.springframework:spring-beans:jar:3.2.4.RELEASE:compile
  org.springframework:spring-core:jar:3.2.4.RELEASE:compile
 commons-logging:commons-logging:jar:1.1.1:compile
  org.springframework:spring-expression:jar:3.2.4.RELEASE:compile
   org.springframework:spring-context-support:jar:3.2.4.RELEASE:compile
   org.springframework:spring-tx:jar:3.2.4.RELEASE:compile
  aopalliance:aopalliance:jar:1.0:compile
   org.springframework:spring-jdbc:jar:3.2.4.RELEASE:compile
   org.springframework:spring-orm:jar:3.2.4.RELEASE:compile
   org.springframework:spring-instrument:jar:3.2.4.RELEASE:compile
   org.springframework:spring-webmvc:jar:3.2.4.RELEASE:compile
  org.springframework:spring-web:jar:3.2.4.RELEASE:compile
   org.springframework:spring-test:jar:3.2.4.RELEASE:test
Verifying availability of
C:\Users\dave\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.jar
from [eclipselink (http://download.eclipse.org/rt/eclipselink/maven.repo/,
releases+snapshots), central (http://repo.maven.apache.org/maven2,
releases)]
Using connector WagonRepositoryConnector with priority 0 for
http://download.eclipse.org/rt/eclipselink/maven.repo/
Downloading:
http://download.eclipse.org/rt/eclipselink/maven.repo/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.jar

Writing resolution tracking file
C:\Users\dave\.m2\repository\com\oracle\ojdbc6\11.2.0.1\ojdbc6-11.2.0.1.jar.lastUpdated
Using connector WagonRepositoryConnector with priority 0 for
http://repo.maven.apache.org/maven2
Downloading:
http://repo.maven.apache.org/maven2/com/oracle/ojdbc6/11.2.0.1/ojdbc6-11.2.0.1.jar


On Tue, Mar 11, 2014 at 4:10 PM, Dave Kennedy davek1...@gmail.com wrote:

 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

Re: Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid

2014-03-11 Thread Dave Kennedy
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

2014-03-09 Thread Dave Kennedy
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

2014-03-08 Thread Dave Kennedy
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

2014-03-08 Thread Dave Kennedy
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

2014-03-08 Thread Dave Kennedy
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

2014-03-08 Thread Dave Kennedy
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


Netbeans 7.4 maven POM for com.oracle:ojdbc6:jar:11.2.0.1 is invalid

2014-03-06 Thread Dave Kennedy
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