B4J Question [SOLVED] Pakai 5: Sometimes clicking Home from Categories does not list Products..

[Mashiane]

Greetings

I'm testing the latest version of Pakai framework. Beautiful work as always.

Ive managed to add a product and also another category. However Ive noted that at times, when clicking Home from the Category screen here...

Does not load the Products.. (its on and off)

How can I solve this...

Thanks in advance...

PS: I am including an error log from running the app, perhaps that could shed some light on what could be happening...

 

[aeric]

Greetings

I'm testing the latest version of Pakai framework. Beautiful work as always.

Ive managed to add a product and also another category. However Ive noted that at times, when clicking Home from the Category screen here...

View attachment 166972

Does not load the Products.. (its on and off)

How can I solve this...

View attachment 166971


Thanks in advance...

PS: I am including an error log from running the app, perhaps that could shed some light on what could be happening...

If you inspect, any error in the Console?

 

[Mashiane]

If you inspect, any error in the Console?

Nope... seems to be working fine now. Perhaps it was my computer..

SSL is disabled
2025-09-17 22:05:31.908:INFO :oejs.Server:main: jetty-11.0.9; built: 2022-03-30T17:44:47.085Z; git: 243a48a658a183130a8c8de353178d154ca04f04; jvm 19.0.2+7-44
2025-09-17 22:05:32.035:INFO :oejss.DefaultSessionIdManager:main: Session workerName=node0
2025-09-17 22:05:32.063:INFO :oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@4fe767f3{/,file:///C:/b4J/Workspace/PakaiTest/Objects/www/,AVAILABLE}
2025-09-17 22:05:32.111:INFO :oejs.RequestLogWriter:main: Opened C:\b4J\Workspace\PakaiTest\Objects\logs\b4j-2025_09_17.request.log
2025-09-17 22:05:32.268:INFO :oejs.AbstractConnector:main: Started ServerConnector@26ba2a48{HTTP/1.1, (http/1.1)}{0.0.0.0:8080}
2025-09-17 22:05:32.285:INFO :oejs.Server:main: Started Server@49fc609f{STARTING}[11.0.9,sto=0] @769ms
EndsMeet server (version = 1.20) is running on port 8080
App version: 5.20
Open the following URL from your web browser
http://127.0.0.1:8080
Checking database...
SQLite database found!
GET: /api/categories
GET: /api/find
GET: /api/categories
GET: /api/find
GET: /api/categories
GET: /api/categories
GET: /api/find
POST: /api/products
GET: /api/categories
GET: /api/categories
GET: /api/find
GET: /api/categories
GET: /api/categories
GET: /api/find
GET: /api/categories
GET: /api/categories
GET: /api/find
GET: /api/categories
GET: /api/categories
GET: /api/find
GET: /api/categories
GET: /api/categories
GET: /api/find
GET: /api/categories

Also nothing on the web console.

Thanks..

 

[Mashiane]

Please see this when doing hard refresh also....

 

[aeric]

Try this MiniORMUtils.

 

[Mashiane]

It's solved thanks, however just noted this on the logs... please take a look...

 

[aeric]

It's solved thanks, however just noted this on the logs... please take a look...

I am unable to reproduce the error but I will take note on this issue.

 

[aeric]

Comment/Delete DB.Close in GetCategories sub.

Private Sub GetCategories
    Log($"${Request.Method}: ${Request.RequestURI}"$)
    DB.SQL = Main.DBOpen
    DB.Table = "tbl_categories"
    DB.Query
    HRM.ResponseCode = 200
    HRM.ResponseData = DB.Results2
    ReturnApiResponse
    'DB.Close
End Sub

[SOLVED] stmt pointer is closed

I am getting this error in Release but not during Debug in my Web API Template when calling an API using ajax. I am using SQLite database. (SQLException) java.sql.SQLException: stmt pointer is closed Private Sub Search (SearchForText As String) Dim con As SQL = Main.DB.GetConnection...

www.b4x.com

 

[aeric]

I will also try to update the JS.

 

[aeric]

New version: 5.30
Fixed this issue when running on release mode.

[Project Template] Pakai Server v5

Pakai Server Version 5.30 GitHub: https://github.com/pyhoon/pakai-server-b4j Template: Pakai Server (5.30).b4xtemplate Depends on: EndsMeet.b4xlib (v1.30) WebApiUtils.b4xlib (v5.30) MiniORMUtils.b4xlib (v3.70) sqlite-jdbc-3.7.2.jar mysql-connector-j-9.3.0.jar mariadb-java-client-3.5.6.jar...

www.b4x.com