Question

用 hibernate连接oracle11数据库出现的问题： java.sql.SQLException: 指定了无效的 Oracle URL

javax.servlet.ServletException: org.hibernate.exception.GenericJDBCException: Cannot open
connection org.apache.struts.action.RequestProcessor.processException
(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.jspdev.biyesheji.EncodingFilter.doFilter(EncodingFilter.java:29)。。。。。

我的配置是：
<property name="connection.username">school</property>
<property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:orcl</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="myeclipse.connection.profile"></property>
<property name="hbm2ddl.auto">update</property>
<property name="connection.password">school123</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

Answer 1

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">//头看看一样不，不一样换成自己的。
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">school</property>
<property name="connection.password">school123</property>
<!-- JDBC connection pool (use the built-in)
<property name="connection.pool_size">1</property> -->
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>

<property name="cache.use_query_cache">true</property>

<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">update</property>
<!-- <mapping resource="com/lq/gdb/model/Cat.hbm.xml"/>
<mapping resource="com/lq/model/Teacher.hbm.xml"/>
<mapping resource="com/lq/model/Student.hbm.xml"/>
<mapping class="com.lq.model.Teacher"/>
<mapping class="com.lq.model.Student"/> -->
mapping换成你自己的

</session-factory>
</hibernate-configuration>
估计不是你刚才展示的那些配置的错误呢

Answer 2

<property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:orcl</property>你的这儿配置对吗？数据库名字，端口这些都对吗?

追问

应该都对的，我其它项目连接这个是对的

追答

oracle数据库驱动包jar文件加载到工程了吗？

追问

是的，我加的是ojdbc5.jar

追答

把工程移出tomcat，重新部署工程到tomcat一下看看效果

Answer 3

oracle的 JAR包不对吧