DataSource with @embeddedId giving some exceptions

[zatix]

Using:

SmartGWT-power-3.1.p20130111
GWT 2.5

Hi, I'm trying to make a ListGrid with a JPA2DataSource pointing to a table using an @embeddedId.
I've already configured the idClass using this method:

http://www.smartclient.com/smartgwtee-latest/javadoc/com/smartgwt/client/docs/serverds/DataSource.html#idClassName

But the server continues to launch the following exception:

Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory left outer join _VwUserVehicleHistory.driver driver1], line 1, column 7: unexpected token [count].

Also, the documentation (QuickStart.pdf) is not helping at all, not even google..

What am I missing here?

Thank you very much for your help.

[Isomorphic]

Start by posting the complete server log for the request. We always need this, not just the exception message.

[zatix]

I'm getting the following exception:

=== 2013-01-21 22:30:38,549 [ng)'] DEBUG JPADataSource - [builtinApplication.vwUserVehicleHistory_fetch] Query string: select _VwUserVehicleHistory, driver1 from VwUserVehicleHistory _VwUserVehicleHistory left outer join _VwUserVehicleHistory.driver driver1 order by _VwUserVehicleHistory.serverDate desc
=== 2013-01-21 22:30:38,550 [ng)'] DEBUG JPADataSource - [builtinApplication.vwUserVehicleHistory_fetch] Marking transaction for roll back.
=== 2013-01-21 22:30:38,550 [ng)'] DEBUG JPADataSource - [builtinApplication.vwUserVehicleHistory_fetch] Got exception while executing. Transaction will be rolled back.
java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory left outer join _VwUserVehicleHistory.driver driver1], line 1, column 7: unexpected token [count].
Internal Exception: NoViableAltException(17!=[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1375)
at sun.reflect.GeneratedMethodAccessor682.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:106)
at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:77)
at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:87)
at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:18)
at $Proxy280.createQuery(Unknown Source)
at com.isomorphic.jpa.JPADataSource.createQuery(JPADataSource.java:1253)
at com.isomorphic.jpa.JPADataSource.executeFetch(JPADataSource.java:612)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1367)
at com.isomorphic.jpa.JPADataSource.execute(JPADataSource.java:571)
at br.com.cp.pj.common.datasource.BaseJPA2DataSource.execute0(BaseJPA2DataSource.java:98)
at br.com.cp.pj.common.datasource.BaseJPA2DataSource.execute(BaseJPA2DataSource.java:40)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:726)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2027)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at br.com.cp.pj.gateway.servlet.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:41)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: Exception [EclipseLink-8025] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory left outer join _VwUserVehicleHistory.driver driver1], line 1, column 7: unexpected token [count].
Internal Exception: NoViableAltException(17!=[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])

[zatix]

The mapped entity and embeddedId:

@Entity
@Table(name = "VW_USER_VEHICLE_HISTORY")
public class VwUserVehicleHistory implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private VwUserVehicleHistoryPK vwUserVehicleHistoryPk = new VwUserVehicleHistoryPK();

	@ManyToOne
	@JoinColumn(name = "DRIV_SQ_DRIVER")
	private Driver driver;

//many attributes above
}


@Embeddable
public class VwUserVehicleHistoryPK {
	
	@Column(name = "VEHS_SQ_VEHICLE_HISTORY")
	private Long historyId;
	
	@Column(name = "USPO_SQ_USER_PORTAL_ORION")
	private Long user;

	@Column(name = "CLIE_SQ_CLIENT_PARTNER")
	private Long clientPartner;

}

And the datasource ds.xml:

<DataSource  
		ID="vwUserVehicleHistory"  
		serverConstructor="com.isomorphic.jpa.JPA2DataSource"
		beanClassName="entity.VwUserVehicleHistory"
		idClassName="entity.VwUserVehicleHistoryPK"  
		schemaBean="entity.VwUserVehicleHistory"
		dropExtraFields="true">   
    <fields>     
       	<field name="directionIcon"/>
       	<field name="eventStatus"/>
       	<field name="vehicleNamePlate"/>
       	
       	<field name="driverNickname"  type="text"     hidden="true"   valueXPath="driver/nickname"/>

       	<field name="driver" title="driver"	canEdit="false" displayField="driverId" foreignKey="driver.id"/>
    </fields>      
</DataSource>

Also, it is important to say that there another datasource named "driver".

I hope the info showed can help us to find a solution.

Thank you!

[Isomorphic]

So again, we need the complete log for the request - not just the exception. The complete log for the request.

[zatix]

So again, we need the complete log for the request - not just the exception. The complete log for the request.

Could you please explain what that log would be?
I didn't get it yet.
Please, give an example of a complete log for the request, so I can fulfill this.

Meanwhile, can you please provide-me more information about how to make a correct datasource mapping with an embedded key? As I said, I am not finding a proper documentation.

[Isomorphic]

The complete log for the request means all server logs that are generated while the HTTP request is being processed by the server.

What you have posted is a subset of this.

There's nothing obviously wrong with your use of the embedded if property. That's why we're asking for logs - to troubleshoot.

[zatix]

The complete log for the request means all server logs that are generated while the HTTP request is being processed by the server.

What you have posted is a subset of this.

There's nothing obviously wrong with your use of the embedded if property. That's why we're asking for logs - to troubleshoot.

Ok, I'm on my way to provide you those logs.
But I still miss the documentation, I'd really appreciate that if you could give me some useful links.

[Isomorphic]

Again, your usage appears to be correct and you already provided a link to the relevant documentation.

Now we are troubleshooting - trying to find out what went wrong, since your usage appears correct (from the information we have so far).

So there is no need for further documentation, rather, there's a need for information to use for troubleshooting (the logs).

[zatix]

Fine, I've got the log.
The screen that shows the desired ListGrid loads others DataSources as well (that's the reason for the huge log) and the problematic one used to work fine before I added the embeddedId.

http://pastebin.com/SHCXFmkK

Thank you.

[Isomorphic]

This is a huge log for several requests and with max verbosity enabled. Could you please just send a log for the failing request, with just the default setting for logging that we ship with the SDK.

This should be easy - we are trying to save you time relative to providing a complete standalone test case.

[zatix]

Hi,

Now the requested log.
Anything else?

Thank you.

                              
Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:06,885 [ng)'] INFO  Compression - /linker/Main.jsp: 6401 -> 2068 bytes
=== 2013-01-23 19:51:06,994 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:07,007 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:07,010 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:07,018 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:07,019 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:07,031 [ng)'] INFO  RequestContext - URL: '/linker/Main/Main.nocache.js', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTM
L, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:07,050 [ng)'] INFO  PoolManager - SmartClient pooling disabled for 'vwVehiclePermanenceUser' objects
=== 2013-01-23 19:51:08,232 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,235 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,235 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,235 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,249 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,249 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,249 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,250 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,253 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,256 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,256 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,256 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,273 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,279 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,279 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,289 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,293 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,296 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,312 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,339 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,342 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,344 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,363 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,363 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,364 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,364 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,365 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,365 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,370 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,370 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,385 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,386 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,392 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,398 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,406 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,407 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,413 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,424 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,437 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,438 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,439 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,442 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,493 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,499 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,511 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,517 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:08,542 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:10,859 [ng)'] INFO  RequestContext - URL: '/linker/Main/SecurityService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.
17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:10,863 [ng)'] INFO  RequestContext - URL: '/linker/Main/PropertiesService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/53
7.17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,204 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, li
ke Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,235 [ng)'] INFO  RequestContext - URL: '/linker/Main/VehicleService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,236 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,243 [ng)'] INFO  RequestContext - URL: '/linker/Main/VehicleService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,244 [ng)'] INFO  RequestContext - URL: '/linker/Main/VehicleService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,244 [ng)'] INFO  RequestContext - URL: '/linker/Main/VehicleService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,305 [ng)'] INFO  IDACall - Performing 1 operation(s)
=== 2013-01-23 19:51:11,432 [ng)'] INFO  RequestContext - URL: '/linker/Main/SecurityService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.
17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,527 [ng)'] INFO  RequestContext - URL: '/linker/Main/SecurityService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.
17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,758 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,760 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,762 [ng)'] INFO  RequestContext - URL: '/linker/Main/SecurityService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.
17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,770 [ng)'] INFO  DSResponse - [builtinApplication.client_fetch] DSResponse: List with 8 items
=== 2013-01-23 19:51:11,779 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,780 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,783 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,784 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, li
ke Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,789 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,792 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,794 [ng)'] INFO  RequestContext - URL: '/linker/Main/SecurityService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.
17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,821 [ng)'] INFO  IDACall - Performing 1 operation(s)
=== 2013-01-23 19:51:11,895 [ng)'] INFO  Compression - /linker/Main/sc/IDACall: 1482 -> 531 bytes
=== 2013-01-23 19:51:11,915 [ng)'] INFO  RequestContext - URL: '/linker/Main/SecurityService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.
17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,952 [ng)'] INFO  RequestContext - URL: '/linker/Main/MenuService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:11,952 [ng)'] INFO  RequestContext - URL: '/linker/Main/MenuService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (
KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,218 [ng)'] INFO  DSResponse - [builtinApplication.vwVehicleCurrentState_fetch] DSResponse: List with 8 items
=== 2013-01-23 19:51:12,428 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,440 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,441 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,442 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,442 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,443 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,443 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,443 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:12,444 [ng)'] INFO  Compression - /linker/Main/sc/IDACall: 5861 -> 1403 bytes
=== 2013-01-23 19:51:12,446 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,782 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,786 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,791 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,793 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,797 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,799 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,802 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,806 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, li
ke Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:12,820 [ng)'] INFO  IDACall - Performing 1 operation(s)
=== 2013-01-23 19:51:13,367 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, li
ke Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:13,373 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:13,374 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:13,374 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:13,381 [ng)'] INFO  IDACall - Performing 1 operation(s)
=== 2013-01-23 19:51:13,383 [ng)'] WARN  DSRequest - In criteria, definition 'vwUserVehicleHistoryPk.clientPartner' refers to a related DataSource ('vwUserVehicleHistor
yPk') that does not exist.  Ignoring this criteria entry.
=== 2013-01-23 19:51:13,384 [ng)'] WARN  DSRequest - In criteria, definition 'vwUserVehicleHistoryPk.user' refers to a related DataSource ('vwUserVehicleHistoryPk') tha
t does not exist.  Ignoring this criteria entry.
=== 2013-01-23 19:51:13,419 [ng)'] WARN  JPADataSource - [builtinApplication.vwUserVehicleHistory_fetch] Field name: 'vwUserVehicleHistoryPk.clientPartner' specified in
 criteria is not defined in data source. Skipping.
=== 2013-01-23 19:51:13,420 [ng)'] WARN  JPADataSource - [builtinApplication.vwUserVehicleHistory_fetch] Field name: 'vwUserVehicleHistoryPk.user' specified in criteria
 is not defined in data source. Skipping.
=== 2013-01-23 19:51:13,422 [ng)'] WARN  RequestContext - dsRequest.execute() failed:
java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory  left outer join _VwUserVehicleHistory.driver dri
ver1], line 1, column 7: unexpected token [count].
Internal Exception: NoViableAltException(17!=[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET
n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1375)
        at sun.reflect.GeneratedMethodAccessor1491.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:106)
        at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:77)
        at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:87)
        at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:18)
        at $Proxy632.createQuery(Unknown Source)
        at com.isomorphic.jpa.JPADataSource.createQuery(JPADataSource.java:1253)
        at com.isomorphic.jpa.JPADataSource.executeFetch(JPADataSource.java:612)
        at com.isomorphic.datasource.DataSource.execute(DataSource.java:1367)
        at com.isomorphic.jpa.JPADataSource.execute(JPADataSource.java:571)
        at br.com.zatix.portalorion.common.datasource.BaseJPA2DataSource.execute0(BaseJPA2DataSource.java:98)
        at br.com.zatix.portalorion.common.datasource.BaseJPA2DataSource.execute(BaseJPA2DataSource.java:40)
        at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:726)
        at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
        at com.isomorphic.application.AppBase.execute(AppBase.java:491)
        at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2027)
        at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
        at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
        at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
        at com.isomorphic.servlet.IDACall.doPost(IDACall.java:75)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
        at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
        at br.com.zatix.portalorion.gateway.servlet.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:41)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: Exception [EclipseLink-8025] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory  left outer join _VwUserVehicleHistory.driver dri
ver1], line 1, column 7: unexpected token [count].
Internal Exception: NoViableAltException(17!=[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET
n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
        at org.eclipse.persistence.exceptions.JPQLException.unexpectedToken(JPQLException.java:372)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.handleRecognitionException(JPQLParser.java:316)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.addError(JPQLParser.java:242)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.reportError(JPQLParser.java:359)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectExpression(JPQLParser.java:5972)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectItem(JPQLParser.java:1356)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectClause(JPQLParser.java:1270)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectStatement(JPQLParser.java:351)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.document(JPQLParser.java:275)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.parse(JPQLParser.java:130)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.buildParseTree(JPQLParser.java:91)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:207)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:182)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:134)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:118)
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1373)
        at sun.reflect.GeneratedMethodAccessor1491.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:106)
        at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:77)
        at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:87)
        at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:18)
        at $Proxy632.createQuery(Unknown Source)
        at com.isomorphic.jpa.JPADataSource.createQuery(JPADataSource.java:1253)
        at com.isomorphic.jpa.JPADataSource.executeFetch(JPADataSource.java:612)
        at com.isomorphic.datasource.DataSource.execute(DataSource.java:1367)
        at com.isomorphic.jpa.JPADataSource.execute(JPADataSource.java:571)
        at br.com.zatix.portalorion.common.datasource.BaseJPA2DataSource.execute0(BaseJPA2DataSource.java:98)
        at br.com.zatix.portalorion.common.datasource.BaseJPA2DataSource.execute(BaseJPA2DataSource.java:40)
        at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:726)
        at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
        at com.isomorphic.application.AppBase.execute(AppBase.java:491)
        at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2027)
        at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
        at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
        at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
        at com.isomorphic.servlet.IDACall.doPost(IDACall.java:74)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
        at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
        at br.com.zatix.portalorion.gateway.servlet.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:40)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
        ... 9 more
Caused by: NoViableAltException(17!=[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variab
leAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectExpression(JPQLParser.java:5817)
        ... 54 more
=== 2013-01-23 19:51:13,458 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:13,459 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:13,459 [ng)'] WARN  JPA2DSGenerator - Property not found for mapped attribute.
=== 2013-01-23 19:51:13,466 [ng)'] INFO  Compression - /linker/Main/sc/IDACall: 685 -> 433 bytes
=== 2013-01-23 19:51:15,526 [ng)'] INFO  RequestContext - URL: '/linker/Main/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, li
ke Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:15,528 [ng)'] INFO  RequestContext - URL: '/linker/Main/VehicleService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:51:15,565 [ng)'] INFO  IDACall - Performing 1 operation(s)
=== 2013-01-23 19:51:15,985 [ng)'] INFO  DSResponse - [builtinApplication.vwVehicleCurrentState_fetch] DSResponse: List with 8 items
=== 2013-01-23 19:51:16,007 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,008 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,008 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,009 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,009 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,010 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,010 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,011 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,018 [ng)'] INFO  Compression - /linker/Main/sc/IDACall: 5861 -> 1403 bytes
=== 2013-01-23 19:51:16,448 [ng)'] INFO  DSResponse - [builtinApplication.vwVehicleCurrentState_fetch] DSResponse: List with 8 items
=== 2013-01-23 19:51:16,485 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,507 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,508 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,509 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,510 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,511 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,512 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,513 [ng)'] WARN  DataSource - Couldn't get value at valueXPath: driver/nickname for datasource: vwVehicleCurrentState - ignoring.  Actual error:
 org.apache.commons.jxpath.JXPathNotFoundException: No value for xpath: driver/nickname
=== 2013-01-23 19:51:16,514 [ng)'] INFO  Compression - /linker/Main/sc/IDACall: 5861 -> 1402 bytes
=== 2013-01-23 19:52:12,918 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header
=== 2013-01-23 19:54:14,508 [ng)'] INFO  RequestContext - URL: '/linker/Main/PushingService.servlet', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1
7 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17': Safari with Accept-Encoding header

[zatix]

I made a basic project wich is running only the problematic datasource, with minimal code and nothing else.

I'm now sending you two logs in diferent categories, INFO and DEBUG in order to provide as much information as I can.

Here is the log with INFO category

Reloading web app to reflect changes in C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0
[WARN] Server class 'com.google.gwt.dev.shell.jetty.JDBCUnloader' could not be found in the web app, but was found on the system classpath
   [WARN] Adding classpath entry 'file:/C:/Users/dirceu/.m2/repository/com/google/gwt/gwt-dev/2.5.0/gwt-dev-2.5.0.jar' to the web app classpath for this session
ISC: Configuring log4j from: file:/C:/projetos/zatix/portalOrion/src/trunk/sandbox-webapp/target/sandbox-webapp-1.0/WEB-INF/classes/log4j.isc.config.xml
=== 2013-01-24 12:33:45,856 [ad-1] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework - Initializing
=== 2013-01-24 12:33:45,862 [ad-1] INFO  ConfigLoader - Attempting to load framework.properties from CLASSPATH
=== 2013-01-24 12:33:45,941 [ad-1] INFO  ConfigLoader - Successfully loaded framework.properties from CLASSPATH at location: jar:file:/C:/projetos/zatix/portalOrion/src/trunk/sandbox-webapp/target/sandbox-webapp-1.0/WEB-INF/lib/isomorphic-core-rpc-3.1.p20130111.jar!/framework.properties
=== 2013-01-24 12:33:45,941 [ad-1] INFO  ConfigLoader - Attempting to load project.properties from CLASSPATH
=== 2013-01-24 12:33:45,944 [ad-1] INFO  ConfigLoader - Unable to locate project.properties in CLASSPATH
=== 2013-01-24 12:33:45,954 [ad-1] INFO  ConfigLoader - Successfully loaded isc_interfaces.properties from CLASSPATH at location: jar:file:/C:/projetos/zatix/portalOrion/src/trunk/sandbox-webapp/target/sandbox-webapp-1.0/WEB-INF/lib/isomorphic-core-rpc-3.1.p20130111.jar!/isc_interfaces.properties
=== 2013-01-24 12:33:45,954 [ad-1] INFO  ConfigLoader - Attempting to load server.properties from CLASSPATH
=== 2013-01-24 12:33:45,957 [ad-1] INFO  ConfigLoader - Successfully loaded server.properties from CLASSPATH at location: file:/C:/projetos/zatix/portalOrion/src/trunk/sandbox-webapp/target/sandbox-webapp-1.0/WEB-INF/classes/server.properties
=== 2013-01-24 12:33:45,963 [ad-1] INFO  Logger - Logging system started.
=== 2013-01-24 12:33:45,964 [ad-1] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework (v8.3p_2013-01-11/PowerEdition Deployment 2013-01-11) - Initialization Complete
=== 2013-01-24 12:33:45,967 [ad-1] INFO  ISCInit - Auto-detected webRoot - using: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0
=== 2013-01-24 12:33:45,970 [ad-1] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework initialization called from com.isomorphic.base.Base
=== 2013-01-24 12:33:45,971 [ad-1] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework is already initialized
[WARN] Server class 'com.google.gwt.junit.server.JUnitHostImpl' could not be found in the web app, but was found on the system classpath
   [WARN] Adding classpath entry 'file:/C:/Users/dirceu/.m2/repository/com/google/gwt/gwt-user/2.5.0/gwt-user-2.5.0.jar' to the web app classpath for this session
=== 2013-01-24 12:33:46,012 [ad-1] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework initialization called from com.isomorphic.base.Init
=== 2013-01-24 12:33:46,012 [ad-1] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework is already initialized
   Reload completed successfully
=== 2013-01-24 12:33:51,225 [0-11] INFO  RequestContext - URL: '/SandboxWebApp/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1': Moz (Gecko) with Accept-Encoding header
=== 2013-01-24 12:33:51,316 [0-11] INFO  PoolManager - SmartClient pooling disabled for 'vwUserVehicleHistory' objects
=== 2013-01-24 12:33:51,336 [0-13] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\load_skin.js
=== 2013-01-24 12:33:51,339 [0-12] INFO  Compression - /SandboxWebApp/sc/modules/ISC_Core.js: 784887 -> 205641 bytes
=== 2013-01-24 12:33:51,724 [0-12] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\skin_styles.css
[WARN] Server resource 'br/com/zatix/portalorion/entities/model/entity/Client.class' could not be found in the web app, but was found on the system classpath
   [WARN] Adding classpath entry 'file:/C:/projetos/zatix/portalOrion/src/trunk/portal-orion/entities.jar/target/classes/' to the web app classpath for this session
=== 2013-01-24 12:33:58,511 [0-12] INFO  RequestContext - URL: '/SandboxWebApp/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1': Moz (Gecko) with Accept-Encoding header
=== 2013-01-24 12:33:58,581 [0-12] INFO  IDACall - Performing 1 operation(s)
=== 2013-01-24 12:33:58,643 [0-12] WARN  RequestContext - dsRequest.execute() failed: 
java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory ], line 1, column 13: unexpected token[*].
Internal Exception: NoViableAltException(93@[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1378)
	at com.isomorphic.jpa.JPADataSource.createQuery(JPADataSource.java:1253)
	at com.isomorphic.jpa.JPADataSource.executeFetch(JPADataSource.java:612)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1367)
	at com.isomorphic.jpa.JPADataSource.execute(JPADataSource.java:571)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:726)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2027)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:74)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:324)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
Caused by: Exception [EclipseLink-8025] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [select count(*) from VwUserVehicleHistory _VwUserVehicleHistory ], line 1, column 13: unexpected token[*].
Internal Exception: NoViableAltException(93@[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
	at org.eclipse.persistence.exceptions.JPQLException.unexpectedToken(JPQLException.java:372)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.handleRecognitionException(JPQLParser.java:320)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.addError(JPQLParser.java:246)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.reportError(JPQLParser.java:363)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectExpression(JPQLParser.java:1328)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectItem(JPQLParser.java:1169)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectClause(JPQLParser.java:1081)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectStatement(JPQLParser.java:359)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.document(JPQLParser.java:281)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.parse(JPQLParser.java:134)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.buildParseTree(JPQLParser.java:95)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:212)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:187)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:139)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:123)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1376)
	... 35 more
Caused by: NoViableAltException(93@[364:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
	at org.eclipse.persistence.internal.libraries.antlr.runtime.DFA.noViableAlt(DFA.java:159)
	at org.eclipse.persistence.internal.libraries.antlr.runtime.DFA.predict(DFA.java:116)
	at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectExpression(JPQLParser.java:1249)
	... 46 more
=== 2013-01-24 12:33:58,659 [0-12] INFO  Compression - /SandboxWebApp/sc/IDACall: 628 -> 412 bytes
=== 2013-01-24 12:33:58,900 [0-12] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\blank.gif
=== 2013-01-24 12:33:59,029 [0-11] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\Scrollbar\hscroll_start.png
=== 2013-01-24 12:33:59,031 [0-14] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\Scrollbar\hthumb_grip.png
=== 2013-01-24 12:33:59,035 [0-12] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\loadingSmall.gif
=== 2013-01-24 12:33:59,037 [l0-8] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\Scrollbar\hscroll_end.png
=== 2013-01-24 12:33:59,037 [0-13] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\Scrollbar\hscroll_track.png
=== 2013-01-24 12:33:59,074 [l0-8] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\Dialog\warn.png
=== 2013-01-24 12:33:59,074 [0-13] INFO  Download - Returning 304: Not modified on conditional get of: C:\projetos\zatix\portalOrion\src\trunk\sandbox-webapp\target\sandbox-webapp-1.0\SandboxWebApp\sc\skins\Enterprise\images\headerIcons\close.png

[zatix]

Here is the log with DEBUG category

http://pastebin.com/j4qyxL96

[zatix]

Also, I'm using eclipselink 2.2.1 as the JPA implementatiom.

Accordingly to the logs, it's doing a "select count(*) from entity", why is it not doing, for instance, a "select count(alias) from enttity alias" or some sort of strategy?