B4J Library [Web][ABMaterial] Framework for WebApps

Harris said:

Hello AB,

Just spent the past few days exploring the ABMaterial concept of web site creation.
Looks great to date! Your examples work well with static data (with very small issues - see my next post...).

Anyone considering avoiding the normal learning curve of JavaScript, HTML(5) and JQuery (to some extent), PHP (- not covered here...) and understands B4X shall find this most welcoming, as I have.

I know enough about each to completely bury myself in a never ending spiral of frustration!
I have explored many different frameworks only to realize that I cannot possibly learn (in short order) what it takes to create what my app demands.
I have also had to HACK into generated code to make it function as I wanted (ie. introduce a filter).

We need a B4C (client) and B4S (server). Or a B4J_CS (covers both).

However complicated it may first appear, following your well defined examples and tutorial makes it easier.
Without this knowledge of how to properly construct a (page, table, etc) one could get way off tract in short order...
Thankfully you have taken the effort to point this out.

I think now is the time to connect it to a DB (MySQL) and introduce those complexities.
A simple CRUD example (using canvas to extend table as you have mentioned) would be most helpful.
Reading and experimenting with all your wonderful stuff, I am still too stupid (novice) to piece this together...

Hopefully you shall find the time soon (or some other contributor).

In my opinion, it only lacks the CRUD functionality (ie. a CRUD framework).
When one examines other offerings from various suppliers, this is not as easy one might expect.
Many technicalities to overcome (INSERT, UPDATE, DELETE, etc.)
I understand this from other suppliers who generate this PHP code to handle these functions.


Thanks

Harris

Click to expand...

Roberto P. said:

Hi Harris
I agree with you! I agree that it is necessary to add CRUD functionality to make this framework up to the other pasati on classic php / jsp.
I think anyway we can already do this with individual implementations.
Hello
Roberto

Click to expand...

Bladimir Carrillo said:

Hi,
@Harris, @Roberto P. , I share my web app code with basic CRUD combining ABMaterial Framework and using concepts from Erel's ServerExample web app. You have to change the database access credentials in the 'settings.txt' file located on 'Objects' folder, and copy de folder 'ABMaterial1.02.zip\Template\Objects\www\' to 'Objects' folder.

@alwaysbusy , I have the following mistakes and needs that I have failed to solve:
- I added an ABMActionbutton to the page 2 (SisMACPage0002) but do not recognize the events. I had to add other normal buttons (ABMButton) to solve the problem.
- The footer on ABMTable appear twice when there are few or nothing rows.
- The ABMTable need a high light option to identify de current position, and a paging option.
- When run the compiled jar file, the app show the special characters as � simbols.
- To confirm the deletion of a row, a message dialog is required with options YES / NO

I appreciate the effort you're making to achieve this great framework and thank you in advance for your answers.

PD. I made a small donation today as a token of appreciation for your great project. Please send me the progress to my email.

Best regards.

Click to expand...

Erel said:

For servers it is recommended to use the ConnectionPool object to connect to databases.

Click to expand...

Sub Process_Globals
    Public pool As ConnectionPool
End Sub

Erel said:

I think that it is better to start a new thread for this discussion. Based on the error message the problem is in the user name / password.

Click to expand...

Harris said:

at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Dec 02, 2015 6:25:44 PM com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@23223dd8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Dec 02, 2015 6:25:44 PM com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@78a1be2e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user 'mhw'@'localhost' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)



Having a heck of a time connecting to my local MySql db. With or without password.
Tried different users, disabled firewall, etc.
Strange, phpmyadmin accesses it just fine...

B4X:

Public Sub init
    Dim JdbcUrl As String = Main.settings.Get("JdbcUrl")
    Dim driverClass As String = Main.settings.Get("DriverClass")
    Dim dbuser As String = Main.settings.Get("DBUser")
    Dim dbpassword As String = Main.settings.Get("DBPassword")
    Log(" Credts : "&JdbcUrl&"  "&driverClass)
    Log(" Credts :"&dbuser&"  "&dbpassword)
    Try
       pool.Initialize(driverClass, JdbcUrl, dbuser, dbpassword)
    Catch
       Log("last Except: "&LastException.Message)
    End Try
     
End Sub

EDIT: App dies here: ---> Dim sql1 As SQL = pool.GetConnection
Public Sub CreateUserTableIfNeeded
Dim sql1 As SQL = pool.GetConnection
End Sub..




settings.txt

B4X:

JdbcUrl=jdbc:mysql://localhost/harris?characterEncoding=utf8
DriverClass=com.mysql.jdbc.Driver
DBUser=mhw
DBPassword=
RecaptchaPrivateKey=6LcslRATAAAAAMfi-QOBebkJfIcJTZBPWuOZlfQu
Port=51043

Click to expand...