[jeus] "부적합한 Oracle URL이 지정되었습니다: OracleDataSource.makeURL" 에러 해결 방법.

"Caused by: java.sql.SQLException: 부적합한 Oracle URL이 지정되었습니다: OracleDataSource.makeURL" 에러 해결 가이드.

 

-JEUS v6.0 Fix#9(was)의 datasource 설정을 통해서 JDBC Connection Pool수행할 때, 하단의 에러 출력을 확인.

<<__Exception__>>
jeus.jdbc.connectionpool.ConnectionPoolException: failed to create the connection pool[anylink]
	at jeus.jdbc.connectionpool.ConnectionPoolImpl.initialize(ConnectionPoolImpl.java:181)
	at jeus.jdbc.connectionpool.ServerSideConnectionPoolInitializer.makeConnectionPool(ServerSideConnectionPoolInitializer.java:43)
	at jeus.jdbc.connectionpool.ConnectionPoolManager.createConnectionPool(ConnectionPoolManager.java:51)
	at jeus.jdbc.connectionpool.CPObjectFactory.getObjectInstance(CPObjectFactory.java:24)
	at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
	at jeus.jndi.JNSContext.lookupInternal(JNSContext.java:584)
	at jeus.jndi.JNSContext.lookup(JNSContext.java:539)
	at jeus.jndi.JNSContext.lookup(JNSContext.java:528)
	at jeus.jndi.JEUSFailoverContext.lookup(JEUSFailoverContext.java:287)
	at javax.naming.InitialContext.lookup(InitialContext.java:411)
	at anylink.common.util.DbUtil.<clinit>(DbUtil.java:30)
	at anylink.batch.BatchUtil.InsertBatchFileLog(BatchUtil.java:109)
	at anylink.batch.banca.soap.SoapBatchSender.sendBatch(SoapBatchSender.java:524)
	at anylink.batch.AnyLinkBatchRunnable.run(AnyLinkBatchRunnable.java:220)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: 부적합한 Oracle URL이 지정되었습니다: OracleDataSource.makeURL
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
	at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
	at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
	at jeus.jdbc.queue.JDBCConnectionRepository.createPooledConnection(JDBCConnectionRepository.java:284)
	at jeus.jdbc.queue.JDBCConnectionRepository.initConnectionRepository(JDBCConnectionRepository.java:79)
	at jeus.jdbc.connectionpool.PooledConnectionProviderImpl.initProvider(PooledConnectionProviderImpl.java:45)
	at jeus.jdbc.connectionpool.ConnectionPoolImpl.initialize(ConnectionPoolImpl.java:163)
	... 14 more
<<__!Exception__>>

---

-트러블 슈팅 가이드

(1번과 2번 가이드 중 하나만 수행하면 됨.)

1.$JEUS_HOME/config/<hostname>/JEUSMain.xml에 하단과 같이 <property> 태그 추가.

<property>
	<name>driverType</name>
	<type>java.lang.String</type>
	<value>thin</value>
</property>

---

2.JEUS Web Admin -> JEUS 매니저 리소스 -> JDBC -> Export Name -> JDBC 데이터 소스 서비스 - 기본 설정

2.1.Property 항목에 "driverType=thin" 입력 후 커밋.