\PowerMonitorServers\Java RDC Server Port 17178 Provides Remote Data Access to psmdb_winSrv.db Port: 17178 Uses predefined queries in config file. 'Per usual, please ensure you have the proper #AdditionalJar set for the database backend directives that pertain to a jRDC version of the DBUtils ' side: java.io.EOFException: Unexpected end of ZLIB input stream This should prevent the following on the B4X client ' took care of an : WRITER exception caused by OutputStream when ' converting the DBResult object and sending it to the client into end of the Try block.
#Sqlite stored procedures allowed code#
Moved the code below the End Try that dealt with 'Modified Try/Catch block in ExecuteBatch2.
#Sqlite stored procedures allowed manual#
' check the manual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 1 ' .jdbc4.MySQLSynta圎rrorException: You have an error in your SQL syntax ' in case of MySQL it looks something like this: This takes care of a syntax exception error for the DB. 'Modified ExecuteQuery2 and ExecuteBatch2 to check for valid command. ' ExecQuery/ExecNonQuery when no cmd.Parameters are given. ' Null pointer exception error message in case cmd.Parameters was Null. 'Modified ExecuteQuery2 and ExecuteBatch2 to check cmd.Parameters for Null. 'Modified Handler to not close the databas connection in case a pool is not used, else SQLite 'Modified GetConnection to handle non-pool SQL connections (SQLite). 'Modified GetCommand to return empty string ("") when no command found. This option was gleaned from the DBM.bas module of ABMaterial. This is the size of the pool that should be used Any other settings are interpreted as False. If set to True or set to 1, then the SQLite database will be created in This option is used for the SQLite backend If the DriverClass contains SQLite (case insensitive), then jRDC 'Added HasIPAddress and GetIPAddress to access IPAddress configuration.
Allows to set the jRDC server's IP address. 'Added ability to assign server to a specific IP address. ' to retrieve the IP address is similar to ServerSocket's GetMyIP method. 'Added the logging of one of the IP addresses that the server is bound to. 'In config properties, set up SQL statement to call stored procedure Modified DBRequestManager to allow usage of 'Added ability to use "simple" stored procedures. 'Updated source to match updates/features of jRDC2 2.22
'8 Removed show-stopping bug in /test handler. Finally, you have to have patience with me, I'm slow. I would rely on you to be knowledgeable in stored procedures and have your own DB available to test the jRDC2 server against. If anyone is interested in fleshing this out, PM me. Out of the box, jRDC2 can handle simple stored procedures (that just return a result set) via ExecuteQuery. Note: The stored procedures add-on is technically unnecessary. Other modifications are listed in the main file and are relisted here: This is more meant for people starting new with jRDC2. Support for V1 has been removed and therefore this is not a drop in replacement for jRDC2. Attached you'll find a modified version of jRDC2 (source ) that supports SQLite as the datastore out of the box.
0 kommentar(er)
