Re: Cannot Connect to Database Server: Type mismatch
I found the connections.xml file. Here it is with both connections. The first section will not connect. The second section will.
The only differences i can see are the db.mgmt.Connection values and the "int" "isDefault" where the top one is set to 1 and the bottom one is set to 0.
<?xml version="1.0"?>
<data grt_format="2.0">
<value _ptr_="000001EB361ECAB0" type="list" content-type="object" content-struct-name="db.mgmt.Connection">
<value type="object" struct-name="db.mgmt.Connection" id="{762832BE-02A6-472B-A16C-5FD6CFBF8092}" struct-checksum="0x96ba47d8">
<link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link>
<value type="string" key="hostIdentifier">Mysql@127.0.0.1:3306</value>
<value type="int" key="isDefault">1</value>
<value _ptr_="000001EB355F8C20" type="dict" key="modules"/>
<value _ptr_="000001EB355F8740" type="dict" key="parameterValues">
<value type="int" key="DbSqlEditor:LastDefaultSchema">1981</value>
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">127.0.0.1</value>
<value type="int" key="lastConnected">1658434767</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="serverVersion">8.0.29</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>
<value type="string" key="userName">root</value>
</value>
<value type="string" key="name">Local instance MySQL80</value>
<link type="object" struct-name="GrtObject" key="owner">{1238A872-4333-4C61-A8AF-F395EEB99503}</link>
</value>
<value type="object" struct-name="db.mgmt.Connection" id="{A07CCE27-C6BB-43A9-AC9E-D48D7E035C73}" struct-checksum="0x96ba47d8">
<link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link>
<value type="string" key="hostIdentifier">Mysql@127.0.0.1:3306</value>
<value type="int" key="isDefault">0</value>
<value _ptr_="000001EB3631EA60" type="dict" key="modules"/>
<value _ptr_="000001EB3631F000" type="dict" key="parameterValues">
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">127.0.0.1</value>
<value type="int" key="lastConnected">1658537048</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="serverVersion">8.0.29</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>
<value type="string" key="userName">root</value>
</value>
<value type="string" key="name">NonBrokenRootAccess</value>
</value>
</value>
</data>
Subject
Views
Written By
Posted
3252
July 22, 2022 01:51PM
887
July 22, 2022 06:46PM
Re: Cannot Connect to Database Server: Type mismatch
864
July 22, 2022 06:54PM
901
July 22, 2022 07:05PM
481
February 17, 2023 04:04PM
241
November 07, 2023 07:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.