Openfire 3.9.3 - java.sql.SQLException: Out of Memory

[Caio]

Hi.

I’m trying to open my admin Openfire but I can’t see it in browse. (its a new installation).

After make the new installation I transfer some datas from old server to this new one.

I transfer the /conf/openfire.xml, /embedded-db and /plugins folders.

After restart the openfire service the error log report me java.sql.SQLException: Out of Memory.

Please help!

Here is the full error log.

2014.10.03 09:52:59 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 09:53:45 org.jivesoftware.database.DbConnectionManager - Out of Memory

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211 )

at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConn ectionProvider.java:61)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:616)

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:100)

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:345)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:88)

at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:66)

at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:567)

at org.jivesoftware.util.cache.CacheFactory.(CacheFactory.java:94)

at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:360)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:464)

at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:197)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessor Impl.java:57)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at java.lang.Class.newInstance(Class.java:374)

at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:113)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:58)

2014.10.03 09:54:33 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 09:56:06 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 09:57:40 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 09:59:12 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:00:42 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:02:14 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:03:50 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:05:23 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:06:54 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:08:30 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:10:10 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:10:55 org.jivesoftware.util.JiveProperties - ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Out of Memory

java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Out of Memory

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:151)

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:345)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:88)

at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:66)

at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:567)

at org.jivesoftware.util.cache.CacheFactory.(CacheFactory.java:94)

at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:360)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:464)

at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:197)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessor Impl.java:57)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at java.lang.Class.newInstance(Class.java:374)

at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:113)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:58)

2014.10.03 10:11:42 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:13:18 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2014.10.03 10:14:52 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

java.sql.SQLException: Out of Memory

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

[LG1]

Increase Xmx to start Openfire.

database/openfire.log + .script are read and kept in memory.

[Caio]

Thanks for answer.

How should I do that? My .script have more than 400MB

[LG1]

The proper way may to create an openfire.vmoptions file - not sure if this works as expected.

Edit the start script and set/change Xmx there. There are already a lot of threads for Win and Linux how to adjust it.

[wroot]

Telling us what OS you are running on would help a bit. You can read about creating vmoptions file here Openfire: Installation Guide

[Caio]

I’m using the last edition of SUSE.

I could increase the memory… I follow this procedure… Increase java memory | Ignite Realtime

But now I’m stuck in Console Admin… it’s not accepting my passwords… any tip to reset this password?

Thanks.

[wroot]

Change the last tag in conf/openfire.xml to the opposite (true i think), rerun the setup and set the other password

[Caio]

Thanks for answer me wr00t… but now my boss just gave me new orders… transfer the database to MySQL.

I try that using Import/Export plugin… but it just transfer the user… anyway to transfer the history and groups?

Thanks.

CAIO

[wroot]

What do you mean by history? Do you have Monitoring Service plugin installed? Then no, you can’t move this history and groups. At least i don’t know of a way to do it.

[Caio]

I found a procedure here… I’m trying to do it in my computer but it’s giving me the heap memory in java process…

I’m trying to increase it using openfired.vmoptions… but if I set more then Xmx2014m it’s giving me the error

Error occurred during initialization of VM

Could not reserve enough space for object heap

The JVM could not be started. The maximum heap size (-Xmx) might be too large or

an antivirus or firewall tool could block the execution.

I have 8GB… why I can’t set that? If I leave in 1024 it’s give me the heap memory issue.

[wroot]

I think this is the limit of 32-bit Java. It probably can be overridden by using 64-bit Java, but i have no experience with that. Maybe LG has a suggestion about that.

[Caio]

Ok… let me try another way…

I’m trying to convert my embedded db to mysql… I found this procedure… https://community.igniterealtime.org/servlet/JiveServlet/previewBody/2622-102-1- 3012/Migrating%20openfire%20HSQLDB%20dat…

But Oracle the gui-tools from Oracle is the MySQL Workbench… i’m trying to do the convertion using it but it’s giving me this error

Starting…

Connect to source DBMS…

• Connecting to source…

Connecting to generic@DRIVER=%driver%;SERVER=%hostName%;PORT=%port%…

Opening ODBC connection to jdbc:hsqldb:C:\Program Files (x86)\Openfire\embedded-db\openfire.script…

Traceback (most recent call last):

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_generic_re_grt.py”, line 689, in connect

return GenericReverseEngineering.connect(connection, password)

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_generic_re_grt.py”, line 143, in connect

con = db_driver.connect(connection, password)

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\workbench\db_driver.py”, line 91, in connect

connection = library.connect(connection_string, password=password)

pyodbc.Error: (‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados n\xe3o encontrado e nenhum driver padr\xe3o especificado (0) (SQLDriverConnect)’)

Connecting to generic@DRIVER=%driver%;SERVER=%hostName%;PORT=%port%…

Opening ODBC connection to jdbc:hsqldb:C:\Program Files (x86)\Openfire\embedded-db\openfire.script…

Traceback (most recent call last):

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_generic_re_grt.py”, line 689, in connect

return GenericReverseEngineering.connect(connection, password)

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_generic_re_grt.py”, line 143, in connect

con = db_driver.connect(connection, password)

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\workbench\db_driver.py”, line 91, in connect

connection = library.connect(connection_string, password=password)

pyodbc.Error: (‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados n\xe3o encontrado e nenhum driver padr\xe3o especificado (0) (SQLDriverConnect)’)

Traceback (most recent call last):

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py”, line 66, in run

self.func()

File “C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\migration_source_selection.py”, line 439, in task_connect

raise e

SystemError: Error("(‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados n\xe3o encontrado e nenhum driver padr\xe3o especificado (0) (SQLDriverConnect)’)"): error calling Python module function DbGenericRE.connect

ERROR: Error during Connect to source DBMS: Error("(‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados n\xe3o encontrado e nenhum driver padr\xe3o especificado (0) (SQLDriverConnect)’)"): error calling Python module function DbGenericRE.connect

ERROR: Exception in task ‘Connect to source DBMS’: SystemError(‘Error("(‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados n\xe3o encontrado e nenhum driver padr\xe3o especificado (0) (SQLDriverConnect)’)"): error calling Python module function DbGenericRE.connect’,)

Failed

Does anyone know if I have to install a JDBC driver? Or something like that?

thanks.

[Caio]

Ok guys… I founded the Migration Tool for Windows… did the procedure and now I’m stuck in java memory issue.

I did what the procedure said about Xmx parameter… but it didn’t help!

My .script have 400MB and my computer have 8GB RAM… here is the log about error.

Connecting to source database and retrieve schemata names.

Initializing JDBC driver …

Driver class Generic Jdbc

Opening connection …

Connection jdbc:hsqldb:C:\Program Files (x86)\Openfire\embedded-db\openfire

The list of schema names could not be retrieved (error: 0).

ReverseEngineeringGeneric.getSchemata :Out of Memory

Details:

org.hsqldb.jdbc.Util.sqlException(Unknown Source)

org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

org.hsqldb.jdbcDriver.getConnection(Unknown Source)

org.hsqldb.jdbcDriver.connect(Unknown Source)

java.sql.DriverManager.getConnection(Unknown Source)

java.sql.DriverManager.getConnection(Unknown Source)

com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)

com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(Unknown Source)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

com.mysql.grt.Grt.callModuleFunction(Unknown Source)

Please help!!!

[Caio]

Ok… all right… Finally I arrive in an aswer for all that issue!

I will open a new thread to explain about that… and I supose some users will like. The PDF I post here about migration procedure between databases is ok but no complete, after Oracle buy MySQL some stuffs change. I will post details in my new thread.