B4J Question Next Reports (Lesson 6. [ABMaterial] For Dummies (beginner lessons))

boontong

Member
Dear Expert,

I am a beginner with B4x and have minimum knowledge in Java. I come from MS Access, VBA and VB6 background. I am now trying with B4j, I am sure it is very very good and appropriate for me to upgrade to web and app application development.

I am now stuck in next report of lesson 6. I have installed/put everything as instructed by Harris in the lesson, but when I try to run the report (vehicle list) from the Application/Report Pages, when I choose PDF and Run Report, nothing happens, next report page remains blank. When I choose html, the application crashes, I have made some screenshots, show below. Please advise, where is my mistake!

IDE screenshot after selectiing PDF output for report:
1678697309360.jpeg


web crash after selecting html as output for report

html.jpg


B4j IDE after selecting html

html_b4j.jpg
 

DonManfred

Expert
Licensed User
Longtime User
Please post errors as TEXT instead of Images. Right click to copy the full error.

Additional a small project showing the problem may help. Upload a small project showind the problem.
Noone can help without knowing the code used.
 
Last edited:
Upvote 0

boontong

Member
Sorry DonManfred, I think the textual explanation of problem, as I put above the pictures, should give understanding of problems. But I was doubt how to give more information, of course I could put in the attachment, so that it does not look too overwhelmed. The code I use here is exactly from the Lesson 6 from the ABMaterial] For Dummies (beginner lessons), I am just trying to run it, learning from it and see how it works. But unfortunately, this time I can not get it worked, I don't know where is my mistake.
 
Upvote 0

boontong

Member
Sorry for inconvenience, I will start describing problem again:

I am now stuck for the next report of lesson 6. I have installed/put everything as instructed by Harris in the lesson, but when I try to run the report (vehicle list) from the Application/Report Pages, when I choose PDF and Run Report, nothing happens, next report page remains blank.

Whole logs shown below:

B4X:
init mysql
2023-03-14 02:38:17.408:INFO :cmvl.MLog:MLog-Init-Reporter: MLog clients using slf4j logging.
2023-03-14 02:38:18.120:INFO :cmvc.C3P0Registry:main: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
loading D:\ABMATE~2\lesson6\Objects: copymewithjar.needs...
Using cache system: 3.0
Current App version: 1678685396761
Needs material/awesome icons
GZipping HTML, JavaScript and CSS files...
Optimizing new and updated PNG files...
Building core.min.1678685396761.css...
2023-03-14 02:38:20.391:INFO :oejs.Server:main: jetty-11.0.9; built: 2022-03-30T17:44:47.085Z; git: 243a48a658a183130a8c8de353178d154ca04f04; jvm 11.0.1+13
2023-03-14 02:38:20.463:INFO :oejss.DefaultSessionIdManager:main: Session workerName=node0
2023-03-14 02:38:20.673:INFO :oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@49cb9cb5{/,file:///D:/ABMaterialForDummies1/lesson6/Objects/www/,AVAILABLE}
2023-03-14 02:38:20.677:INFO :oejs.RequestLogWriter:main: Opened D:\ABMaterialForDummies1\lesson6\Objects\logs\b4j-2023_03_13.request.log
2023-03-14 02:38:20.691:INFO :oejs.AbstractConnector:main: Started ServerConnector@64b0598{HTTP/1.1, (http/1.1)}{0.0.0.0:51045}
2023-03-14 02:38:20.696:INFO :oejs.Server:main: Started Server@662706a7{STARTING}[11.0.9,sto=0] @3623ms
2023-03-14 02:38:20.698:INFO :oejs.Server:main: Stopped Server@662706a7{STOPPING}[11.0.9,sto=0]
2023-03-14 02:38:20.702:INFO :oejs.AbstractConnector:main: Stopped ServerConnector@64b0598{HTTP/1.1, (http/1.1)}{0.0.0.0:51045}
2023-03-14 02:38:20.704:INFO :oejsh.ContextHandler:main: Stopped o.e.j.s.ServletContextHandler@49cb9cb5{/,file:///D:/ABMaterialForDummies1/lesson6/Objects/www/,STOPPED}
2023-03-14 02:38:20.724:INFO :oejs.Server:main: jetty-11.0.9; built: 2022-03-30T17:44:47.085Z; git: 243a48a658a183130a8c8de353178d154ca04f04; jvm 11.0.1+13
2023-03-14 02:38:20.726:INFO :oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@49cb9cb5{/,file:///D:/ABMaterialForDummies1/lesson6/Objects/www/,AVAILABLE}
2023-03-14 02:38:20.727:INFO :oejs.RequestLogWriter:main: Opened D:\ABMaterialForDummies1\lesson6\Objects\logs\b4j-2023_03_13.request.log
2023-03-14 02:38:20.727:INFO :oejss.DefaultSessionIdManager:main: Session workerName=node0
2023-03-14 02:38:20.730:INFO :oejs.AbstractConnector:main: Started ServerConnector@64b0598{HTTP/1.1, (http/1.1)}{0.0.0.0:51045}
2023-03-14 02:38:20.730:INFO :oejs.Server:main: Started Server@662706a7{STARTING}[11.0.9,sto=0] @3658ms
  ----ContPage view ws Connected
Waiting for value (4 ms)
 page Disconnected
Connected
Waiting for value (2 ms)
Waiting for value (1 ms)
Waiting for value (0 ms)
Disconnected
Home Page Connected
Waiting for value (0 ms)
UpdateFromCache: HomePage3820149f-7c4c-448f-b92d-2ddddefe6094
Saving the first instance
Waiting for value (0 ms)
Websocket first connection
Waiting for value (2 ms)
  -- This Page ID: HomePage3820149f-7c4c-448f-b92d-2ddddefe6094
 *** Page Event name: page_navigationbarclicked  (MyMap) {eventparams=action,value, action=Login, value=, eventname=page_navigationbarclicked}
Waiting for value (1 ms)
 *** Page Event name: page_modalsheetready  (MyMap) {eventparams=modalsheetname, eventname=page_modalsheetready, modalsheetname=login}
 *** Page Event name: logininp1_gotfocus  (MyMap) {eventparams=, eventname=logininp1_gotfocus}
 *** Page Event name: logininp1_lostfocus  (MyMap) {eventparams=, eventname=logininp1_lostfocus}
 *** Page Event name: logininp1_gotfocus  (MyMap) {eventparams=, eventname=logininp1_gotfocus}
 *** Page Event name: logininp1_lostfocus  (MyMap) {eventparams=, eventname=logininp1_lostfocus}
 *** Page Event name: logininp1_gotfocus  (MyMap) {eventparams=, eventname=logininp1_gotfocus}
 *** Page Event name: logininp1_lostfocus  (MyMap) {eventparams=, eventname=logininp1_lostfocus}
 *** Page Event name: logininp2_gotfocus  (MyMap) {eventparams=, eventname=logininp2_gotfocus}
 *** Page Event name: logininp2_lostfocus  (MyMap) {eventparams=, eventname=logininp2_lostfocus}
 *** Page Event name: loginbtn_clicked  (MyMap) {eventparams=target, eventname=loginbtn_clicked, target=login-footer-loginbtn}
Waiting for value (1 ms)
2023-03-14 02:39:10.733:INFO :cmvci.AbstractPoolBackedDataSource:pool-1-thread-3: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hgektnau1p6bitq1dpu2b0|436a4e4b, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgektnau1p6bitq1dpu2b0|436a4e4b, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost/bounthong?characterEncoding=utf8&useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {password=******, user=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
 Returned this user: (MyMap) {userid=11, username=Default Demo, userlogin=demo, userpassword=demo, usertype=1, useractive=0, userrows=9, comp_id=93, usertz=0, s1=img4.jpg, s2=null, s3=null, pic=ÿØÿàJFIF``ÿá"ExifMM*ÿÛC        

    
 ÿÛC ÿÀ¦"ÿÄ   
ÿĵ}!1AQa"q2¡#B±ÁRÑð$3br   
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÄ   
ÿĵw!1AQaq"2B¡±Á    #3RðbrÑ
$4á%ñ&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚâãäåæçèéêòóôõö÷øùúÿÚ?øA?ñ$´ÿ®+üªÕTÐÎ4k?úâ¿Ê×6§V¤l¿>OÝ¥Ú»r)dSæ§fLlÉÀ©bùÔ0¬êVv5«mFTþ5âZÆÿÙjÓGö»[¶£Gï©I#ëOéþyA·!¿Â½#ÀkIâxßhݯ|%ñÏÄ£o?~;gâ½SÂ?´6½mm#U#$ô¼    ÉÞÈúkâ´´49"oy¥Ç+a·;r    î+Î<sûIê,?hFÜÝ®Nßã^m{nSò`ÐÕb°¼ó¼Tå(+N,úCK8i.+VMdAdÞ[ßξv·øñ¬=¿Ê¶ùúTÿð¾õ<p2dzÖKR(ÎXªw²=î-jâv8ÏpÕ«n!±hú±ïùÒßöÔ¼¿øõýMhøk㦧k1Ûý    ;±Èà¿aR0%Vgêkq1Ûæ¬?J Þe¾_)»{Uí±C6ïfø¶P¼ÿ®f¼u=N«§±ñ׬WûFmßtÊÕ·d½mk¥¦¿O1¿eÜG·ë]ÿd
ò¢õÆïj®ñäÿ«XsLÛîkAϦtOùYÿ×þUr©è§Mýq_åV÷
òìÏB[F3@lÐNTLe¹ªÚ,èê~ë+æÿºgö_ ûÄ_Gxïì6v¶2µà|Ac¡M%æ æ¡rÁa»Èzp9®ª7ÎÉ>yX§ x¢?Û,ÅVY|±âíÿ×ü*7ñf¥ã«åY¦òá_*·×é×ð®Væãíw-.HÇÚºoB¤þ-ÜW34©7h¶ô9~uÔô/øN7UÕÄ©À ~9Ít·þźÍÏ姵Wð¾o¥vÖv&âÓh\çâÇZý¤fÏ©Z$¢Üó=ZI´Ëüj§ü$aò°ÞWyñÀÛDÐÇòÜIòÿÞÔWø3Æ3júmÒùÖ*wJxèÛH¯²É³ùâ}ÊÖºì~wdtðoìÏOµ½Êu¯Eø¤h]M;¯ÍÞ¸_èºIöà0}+²øeâ$Ñn¼Û÷lÄÁ¯R¶1I8£Á§FíHö¦ .8Åeø³iÐnÃÏ3Víõ%ºì²+3ÅSnÑ.ÿëWöÏN*ËCå]bÝMÛíÿY7¶þY%¸µ¨Ý±ÿ¦ýk/TÎEÎ2:×dº)sÆ
äùÔ;=ÿZâu½búÂþXüÂü¼æ¨ß/ü¼W>¤Çsí½þAõÅjÍUÑØdYÿ׫A³^|v;ìÅSRà 
Yµûâ¦RÜ¡âíµ6T.ÞNzWÄÿõÛâÚLͶÞPükm"îä©Ækâ_ÚOJþÆøÊÏ"ìY8÷9æ´©ðÒ¢Uýìt®ËÀÌ%]ËrrzW,?4
zê<+ã8ïp°^ÍÀýÒþCåÎõTÚVl÷ªÇp»ºH8=s^áè¡Ü~^µç>×ìuëHãY£nA&ݤv5ÒKâÏøE¬â?µ\Ã}¹õý=+T¾Ë=ªRJÒúW,$I¸?|ã_¯ÿh
XF<¥½.¶¯!w"Þ»ò¯ -üwâ/YIq>éø`þ\ÁÙp;¯QÎ:×øÿÁk?l®QqeH]ë±ÂÿWN]«WºêyÙÄV3
î£CáÝØ<7Ý<ó]-æ¹ñÇåíòÛ*3÷¸¬WËi-Ź޻O    ÄMµ?ú:k^ççÐ/»Øôí-8ïâPUñAÆwÿ\Z·ZÕv»Y~,¸ÆyÏü²5Ç^wf>g¿uIÿ]²5kH\æ®ê1i?ß&±õ%yb`Zî]ÂG¯iÿÚ7M$cvß±n4ÓüËê|©$ÝÅQºÒ&º}Ѧáë¸
tÞ¢w>½Ñÿägÿ\V)ÁªCcH³ÿ®+Vw
ó#±èKbPÙ©¡~xëUQêkUïqo¥SyÛzWÇ_ïÆ$¸¼æÖìÃéó?:úãSºdFQ¹Kc=@äþò¿ÅýÈñıñ±»?Ö±«&O,ör,×ÌÉÒ 3ùÊÑùgg¯µu?®uË}{Ie¶û÷
/£·UYâ?1ÉǦkÃÆñL¸Ý1¾â½ËÃbÜøJkãÜFHHPkÚCOª>SÊì¼[w§üHÚÒL,âÑñæ÷íà·Nìßü#yã
ÚóIHHþxã]ǧ\q^#ý¡Ö´×J»ÍÀ`2:×ÓÞÔ¥¿ð¬ËòãNÐx®j×ææ;p´T£*}7øcðêH|?£ØI|ñêl²þú4dëyé.N5Úxëëaªi²JÎnI#mѳ`þ**ÿ¼Y¥Íã£ZÒhäå_\óÓÿNøÕ¯ÛÙÃc4~Û
ZÕª-cOá~ø{Pk=]¤Î<ÜÈ×£ørus÷â¼²ì=QÕ©eÕrNkÐü¨¼VÝò²ä¾¥E(¯CóÆ\òvêzö-úÖgï±¢^<~|
u¬B?ÚéïY¾/nu»ûÔW,^¤j|÷y!²·©SKzµ¨×öÍUy«}
tÉÌè²,Ôoyå·ÈÙOZ¹"æm½sYÇPqZG`[cèògL³ÿ®+üªàlÖv*¾k÷a\þUm¤ë\1:ÔàÒ¼Tª$$ÔrÝ/+¹w`ñTD¯rïÖÛM¶ïRõ¯ñ&X¤ýÛÊýWé^6¿I£·VÝ!À}zW£Ú=òÉ3/1ÊG|éJQMÑæOCÈü1µfµö½¬Ì§?ÂqúWQñ3â¼z'môøá-5ÑÜHçÇñFñBâù#¾>~?J§ãÝ=u««±ùsZÉ_ßÅ*iKSܧZ¤ax³ÎûTÔåµ6ö×Ç#å}ÖõÏaø×µx_ľ8¿´ÒÝ=6·Êq\~ÏüÕᆵ¢éÚ¤)÷J7¸Â»[HSù×ÐÚÅ,´Ë¥ðÿ4áYçPÆ Ä8É*W·Ó*èuá£6¯&ÏñGÅýKJñ%µgÝ+¯qädg ÷õ¯Løa©x£KÑa´KUgyÁ$Ðrq\NµðòûV¹&ñMÒêzµö¯<¢/-D@0
ª¼(ÆÒ¾·ýmôX¼ñ.óTd³Òô(üÙÉ¿»:zsQ
|õ0GF3æ½¼Ïü[¥Þiw[ÍCq%ð û9Èìk£øe©}¡á!²ª?Zú£Æ±kücðþ¯6-åâÛ¥¬ïnø©Ë`½ð¬ËôUÏJóß°×?fã¡$7ÒÝ"%¹aÄr¨äózôªQDxuq¨.ÛÏû¸¾ã[ø]¹ýEi[/îcéòy¬Ú×ûÔV+}NCÁfrÓIþùª·o±ûU©l¯õÍQÕsöY1é]Qܧ6ûÙ>µî3SÞ³}º@}j«ýêèègÔûÃ÷9ÒmÛ<4Kº.2k/Ãà¶g·¯?ª4Û&OºêkìW4.õXìStg÷·SÖnõa£5Í    :rÿé+ ð÷c¾øo±ù×Í!gò"ÿÕxW_Zð´+äÆÓXíÞX篿ҴnöÄ3ŪF·ÁWÌP´öíW5/ì]FÞú1û©Ç1þ¤ãwëW> [¾¥g§ëîfÖ[NháÃGÓY³jԣܶÒ7ËaÀÏ·_¢ÖÆçþÒXâÓõXCm»È½}Â+Syduî-Ó6q½{{×Óðñÿu/ê;a½¸£2ÆÀöÉùÿÇÞ
GðÖkª[ÜZêú¿fteY;>ob¡¬ªQm^Æôkrè´«{iÝGûÆA¸ß®×á¿öÿ/f©»k\ÈÊwvàc=?ùæË]¼Ò~\2º@zVxëXá|»«xÔÁzçÍ;ôc{%f}y©jKâÿè~ÒV;OSºE8R ål    <ô¾¼øSû5ÍâEÑ|£jßxoKÕ\ñ^ºè©¡zjZÃnHöG&¼3þ    ]û\ø¥â'ÈrÜ0úÈärªËÇ®+ôwEÓôïø1®ì¶ze¤'Ê!´Ï×qçÖ½|¿.p<f~Ûá4ôéôÏZÛÛ¡[[q'ÆlÃéøÖ.ìüM§ê%½µä/ä²®x Î@í^qâ6ú^©xZo&ÇHÌä¶<¹9Ú^Ãò߶v¥ñËƲYxGk*Õ¹ãæçþ¹úõç§èÖOÁe8·©ó½æýyulѼrÙ9«u@ãó9Îø¾Em
èêÏzú³ã7Ák?jkâIµtg·,vRËÀüH¯¾&è}
ÔqÃ4e£uyx¦ã.çgÙ>|ýs}?gßÌ[©nÕvîL>ö@ñ÷O\Cõ¬
bf¶+¢'9ÇjrGöé9ïéTÀj»,;äïf©Ì7ÿZ¶Äõ>´ðþãáû2~U©&±¼W|ÚµøDVû<\d)æ®xZ9u«+[8[ky!çÏãÓµu¿®#11w±+óôÆzM-Ná×.|¨ÙÍ÷ãb0«ÞºÜÉðï[Óu«Y6iywS¸aäMo|ðâKÛȵ+?ôÅ+°È¤¾×ü}ðCjß    µ*K$¶¼Ò¬_PÓ])"!ÂÎv㯵mN.Ærø®yÃø*MWàl,öÍu«kï|ꤡ2qíÛµûGü8?f¼EU[G¼@?Ò½Cö1ßQðÅK¼ó4YfõÏyü:Ö?í 4ÿxÆêÊÏRîûOL\A,cú0>¯4cäõ*1åËsÄôC¨ê0´ÎˬÛäμ3Ñ[·µzí-û*k߶gt-OCm/MÕ$m¯LCì»ØAY,0~zs^kàM&Î/qMt
Í»2ùÆÃ,û¾Ù<ø<s_¡³ö¯cs Zëscoik`±ÝUKà*§Í^\fÓzâ¡:Nûü<ÿXøgÂQíÚë#+?Þ
áQÀÅtÿÁ14=CÆpObë«f´óÆXl×Ð:Ô&Öüyu5f;×°"á9ÈõÇÖS]¶øi=¼¶Ïq¨j;1·{sÚ»Qw±Çí§?ô/Xiü%g¤Û,ouHEÚ1Ù¦P¹Ý8®öøï'Ã
ÇæM
ÕíÁg·ÓÁýÜg»ûP*Y]|=Ôµ
{ÄDý¦Ñ120ÛÓå*ªO9lù/ã·Ä{ïYjZÝÖÖº¿ÞÙðî`ElTR´M#G]Aø§ãRoÙCCQ¿çSñ¾£%ôìãþY&Æ p¨    R¯ã[¿²ß£ðÁkÅ×ce
ÌÌ%»ek?öðâéWÃÌÕýwlGáSx¥o5Í+áÃËk
êPK]ä\K9oõUô¼¸ÔsÈÆÊç¸|
Ôa×üÞ }";búòKM>7Ú
¨Ì¤tdç8ç¤
ê¾!üÐõzµÇ`±ÕoîmÈbTB|ÂGî¢+Óõ{à¶cáï    MâYº=¤BËKÜ6¼Vjyr:ù>ç<gîúUß
¸øç¨G¬_*ÚèlÙ¶P:3g«gö®Øû8é-È{_¶§ì3©~αxOi5
êA#M¥³m+£/\?®2kæN"×Ðç×ü+öÓâoôz©á,ãÕ4}VÙí®s¸Àaß*@<zWã/Çß|øxgPaö"íà$õ©Uþ6¸öjʯ-ï)}4)$Vùw¥ql¬Ôí^õÅAYòjSùTÅ«
;Rx~Á~Ëk7%¸¸®ì{õÏ·×ÔzÛ,n£    ÉslÿÞÚzد Ðg
³r³G¾kÐüq:ê».VÝ÷_\sÑǤ¿/2å´û4'v¾c²ös[Àäô
kàj7y>VFxÔÄbè¬æPrAÏÔ~º¸Y£f¸¶XÓå3óqëÒ´¾%øËEÑþøó^VÆÖÆCu"0i$`(à± ¸ÍvBi+ÜçåmòüIý£/¾øgNðÿfXu)4ÑçÝæÞ)(UøÀò/ß/¼+æ¢÷S"F{òH=KË1Î?ä¼KâkÏëó_]L·R4H¥ã#0TÑVºmwI±á½»Kq5Æ$`¨kmYyïòÒ¼zÕ9¯sép18Øï>    |sM#Ì}?I>uôÒúB2[pÀ<óNõö×Ã_Ú?EGÓtoyÚmä    ü1ù±É ùVbënÜð+àÏÔ¤d(HÇʸû¸é^ûáTo>y6¬0mß¿Æ1ÿ×®<>.t'x#/*×>±ño%»°¼OôÛSåùm^Ƽûá¬ÚÇÁï.®&³ÖîæB¡¯WÍòý'¡xô¬Ù«âÕî¼Ú5FV=ª\ØH±òa2y{    öÜXø¡âl ¸ó'X£Ù¸³ª×§júuS§Í±ñUðn_dsþ.êß5O&òmÑ©Q+/]¼àûdWÎÿ¼t²øºÓJ×éóG3Ûr    íW¾#ül"_°ø~þ¼¸;e¹þzÆO¸¯ñþ¬xÄM©^5ÿö3CqÈbÊÀý3ýkƯ×CÕÁàRÖGÖÿiËðÞëìñéöú}¤°^Ä&óB¬¥Hldçç8=1ô®Ïàì~)è÷L̶VÚ*¸0ÚÄ×9äɶ¾ÇÍu£.uænó¼ØvLXãéÈæ½çö}øþÝ"xUøÜQAèEsÓ¯RöõjáhÔ$UÐÚ;Æk©¼?æ\Cj],<¤mµXPO=8¬?Îm-<1qq¬jVû® Òå&·Ï.6êy¯3øiã;íUtµ¸¾øCòµÃu"B9#þôoÃ[ÏøG,pèIkfÃXwø    ÉçÔW½ñçhù¬FT+5¼1àÖ¥Hôø4%b0kf]MÏY ÿº~µð_üàÞ×¼;ãCm-àþÉÔ$0$C<Rø+ôU¯Ñâ$7ùrXÍçGÀHÊ@1^ÿ5ø;~вΥh:Mæ¥â¸¶¹²µùUÈÄ(Ä{'µuT§¯ü\½×VâI(m¿{[ûE¸µRúÞm.æh.#¤¢H*Êy¥AæµpÊ6CçÙ<Jè¿(õj][ìø_kdc¶9ª0»ZضqUmîÖ{Ä·\ç¦{§ÁßÓL¶Ûq¶)ºö«ÿµFw©~Ì^0µäÕn0üXåIÿV®[áÃOmi¡±HÝ=ÁÝ& Ê~×ï¼9à¯
iÓî\åyòã¨Ü29õ©-§çt|¿¢Á®¡m7    à>Åz^¥¨Ûë©+qå¨é^ce¹ö¯÷È=ÍÇò®çá涣^¨ëÏðó§ö=ê5 § ø?Âb;¥¸÷1××jô
3t¢âÞ2¥0û¹üÆxë^tÿãð¤j>̧,ÀÜÌñ]ã©<QzÖºm¯4¿p±Çå×ð®oc&îÑè}f
iËû=Oô/x¢ð¨ReÒôÕþôPÒÉô/±yÇú¯B
yÏíqâKðþ;u
ÿKØíÆÕ
\óøW{§è«¡i6º,%ä·ÓP"î9à³3ø0o©üIøkoñ+ÀwZ<·íÞm¼«ÃC û¿à}«ÞÑR²>WÛ©×æ>^ñG®ü    ý©2¤~®
oû;¨#ê9®ÅÖ°xÏà´|¿ÚZLÑË«£3ô9®Wľ3<#«x[RQý©§^(F½+c꡾´ñZ[IoæohÈeõâ¼~WÌ{©    +Äæ.þìÉnö²y3IÏ'¯Jê<%æ¬-Ò¶ëSó'÷¸ÀÁè}xª~×!}zhnëb¤AàõËY³s#C0u^DÔéUSbùî}ðwÇ×Z't{ÈÝéó.@ûÄ7Éÿ³WÒGⶳ¬ÜÁc¥¯,à(ßÉÏ9úcÞ¾9øoy®kÑÜM¼Áo"6ü¯ÜsÓ¿}³û;ZiââKË#ùànzWf]µ£ÒçTS¨ìz¯Ã²øSJûMÕÄÀ;»}ÌúV÷diì&9Lry.í8?:-]Õ÷jÃõ¬ßÞ,Q>à[rzúOuBÈðe¹üóßiò2]7w+$d´Ëþ?Wûô®çãæømñKÄ~÷èúŦüÿHUâ æ¾Í^eAGsê
F>T
nrÒ¦oáVKÊÜ"ÿdµVâ1Y[råIÎ:b¹%ö=3G[ø¯ÿ6sy&oZ(Gè    àù×ê~"Ô<[®ÝjÓÝÝ]¾÷fíýо«Æ=k¾øÛc3xRÕcݹý·¤ó}-yºA?Óù×5X´õ=,Vì»d<u[9ǬÝÈR=9®åõÜøJ6^?3sé¼TFvÐÑÇ]
Oø÷S6vòmÙöÌ88Ï®kÚ>øMð4Ëqy ÿZãå»QÇyþ£«§f¶lX¹)é¨^ÐùCý=¢]Q<¶Ý$ïê¥evrVªÓå=V×ÅvöìÞIVf9þ#QZý¹®¢Uî¢EýÐ<g¯n¿pdoàHsõ©m~ÕÞd7·ÞÖ¼¶VG&ÇþÔ?
.n|cq®YÛHOâ(ðÇ8>\üÝ:còë!%1`ËÔÓ5ôÕåÜ×p×yªçï`q<5g¬øuáóñ.õ]ÓïÂTîµ:(ÖäÐò8,Ybfï·<éü¡Üj,#
ÎìÃ
NÇ5àí2;©$Fw/ ÆEwMêèZÛ¢³w +¤lzê¹hÏZø}â~5rCöë`.ãBIO§ê¯´<5á
/RðÖªiÿ¼ê»·o%×+qFAäzf¾³»þÓÇæ2rrqsǧã_nÿÁ<¼Vþ:ø5ÏÿsZºÓ!9ä.RTýß4¢×vS.iû6rç4R£íçu£øºkÝfVhø    /Í!íòÿN»YÔ
ÝNªcË4düØÇ¥jÙø~ÇûjI¦±f\m¿2d:ã±QøûB³úYÖ·mÿX©Ó¯á_A7>jMY3ñ?ö©Ö¡ñWí/ãëÔåÍ®]®@ã1Êbývø×,½?*ì~?xBûÀÿ|e¤ê´7V:Ýän,<÷*ÙÊC~"¹8þZóêFÍ îÇ^õwBÃäzbëVÒ\"ùsaó{ÑEgÑSÇ6¾-ðå¾&¢®Õèc¿P1ø×éð7þò+ý3EÏ[â;0íò¶ÚëSTÿ[Ã÷z©f³ITä)ÇëEÇ%ïÔ[#ýüjºu+;È|˦ÅòÎ;HÜÿ{Ïcø
ô+ZÃ6ý£ûª3EÝKá<Êß¡müÁòÜþKR·íÂýÛÉh¢´0BïÅpHX½®Wâ7?³|©Ï?<p6?ëE2ØÎOcÆô-ÊZMåºÍ2°>Ä×} øRÜnúEçÖ=º-Ùxâ='KëÉý£iȯ¬¿àÿ>Ïû<x¶þé®n$Ô¼[ut¹
|¯ôxF:ÑEteÇ2Í?}YeñRÎïYÞml²qõË_§åXº§ÅÛ=B&û=×ï    L\ôQ_YO©òµ~~sÿÁ]´}>/ÚÅ5}66·OhvºÑÀ"@ZÜÜ@ó¯6û(¯¾ìÚ=ÿÙ}
Disconnected
Connected
Waiting for value (0 ms)
UpdateFromCache: AboutPage2607af6f-91cf-4b0d-8d6e-afca8978d462
Saving the first instance
Waiting for value (5 ms)
Websocket first connection
 page: AboutPage
Waiting for value (1 ms)
  -- This Page ID: AboutPage2607af6f-91cf-4b0d-8d6e-afca8978d462
 *** Page Event name: page_navigationbarclicked  (MyMap) {eventparams=action,value, action=Tickets, value=../reportPage, eventname=page_navigationbarclicked}
Waiting for value (1 ms)
Disconnected
  ----reportPage view ws Connected
Waiting for value (1 ms)
UpdateFromCache: reportPage2ec38bb7-7edb-4a9a-9146-4ffaa31b714b
Saving the first instance
Waiting for value (2 ms)
Websocket first connection
 page: reportPage
Waiting for value (7 ms)
 Width: 1536  Height: 718
 Finished loading and connecting page
Waiting for value (3 ms)
Waiting for value (7 ms)
Waiting for value (5 ms)
reportPagereportPage2ec38bb7-7edb-4a9a-9146-4ffaa31b714b
 event name and params: btnrun_clicked  target
 event name and params: report_gotfocus 
 event name and params: report_lostfocus 
 event name and params: report_clicked  itemid
 What is report target: 3
 param map: (MyMap) {pk=3, repname=Vehicle List, repfile=vehlist, p1=1, p2=1, p3=1, p4=1, p5=1, comp_id=93, rtype=1}
Waiting for value (1 ms)
Waiting for value (7 ms)
Waiting for value (1 ms)
Waiting for value (5 ms)
Waiting for value (4 ms)
Waiting for value (2 ms)
Waiting for value (1 ms)
 event name and params: btnrun_clicked  target
path for images - updating histomast table: D:\ABMATE~2\lesson6\Objects\www\template\images\pics
Location = D:\ABMATE~2\lesson6\Objects\reports / vehlist
Output File = D:\ABMATE~2\lesson6\Objects\www\template\reportout/vehlist1678736386131
Waiting for value (1 ms)
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.thoughtworks.xstream.core.util.Fields (file:/D:/ABMaterialForDummies1/lesson6/Objects/Template.jar) to field java.util.Properties.defaults
WARNING: Please consider reporting this to the maintainers of com.thoughtworks.xstream.core.util.Fields
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
java.sql.SQLException: Access denied for user 'harris'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
    at ro.nextreports.integration.ReportSupport.createConnection(ReportSupport.java:41)
    at ro.nextreports.integration.ReportExec.reportPrepAndRun(ReportExec.java:87)
    at com.ab.template.reportpage._run_report(reportpage.java:898)
    at com.ab.template.reportpage._btnrun_clicked(reportpage.java:51)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:111)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:514)
    at anywheresoftware.b4a.keywords.Common.CallSubNew2(Common.java:469)
    at com.ab.template.reportpage._page_parseevent(reportpage.java:704)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:111)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:98)
    at anywheresoftware.b4j.object.WebSocketModule$Adapter$1.run(WebSocketModule.java:142)
    at anywheresoftware.b4a.keywords.SimpleMessageLoop.runMessageLoop(SimpleMessageLoop.java:47)
    at anywheresoftware.b4a.StandardBA.startMessageLoop(StandardBA.java:43)
    at anywheresoftware.b4j.object.WebSocketModule$Adapter$ThreadHandler.run(WebSocketModule.java:207)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
 file does not exist vehlist1678736386131.pdf
 event name and params: extrasidebar_closed

When I choose html, the application crashes, additional logs shown below:

B4X:
 event name and params: rg1_clicked  target
 event name and params: btnrun_clicked  target
path for images - updating histomast table: D:\ABMATE~2\lesson6\Objects\www\template\images\pics
Location = D:\ABMATE~2\lesson6\Objects\reports / vehlist
Output File = D:\ABMATE~2\lesson6\Objects\www\template\reportout/vehlist1678736853403
Waiting for value (2 ms)
java.sql.SQLException: Access denied for user 'harris'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
    at ro.nextreports.integration.ReportSupport.createConnection(ReportSupport.java:41)
    at ro.nextreports.integration.ReportExec.reportPrepAndRun(ReportExec.java:87)
    at com.ab.template.reportpage._run_report(reportpage.java:898)
    at com.ab.template.reportpage._btnrun_clicked(reportpage.java:51)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:111)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:514)
    at anywheresoftware.b4a.keywords.Common.CallSubNew2(Common.java:469)
    at com.ab.template.reportpage._page_parseevent(reportpage.java:704)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:111)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:98)
    at anywheresoftware.b4j.object.WebSocketModule$Adapter$1.run(WebSocketModule.java:142)
    at anywheresoftware.b4a.keywords.SimpleMessageLoop.runMessageLoop(SimpleMessageLoop.java:47)
    at anywheresoftware.b4a.StandardBA.startMessageLoop(StandardBA.java:43)
    at anywheresoftware.b4j.object.WebSocketModule$Adapter$ThreadHandler.run(WebSocketModule.java:207)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
 html file: D:\ABMATE~2\lesson6\Objects\www\template\reportout\vehlist1678736853403.html
 event name and params: page_visibilitystate  state
null
null
 event name and params: extrasidebar_closed
 
Upvote 0

Harris

Expert
Licensed User
Longtime User
I am now stuck in next report of lesson 6. I have installed/put everything as instructed by Harris in the lesson, but when I try to run the report (vehicle list) from the Application/Report Pages, when I choose PDF and Run Report, nothing happens, next report page remains blank. When I choose html, the application crashes, I have made some screenshots, show below. Please advise, where is my mistake!


I dont know what could be wrong. My example is rather simple. Have you tried with your own example from what you have learned from the lesson?

NextReports has always worked great for me. Very light and does the job, even for complex reports.
 
Upvote 0
Top