java.lang.OutOfMemoryError: Java heap space
Brought to you by:
johncurrier
Hi,
First, congrats for this app it is amazing!!!
Well, I already created some schemaspy documentations with this app and now I am receiving an error message (Gathering schema details...Exception in thread "main" java.lang.OutOfMemoryError: Java heap space). I tried to found the solution on the sourceforge site but without success.
I am using the parameter -i with some tables... and I believe that the number of those tables is my problem.
Could you help how Can I proceed to increase the java space or other solution ?!
I have the last version ... schemaSpy_5.0.0.jar
Thank you.
D:\schemaSpy>C:\app\Oracle\product\11.2.0\client_2\jdk\bin\java -jar schemaSpy_5.0.0.jar -dp ojdbc14.jar -t orathin -db BD -
host 10.1.60.52 -port 1521 -u DES -p des -o "d:\schemaSpy\DES_tab_EMP" -norows -hq -
s DES -i "(ACAO_LDO_PPA)|(AGENCIA)|(APLICACAO_RECURSO)|(BANCO)|(BLOQUEIO_SALDO)|(CATEGORIA_DESPESA)|(CEPS)|(CIDADE)|(C
LASSIFICACAO_DESPESA)|(CLASSIFICACAO_PLANO_CONTAS)|(CLASSIFICACAO_RECEITA)|(CONTA_PROCESSADA)|(CONVENIO)|(CRITERIO_JULGAMENTO)|(DE
SDOBRAMENTO_FONTE)|(DETALHAMENTO_FONTE)|(DIV_BAIRRO)|(DIV_CEP)|(DIV_CIDADE)|(DIV_ESTADO)|(DIV_PAIS)|(DOTACAO_ORCAMENTARIA_EXECUCAO
)|(ELEMENTO_DESPESA)|(EMPENHO)|(EMPENHO_EXCECOES)|(EMPRESA)|(ENDERECOS)|(ESTADO)|(EXERCICIO_EMPRESA)|(FONTE)|(FONTE_GRUPO_RECURSO)
|(FONTE_PRIMARIA)|(FONTE_TCE)|(FONTE_USO)|(FORNECEDOR)|(FUNCAO)|(FUNDAMENTACAO)|(GRUPO_DESPESA)|(GRUPO_UNIDADE_CUSTO)|(GUIA_IMPOST
O)|(GUIAS_INSS)|(HISTORICO_CONTABILIDADE)|(ITEM_DESP_CONTROLE_INTERNO)|(ITENS_EMPENHO)|(ITENS_EMPENHO_TCE)|(LEI_ATO_TCE)|(METRICA)
|(MIGRACAO_FOLHA)|(MODALIDADE)|(MODALIDADE_APLICACAO)|(MOVIMENTACAO_EMPENHO)|(MOVIMENTACAO_EXTRA_ORC)|(MOVIMENTACAO_PARCELA_FINANC
EIR)|(ORDEM_EXTRA_IRRF)|(ORDEM_FOLHA_PAGAMENTO)|(ORDEM_PGTO_EXTRA_ORCAMENTARIA)|(ORGAO)|(ORGAO_CONSOLIDADO)|(ORGAO_ORDENADOR)|(ORI
GEM_RECURSO)|(PLANO_CONTAS_ORDEM_EXTRA)|(PLNUNMUNIDADE_MEDIDA)|(PROC_COMPRA)|(PROGRAMA)|(PROJETO_ATIVIDADE)"
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/orathin.properties
Gathering schema details....................................................................Exception in thread "main" java.lang.O
utOfMemoryError: Java heap space
at oracle.jdbc.driver.OracleStatement.prepareAccessors(OracleStatement.java:868)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1045)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at oracle.jdbc.OracleDatabaseMetaData.keys_query(OracleDatabaseMetaData.java:3086)
at oracle.jdbc.OracleDatabaseMetaData.getImportedKeys(OracleDatabaseMetaData.java:3153)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:55)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
at net.sourceforge.schemaspy.model.RemoteTable.connectForeignKeys(RemoteTable.java:60)
at net.sourceforge.schemaspy.model.Database.addRemoteTable(Database.java:746)
at net.sourceforge.schemaspy.model.Table.addForeignKey(Table.java:199)
D:\schemaSpy>pause
Pressione qualquer tecla para continuar. . .
\java -Xmx1073741824 -jar schemaSpy_5.0.0.jar -dp ojdbc14.jar -t orathin -db
This parameter soved my problem... for this moment...
https://plumbr.eu/outofmemoryerror/java-heap-space