Android Question incompatibility sql and mysql library

rkxo · Jul 20, 2016

Hi,
I have problems when trying to connect 2 concurrent databases . MySQL and SQLite . Attached is an example .
http://www.mediafire.com/download/qoqed7783w8btso/GestApp.rar

I get this error:

--------- beginning of /dev/log/system
--------- beginning of /dev/log/main
** Service (starter) Create **
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
Error occurred on line: 65 (Main)
java.lang.ClassCastException: com.mysql.jdbc.JDBC4ResultSet cannot be cast to android.database.Cursor
at anywheresoftware.b4a.sql.SQL$CursorWrapper.getRowCount(SQL.java:313)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:703)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:337)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:247)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:134)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:157)
at anywheresoftware.b4a.debug.Debug.delegate(Debug.java:259)
at b4a.example.main._connect(main.java:403)
at b4a.example.main._activity_create(main.java:395)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:703)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:340)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:247)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:134)
at b4a.example.main.afterFirstLayout(main.java:102)
at b4a.example.main.access$000(main.java:17)
at b4a.example.main$WaitForLayout.run(main.java:80)
at android.os.Handler.handleCallback(Handler.java:733)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:136)
at android.app.ActivityThread.main(ActivityThread.java:5017)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)
at dalvik.system.NativeStart.main(Native Method)

Thank you very much for your help.

Erel · Jul 20, 2016

This is not a bug. The MySQL library that you are using doesn't work with Cursor from the SQL library. It cannot work as Cursor will only work with the built-in SQLite engine.

rkxo · Jul 20, 2016

thanks erel
but i use ResultSet for mysql and cursor for sql.

why with this example works? ,its the same code that the first example.
http://www.mediafire.com/download/7c70l279u1rr74v/GestorOK.rar

the first example is part of big code

Erel · Jul 20, 2016

B4A ResultSet and Cursor objects will only work with the internal SQLite engine.

Widget · Jul 20, 2016

There are several libraries available to access MySQL. Do a forum search on "mysql library" and look at the examples. There are new MySQL libraries coming up every few months, including several for MariaDB which gets around licensing issues with MySQL.

rkxo · Jul 20, 2016

Then , its possible works with these libraries at the same time, sql.jar and mysql.jar?
I know that there are a lot of mysql libraries, in particular msmysql library , from mamfred. i have it,and i use it for blob data with mysql, but is more complicated for obtain fast qyeries. With mysql.jar library es very fast for programing and obtain the data. I want work with mysql.jar library becouse the app its done ,if i have change at other mysql library i have to reprograming a big code. There are any other sqlite library for b4a?. I search but i don' t found.Sorry for my english.

DonManfred · Jul 21, 2016

rkxo said:
Then , its possible works with these libraries at the same time, sql.jar and mysql.jar?

yes. you need to use the correct syntax/code for the libs... SQLite, mysql, msmysql. Each of them have another syntax

rkxo said:
in particular msmysql library , from mamfred

My name is Manfred

rkxo said:
There are any other sqlite library for b4a?

No

rkxo · Jul 21, 2016

sorry, Manfred, Which is the correct sintax of mysql?
basically i understand that:
Sub SqliteConnection
dim Sqlite as Sql 'SQL.jar library
dim SqCursor as Cursor
Sqlite.Initialize(File.DirDefaultExternal, "test.db",False)
Cursor1= Sqlite.ExecQuery("SELECT * FROM configSqlite")
For i=1 to Cursor1.RowCount-1
Cursor1.Position=i
Next
End Sub
----------------------------------------------------------
Sub MysqlConnection
dim Mysql as MysqlHandler 'mysql.jar library
dim MysqResult as ResultSet
MysqResult = Mysql.Query("SELECT * FROM configmysql")
For i=1 to MysqResult.RowCount-1
MysqResult.Position=i
Next
End sub
but resultset is assigned to sqlite engine in MysqlConnection?
----------------------------------------------------------
dim Msmysql as MySql 'msmysql.jar library
.........
.......

thanks

DonManfred · Jul 21, 2016

rkxo said:
Which is the correct sintax of mysql?

ask the author of the mysql library. Not me. I am using msMySQL library (for sure)

rkxo · Jul 21, 2016

ok, i try to find to
@BA.ShortName("MysqlHandler")
@BA.Author("Fabio Pignoletto")
@BA.Version(1.02F)

thanks

klaus · Jul 21, 2016

Are you sure that MysqResult.RowCount and MysqResult.Position exist in the MySQL library you are using !?

rkxo · Jul 21, 2016

yes, when i try only mysql.jar all works fine, but i load sql.jar library, gets error
Error occurred on line: 65 (Main)
java.lang.ClassCastException: com.mysql.jdbc.JDBC4ResultSet cannot be cast to android.database.Cursor

part of code mysql.jar class.

public int RowCount()
throws SQLException
{
int position = ((ResultSet)getObject()).getRow();
((ResultSet)getObject()).last();
int rowCount = ((ResultSet)getObject()).getRow();
if (position > 0) {
((ResultSet)getObject()).absolute(position);
}
return rowCount;
}

Erel · Jul 21, 2016

What is line 65 in your code?

rkxo · Jul 21, 2016

its a call at MysqResult.RowCount . I think that the problem is shared one resultset or cursor in two library, its possible?

Really the question its . why when i util mysql.jar library all works fine but when i "only" load sql.jar and call anything at function of resultset or cursor gets error ?

Erel · Jul 22, 2016

They probably used ResultSet as the object name and it conflicts with ResultSet from the SQL library. You can edit the XML of this library and change the ShortName value to something different.

rkxo · Jul 22, 2016

Thanks Erel. Work!!!!

Android Question incompatibility sql and mysql library

rkxo

Active Member

Erel

B4X founder

rkxo

Active Member

Erel

B4X founder

Widget

Well-Known Member

rkxo

Active Member

DonManfred

Expert

rkxo

Active Member

DonManfred

Expert

rkxo

Active Member

klaus

Expert

rkxo

Active Member

Erel

B4X founder

rkxo

Active Member

Erel

B4X founder

rkxo

Active Member

Similar Threads

Android Question incompatibility sql and mysql library

Active Member

B4X founder

Active Member

B4X founder

Well-Known Member

Active Member

Expert

Active Member

Expert

Active Member

Expert

Active Member

B4X founder

Active Member

B4X founder

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency