[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))

DonManfred · Jun 14, 2016

vbmundo said:
What about the TASK label ? the TASK in the QUERYASYNC doesn't work..

it works fine for me

B4X:

    db.QueryASync("select Description as My_Name from Categories;","test")   
    db.QueryASync("select Description as My_Name from Categories;","test2")

MySQL_Status(true,false,0)
MySQL_QueryResult(Columns 1, Records 11,381ms,test2
(MyMap) {My_Name=Soft drinks, coffees, teas, beers, and ales}
(MyMap) {My_Name=Sweet and savory sauces, relishes, spreads, and seasonings}
(MyMap) {My_Name=Desserts, candies, and sweet breads}
(MyMap) {My_Name=Cheeses}
(MyMap) {My_Name=Breads, crackers, pasta, and cereal}
(MyMap) {My_Name=Prepared meats}
(MyMap) {My_Name=Dried fruit and bean curd}
(MyMap) {My_Name=Seaweed and fish}
MySQL_QueryResult(Columns 1, Records 11,382ms,test
(MyMap) {My_Name=Soft drinks, coffees, teas, beers, and ales}
(MyMap) {My_Name=Sweet and savory sauces, relishes, spreads, and seasonings}
(MyMap) {My_Name=Desserts, candies, and sweet breads}
(MyMap) {My_Name=Cheeses}
(MyMap) {My_Name=Breads, crackers, pasta, and cereal}
(MyMap) {My_Name=Prepared meats}
(MyMap) {My_Name=Dried fruit and bean curd}
(MyMap) {My_Name=Seaweed and fish}
** Activity (main) Pause, UserClosed = false **
** Activity (main) Resume **
Activity_Resume()

The task is given back in the metadata...

vbmundo · Jun 14, 2016

DonManfred said:
it works fine for me

B4X:

db.QueryASync("select Description as My_Name from Categories;","test") db.QueryASync("select Description as My_Name from Categories;","test2")

The task is given back in the metadata...

???

But the SUB is allways the same ?

I need to put all code in 1 Sub for all queries ?

vbmundo · Jun 15, 2016

vbmundo said:

Hi,

I have this code

B4X:

        If data.Get("COLLATION_NAME")<>Null Then
           Cola=data.Get("COLLATION_NAME")
        Else
           Cola=""
        End If

And trow this error

B4X:

** Activity (main) Pause, UserClosed = false **
** Service (starter) Create **
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
MySQL Database not connected!
Sub NOT FOUND: 'vertablas_status
Connected to Database
** Activity (main) Pause, UserClosed = false **
** Activity (listatablas) Create, isFirst = true **
** Activity (listatablas) Resume **
** Activity (listatablas) Pause, UserClosed = false **
** Activity (estructuras) Create, isFirst = true **
** Activity (estructuras) Resume **
An error occurred:
(Line: 72) If data.Get("COLUMN_DEFAULT")<>Null Then
java.lang.NumberFormatException: For input string: "COLUMN_DEFAULT"
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
** Activity (main) Resume **

Hi Donmanfred

Can you see this previous problem ?

I have this error when I tried to check if this Field return Null

Regards

DonManfred · Jun 15, 2016

vbmundo said:
I need to put all code in 1 Sub for all queries ?

yes. It is like the sub JobDone when using okhttputils.

You can call other subs to handle the result from there

vbmundo · Jun 15, 2016

Hi DonMandred, ok.. not problem with that.

But, I'm still hold with
java.lang.NumberFormatException

You Know, COLUMN_DEFAULT return Null sometimes and you have an Issue when you try to determine if the field is null.

I can't advance

Regards

DonManfred · Jun 15, 2016

vbmundo said:
Can you see this previous problem ?

what is the result of the folloging code???

B4X:

log($"->${data.Get("COLLATION_NAME")}<-"$)

vbmundo · Jun 15, 2016

DonManfred said:
what is the result of the folloging code???

B4X:

log($"->${data.Get("COLLATION_NAME")}<-"$)

nothing

The App abort when you try to show data.Get("COLUMN_DEFAULT")

COLUMN_DEFAULT is a LONGTEXT maybe your Control reject a LONGTEXT field.

See the Attached file

Regards

DonManfred · Jun 15, 2016

vbmundo said:
LT is a LONGTEXT maybe your Control reject a LONGTEXT field

The used mysql connector does not have such a Type...Or let me say...

There is no such Type in java.sql.Types

vbmundo · Jun 15, 2016

DonManfred said:
The used mysql connector does not have such a Type...Or let me say...

There is no such Type in java.sql.Types

I know that you use HeidiSQL, try to connect to your information_schema Database and see the COLUMN table please...

LONGTEXT is one of MySQL Type

See

http://dev.mysql.com/doc/refman/5.7/en/string-type-overview.html

vbmundo · Jun 15, 2016

Look

http://marc.info/?l=mysql-java&m=105160752619656&w=2

keirS · Jun 15, 2016

DonManfred said:
The used mysql connector does not have such a Type...Or let me say...

There is no such Type in java.sql.Types

ResultSetMetaData.getColumnType should return a MySQL LONGTEXT type as java.sql.Types.LONGNVARCHAR

DonManfred · Jun 15, 2016

keirS said:
ResultSetMetaData.getColumnType should return a MySQL LONGTEXT type as java.sql.Types.LONGNVARCHAR

so the following should work?

B4X:

                      } else if(rsmd.getColumnType(i)==java.sql.Types.LONGNVARCHAR){
                          mm.Put(columnname, rs.getString(i));

rsmd = resultset metadata
mm = B4A Map to return

vbmundo · Jun 15, 2016

Yes, with the Keirs Control I hasn't problem to receive LongText Fields.

DonManfred, Could you consider at some point to include some Error Handler to your library? that if a SQL or Execute fails not abort or hang the APP ?

Your Lib is a Holy Grail but lacks a few things to be perfect

Thanks

keirS · Jun 15, 2016

DonManfred said:
so the following should work?

B4X:

} else if(rsmd.getColumnType(i)==java.sql.Types.LONGNVARCHAR){ mm.Put(columnname, rs.getString(i));

rsmd = resultset metadata
mm = B4A Map to return

Yes it should. Just Googled it and the MYSQL site says.

MySQL said:
All TEXT types return Types.LONGVARCHAR with different getPrecision() values (65535, 255, 16777215, and 2147483647 respectively) with getColumnType() returning -1. This behavior is intentional even though TINYTEXT does not fall, regarding to its size, within the LONGVARCHAR category. This is to avoid different handling inside the same base type. And getColumnType()returns -1 because the internal server handling is of type TEXT, which is similar to BLOB.

Also note that getColumnTypeName() will return VARCHAR even though getColumnType() returns Types.LONGVARCHAR, because VARCHAR is the designated column database-specific name for this type.

Could the bit in bold be causing you a problem?

vbmundo · Jun 16, 2016

Look DonManfred,

Is the best time to you to include a new Event into your Library.. an Sub MySQL_Error(Status as string) to trap any MySQL/Java error !!!

I'm waiting for your new (MySQL Longtext type) version

Regards

DonManfred · Jun 19, 2016

vbmundo said:
I'm waiting for your new (MySQL Longtext type) version

You can try v1.0.9 (download in my dropbox at same place)

It adds also a new event to show errors (untested) for a query

vbmundo · Jun 19, 2016

DonManfred said:
You can try v1.0.9 (download in my dropbox at same place)

It adds also a new event to show errors (untested) for a query

Wow man....

I will give you my opinion !!

Thanks !!!

vbmundo · Jun 19, 2016

DonManfred said:
It adds also a new event to show errors (untested) for a query

This works with Querys and Exec or only Querys ?

Can you give me the Sintax to this new Sub ?

Luis Carrillo Escalona · Jun 19, 2016

Might detail new things added

DonManfred · Jun 19, 2016

vbmundo said:
Can you give me the Sintax to this new Sub ?

Use the IDE to create the sub for you!?

[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))

Expert

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Attachments

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Member

Expert