Sample Sample Project built-in-ds running in hosted mode has errors

[forlego]

SmartGWT version smartgwtpro-4.1d

Broswer FireFox version 25.0.1

GWT home set to GWT version 2.5.1

ANT_HOME set to java 1.6.0_45

[java] === 2013-12-05 14:53:19,245 [l0-0] DEBUG PoolableSQLConnectionFactor
y - [builtinApplication.animals_fetch] DriverManager fetching connection for HSQ
LDB via jdbc url jdbc:hsqldb:hsql://localhost/isomorphic
[java] === 2013-12-05 14:53:19,245 [l0-0] DEBUG PoolableSQLConnectionFactor
y - [builtinApplication.animals_fetch] Passing JDBC URL only to getConnection
[java] === 2013-12-05 14:53:19,347 [l0-0] DEBUG PoolableSQLConnectionFactor
y - [builtinApplication.animals_fetch] makeObject() created an unpooled Connecti
on '422509968'
[java] === 2013-12-05 14:53:19,352 [l0-0] WARN RequestContext - dsRequest.
execute() failed:
[java] java.sql.SQLSyntaxErrorException: incompatible data type in operatio
n
[java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[java] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
[java] at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
[java] at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.
java:657)
[java] at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.
java:534)
[java] at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.
java:527)
[java] at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:6
91)
[java] at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:941
)
[java] at com.isomorphic.sql.SQLDataSource.runRowCountQuery(SQLDataSour
ce.java:2726)
[java] at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDat
aSource.java:2143)
[java] at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.jav
a:1789)
[java] at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource
.java:411)
[java] at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.j
ava:356)
[java] at com.isomorphic.datasource.DataSource.execute(DataSource.java:
1487)
[java] at com.isomorphic.application.AppBase.executeDefaultDSOperation(
AppBase.java:723)
[java] at com.isomorphic.application.AppBase.executeAppOperation(AppBas
e.java:658)
[java] at com.isomorphic.application.AppBase.execute(AppBase.java:491)
[java] at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:25
61)
[java] at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:2
15)
[java] at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.
java:172)
[java] at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:13
7)
[java] at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
[java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
[java] at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:1
52)
[java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
[java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.
java:487)
[java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandle
r.java:362)
[java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHan
dler.java:216)
[java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandle
r.java:181)
[java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandle
r.java:729)
[java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.j
ava:405)
[java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrappe
r.java:152)
[java] at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLog
Handler.java:49)
[java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrappe
r.java:152)
[java] at org.mortbay.jetty.Server.handle(Server.java:324)
[java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection
.java:505)
[java] at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpC
onnection.java:843)
[java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
[java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:2
11)
[java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:3
80)
[java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEnd
Point.java:395)
[java] at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThre
adPool.java:488)
[java] === 2013-12-05 14:53:19,356 [l0-0] DEBUG RPCManager - Content type f

[Isomorphic]

Hi
We haven't seen this problem.
Can you tell us exactly the steps you're taking to get this error.

Are you using an IDE [Eclipse or something else?]

How are you installing the SmartGWT project (importing into Eclipse vs something else)? Any configuration errors showing up?
What steps do you take before you see the error?

Also - are you using the latest nightly build or something older?

Thanks
Isomorphic Software

[forlego]

I am not using an IDE. I am using the DOS command line. I entered command 'ant hosted' from directory smartgwtpro-4.1d\samples\built-in-ds.

I had to increase memory in the build file - jvmarg was set to 512M, else I got out of memory error.


<target name="hosted" depends="javac" description="Run hosted mode">
<java failonerror="true" fork="true" classname="com.google.gwt.dev.DevMode">
<classpath>
<pathelement location="src"/>
<path refid="project.class.path"/>
</classpath>
<jvmarg value="-Xmx512M"/>
<arg value="-startupUrl"/>
<arg value="BuiltInDS.html"/>
<!-- Additional arguments like -style PRETTY or -logLevel DEBUG -->
<arg value="com.smartgwt.sample.BuiltInDS"/>
</java>
</target>



This is a nightly build pro edition.

Scenario to re-create problem:
running command 'ant hosted' bring up GWT Development Mode dialog box.

I click on Launch Default Browser button. This brings up Firefox browser with web page.

I clicked 'Animals' under select data source. This populates the table with the animals data.

Click on an animal in the table. For example 'Arabian Camel'.

Click on filter button. Browser pops up dialog box with message "Incomptible data type operation" and DOS command window outputs exception messages.

[Isomorphic]

We are reproducing this issue and will follow up when we have a resolution

Regards
Isomorphic Software