关于java连接oracle集群url问题

0 0

关于java连接oracle集群url问题5

数据库url : jdbc:oracle:thin@(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.131)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))
      (LOAD_BALANCE = no)(FAILOVER=YES)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CLDB)
    )
)
数据库配置的net manager可以使用也可以查得出数据，但是用jdbc连就报异常如下:

java.sql.SQLException: æå®äºæ æç
                                 Oracle URL
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:504)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
        at com.voice.hibernate.HibernateSessionFactory.init(HibernateSessionFactory.java:56)
        at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:869)
        at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
        at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3190)
        at org.apache.catalina.loader.WebappLoader.backgroundProcess(WebappLoader.java:404)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1309)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
        at java.lang.Thread.run(Thread.java:595)

服务器是linux因此不能显示中文。我想应该是 指定了无效url.后来我把空格去掉还是报以上错误。求教达人帮助

<session-factory>
		<property name="connection.username">***</property>
		<property name="connection.url">jdbc:oracle:thin@(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.131)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))
      (LOAD_BALANCE = YES)(FAILOVER=YES)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CLDB)
    )
  )</property>
		<property name="dialect">
			org.hibernate.dialect.Oracle9Dialect
		</property>
		<property name="myeclipse.connection.profile">oracle</property>
		<property name="connection.password">***</property>
		<property name="connection.driver_class">
			oracle.jdbc.driver.OracleDriver
		</property>

驱动用的是classes12.jar 同样ojdbc14.jar也试过还是报以上错误

Hibernate