... oh :D sorry ... 

I found  /model/jpa/testData/create_db_content.ddl ... I try it ...

Mgr. Ivan Gürtler

Mobile software developer

AHEAD iTec, s.r.o., Botanická 554/68a,
602 00 Brno (Czech Republic)

www.ahead-itec.com | twitter | mobile security solutions

2015-04-23 15:30 GMT+02:00 Ivan Gürtler <ivan.gurtler@ahead-itec.com>:

In report file for PushApplicationDaoTest ... i found:

...

javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not initialize a collection: [org.jboss.aerogear.unifiedpush.api.PushApplication.variants#1]

at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedResultSet.dataTypeConversion(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedResultSet.getClob(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedResultSet.getClob(Unknown Source)

at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60)

at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)

at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)

at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261)

at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:251)

at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:336)

at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2924)

at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695)

at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)

at org.hibernate.loader.Loader.getRow(Loader.java:1509)

at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:719)

at org.hibernate.loader.Loader.processResultSet(Loader.java:949)

at org.hibernate.loader.Loader.doQuery(Loader.java:917)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:318)

at org.hibernate.loader.Loader.loadCollection(Loader.java:2262)

at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:65)

at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:674)

at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:86)

at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1774)

at org.hibernate.collection.internal.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:696)

at org.hibernate.engine.internal.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:1037)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:353)

at org.hibernate.loader.Loader.doList(Loader.java:2550)

at org.hibernate.loader.Loader.doList(Loader.java:2536)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)

at org.hibernate.loader.Loader.list(Loader.java:2361)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)

at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)

at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)

at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)

at org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPABaseDao.getSingleResultForQuery(JPABaseDao.java:93)

at org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAPushApplicationDao.findByPushApplicationID(JPAPushApplicationDao.java:73)

at org.jboss.aerogear.unifiedpush.jpa.PushApplicationDaoTest.updatePushApplication(PushApplicationDaoTest.java:125)

...

In aerogear:master version two mounth ago it was without problems. I found commit "Use JMS message queues for sending notifications in batches AGPUSH-1348" ... in this commit was changed orm.xml file ... but I dont know background of commit change.

Mgr. Ivan Gürtler

Mobile software developer

AHEAD iTec, s.r.o., Botanická 554/68a,
602 00 Brno (Czech Republic)

www.ahead-itec.com | twitter | mobile security solutions

2015-04-23 15:05 GMT+02:00 Erik Jan de Wit <edewit@redhat.com>:

Hi Ivan,

Try running without the test `mvn install -DskipTests`, because they
are testing against another schema. Or see why the tests fail in the
C:\Users\Ivan\Documents\aerogear-unifiedpush-server\model\jpa\target\surefire-reports
directory and fix those tests, by changing
model\jpa\test\create_db_content.ddl

On Thu, Apr 23, 2015 at 2:58 PM, Ivan Gürtler

<ivan.gurtler@ahead-itec.com> wrote:
> Hi,
> We have own fork ... and I sync with "aerogear:master". Master branch in
> fork is OK.
> I merge master to second branch. We changed
> model/jpa/src/main/resources/META-INF/orm.xml file in second branch because
> we use ORACLE
> ...
>      <entity class="iOSVariant" access="FIELD">
>         <discriminator-value>ios</discriminator-value>
>         <attributes>
>             <basic name="certificateData">
>                 <column name="cert_data"/> <!--length="100000"/> BECAUSE
> ORACLE !!!-->
>     <lob/>
>             </basic>
>         </attributes>
>     </entity>
> ...
> (Second change in orm.xml file was because of Installation class, it was
> bigger than 4000 -> problem in ORACLE ... but in "aerogear:master" it was
> removed from orm.xml file)
> but when ... Run as ... Maven insall ... In console:
> ...
> Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.366 sec
> Results :
> Failed tests:
>    Expected exception: javax.persistence.PersistenceException
> Tests in error:
>   PushApplicationDaoTest.updatePushApplication:125 » Persistence
> org.hibernate.e...
>   PushApplicationDaoTest.pushApplicationIDUnmodifiedAfterUpdate:159 »
> Persistence
>
> PushApplicationDaoTest.deletePushApplicationIncludingVariantAndInstallations:194
> » Persistence
>   PushApplicationDaoTest.findByPushApplicationID:116 » Persistence
> org.hibernate...
>   PushApplicationDaoTest.findAllForDeveloper:72 » Persistence
> org.hibernate.exce...
>   PushApplicationDaoTest.primaryKeyUnmodifiedAfterUpdate:174 » Persistence
> org.h...
>   PushApplicationDaoTest.findAllIDsForDeveloper:96 » Persistence
> org.hibernate.e...
>   PushApplicationDaoTest.findByPushApplicationIDForDeveloper:103 »
> Persistence o...
>   PushApplicationDaoTest.updateAndDeletePushApplication:140 » Persistence
> org.hi...
> Tests run: 75, Failures: 1, Errors: 9, Skipped: 0
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Reactor Summary:
> [INFO]
> [INFO] AeroGear UnifiedPush Server ....................... SUCCESS [  2.833
> s]
> [INFO] UnifiedPush Model Layer ........................... SUCCESS [  0.058
> s]
> [INFO] UnifiedPush Server Model API ...................... SUCCESS [  2.886
> s]
> [INFO] UnifiedPush Server Model JPA implementation ....... FAILURE [ 32.992
> s]
> [INFO] UnifiedPush Service Layer ......................... SKIPPED
> [INFO] UnifiedPush Sender Module ......................... SKIPPED
> [INFO] UnifiedPush Push Message Model .................... SKIPPED
> [INFO] UnifiedPush Push Notification Networks ............ SKIPPED
> [INFO] UnifiedPush RESTful Endpoint ...................... SKIPPED
> [INFO] UnifiedPush Server (Admin UI) ..................... SKIPPED
> [INFO] UnifiedPush Dependencies Parent ................... SKIPPED
> [INFO] UnifiedPush Server Dependencies Server ............ SKIPPED
> [INFO] UnifiedPush Auth Server ........................... SKIPPED
> [INFO] UnifiedPush Server for JBossAS (WAR) .............. SKIPPED
> [INFO] UnifiedPush Server for Wildfly (WAR) .............. SKIPPED
> [INFO] UnifiedPush Servers Parent ........................ SKIPPED
> [INFO]
> ------------------------------------------------------------------------
> [INFO] BUILD FAILURE
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Total time: 40.717 s
> [INFO] Finished at: 2015-04-23T14:35:45+01:00
> [INFO] Final Memory: 21M/420M
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] Failed to execute goal
> org.apache.maven.plugins:maven-surefire-plugin:2.14.1:test (default-test) on
> project unifiedpush-model-jpa: There are test failures.
> [ERROR]
> [ERROR] Please refer to
> C:\Users\Ivan\Documents\aerogear-unifiedpush-server\model\jpa\target\surefire-reports
> for the individual test results.
> [ERROR] -> [Help 1]
> [ERROR]
> [ERROR] To see the full stack trace of the errors, re-run Maven with the -e
> switch.
> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> [ERROR]
> [ERROR] For more information about the errors and possible solutions, please
> read the following articles:
> [ERROR] [Help 1]
> http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
> [ERROR]
> [ERROR] After correcting the problems, you can resume the build with the
> command
> [ERROR]   mvn <goals> -rf :unifiedpush-model-jpa
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------
> Do you have any idea where is the problem and how to solve it?
> Thanks
>
> Mgr. Ivan Gürtler
> Mobile software developer
>
> AHEAD iTec, s.r.o., Botanická 554/68a,
> 602 00 Brno (Czech Republic)
>
> www.ahead-itec.com | twitter | mobile security solutions
>
> 2015-04-23 8:55 GMT+02:00 Erik Jan de Wit <edewit@redhat.com>:
>>
>> Hi Ivan,
>>
>> We have functionality for this available in the master branch on
>> github. Go to <server>/ag-push/rest/sys/info/health it will return
>> json with the push network status and db status. This PR
>> https://github.com/aerogear/aerogear-unifiedpush-server/pull/519
>> includes details about the returned json.
>>
>> Hope this helps...
>>
>> ---
>> Cheers,
>>     Erik Jan
>>
>> On Thu, Apr 23, 2015 at 8:39 AM, Ivan Gürtler
>> <ivan.gurtler@ahead-itec.com> wrote:
>> > Hi,
>> > I have some questions about server status.
>> > Is possible to check with some kind of ping (or something else) that DB
>> > is
>> > available from push server?
>> > How to check if platform push server (APNS...) is also available?
>> >
>> >
>> > Thanks
>> >
>> > Mgr. Ivan Gürtler
>> > Mobile software developer
>> >
>> > AHEAD iTec, s.r.o., Botanická 554/68a,
>> > 602 00 Brno (Czech Republic)
>> >
>> > www.ahead-itec.com | twitter | mobile security solutions
>> >
>> > _______________________________________________
>> > aerogear-dev mailing list
>> > aerogear-dev@lists.jboss.org
>> > https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>
>>
>>
>> --
>> Cheers,
>>        Erik Jan
>>
>> _______________________________________________
>> aerogear-dev mailing list
>> aerogear-dev@lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>
>
>
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev



--
Cheers,
       Erik Jan

_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev