The latest tool doesn't work well... alpha 4.

etienne · **Posted:** Tue Jul 19, 2005 9:29 am

Tool problem

I use Eclipse 3.1 with the latest tool (3.0 alpha 4) and I have this strange problem :

Error 2005-07-18 18:22:30.249 The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

Code:

Error 2005-07-18 18:22:30.249 The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.
com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1511)
at com.sybase.jdbc2.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:69)
at com.sybase.jdbc2.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:2288)
at com.sybase.jdbc2.jdbc.SybDatabaseMetaData.getColumns(SybDatabaseMetaData.java:1892)
at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:732)
at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:123)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:91)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:37)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:237)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:77)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:234)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:164)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:132)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:98)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

I have the same error than this mail:
http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-6825-view-previous.html

Also, check your help page at http://www.hibernate.org/hib_docs/tools/ant/

the hibernate-reverse-engineering.xml example is not valide xml.

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering SYSTEM "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >
<hibernate-reverse-engineering>

   <type-mapping>
      <sql-type jdbc-type="VARCHAR" length='20' hibernate-type="SomeUserType" /> <-- jdbc-type is name fom java.sql.Types -->
      <sql-type jdbc-type="VARCHAR" length='1' hibernate-type="yes_no" />
      <sql-type jdbc-type="NUMERIC"  precision='1' hibernate-type="boolean" /> <-- length, scale and precision can be used to specify the mapping precisly -->
        <sql-type jdbc-type="NUMERIC"  hibernate-type="long" /> <-- the type-mappings are ordered. This mapping will be consulted last, thus overriden by the previous one if precision=1 for the column -->
   </type-mapping>

   <table-filter match-name="BIN$.*" exclude="true" /> <-- BIN$ is recycle bin tables in Oracle -->
   <table-filter match-name="DoNotWantIt" exclude="true" /> <-- Exclude DoNotWantIt from all catalogs/schemas -->
   <table-filter match-catalog="BAD" match-schema="SCHEMA" match-name=".*" exclude="true" /> <-- exclude all tables from the schema SCHEMA in catalog BAD. -->
   
</hibernate-reverse-engineering>

So, I have revert to an older version of Eclipse having an oldest Hibernate tool and now everithing is working fine with the same workspace!

Etienne.

max · **Posted:** Tue Jul 19, 2005 11:58 am

the schema export is the same as before - have not changed it and it seems sybase is the "bad" boy here. If you can tell me what we do wrong since sybase cannot handle create table like any other then i will be glad to fix it.

the possible bad reveng.xml you are referring too - please provide a patch in the jira.

max · **Posted:** Tue Jul 19, 2005 12:03 pm

http://manuals.sybase.com/onlinebooks/g ... View/34899

where it is explained how to run DDLs in a transaction.

Does schemaexport work for you via ant/directly ?

max · **Posted:** Tue Jul 19, 2005 12:06 pm

hmm sorry - it is not even schemaexport that is the issue it is sybase that cannot handle .getColumns(). This is definitly a limitation of sybase.

I find it very hard to belive that this would work with a previous version.

etienne · **Posted:** Wed Jul 20, 2005 10:14 am

Yes it work well with my previous version.

I used eclipse3.1M7 and org.hibernate.eclipse.feature_3.0.0.alpha2 + org.jboss.ide.eclipse.ui_1.5.0.m1. It has some minor problem, but I was able to make all my pojo with the reverse engineering. I used the same workspace in 3.1M7 and 3.1.

The problematic xml examples are at http://www.hibernate.org/hib_docs/tools/ant/

Etienne

here the configuration detail of eclipse3.1M7 where my reverse eng. worked :

Code:

*** System properties:
awt.toolkit=sun.awt.windows.WToolkit
eclipse.application=org.eclipse.ui.ide.workbench
eclipse.buildId=I20050627-1435

...

 Configured features:
  ID: com.ibm.wtp.emf.integration.core, Version: 1.0.1.2
  ID: org.hibernate.eclipse.feature, Version: 3.0.0.alpha2
  ID: org.eclipse.jdt.source, Version: 3.1.0
  ID: org.eclipse.emf.ecore.sdo.source, Version: 2.0.3
  ID: org.eclipse.sdk, Version: 3.1.0
  ID: org.eclipse.pde.source, Version: 3.1.0
  ID: org.eclipse.rcp.source, Version: 3.1.0
  ID: org.springframework, Version: 1.0.2
  ID: org.eclipse.emf.ecore.sdo.doc, Version: 2.0.3
  ID: org.eclipse.gef.examples.source, Version: 3.0.1
  ID: org.springframework.ide.eclipse.beans, Version: 1.0.3
  ID: org.eclipse.platform, Version: 3.1.0
  ID: org.eclipse.emf.source, Version: 2.0.3
  ID: org.eclipse.gef.source, Version: 3.0.1
  ID: org.eclipse.jdt, Version: 3.1.0
  ID: org.eclipse.jem, Version: 1.0.2
  ID: org.eclipse.ve.source, Version: 1.0.2.1
  ID: org.eclipse.gef, Version: 3.0.1
  ID: org.eclipse.gef.source, Version: 3.0.1
  ID: org.eclipse.emf, Version: 2.0.3
  ID: org.eclipse.jem.source, Version: 1.0.2.1
  ID: org.eclipse.platform.source, Version: 3.1.0
  ID: org.eclipse.ve.sdk, Version: 1.0.1
  ID: org.eclipse.rcp, Version: 3.1.0
  ID: org.eclipse.ve, Version: 1.0.1
  ID: org.eclipse.emf.sdk, Version: 2.0.3
  ID: org.eclipse.xsd.doc, Version: 2.0.2
  ID: org.eclipse.xsd.source, Version: 2.0.2
  ID: net.sourceforge.eclipseccase, Version: 1.0.2
  ID: com.ibm.wtp.common.utilities, Version: 1.0.1
  ID: org.eclipse.pde, Version: 3.1.0
  ID: org.eclipse.emf.doc, Version: 2.0.3
  ID: org.eclipse.emf.ecore.sdo, Version: 2.0.3
  ID: org.eclipse.xsd, Version: 2.0.2
  ID: org.eclipse.jem.sdk, Version: 1.0.1
  ID: org.eclipse.emf.examples, Version: 2.0.1

 Configured plug-ins:
  file:/d:/eclipse3.1/plugins/com.ibm.etools.emf.event_3.0.0.1/
  file:/d:/eclipse3.1/plugins/com.ibm.wtp.common.util_1.0.1/
  file:/d:/eclipse3.1/plugins/com.ibm.wtp.emf.workbench_1.0.1.2/
  file:/d:/eclipse3.1/plugins/net.sourceforge.clearcase_1.0.2/
  file:/d:/eclipse3.1/plugins/net.sourceforge.eclipseccase.ui_1.0.2/
  file:/d:/eclipse3.1/plugins/net.sourceforge.eclipseccase_1.0.2/
  file:/d:/eclipse3.1/plugins/org.apache.ant_1.6.5/
  file:/d:/eclipse3.1/plugins/org.apache.lucene_1.4.3/
  file:/d:/eclipse3.1/plugins/org.apache.xalan_2.6.0/
  file:/d:/eclipse3.1/plugins/org.apache.xerces_2.6.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.ant.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ant.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.compare_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.boot_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.commands_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.expressions_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.filebuffers_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.resources.compatibility_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.resources.win32_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.resources_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.runtime.compatibility_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.runtime_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.core.variables_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.debug.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.debug.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.draw2d.doc.isv_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.draw2d_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.draw2d_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.activities_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.codegen.ecore.ui_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.codegen.ecore_2.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.codegen.ui_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.codegen_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.common.ui_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.commonj.sdo_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.common_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.common_2.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.doc_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.change.edit_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.change_2.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.editor_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.edit_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.sdo.doc_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.sdo.editor_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.sdo.edit_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.sdo.source_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.sdo_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.xmi_2.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore.xmi_2.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.ecore_2.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.edit.ui_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.edit_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.examples_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.java.editor_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.java.edit_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.java_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.mapping.ecore2ecore.editor_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.mapping.ecore2ecore_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.mapping.ui_2.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.mapping.xsd2ecore.editor_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.mapping.xsd2ecore_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.mapping_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf.source_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.emf_2.0.3/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef.doc.isv_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef.examples.flow_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef.examples.logic_3.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef.examples.source_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef.source_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef_3.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.gef_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.help.appserver_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.help.base_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.help.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.help.webapp_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.help_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.debug.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.debug_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.doc.isv_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.doc.user_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.junit.runtime_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.junit_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.launching_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.source_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jdt_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.beaninfo_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.proxy_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.sdk_1.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.source_1.0.2.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.ui_1.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.util_1.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem.workbench_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.jem_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.jface.text_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.jface_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ltk.core.refactoring_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ltk.ui.refactoring_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.osgi.services_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.osgi.util_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.osgi_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.build_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.doc.user_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.junit.runtime_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.runtime_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.source_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.pde.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.pde_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.platform.doc.isv_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.platform.doc.user_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.platform.source.win32.win32.x86_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.platform.source_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.platform_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.rcp.source.win32.win32.x86_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.rcp.source_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.rcp_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.sdk_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.search_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.swt.win32.win32.x86_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.swt_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.team.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.team.cvs.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.team.cvs.ssh2_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.team.cvs.ssh_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.team.cvs.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.team.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.text_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.tomcat_4.1.30.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.browser_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.cheatsheets_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.console_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.editors_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.externaltools_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.forms_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.ide_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.intro_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.presentations.r21_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.views_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.win32_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.workbench.compatibility_3.1.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.workbench.texteditor_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui.workbench_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.update.configurator_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.update.core.win32_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.update.core_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.update.scheduler_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.update.ui_3.1.0.jar
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.cde_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.doc_1.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.java.core_1.0.2.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.jfc_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.propertysheet_1.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.sdk_1.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.source_1.0.2.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve.swt_1.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.ve_1.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.common.frameworks.ui_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.common.frameworks_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.common.ui_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.common.uriresolver_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.dtd.core_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.sse.core_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.sse.ui_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.validation_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.xml.core_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.xml.ui_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.xml.uriresolver.ui_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.wst.xml.uriresolver_1.0.0/
  file:/d:/eclipse3.1/plugins/org.eclipse.xsd.doc_2.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.xsd.editor_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.xsd.edit_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.xsd.source_2.0.2/
  file:/d:/eclipse3.1/plugins/org.eclipse.xsd.test_2.0.1/
  file:/d:/eclipse3.1/plugins/org.eclipse.xsd_2.0.2/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse.console_3.0.0.alpha2/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse.console_3.0.0.alpha4/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse.help_3.0.0.alpha4/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse.mapper_3.0.0.alpha2/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse.mapper_3.0.0.alpha4/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse_3.0.0.alpha2/
  file:/d:/eclipse3.1/plugins/org.hibernate.eclipse_3.0.0.alpha4/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.j2ee.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.j2ee.jsp.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.j2ee.xml.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.j2ee.xml.ui_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.test.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.test.ui_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.ui_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.ws.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.ws.ui_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.xml.core_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.jdt.xml.ui_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.jboss.ide.eclipse.ui_1.5.0.m1/
  file:/d:/eclipse3.1/plugins/org.junit_3.8.1/
  file:/d:/eclipse3.1/plugins/org.springframework.core_1.0.2/
  file:/d:/eclipse3.1/plugins/org.springframework.doc.reference_1.0.2/
  file:/d:/eclipse3.1/plugins/org.springframework.ide.eclipse.beans.core_1.0.2/
  file:/d:/eclipse3.1/plugins/org.springframework.ide.eclipse.beans.ui.doc_1.0.0/
  file:/d:/eclipse3.1/plugins/org.springframework.ide.eclipse.beans.ui.graph_1.0.0/
  file:/d:/eclipse3.1/plugins/org.springframework.ide.eclipse.beans.ui_1.0.3/
  file:/d:/eclipse3.1/plugins/org.springframework.ide.eclipse.beans_1.0.3/
  file:/d:/eclipse3.1/plugins/org.springframework_1.0.2/
  file:/d:/eclipse3.1/plugins/ru.nlmk.eclipse.plugins.profiler/

max · **Posted:** Wed Jul 20, 2005 10:19 am

i know where the xml files are ,)
I asked you to provide a patch if there is an error.

Regarding the sybase problem then I gave you a link on how to fix sybase (something with setting an option that allows you to get metadata while in a transaction)

etienne · **Posted:** Wed Jul 20, 2005 11:04 am

Thanks,

for the bad xml, it is only a bad comment:

<-- exclude all tables from the schema SCHEMA in catalog BAD. -->

instead of


...

Etienne.

max · **Posted:** Wed Jul 20, 2005 11:08 am

thank you - much easier when you pinpoint it ,)

and there were more than one, but they are fixed now.

-max

kshreeram · **Joined:** Wed Jul 06, 2005 4:51 pm **Posts:** 27

IMHO, I think still this multi-statement error of 'create table not allowed with-in mutlistatement transaction in the temp db' needs to be fixed. I don't think changing the flag on the sybase to allow ddl creation in transactions is a solution. From the sybase link which you posted ( I think I posted it in some other thread for a similar problem ), it clearly states that it is not recommended to turn on the setting of ddl creation in transaction. What intrigues me is, HybernateSynchronizer doesn't pose this problem. Why only this version of the tools?

max · **Posted:** Thu Jul 28, 2005 1:57 am

i dont have an sybase installatiion, so you are the most obvious person to provide insight to what works and not. patches welcome.

i guess it is because we make more than one call on a connection (very normal)

sma202 · **Joined:** Tue Sep 20, 2005 3:55 pm **Posts:** 15

Hi, was wondering whether there was a solution for this problem? The latest tools still gives this error upon artifact generation using Sybase 12.5.

Someone suggested that the problem goes away if using a different connection provider if you're only using hibernate:

http://forum.hibernate.org/viewtopic.ph ... b+database

max · **Posted:** Tue Sep 20, 2005 4:19 pm

so did you try ?

this is some weird bug/limitation of their impl of jdbc metadata...

sma202 · **Joined:** Tue Sep 20, 2005 3:55 pm **Posts:** 15

Yes, it does work by using a different provider if i'm using only hibernate by itself but not sure how to change this setting for the tool plugin. I would enable "ddl in tran" for tempdb on the DB just to use the plugin but that requires an SA role.

Since this is particular to sybase transactions in tempdb, I was wondering if a fix could be added to the sybase dialect if it's using tempdb and transactions.

sma202 · **Joined:** Tue Sep 20, 2005 3:55 pm **Posts:** 15

I got past this issue by using a hibernate.properties file with c3p0 enabled but now I get a different error. I don't have foreign keys but I do have primary keys. I suspect the driver is somewhere calling "sp_jdbc_primarykey" which is being used to look up the primary/foreign keys, but the correct parameters are not being passed which results in "No such object or user exists in the database."

I have defined:

hibernate.default_schema dbo
hibernate.default_catalog PBCanCor

and:

<hibernate-reverse-engineering>
<table-filter match-catalog="PBCanCor" match-schema="dbo" match-name="cc_trade_requests"/>
</hibernate-reverse-engineering>

I've tried executing the stored proc directly and it works:

sp_jdbc_primarykey @table_qualifier = "PBCanCor", @table_owner = "dbo", @table_name = "cc_trade_requests"

If the table_owner is not provided properly then it results in this exception being thrown:

org.hibernate.exception.GenericJDBCException: Exception while reading foreign key meta data
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.cfg.reveng.JDBCReader.processForeignKeys(JDBCReader.java:152)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:65)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:55)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:44)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.fetchDeferredChildren(LazyDatabaseSchemaWorkbenchAdapter.java:30)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: No such object or user exists in the database.
at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1705)
at com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:103)
at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:2541)
at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getExportedKeys(SybDatabaseMetaData.java:2091)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getExportedKeys(NewProxyDatabaseMetaData.java:3088)
at org.hibernate.cfg.reveng.JDBCReader.processForeignKeys(JDBCReader.java:90)
... 7 more

max · **Posted:** Wed Sep 21, 2005 2:16 am

that code simply iterates over the table/view names returned from the previous metadata call and ask for exported foreign keys....apparently they give more table names than they have - great ;)