weimingtom / assql Goto Github PK

asSql Flex 2.01 fails to detect MySql version 4.0.21. Should throw 
BadServerVersionError but instead throws a Connection error. The error is 
in Statement.meetsVersion logic. If ( minor >= mnr ) returns false the 
function returns true but should return false.

If MySql sends data back REALLY fast, the checkForPackets() method will
cause a stack overflow error. Needs to be changed not to use recursion.

What steps will reproduce the problem?
1. Install Flash Player 9.0.124
2. Run a SWF off of your local host server that connects through ASSQL

What is the expected output? What do you see instead?
You get this error:
"Error #2044: Unhandled sqlError:. text=SQL Error #0: Error #2048: Security
sandbox violation: http://localhost/index.swf cannot load data from
localhost:3306."

What version of the product are you using? On what operating system?
Beta 2.4
Windows Vista

Please provide any additional information below.
I have not yet tested on an actual server but so far, because of the
security updates in the new flash player, I am sure you will get the same
error. ASSQL worked perfectly until I updated Flash Player from 9.0.115 to
9.0.124.
Currently, I don't know of if you can load a crossdomain.xml file to the
mySQL server.

When calling rs.getRows(), current it just uses getString to populate the
value. This needs to be changed to detect the actual column type and cast
the value properly

Add previous() method to ResultSet

checkForPackets get's called more then actually needed.

What steps will reproduce the problem?
1. Add binary data to an instance of a BinaryQuery
2. Execute the query
3.

What is the expected output? What do you see instead?
Query results.  A MySQL error is generated instead.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. connectionChangeDatabaseTo("somedb");


What is the expected output? 
Event as a result

What do you see instead?
TypeError: Error #1009: Cannot access a property or method of a null object
reference.
    at com.maclema.mysql::DataHandler/pushPacket()[F:\My Documents\Flex
Builder Moxie\asSQL\src\com\maclema\mysql\DataHandler.as:33]
    at
com.maclema.mysql::Connection/com.maclema.mysql:Connection::checkForPackets()[F:
\My
Documents\Flex Builder Moxie\asSQL\src\com\maclema\mysql\Connection.as:124]
    at
com.maclema.mysql::Connection/com.maclema.mysql:Connection::onSocketData()[F:\My
Documents\Flex Builder Moxie\asSQL\src\com\maclema\mysql\Connection.as:95]


What version of the product are you using? On what operating system?
assql for moxie

Please provide any additional information below.

Great library. Would like to work with you on coming up with a standard db
api and help with maintaining the project (I know how that can be difficult
to do solo)

getDataGridColumns should provide a label function for date or time fields.
It should also exclude binary columns unless otherwise specified.

Look into BinaryQuery for errors:

Error: Error #2030: End of file was encountered.
       at flash.utils::ByteArray/readBytes()
       at
com.maclema.mysql::Buffer/readLengthCodedData()[/Users/Matt/Documents/FlexBuilde
r3/assql/com/maclema/mysql/Buffer.as:142]
       at
com.maclema.mysql::QueryHandler/handleNextPacket()[/Users/Matt/Documents/FlexBui
lder3/assql/com/maclema/mysql/QueryHandler.as:119]
       at
com.maclema.mysql::QueryHandler/newPacket()[/Users/Matt/Documents/FlexBuilder3/a
ssql/com/maclema/mysql/QueryHandler.as:33]
       at
com.maclema.mysql::DataHandler/pushPacket()[/Users/Matt/Documents/FlexBuilder3/a
ssql/com/maclema/mysql/DataHandler.as:33]
       at
com.maclema.mysql::Connection/checkForPackets()[/Users/Matt/Documents/FlexBuilde
r3/assql/com/maclema/mysql/Connection.as:175]
       at
com.maclema.mysql::Connection/onSocketData()[/Users/Matt/Documents/FlexBuilder3/
assql/com/maclema/mysql/Connection.as:146]

Reading split packets is also failing

when i use assql writer chinese data into database,

the chinese data is garbled when I see it in the "MySQL Command Line Client".

but I use assql read the chinese data,put they in the datagrid,it is normal.

air application,database use utf8.

I try use a html,and servlet(all is utf8).put data in database,display data
in    

 "MySQL Command Line Client",read data and put they in the html,all is normal.

why?

What steps will reproduce the problem?
1. getBoolean() is needed in resultset.
2.
3.

What is the expected output? What do you see instead?
rs.getBoolean(). should return true or false

What version of the product are you using? On what operating system?
2.4

Please provide any additional information below.

What steps will reproduce the problem?
1. I downloaded your sorcecode for asSQL.
2. I copied the AS code frome your webbpageand changed the port,userneame
and so on to my settings.
3. You never wrote what librarys to import. So I tryed to import them on my
own.

What is the expected output? What do you see instead?
I expected to get a working connection with mySQL:
Instead I got "1046: Type was not found or was not a compile-time constant:
ResultsEvent.",
"1046: Type was not found or was not a compile-time constant: ResponseEvent." 
and "1046: Type was not found or was not a compile-time constant:
mySQLErrorEvent."

What version of the product are you using? On what operating system?
Flash CS3,The latesed mySQL (installed it two weeks ago), Windows XP

Please provide any additional information below.
These are the librarys I've imported this far:
import flash.display.MovieClip;
import flash.events.*;
import com.maclema.mysql.events;

My FLA file and my Creator file is saved inside the "com"-folder.


Cheers
Mikael

What steps will reproduce the problem?
1. What is the difference between sqlService.lastResultSet and evt.resultSet ??
2. sqlService of type MySqlService and evt of type MySqlEvent.RESULT here.
3. Both doesn't seem returning the same results.

What is the expected output? What do you see instead?
Should return the same resultset

What version of the product are you using? On what operating system?
2.4

Please provide any additional information below.

Add responder's to statement to connection / statement to improve usability.

Example:

{{{
var st:Statement = con.createStatement();
st.executeQuery("SELECT * FROM users", new MySqlResponder(resultHandler,
errorHandler);
}}}

or:

{{{
var st:Statement = con.createStatement();
st.executeQuery("SELECT * FROM users", new MySqlResponder(
   function (e:MySqlEvent) {
      //handle result here
   },
   function (e:MySqlErrorEvent) {
      //handle error here
   }
);
}}}

What steps will reproduce the problem?
1. Execute 1 or more queries while another query is still executing.

What is the expected output? What do you see instead?
All queries execute successfully, instead, an error is thrown.


We are currently looking into how to handle this issue properly and hope to
have a fix soon.

Packets larger than 16MB fail. sendSplitPackets needs to be fixed.

Added logic to check for premature disconnect() calls. Committed to
subversion, will be released in the next build.

Add support for MySql comporssion.

When using Statement.setString, or Statement.setBinary, the query will
sometimes files.

The fix for this is already in subversion and will be available in the next
release.

Optimize the getRows() method.

MySqlResponder is now not needed, it can be replaced by AsyncResponder from
within the flex framework.

Implement tokens, similar to HTTPService and RemoteObject.

Allow attaching of result and fault handler to the mysql service.

assql should get mysql character set and use it in assql.

The following is a rough proposed changes. 

Connection.as
use packet.writeMultiByte(data,#mysql character set#) to replace
    packet.writeUTFBytes(data);

ResultSet.as
and data.readMultiByte(data.bytesAvailable,#mysql character set#) to replace 
    data.readUTFBytes(data.bytesAvailable)

HandshakeHandler.as
//language
packet.writeByte( 8 ); //charset
replace to this
//language
packet.writeByte( getMysqlCharacterSetCode(#mysql character set#));//charset

Field flags need to be read like:

_flags = ((packet.readByte() & 0xff)) | ((packet.readByte() & 0xff) << 8);

Re-implement the MysqlService Class

update the demo application to use the new beta 2.5

MySqlService should have a pure actionscript version, as well as a MXML
version.

What steps will reproduce the problem?
1. MySqlService's autoConnect missing.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
2.4, 2.5

Please provide any additional information below.
autoConnect is missing from both the versions.
I had confirmed it from the docs as well as in FlexBuilder's dropdown list,
it is not displaying that method.

What steps will reproduce the problem?
1. rs.getDate() function doesn't pick a mysql DateTime value. Returns
Invalid Date.
2.
3.

What is the expected output? What do you see instead?
expecting a DateTime value.

What version of the product are you using? On what operating system?
2.4

Please provide any additional information below.

Re Issue #10 conversation. This seems to be unrelated to Responders and may
be an issue.

Info:
[ALL] com.maclema.mysql::Connection                : Set Data Handler To: 
com.maclema.mysql::HandshakeHandler
[ALL] com.maclema.mysql::Connection                : Socket Connected
[ALL] com.maclema.mysql::Connection                : Socket Data (65 bytes)
[ALL] com.maclema.mysql::HandshakeHandler          : Push Packet (Total
Packets: 0)
[ALL] com.maclema.mysql::HandshakeHandler          : Server Information Packet
[ALL] com.maclema.mysql::HandshakeHandler          : Next Packet
[ALL] com.maclema.mysql::ServerInformation         : Version: 5.0.37-standard
[ALL] com.maclema.mysql::HandshakeHandler          : doHandshake
[ALL] com.maclema.mysql::HandshakeHandler          : doSecureAuthentication
[ALL] com.maclema.mysql::Connection                : Socket Data (11 bytes)
[ALL] com.maclema.mysql::HandshakeHandler          : Push Packet (Total
Packets: 0)
[ALL] com.maclema.mysql::HandshakeHandler          : Next Packet
[ALL] com.maclema.mysql::HandshakeHandler          : Success Packet
[ALL] com.maclema.mysql::Connection                : Change Database 
(codeit_airlive_rentajewel)
[ALL] com.maclema.mysql::Connection                : Socket Data (11 bytes)
[ALL] com.maclema.mysql::HandshakeHandler          : Push Packet (Total
Packets: 0)
[ALL] com.maclema.mysql::HandshakeHandler          : Next Packet
[ALL] com.maclema.mysql::HandshakeHandler          : Connect With DB
Success Packet
[ALL] com.maclema.mysql::Connection                : Unregistered Data Handler
[ALL] com.maclema.mysql::Connection                : Connected
[ALL] com.maclema.mysql::Statement                 : executeQuery
[ALL] com.maclema.mysql::Statement                 : executing a regular
statement
[ALL] com.maclema.mysql::Connection                : Execute Query (update
revision 
set revision = revision+1, lastupdate=now())
[ALL] com.maclema.mysql::Connection                : Set Data Handler To: 
com.maclema.mysql::QueryHandler
[ALL] com.maclema.mysql::Statement                 : executeQuery
[ALL] com.maclema.mysql::Statement                 : executing a regular
statement
[ALL] com.maclema.mysql::Connection                : Execute Query (select
revision 
from revision)
[ALL] com.maclema.mysql::Connection                : Set Data Handler To: 
com.maclema.mysql::QueryHandler
[ALL] com.maclema.mysql::Connection                : Disconnected

What steps will reproduce the problem?
1. I can receive the returned records in Firefox. But, there is nothing
returned in Internet Explorer. I tried clearing the cache/temp files, but
still the same. Any reasons/clues ??
2.
3.

What is the expected output? What do you see instead?
Expecting my grid to be filled with records. Firefox working fine.

What version of the product are you using? On what operating system?
2.4

Please provide any additional information below.

What steps will reproduce the problem?
1. MySqlResponser
2.
3.

What is the expected output? What do you see instead?
One should not aim the output as ArrayCollection only.

What version of the product are you using? On what operating system?
2.3 / 2.4

Please provide any additional information below.
I am working for a small to medium level application where for different
calls, I need different responder. I tried extending MySqlResponser, but
then I can not override the two methods. And receiving all the output in
the MySqlResponser's method's will be too complicated (where I am receiving
output from 10+ tables).

The appropriate solution will be the one declaring MySqlResponser as interface.
The best and ideal solution would be one where all the output will be
handled by IResponder implementing classes directly.
public function result(data:Object):void
{
    //TODO: implement function
    var list:ArrayCollection = data.result as ArrayCollection;
}

public function fault(info:Object):void
{
    //TODO: implement function
    Alert.show("In Fault:Responder");
}

Also, if you can provide some functionality like this:
var call : AsyncToken = someMethodCall();
call.addResponder( responder );

where someMethodCall() is:
public function someMethodCall():Object/IMessage
{
    sqlService.send("SELECT * FROM tbl_flat");
}

Let me know, if you could not understand the problem exactly.
Thanks.

Instead of dispatching MySqlEvent.RESULT and MySqlEvent.RESPONSE, only
dispatch MySqlEvent.RESULT for both results and responses.

In ResultSet getter methods, if a column value is null, it is not handled
correctly.

The online documentation needs to be updated.

EOF Error when querying LongBlobs >100kb

getCastedValue needs to check for FIELD_TYPE_TIME columns and cast properly.

Update demo application to use the new Beta 2.5

What steps will reproduce the problem?
1. following the fix for new flash player 9.124
2. following the first example for connecting to mysql database
3.

What is the expected output? 
to see datagrid connected to mysql server


What do you see instead?
Error: Unsupported Char Set
at
CharSets$/as3CharSetFromMysqlCharSet()[/Users/Matt/Documents/FlexBuilder3/assql/
com/maclema/mysql/CharSets.as:32]
    at
com.maclema.mysql::Connection/initConnection()[/Users/Matt/Documents/FlexBuilder
3/assql/com/maclema/mysql/Connection.as:322]
    at
HandshakeHandler/newPacket()[/Users/Matt/Documents/FlexBuilder3/assql/com/maclem
a/mysql/HandshakeHandler.as:98]
    at
DataHandler/pushPacket()[/Users/Matt/Documents/FlexBuilder3/assql/com/maclema/my
sql/DataHandler.as:48]
    at
com.maclema.mysql::Connection/checkForPackets()[/Users/Matt/Documents/FlexBuilde
r3/assql/com/maclema/mysql/Connection.as:439]
    at
com.maclema.mysql::Connection/onSocketData()[/Users/Matt/Documents/FlexBuilder3/
assql/com/maclema/mysql/Connection.as:413]


What version of the product are you using? On what operating system?
the newest assql 2.6beta .. on a ubuntu linux 7.10 server .Apache/2.2.4
PHP/5.2.6-0.dotdeb.1


Please provide any additional information below.

I am a newbie to flex and to your script so I am not sure if I just did not
follow the instructions close enough.. However I wanted to possibly lend a
hand .. just in case this is a true bug.. 

MySqlService should not extend UIComponent but rather implement
IMXMLSupport and IMXMLObject

What steps will reproduce the problem?
1. ResultsUtil.getDataGridColumns(rs); returning me only 8 fields whereas
my db has 16 fields and expected to return all 16.
2. You can try the same code that I sent you. Only change needed is in the
FlatResponder.as file. Change the Alert.show("...") to          Alert.show("Here
it is: "+list2.length+" - "+list.length+" - "+str);
3.

What is the expected output? What do you see instead?
Should return all the fields.

What version of the product are you using? On what operating system?
2.4
Please provide any additional information below.

If there is an error connecting, an error is not thrown. This is just a
typo in the HandshakeHandler class. There is an "if" where `0xFF || -1`
needs to be `0xFE || -1`

What steps will reproduce the problem?
1. Execute a statement and get a ResultSet back in the data Object
2. var results:ArrayCollection = resultSet.getRows();
3. notice that results.getItemAt(0); is actually row 1 instead of row 0
   Also notice that resultSet.numColumns is 1 less than it should be

What is the expected output? What do you see instead?
getItemAt(0) should return the first row, not the second
resultSet.numColumns should return the number of columns, not the index of
the last column

What version of the product are you using? On what operating system?
ASSQL Beta 2.6 

Optimize getTime

MySqlResponder Should Implement IResponder

Add showBusyCursor support to MySqlService

Problem:

When attempting to connect to MySql v4.0.21 I get a "Error #2030: End of 
file was encountered."

Solution:

The problem is caused by ServerInformation.as Line 75. MySql v4.0 does not 
send "rest of scramble_buff" packets as does 4.1 and up. There needs to be 
a check of available bytes before issue the readString function.

if( packet.bytesAvailable > 0 )
{
seed += packet.readString();
}