maoyi83929925 2009-04-18 22:02
浏览 238
已采纳

eclipse3.4 +插件开发ssh web应用

今天写了个小程序,环境是: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。

  • 写回答

3条回答

  • hantsy 2009-04-19 21:20
    关注

    你说这些在上面文档中都有解决,下载一份源代码,就可以看到。
    必须说明的是,不管是你技术处于什么层次,不要依赖IDE。
    myeclipse 我用过一次,06年我才用eclipse,之前都是用jbuilder(从jb8开始使用)。
    一般的练习用一个text editor就够了。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办
  • ¥15 kylin启动报错log4j类冲突
  • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
  • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序