[jboss-user] [JNDI and Naming] - ORA-12519, TNS:no appropriate service handler found
tamizharasi periyasamy
do-not-reply at jboss.com
Wed Aug 3 10:31:57 EDT 2011
tamizharasi periyasamy [http://community.jboss.org/people/tamizharasi.periyasamy] created the discussion
"ORA-12519, TNS:no appropriate service handler found"
To view the discussion, visit: http://community.jboss.org/message/619159#619159
--------------------------------------------------------------
Hi,
I am trying to connect a oracle 10g server. Following is my
Oracle ds entry
<local-tx-datasource>
<jndi-name>dnbame</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:oracle:thin:@...................:XE</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>....</user-name>
<password>...</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>OracleXE</type-mapping>
</metadata>
</local-tx-datasource>
I am able to make connection and fetch the data. But it throws the warning like
10:15:14,523 WARN [JBossManagedConnectionPool] Unable to fill pool
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
...................:XE
)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:584)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:531)
at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)
at java.lang.Thread.run(Unknown Source)
Could any one tell me why I am getting this error and how to solve this issue?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/619159#619159]
Start a new discussion in JNDI and Naming at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2083]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110803/b92f00cb/attachment.html
More information about the jboss-user
mailing list