users@glassfish.java.net

RE: Getting Class name is wrong or classpath is not set for : oracle.jdbc.pool

From: Martin Gainty <mgainty_at_hotmail.com>
Date: Mon, 7 Dec 2009 09:16:38 -0500

Kumar

nothing we can do to solve your problem if you dont attach :
the abending code sample
specifics of version for the oracle jdbc driver you are using
log with full stacktrace

and at the very minimum /META-INF/ra.xml should contain:
<connection-definition>

                <config-property>
                    <config-property-name>ClassName</config-property-name>
                    <config-property-type>java.lang.String</config-property-type>
                    <config-property-value>oracle.jdbc.pool.OracleDataSource</config-property-value>
                </config-property>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>

                <!-- Since 9.1 supports both JDBC 3.0 and JDBC 4.0,
                ConnectionFactory will be
                com.sun.gjc.spi.jdbc30.DataSource (JDK 1.5) or
                com.sun.gjc.spi.jdbc40.DataSource (JDK 1.6)
                -->
                <connectionfactory-impl-class>com.sun.gjc.spi.DataSource</connectionfactory-impl-class>

                <connection-interface>java.sql.Connection</connection-interface>

                <!-- Since 9.1 supports both JDBC 3.0 and JDBC 4.0,
                Connection will be
                com.sun.gjc.spi.jdbc30.ConnectionHolder30 (JDK 1.5) or
                com.sun.gjc.spi.jdbc40.ConnectionHolder40 (JDK 1.6)
                -->
                <connection-impl-class>com.sun.gjc.spi.ConnectionHolder</connection-impl-class>

</connection-definition>

here is a listing of my oracle type4 jdbc drivers (which work in Oracle 11i)

ls -al $ORACLE_HOME%/jdbc/lib

08/16/2005 1,590,041 classes12.jar
08/16/2005 1,602,539 classes12.zip
08/16/2005 1,597,679 classes12dms.jar

Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.






> Date: Mon, 7 Dec 2009 01:56:10 -0800
> From: glassfish_at_javadesktop.org
> To: users_at_glassfish.dev.java.net
> Subject: Getting Class name is wrong or classpath is not set for : oracle.jdbc.pool
>
> Dear All,
>
> I am getting the below error while testing the Connection pool created (Oracle). I have set the classes12.jar in Classpath Suffix(JVM Options / Path Settings) in SunOne9.1 App Server.
> PFA screenshot for reference.
>
> Kindy revert with your inputs on this.
>
> Regards,
> Kumar
> [Message sent by forum member 'dv320002205' ]
>
> http://forums.java.net/jive/thread.jspa?messageID=375101
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
                                               
_________________________________________________________________
Chat with Messenger straight from your Hotmail inbox.
http://www.microsoft.com/windows/windowslive/hotmail_bl1/hotmail_bl1.aspx?ocid=PID23879::T:WLMTAGL:ON:WL:en-ww:WM_IMHM_4:092009