由于初学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)
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)
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@locahost:1521/orcl","projectText","projectText");
jdbc:oracle:thin:@locahost:1521:orcl
orcl这个是oracle sid 你安装的时候填的啥就写啥 默认是orcl
Port = 1521
DBName = 你所建立数据库的名称