今天写了个小程序，环境是：winxp，eclipse3.4 +插件（hibernate tools）。没有用myeclipse 插件（ecplise3.4.2的现在没有myeclipse插件吧？）
创建的是Dynamic Web Project,工程里配置了J2EE Runtime Library,然后我给工程里加了Hibernate.jar和ojdbc14.jar
如下图：
我添加hibernate的时候，我选的是oracle，并且测试成功了。但是在hibernate视图中，显示的错误信息是：Unhandled event loop exception 并且不能打开数据库表信息，自然就不能添加映射文件了。当一点击Database的时候出现的错误如下：
Error
Sat Apr 18 22:57:25 CST 2009
java.sql.SQLException: 列名无效

java.sql.SQLException: 列名无效
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:37)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:59)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:483)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$2.execute(LazyDatabaseSchemaWorkbenchAdapter.java:114)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:64)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:105)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:61)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:105)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:234)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Error
Sat Apr 18 22:57:25 CST 2009
org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:null
Configured catalog:null
Available schemas:
ANONYMOUS
CTXSYS
DBSNMP
DIP
DMSYS
EXFSYS
MAOYI
MDDATA
MDSYS
MGMT_VIEW
OLAPSYS
ORDPLUGINS
ORDSYS
OUTLN
SCOTT
SI_INFORMTN_SCHEMA
SYS
SYSMAN
SYSTEM
WKPROXY
WKSYS
WK_TEST
WMSYS
XDB
Available catalogs:

org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:null
Configured catalog:null
Available schemas:
ANONYMOUS
CTXSYS
DBSNMP
DIP
DMSYS
EXFSYS
MAOYI
MDDATA
MDSYS
MGMT_VIEW
OLAPSYS
ORDPLUGINS
ORDSYS
OUTLN
SCOTT
SI_INFORMTN_SCHEMA
SYS
SYSMAN
SYSTEM
WKPROXY
WKSYS
WK_TEST
WMSYS
XDB
Available catalogs:

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.handleSQLException(JDBCMetaDataDialect.java:44)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:62)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:483)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$2.execute(LazyDatabaseSchemaWorkbenchAdapter.java:114)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:64)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:105)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:61)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:105)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:234)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: java.sql.SQLException: 列名无效
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:37)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:59)
... 9 more

请问这是为什么？请大家指点！谢谢
还有用eclipse3.4+插件创建ssh web应用的具体步骤是什么呢？一步一步的来，谢谢大家。我是小菜鸟····，我的分全压上了！
[img]/upload/attachment/95437/a7debc86-c35e-32fa-88c0-9295c59659c7.jpg[/img]

[img]/upload/attachment/95432/ae575f91-5061-3f87-869d-0d9a70d689e4.jpg[/img]

[img]/upload/attachment/95440/13b0766d-d930-358a-bad3-67f20b9b6923.jpg[/img]

[img]/upload/attachment/95430/61d86ebe-8470-370b-bb26-ca500cc5f90f.jpg[/img]

[img]/upload/attachment/95434/70f824a4-106e-3d8f-b3b9-146e113704aa.jpg[/img]

[b]问题补充：[/b]
谢谢hantsy的提示。问题不是出在这里的。好像是eclipse的某个缓存问题，导致加不上，今天早上居然加上了，然我很是费解。（是不是昨天买了3斤苹果给朋友吃了，导致人品上涨了-_-!）呵呵，题外话！不管那么多了，少的jar包一会再加（ssh整合的时候）。现在问题改了，改成怎么在eclipse 下把struts、spring和hibernate整合在一起？我没视频，上网上找，暂时没找到。希望各位朋友能给步骤详细说明一下！谢谢各位！分数不撤销。
[b]问题补充：[/b]
谢谢hantsy给的资料，我看了。收藏一下。现在我现在已经配置了hibernate.cfg.xml文件了。里面的信息就是dataSouce里面的信息---连接数据库的地址，用户名，密码，驱动，方言这些东西。问题是eclipse里面我没有发现和myeclipse一样里面把hibernate交给spring来管理的这么一个过程，请问现在改怎么把他们整合在一起，照着applictionContext.xml里面的内容写就不太合适了吧？现在我应该怎么改呢？
我目前想整合的是struts1.2+spring2.2+hibeinate3.2,以后还继续整合struts2+spring+hibernate。

myeclipse2019无法新建web工程

weixin_43773929

2个回复