JDBC設定方式 - Oracle

這是網路上找到比較完整的資料，但其實我還是沒設成功....
用PING都可以成功，可是直接去拿DataSource就是null...殘念......

Connection Pools
GlassFish Admin Console -> Resources -> JDBC -> Connection Pools -> Click "New" Button
Input
name: OraclePool
DataSource Classname: oracle.jdbc.pool.OracleDataSource
Resource Type: javax.sql.DataSource
Click "Save" Button

點選 Additional Properties tab
Click Add Property -> Input Name: username Value: myusername
Click Add Property -> Input Name: password Value: mypassword
Click Add Property -> Input Name: url Value: jdbc:oracle:thin:@localhost:1521:orcl
Click "Save" Button

JDBC Resources
GlassFish Admin Console -> Resources -> JDBC -> JDBC Resources -> Click "New" Button
Input
JNDI Name: jdbc/oracle
Pool Name: OraclePool
Click "Save" Button

Integrate JDBC driver
GlassFish Admin Console -> Application Server -> JVM Settings tab -> Path Settings tab
Input Classpath Suffix: C:\XXX\lib\ojdbc14.jar
Click "Save" Button

评论

1 楼 tianxingjian 2009-03-01