B4J Tutorial [Server] Building web servers with B4J - Erel    Sep 1, 2021   (31 reactions)   tags: server, Erel code in Debug mode the handlers will always run in the main thread. Datebase Connections Pooling... B4J Question java.sql.SQLNonTransientConnectionException - EnriqueGonzalez (first post)    Oct 11, 2023   (2 reactions) Server app is to be 24\7 working... if it is a serverapp then you have to use a ConnectionPool, https://www.b4x.com/android/forum/threads/server-building-web-servers-with-b4j.37172/#content look for Datebase Connections Pooling... B4J Question How to query Sqlite on my VPS - moster67    Jun 5, 2019 I have set up a website on my VPS (running Ubuntu with a B4JServer). For this test-project, I used Sqlite.
Normally I use DB Browser for Sqlite but that means I must download the DB locally and then open it. To do that, I must stop the server which I prefer not to do...
Thus, I am wondering if it is possible to query the Sqlite datebase from a shell?
Thanks.... B4A Question SQL Convert String to Date - emexes (first post)    Feb 3, 2020 my datebase is
Always makes me smile when typo is a better fit than the intended word ✌... B4A Question Mysql JRDC Date problem - John Decowski    Dec 29, 2019 I have a mySql datebase with a date/time field. When i view it in mysql it views as a date fine. I can even add to the date fine with JRDC. But the problem happens when I query the results from JRDC to my android app I get some weird long integer that doesn't resemble a date at all. for instance my sql says field value is: 2012-12-19 00:00:00 comes back as : 1355875200000 Every other field returns fine. Just issue with the date/ time field. sorry if this issue has been already address... B4A Question ContactsUtils lib cannot add pnone - hzytsoft (first post)    Dec 11, 2013 maybe android 2.x ‘s datebase in not same as above ver this is my contacts2.db... Wish New forum for beginners? - Erel (first post)    Dec 15, 2013   (3 reactions) Here is the games forum: http://www.b4x.com/search?query=Games Database forum: http://www.b4x.com/search?query=Datebase GPS forum: http://www.b4x.com/search?query=GPS ;)... B4A Question Check log error Application - lucasheer (first post)    Jan 7, 2020 I may be wrong, but I don't believe crash reports are accessible in android. It might be a developer feature, I'm not sure. I think the easiest way would be to debug your client's phone and check the errors through the compiler. Or use try/catch, and log to a file whenever an exception is thrown. ex. File.WriteString(File.DirRootExternal, "log.txt", "SendFileToDatebase args: " & param1 & "," & param2 & " " & DateTime.Date... B4A Question Need to get Bmp from content URI - Steini1980 (first post)    Feb 9, 2015 Unfortunately I have no access to the customers device, so I can't Use debugging to find out the what's wrong. The only way is to deliver a new release and waiting for response. In case of an error currently I receive an E-Mail containiing App and Androcd Version, the Memo content and my Application sqlite Datebase. Which information is also important?... B4J Question [Web App] MS SqlServer App - billzhan (first post)    May 15, 2014   (1 reaction) 'in main module Private sql1 As SQL 'change to Public sql1 As SQL 'in handler use main.sql1 If you have high concurrent queries, it's better to use ConnectionPool to manage. See Datebase Connections Pooling section. You can find example of a mysql db(handler,not websocket) here. A simple demo for text input attached.... Page: 1   2   |