由于初学JAVA  安装了oracle10g 并用myeclips连接oracle,报了错.还望各位帮助,感谢感谢!
package aaa;
import java.sql.*;
public class ljdemo {

/**
 * @param args
 * @throws ClassNotFoundException 
 * @throws SQLException 
 */
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@locahost:1521/orcl","projectText","projectText");
}}
报错:
Exception in thread "main" java.sql.SQLException: Io 异常: Invalid connection string format, a valid format is: "host:port:sid" 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at aaa.ljdemo.main(ljdemo.java:12)

解决方案 »

  1.   

    看报的错误 是 Invalid connection string format, a valid format is: "host:port:sid" 用 有道翻译下是无效的连接字符串格式,一个有效的格式是:“host:port:sid”  说明你写错了// 改成jdbc:oracle:thin:@locahost:1521:orcl
    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@locahost:1521/orcl","projectText","projectText");
      

  2.   

    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@locahost:1521/orcl","projectText","projectText");url错了
    jdbc:oracle:thin:@locahost:1521:orcl
    orcl这个是oracle sid 你安装的时候填的啥就写啥 默认是orcl
      

  3.   

    url 填写错误"jdbc:oracle:thin:@" + IP + ":" + Port + ":" + DBName;IP = localhost
    Port = 1521
    DBName = 你所建立数据库的名称
      

  4.   

    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/orcl","projectText","projectText"); 楼上好眼力,少了个l