Announcement

**Isomorphic** · 21 Mar 2011, 15:07

This is working fine in our test environments. Can you show the information you see in server-side logs (if any) and contents of the Developer Console, both the "Results" tab and the RPC tab if there are any RPCs.

**aarontsmith** · 22 Mar 2011, 05:38

Originally posted by Isomorphic

This is working fine in our test environments. Can you show the information you see in server-side logs (if any) and contents of the Developer Console, both the "Results" tab and the RPC tab if there are any RPCs.

Upfront, I am a noob to smartgwt..... I have the dev console up when I
start the visual builder, however, I don't see any output while running the
tools. Do I have to start the console within the visual builder window?
If so, how?

I have attached the server-side logs. I don't see any errors.
The last bit of logs just before the black squares is below:

I was able to get this to work by importing the LPGL version of the showcase
into eclipse 8.6.

09:34:43,630 INFO [STDOUT] === 2011-03-22 09:34:43,627 [80-2] DEBUG AppBase - [builtinApplication.ANIMALS-dbBrowser_fetch] No userTypes defined, allowing anyone access to all operations for this application
09:34:43,630 INFO [STDOUT] === 2011-03-22 09:34:43,630 [80-2] DEBUG AppBase - [builtinApplication.ANIMALS-dbBrowser_fetch] No public zero-argument method named '_ANIMALS-dbBrowser_fetch' found, performing generic datasource operation
09:34:43,631 INFO [STDOUT] === 2011-03-22 09:34:43,631 [80-2] INFO SQLDataSource - [builtinApplication.ANIMALS-dbBrowser_fetch] Performing fetch operation with
criteria: {} values: {}
09:34:43,632 INFO [STDOUT] === 2011-03-22 09:34:43,631 [80-2] INFO SQLWhereClause - [builtinApplication.ANIMALS-dbBrowser_fetch] empty condition
09:34:43,632 INFO [STDOUT] === 2011-03-22 09:34:43,632 [80-2] INFO SQLDataSource - [builtinApplication.ANIMALS-dbBrowser_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
09:34:43,634 INFO [STDOUT] === 2011-03-22 09:34:43,634 [80-2] DEBUG SQLDataSource - [builtinApplication.ANIMALS-dbBrowser_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
09:34:43,634 INFO [STDOUT] === 2011-03-22 09:34:43,634 [80-2] DEBUG SQLDataSource - [builtinApplication.ANIMALS-dbBrowser_fetch] Eval'd row count query: SELECT COUNT(*) FROM PUBLIC.ANIMALS WHERE ('1'='1')
09:34:43,634 INFO [STDOUT] === 2011-03-22 09:34:43,634 [80-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ANIMALS-dbBrowser_fetch] DriverManager fetching connection for HSQLDB via jdbc url jdbc:hsqldb:hsql://localhost/isomorphic
09:34:43,634 INFO [STDOUT] === 2011-03-22 09:34:43,634 [80-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ANIMALS-dbBrowser_fetch] Passing JDBC URL only to getConnection
09:34:43,636 INFO [STDOUT] === 2011-03-22 09:34:43,636 [80-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ANIMALS-dbBrowser_fetch] Returning unpooled Connection
09:34:43,636 INFO [STDOUT] === 2011-03-22 09:34:43,636 [80-2] INFO SQLDriver - [builtinApplication.ANIMALS-dbBrowser_fetch] Executing SQL query on 'HSQLDB': SELECT COUNT(*) FROM PUBLIC.ANIMALS WHERE ('1'='1')
09:34:43,637 INFO [STDOUT] === 2011-03-22 09:34:43,637 [80-2] DEBUG SQLDataSource - [builtinApplication.ANIMALS-dbBrowser_fetch] Using SQL Limit query
09:34:43,638 INFO [STDOUT] === 2011-03-22 09:34:43,638 [80-2] DEBUG SQLDataSource - [builtinApplication.ANIMALS-dbBrowser_fetch] SQL windowed select rows 0->75, result size 75. Query: SELECT LIMIT 0 75 ANIMALS.PICTURE, ANIMALS.INFORMATION, ANIMALS.LIFESPAN, ANIMALS.DIET, ANIMALS.STATUS, ANIMALS.SCIENTIFICNAME, ANIMALS.COMMONNAME FROM PUBLIC.ANIMALS WHERE ('1'='1')
09:34:43,638 INFO [STDOUT] === 2011-03-22 09:34:43,638 [80-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ANIMALS-dbBrowser_fetch] DriverManager fetching connection for HSQLDB via jdbc url jdbc:hsqldb:hsql://localhost/isomorphic
09:34:43,638 INFO [STDOUT] === 2011-03-22 09:34:43,638 [80-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ANIMALS-dbBrowser_fetch] Passing JDBC URL only to getConnection
09:34:43,639 INFO [STDOUT] === 2011-03-22 09:34:43,639 [80-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ANIMALS-dbBrowser_fetch] Returning unpooled Connection
09:34:43,642 INFO [STDOUT] === 2011-03-22 09:34:43,642 [80-2] INFO DSResponse - [builtinApplication.ANIMALS-dbBrowser_fetch] DSResponse: List with 29 items
09:34:43,644 INFO [STDOUT] === 2011-03-22 09:34:43,644 [80-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
09:34:43,644 INFO [STDOUT] === 2011-03-22 09:34:43,644 [80-2] DEBUG RPCManager - non-DMI response, dropExtraFields: false

**aarontsmith** · 22 Mar 2011, 09:14

I have been able to capture a possible error in the developer console:

13:12:27.549:MUP0:WARN:Log:TypeError: this.$73w is not a function
HTMLFlow.modifyContent()
Canvas._completeHTMLInit()
Canvas.draw()
Class.invokeSuper(_1=>null, _2=>"draw")
Class.Super(_1=>"draw", _2=>{Obj})
HTMLFlow.draw()
Layout.layoutChildren("initial draw")
Layout.drawChildren()
Canvas.draw()
Layout.layoutChildren("initial draw")
Layout.drawChildren()
Canvas.draw()
Layout.layoutChildren("initial draw")
Layout.drawChildren()
Canvas.draw()
Layout.layoutChildren("initial draw", undef, undef, undef, undef, undef, undef, undef)
Class.invokeSuper(_1=>{Obj}, _2=>"layoutChildren", _3=>"initial draw", _4=>undef, _5=>undef, _6=>undef)
Window.layoutChildren("initial draw")
Layout.drawChildren()
Canvas.draw(undef, undef, undef, undef, undef, undef, undef, undef)
Class.invokeSuper(_1=>{Obj}, _2=>"draw", _3=>undef, _4=>undef, _5=>undef, _6=>undef)
Window.draw()
[c]Class.init(=>{Obj}, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef, undefined=>undef)
Class.completeCreation({Obj}, undef, undef, undef, undef, undef, undef, undef, undef, undef, undef, undef, undef)
[c]Class.create(_1=>{Obj})
VisualBuilder.makeDSEditor()
VisualBuilder.showDSEditor({Obj}, true, undef)
DSWizard.showDSEditor({Obj}, true, undef)
unnamed({Obj})
[c]Class.fireCallback(_1=>function (_10), _2=>"node", _3=>[object Array], _4=>{Obj}, _5=>undef)
[c]Class.fireCallback(_1=>function (_10), _2=>"node", _3=>[object Array])
unnamed({Obj})
[c]Class.fireCallback(_1=>function (_6), _2=>"node", _3=>[object Array], _4=>{Obj}, _5=>undef)
[c]Class.fireCallback(_1=>function (_6), _2=>"node", _3=>[object Array])
unnamed({Obj}, undef)
StatefulCanvas.handleActivate({Obj}, undef)
StatefulCanvas.handleClick({Obj}, undef)
[c]EventHandler.bubbleEvent(_1=>{Obj}, _2=>"click")
[c]EventHandler.handleClick(_1=>{Obj})
EventHandler._handleMouseUp([object MouseEvent], undef)
[c]EventHandler.handleMouseUp(_1=>[object MouseEvent])
[c]EventHandler.dispatch(_1=>isc_c_EventHandler_handleMouseUp, _2=>[object MouseEvent])
anonymous([object MouseEvent])
unnamed()

**aarontsmith** · 22 Mar 2011, 09:27

13:25:52,539 ERROR [STDERR] log4j:ERROR A "org.jboss.logging.appender.FileAppender" object is not assignable to a "org.apache.log4j.Appender" variable.
13:25:52,539 ERROR [STDERR] log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
13:25:52,539 ERROR [STDERR] log4j:ERROR [WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
----------> Parent Classloader:
java.net.FactoryURLClassLoader@5ec60ee2
] whereas object of type
13:25:52,539 ERROR [STDERR] log4j:ERROR "org.jboss.logging.appender.FileAppender" was loaded by [org.jboss.system.server.NoAnnotationURLClassLoader@e05d173].
13:25:52,539 ERROR [STDERR] log4j:ERROR Could not instantiate appender named "FILE".
13:25:52,628 INFO [STDOUT] === 2011-03-22 13:25:52,628 [80-6] DEBUG SQLDataSource - [builtinApplication.biu_folder-dbBrowser_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
13:25:52,629 INFO [STDOUT] === 2011-03-22 13:25:52,629 [80-6] DEBUG SQLDataSource - [builtinApplication.biu_folder-dbBrowser_fetch] Eval'd row count query: SELECT COUNT(*) FROM public.biu_folder WHERE ('1'='1')
13:25:52,629 INFO [STDOUT] === 2011-03-22 13:25:52,629 [80-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.biu_folder-dbBrowser_fetch] DriverManager fetching connection for PostgreSQL via jdbc url jdbc:postgresql://localhost:5432/pdmsTest?user=postgres&password=admin
13:25:52,629 INFO [STDOUT] === 2011-03-22 13:25:52,629 [80-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.biu_folder-dbBrowser_fetch] Passing JDBC URL only to getConnection
13:25:52,642 INFO [STDOUT] === 2011-03-22 13:25:52,641 [80-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.biu_folder-dbBrowser_fetch] Returning pooled Connection
13:25:52,642 INFO [STDOUT] === 2011-03-22 13:25:52,642 [80-6] INFO SQLDriver - [builtinApplication.biu_folder-dbBrowser_fetch] Executing SQL query on 'PostgreSQL': SELECT COUNT(*) FROM public.biu_folder WHERE ('1'='1')
13:25:52,652 INFO [STDOUT] === 2011-03-22 13:25:52,652 [80-6] DEBUG SQLDataSource - [builtinApplication.biu_folder-dbBrowser_fetch] Using SQL Limit query
13:25:52,652 INFO [STDOUT] === 2011-03-22 13:25:52,652 [80-6] DEBUG SQLDataSource - [builtinApplication.biu_folder-dbBrowser_fetch] SQL windowed select rows 0->75, result size 75. Query: SELECT biu_folder.id, biu_folder.electricity_cost, biu_folder.rollups, biu_folder.level, biu_folder.folder_personality, biu_folder.folder_type, biu_folder.parentaccount, biu_folder.parent_id FROM public.biu_folder WHERE ('1'='1') OFFSET 0 LIMIT 75
13:25:52,653 INFO [STDOUT] === 2011-03-22 13:25:52,653 [80-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.biu_folder-dbBrowser_fetch] DriverManager fetching connection for PostgreSQL via jdbc url jdbc:postgresql://localhost:5432/pdmsTest?user=postgres&password=admin
13:25:52,653 INFO [STDOUT] === 2011-03-22 13:25:52,653 [80-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.biu_folder-dbBrowser_fetch] Passing JDBC URL only to getConnection
13:25:52,671 INFO [STDOUT] === 2011-03-22 13:25:52,671 [80-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.biu_folder-dbBrowser_fetch] Returning pooled Connection
13:25:52,683 INFO [STDOUT] === 2011-03-22 13:25:52,683 [80-6] INFO DSResponse - [builtinApplication.biu_folder-dbBrowser_fetch] DSResponse: List with 34 items
13:25:52,684 INFO [STDOUT] === 2011-03-22 13:25:52,684 [80-6] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
13:25:52,685 INFO [STDOUT] === 2011-03-22 13:25:52,685 [80-6] DEBUG RPCManager - non-DMI response, dropExtraFields: false

**Isomorphic** · 23 Mar 2011, 01:43

You need the HTMLFlow patch in the Addendums forum. However, you should first read the QuickStart Guide. If you are new to SmartGWT you're probably going down the wrong path by looking at DataSource wizards. The Server Framework chapter explains what approaches to take.

**aarontsmith** · 23 Mar 2011, 05:49

Originally posted by Isomorphic

You need the HTMLFlow patch in the Addendums forum. However, you should first read the QuickStart Guide. If you are new to SmartGWT you're probably going down the wrong path by looking at DataSource wizards. The Server Framework chapter explains what approaches to take.

Thank you for your help. I am extending a current J2EE/ICEFACES application to use smartgwt and am connecting into our postgres database. I was wanting to use the datasource wizard to automate the creation of the XML files from our db schema....

**Isomorphic** · 23 Mar 2011, 07:25

Yes, and this is why you need to read the QuickStart Guide, because there is a better way to derive DataSources from database schema.

**aarontsmith** · 23 Mar 2011, 07:30

Originally posted by Isomorphic

Yes, and this is why you need to read the QuickStart Guide, because there is a better way to derive DataSources from database schema.

Yes, but I don't want to buy the batch tool ;)

**Isomorphic** · 23 Mar 2011, 08:07

More than one method is discussed - autoDeriveSchema - opening paragraph of Server Framework chapter.

**aarontsmith** · 23 Mar 2011, 08:09

Originally posted by Isomorphic

More than one method is discussed - autoDeriveSchema - opening paragraph of Server Framework chapter.

I am using this already. I just have a lot things I need to override.

Oh well....

Thank you for your help.

**tece321** · 29 Mar 2011, 09:03

Followup to:

Originally posted by aarontsmith

SmartGWT 2.4 running in JBOSS 4.2.3
Firefox or Chrome

I cannot get new from the DataSources window in the VisualBuilder
to work. I get to step three, just after selecting "use an existing table".
When I click Next, all that I see is a small rectangle towards the bottom
of the screen. The shading on the screen is inverted to the screen
underneath. There are no errors on the AS nor in the developers console.

The application is run the stock built-in-ds sample code.

I can browse the HSQLDB just fine.

Am also a newbee.
1. Using SmartGwtPower 2.4 release
2. Have updated HTMLFlow Patch as reference in

Originally posted by Isomorphic

You need the HTMLFlow patch in the Addendums forum. However, you should first read the QuickStart Guide. If you are new to SmartGWT you're probably going down the wrong path by looking at DataSource wizards. The Server Framework chapter explains what approaches to take.

Whereas in your responses you seem to infer that the autoDeriveSchema should be used, and to read the StartUp Guide Chapter 8, both of which I've done, I just want to know why the Visual Builder may be failing to get beyond step 3. Why isn't this working?

I recently purchased full support, should I be addressing these questions differently than on the forum?

Here is a copy of what the Developer Console reports when VB hangs:

=== 2011-03-29 12:43:32,566 [l0-0] INFO SQLWhereClause - [builtinApplication.Block_Instance-dbBrowser_fetch] empty condition
=== 2011-03-29 12:43:32,566 [l0-0] INFO SQLDataSource - [builtinApplication.Block_Instance-dbBrowser_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
=== 2011-03-29 12:43:32,566 [l0-0] DEBUG SQLDataSource - [builtinApplication.Block_Instance-dbBrowser_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
=== 2011-03-29 12:43:32,566 [l0-0] DEBUG SQLDataSource - [builtinApplication.Block_Instance-dbBrowser_fetch] Eval'd row count query: SELECT COUNT(*) FROM Block_Instance WHERE ('1'='1')
=== 2011-03-29 12:43:32,566 [l0-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Block_Instance-dbBrowser_fetch] DriverManager fetching connection for BEER via jdbc url jdbc:mysql://phpmyadmin.and.broadcom.com:3310/BEER
=== 2011-03-29 12:43:32,566 [l0-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Block_Instance-dbBrowser_fetch] Passing credentials getConnection separately from JDBC URL
=== 2011-03-29 12:43:32,574 [l0-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Block_Instance-dbBrowser_fetch] Returning pooled Connection
=== 2011-03-29 12:43:32,574 [l0-0] DEBUG SQLTransaction - [builtinApplication.Block_Instance-dbBrowser_fetch] Started new BEER transaction "823181209"
=== 2011-03-29 12:43:32,574 [l0-0] INFO SQLDriver - [builtinApplication.Block_Instance-dbBrowser_fetch] Executing SQL query on 'BEER': SELECT COUNT(*) FROM Block_Instance WHERE ('1'='1')
=== 2011-03-29 12:43:32,575 [l0-0] DEBUG SQLDataSource - [builtinApplication.Block_Instance-dbBrowser_fetch] Using SQL Limit query
=== 2011-03-29 12:43:32,575 [l0-0] DEBUG SQLDataSource - [builtinApplication.Block_Instance-dbBrowser_fetch] SQL windowed select rows 0->75, result size 75. Query: SELECT Block_Instance.Instance, Block_Instance.idBlock_Instance, Block_Instance.Project_idProject, Block_Instance.Block_Name_idBlock_Name FROM Block_Instance WHERE ('1'='1') LIMIT 0, 75
=== 2011-03-29 12:43:32,577 [l0-0] INFO DSResponse - [builtinApplication.Block_Instance-dbBrowser_fetch] DSResponse: List with 23 items
=== 2011-03-29 12:43:32,577 [l0-0] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2011-03-29 12:43:32,577 [l0-0] DEBUG SQLTransaction - Committing BEER transaction "823181209"
=== 2011-03-29 12:43:32,578 [l0-0] DEBUG SQLTransaction - Ending BEER transaction "823181209"
=== 2011-03-29 12:43:32,578 [l0-0] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2011-03-29 12:43:32,579 [l0-0] INFO Compression - /beer/tools/visualBuilder/vbOperations.jsp: 2693 -> 494 bytes
=== 2011-03-29 12:43:42,095 [l0-0] INFO RequestContext - URL: '/beer/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16': Safari with Accept-Encoding header
=== 2011-03-29 12:43:42,099 [l0-0] INFO Compression - /beer/sc/IDACall: 81 -> 86 bytes
=== 2011-03-29 12:43:42,141 [l0-0] INFO RequestContext - URL: '/beer/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16': Safari with Accept-Encoding header
=== 2011-03-29 12:43:42,156 [l0-0] INFO Compression - /beer/sc/IDACall: 146317 -> 11754 bytes
=== 2011-03-29 12:49:52,735 [l0-0] INFO RequestContext - URL: '/beer/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16': Safari with Accept-Encoding header
=== 2011-03-29 12:49:52,750 [l0-0] INFO Compression - /beer/sc/IDACall: 81 -> 86 bytes
=== 2011-03-29 12:49:52,770 [l0-0] INFO RequestContext - URL: '/beer/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16': Safari with Accept-Encoding header

**Isomorphic** · 29 Mar 2011, 10:05

To actual use the HTMLFlow patch with Visual Builder, you need to put it into Visual Builder's bootstrap file, not just the bootstrap file for your application.

This can be found in smartgwtee.jar. But the simplest thing is to download a recent nightly for now, where the patch is already applied to all tools.

**aarontsmith** · 29 Mar 2011, 11:18

Originally posted by Isomorphic

To actual use the HTMLFlow patch with Visual Builder, you need to put it into Visual Builder's bootstrap file, not just the bootstrap file for your application.

This can be found in smartgwtee.jar. But the simplest thing is to download a recent nightly for now, where the patch is already applied to all tools.

It works,
Thank you

**tece321** · 30 Mar 2011, 12:01

Originally posted by Isomorphic

To actual use the HTMLFlow patch with Visual Builder, you need to put it into Visual Builder's bootstrap file, not just the bootstrap file for your application.

This can be found in smartgwtee.jar. But the simplest thing is to download a recent nightly for now, where the patch is already applied to all tools.

This also works for me, after I figured out I needed to edit the index.jsp file in application/tools/visualBuilder area.

It would be nice if instructions were less terse and more explicit for newbees.

Announcement

DataSource Wizards fails on step 3

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment