AeroGear Crypto Java 0.1.2 released
by Bruno Oliveira
Good morning, just to let you know we released today the bits for digital signatures and some bug fixes.
Have a happy new year sweet hearts.
--
abstractj
2 years, 12 months
Chrome Push Messages
by Lucas Holmquist
Hello,
now that the 1.0.0-final is pretty much out for the UnifiedPush Server, i’m starting to look at the new API that Chrome apps use for sending push notifications.
the TL;DR of it is, it’s basically the same as Android now.( no more refresh tokens and access tokens and such )
So the question is, do we need to have a deprecation period on what is currently there?
The v1 of the chrome pushMessaging api has become legacy and it is recommended to use the new stuff. https://developer.chrome.com/apps/cloudMessagingV1
While i have looked to deeply, it’s possible we can use the same “Variant” structure for Chrome Apps, Since they will be using the same Network
wdyt?
-Luke
10 years, 3 months
Unable to resolve realm public key remotely
by Amit Ranjan
I am trying to deploy aerogear-unifiedpush-server-1.0.2 on
wildfly-8.1.0.Final. Following is my setup: Aerogear + wildfly deployed on
server Linux 2.6.32-358.el6.x86_64. I am trying to access the server through
web browser running on my windows dev machine.
I am getting following error when trying to access https//ip:8443/ag-push.
However, I can access the https://ip:8443/auth for aerogere relm.
11:42:20,307 ERROR [io.undertow.request] (default task-1) UT005023:
Exception handling request to /ag-push/index.htm:
java.lang.RuntimeException: Unable to resolve realm public key remotely
at
org.keycloak.adapters.AdapterDeploymentContext.resolveRealmKey(AdapterDeploymentContext.java:94)
[keycloak-adapter-core-1.0.4.Final.jar:]
at
org.keycloak.adapters.AdapterDeploymentContext.resolveDeployment(AdapterDeploymentContext.java:55)
[keycloak-adapter-core-1.0.4.Final.jar:]
at
org.keycloak.adapters.undertow.ServletKeycloakAuthMech.authenticate(ServletKeycloakAuthMech.java:54)
[keycloak-undertow-adapter-1.0.4.Final.jar:]
at
io.undertow.security.impl.SecurityContextImpl$AuthAttempter.transition(SecurityContextImpl.java:281)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.impl.SecurityContextImpl$AuthAttempter.transition(SecurityContextImpl.java:298)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.impl.SecurityContextImpl$AuthAttempter.access$100(SecurityContextImpl.java:268)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.impl.SecurityContextImpl.attemptAuthentication(SecurityContextImpl.java:131)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.impl.SecurityContextImpl.authTransition(SecurityContextImpl.java:106)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.impl.SecurityContextImpl.authenticate(SecurityContextImpl.java:99)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:54)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.0.4.Final.jar:]
at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.0.4.Final.jar:]
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146)
[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.server.Connectors.executeRootHandler(Connectors.java:177)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:727)
[undertow-core-1.0.15.Final.jar:1.0.15.Final]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[rt.jar:1.7.0_09-icedtea]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[rt.jar:1.7.0_09-icedtea]
at java.lang.Thread.run(Thread.java:722)
[rt.jar:1.7.0_09-icedtea] Caused by:
org.apache.http.conn.HttpHostConnectException: Connection to
https://125.21.243.59:8443 refused
at
org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:190)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:151)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:125)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:640)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:479)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:906)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:805)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:784)
[httpclient-4.2.1.jar:4.2.1]
at
org.keycloak.adapters.AdapterDeploymentContext.resolveRealmKey(AdapterDeploymentContext.java:65)
[keycloak-adapter-core-1.0.4.Final.jar:]
... 32 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
[rt.jar:1.7.0_09-icedtea]
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
[rt.jar:1.7.0_09-icedtea]
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
[rt.jar:1.7.0_09-icedtea]
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
[rt.jar:1.7.0_09-icedtea]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
[rt.jar:1.7.0_09-icedtea]
at java.net.Socket.connect(Socket.java:579)
[rt.jar:1.7.0_09-icedtea]
at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:618)
[jsse.jar:1.7.0_09-icedtea]
at
org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:549)
[httpclient-4.2.1.jar:4.2.1]
at
org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)
[httpclient-4.2.1.jar:4.2.1]
... 40 more
Would be really greatful if you can help me out on this.
--
View this message in context: http://aerogear-dev.1069024.n5.nabble.com/Unable-to-resolve-realm-public-...
Sent from the aerogear-dev mailing list archive at Nabble.com.
10 years, 5 months
[UPS] Geolocation Support
by Sebastien Blanc
Hi Folks !
During our last f2f we agreed on adding some geolocation support for the
next UnifiedPush Release (1.1). I would like to start here a thread to
discuss this topic.
Let's keep in mind : *Crawl, Walk, Run*
I would like to start with a concrete proposition and initiate the
discussions from there :
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#installations>
Installations
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#model-change>Model
Change
The idea is to add 2 new fields to the Installation Object :
double longitude;
double latitude;
These field *should* be optional !
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#registration>
Registration
When the device registers, along with alias, categories etc ... it will
also be possible to pass a latitude and longitude.
Later, we will probably offer a endpoint to update these properties. PUT
/registry/device/{token}
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#sender>Sender
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#server-side>Server
Side
We need to extend the current sender API to be able to add geolocation as a
criteria. I see that as something like :
{
"message":{
"alert":"HELLO!
},
"criteria":{
"geolocation":
{
"latitude" : 40.2566
"longitude": 2.36556
"within" : 5
"unit" : "Km" // optional, default is Km
}
}
}
In this example, the Push Notification will be sent only to devices within
a radius of 5 km of the supplied location.
On the implementation side, I think it make sense to use Hibernate Search
since it has nice support forSpatial queries
<https://docs.jboss.org/hibernate/search/4.2/reference/en-US/html/spatial....>
.
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#sender-client>Sender
Client
The different Sender Clients (Java, Node.js, .net) should be updated
accordingly.
<https://gist.github.com/sebastienblanc/d89e41b72c9de537dbde#client-sdks>Client
SDKs
In this fisrt iteration, the registration code would to be updated to
include latitude and longitude for :
- iOS (Including Safari ? )
- Android ( Including Chrome Apps ?)
- JS UPS-SPS Lib
- Cordova Plugin
- Amazon
- Windows
Retrieving the current position of the device is not in scope of this first
version, later we could offer some features around that.
There are some jiras to track these tasks :
https://issues.jboss.org/browse/AGPUSH-828
Comments and questions welcome !
Sebi
10 years, 5 months
Aerogear Website Design
by Andres Galante
Hello,
Just wanted to tell you that Feedhenry gig I was involved is done and I will mainly be working on the website during the next days.
I still need to implement the suggestions Lukas, Matthias and Bruno made, but if you want to follow the progress I'll be updating it here (please use Safari or Firefox):
http://andresgalante.com/aerogearwebsite/
I will concentrate first on structure and content changes, then on styling and colors.
Feedback is very welcome. Please send as much info, changes and critics as possible.
Thanks!
10 years, 5 months
AGPUSH-1047 - Heads up
by Bruno Oliveira
Good morning my friends, decouple AeroGear from Keycloak was easy[1], we
did that last week. This week I'm struggling with auth server url which
must be dinamically replaced[2], for this reason I started a discusson
on keycloak-dev mailing list[3].
Based on the discussion there, I started some changes[4], moved most of
configuration be programatically[5] and make use of placeholders, as
well move our client-side configuration[6]. Altough I'm getting an annoying exception[7]
and already reported to KC team (certainly something missing).
Some of the possible alternatives to KC placeholders:
1. During the configuration wizard, generate the JSON file and store in
some place. The problem is: Keycloak.js must be able to retrieve this
resource, otherwise, won't happen.
2. Allow people to upload their own configuration files to the server,
which requires to manually change it (I don't like it, but works).
If you're feeling bored and want to try my branch:
1. docker run -it -p 8080:8080 -p 9090:9090 jboss/keycloak
2. Login at http://dockerip:8080/auth
3. Add a real and upload ups-realm.json
4. git clone git@github.com:abstractj/aerogear-unifiedpush-server.git &&
switch to strawman branch
5. mvn clean install
6. Deploy ag-push to WildFly
7. Try it (an exception is expected like I mentioned)
I have switch to another task at the moment, and wanted to give to you a
heads up, just in case you want to try/help.
[1] - https://github.com/abstractj/aerogear-unifiedpush-server/commit/e8fc8461f...
[2] - https://github.com/abstractj/aerogear-unifiedpush-server/commit/e8fc8461f...
[3] - http://lists.jboss.org/pipermail/keycloak-dev/2014-November/003096.html
[4] - https://github.com/abstractj/aerogear-unifiedpush-server/commit/d5298d613...
[5] - https://github.com/abstractj/aerogear-unifiedpush-server/commit/d5298d613...
[6] - https://github.com/abstractj/aerogear-unifiedpush-server/commit/d5298d613...
[7] - https://gist.github.com/abstractj/ef42e28903e470d5033d
--
abstractj
PGP: 0x84DC9914
10 years, 5 months
use oracle database
by Ivan Gürtler
Hi,
I tried to use aerogear with oracle database. When I used wildfly it was
good.
I create module.xml for "ojdbc6-12.1.0.1.jar":
*<?xml version="1.0" encoding="UTF-8"?>*
*<module xmlns="urn:jboss:module:1.0" name="com.oracle">*
* <resources>*
* <resource-root path="ojdbc6-12.1.0.1.jar"/>*
* <!-- Insert resources here -->*
* </resources>*
* <dependencies>*
* <module name="javax.api"/>*
* <module name="javax.transaction.api"/>*
* </dependencies>*
*</module>*
next I create oracle-database-config-wildfly.cli
*# $WILDFLY_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*
*connect*
*batch*
*## Add Oracle driver*
*/subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)*
*## Add UnifiedPush Datasource*
*data-source add --name=UnifiedPushDS --driver-name=oracleup
--jndi-name=java:jboss/datasources/UnifiedPushDS
--connection-url=jdbc:oracle:thin:@localhost:1521:XE
--user-name=unifiedpush --password=unifiedpush --use-ccm=false
--max-pool-size=25 --blocking-timeout-wait-millis=5000 --enabled=true*
*run-batch*
*#:reload*
next I configurate wildfly with this and deploy 2 war files. It was very
good :)
But when I tried it with EAP 6.3.0 with same "ojdbc6-12.1.0.1.jar",
module.xml and
next oracle-database-config.cli
*# $JBOSS_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*
*connect*
*batch*
*## Add Oracle driver*
*/subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)*
*## Add UnifiedPush Datasource*
*data-source add --name=UnifiedPushDS --driver-name=oracleup
--jndi-name=java:jboss/datasources/UnifiedPushDS
--connection-url=jdbc:oracle:thin:@localhost:1521:XE
--user-name=unifiedpush --password=unifiedpush --use-ccm=false
--max-pool-size=25 --blocking-timeout-wait-millis=5000*
*data-source enable --name=UnifiedPushDS*
*run-batch*
*#:reload*
after configurating database and deploying 2 war files (ag-push.war
specialy for AS7), it started Aerogear administration web UI and I can
login to web interface. After creating application and variant, I tried to
register mobile device in AG with successfull status in mobile device, but
without creating instalation in AG and server threw exception (log)
*17:10:06,593 WARN [org.jboss.resteasy.core.ResourceLocator]
(http-/0.0.0.0:8080-2) Field uriInfo of subresource
org.keycloak.services.resources.PublicRealmResource will not be injected
according to spec*
*17:10:06,594 WARN [org.jboss.resteasy.core.ResourceLocator]
(http-/0.0.0.0:8080-2) Field request of subresource
org.keycloak.services.resources.PublicRealmResource will not be injected
according to spec*
*17:10:06,594 WARN [org.jboss.resteasy.core.ResourceLocator]
(http-/0.0.0.0:8080-2) Field response of subresource
org.keycloak.services.resources.PublicRealmResource will not be injected
according to spec*
*17:10:06,671 INFO [org.jboss.resteasy.cdi.CdiInjectorFactory]
(http-/0.0.0.0:8080-1) Found BeanManager at java:comp/BeanManager*
*17:10:06,698 INFO [org.jboss.resteasy.spi.ResteasyDeployment]
(http-/0.0.0.0:8080-1) Deploying javax.ws.rs.core.Application: class
org.jboss.aerogear.unifiedpush.rest.RestApplication$Proxy$_$$_WeldClientProxy*
*17:10:07,074 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB
default - 1) SQL Error: 997, SQLState: 42000*
*17:10:07,074 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB
default - 1) ORA-00997: illegal use of LONG datatype*
*17:10:07,094 ERROR [org.jboss.as.ejb3.invocation] (EJB default - 1)
JBAS014134: EJB Invocation failed on component
ClientInstallationServiceImpl for method public abstract void
org.jboss.aerogear.unifiedpush.service.ClientInstallationService.addInstallation(org.jboss.aerogear.unifiedpush.api.Variant,org.jboss.aerogear.unifiedpush.api.Installation):
javax.ejb.EJBException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not extract ResultSet*
* at
org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:189)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:274)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:339)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.interceptors.AsyncFutureInterceptorFactory$1$1.runInvocation(AsyncFutureInterceptorFactory.java:89)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.ejb3.component.interceptors.AsyncInvocationTask.run(AsyncInvocationTask.java:73)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_67]*
* at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_67]*
* at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]*
* at org.jboss.threads.JBossThread.run(JBossThread.java:122)*
*Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not extract ResultSet*
* at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
[hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
[hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)
[hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.getSingleResultForQuery(JPAInstallationDao.java:199)
[unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*
* at
org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.findInstallationForVariantByDeviceToken(JPAInstallationDao.java:72)
[unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*
* at
org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.findInstallationForVariantByDeviceToken(ClientInstallationServiceImpl.java:177)
[unifiedpush-service-1.1.0-SNAPSHOT.jar:]*
* at
org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.addInstallation(ClientInstallationServiceImpl.java:51)
[unifiedpush-service-1.1.0-SNAPSHOT.jar:]*
* at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[rt.jar:1.7.0_67]*
* at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[rt.jar:1.7.0_67]*
* at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_67]*
* at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_67]*
* at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:86)
[jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:97)
[jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[jboss-as-jpa-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:93)
[jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
[jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
* at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:272)
[jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*
* ... 25 more*
*Caused by: org.hibernate.exception.SQLGrammarException: could not extract
ResultSet*
* at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.doQuery(Loader.java:906)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.doList(Loader.java:2550)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.doList(Loader.java:2536)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.Loader.list(Loader.java:2361)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at
org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)
[hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* ... 60 more*
*Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use of
LONG datatype*
* at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)*
* at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)*
* at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)*
* at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)*
* at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)*
* at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)*
* at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)*
* at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)*
* at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)*
* at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)*
* at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)*
* at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)*
* at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)*
* at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)*
* at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)*
* at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
[hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
* ... 75 more*
I use same ojdbc6-12.1.0.1.jar and same database with wildfly and EAP ... I
tried to fix it for a 3 days, but I haven't found solution.
Can you help me with this problem? Thanks.
10 years, 5 months
