'Initialize a connection to MySQL server and returns True if successful
Sub InitializeMySQL(serverIP As String, serverPort As String, serverDB As String, login As String, password As String, poolSize As Int) As Boolean
Log("init mysql")
DatabaseType = 1
UsePool = True
Try
Dim jdbcUrl As String
jdbcUrl = MySQLConnectionString(serverIP,serverPort,serverDB)
pool.Initialize("com.mysql.jdbc.Driver", jdbcUrl, login, password)
' change pool size...
Dim jo As JavaObject = pool
jo.RunMethod("setMaxPoolSize", Array(poolSize))
Return True
Catch
Log("Last Pool Init Except: "&LastException.Message)
Return False
End Try
End Sub
'Initialize a connection to Microsoft SQL server
Sub InitializeMSSQL(serverIP As String, serverPort As String, serverDB As String ,login As String, password As String, poolSize As Int) As Boolean
DatabaseType = 2
Try
Dim jdbcUrl As String
jdbcUrl = MSSQLConnectionString(serverIP,serverPort,serverDB)
pool.Initialize("net.sourceforge.jtds.jdbc.Driver", jdbcUrl, login, password)
' change pool size...
Dim jo As JavaObject = pool
jo.RunMethod("setMaxPoolSize", Array(poolSize))
Return True
Catch
Log("Last Pool Init Except: " & LastException.Message)
Return False
End Try
End Sub