1、启动tomcat的时候报的一个小错误:
Caused by: java.sql.SQLException: Invalid number format for port number
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 26 more
answer:英文好的童鞋,一看就知道是端口有问题。的确,这是因为配置数据源的时候,url没有写端口号了。
url="jdbc:oracle:thin:@localhost:1521:db_name" 这里的1521就是端口号了。
协议名:jdbc,子协议名:oracle:thin 子名称:@localhost:1521:db_name
thin是oracle的一种驱动模式,他还有其他的驱动模式,如oci(oracle cll interface),一般都是用thin
localhost=127.0.0.1 ip地址 1521 oracle默认使用的端口 db_name数据库名称
关键字不区分大小写,值区分大小写。