• RELEVANCY SCORE 4.80

    DB:4.80:Classpath Problem With Exejava fz




    I want to query a oracleDB from execJava called java code. I have the problem, where I have to place the ojdbc14.jar and how to define the classpath.
    If I put it in the classpath of execJava in that way:

    execJava className='AbixExecutorFactory' classPath='/tmp/ojdbc14.jar:/tmp/AbixExecutorFactory.jar'
    argList connect=':[connect]' query=':[query]'/argList
    /execJava

    I get the error:

    Problems encountered during plan run or preflight

    Error loading java procedure classes from classpath "/tmp/ojdbc14.jar:/tmp/AbixExecutorFactory.jar" (026072)
    AbixExecutorFactory

    How or where I should set the classpath for the Oracle Thin driver ojdbc14.jar?

    DB:4.80:Classpath Problem With Exejava fz

    Oh, I have found the problem:
    there must be a semicolon between the jar paths, not a colon!

  • RELEVANCY SCORE 4.09

    DB:4.09:Re: Problem Executing Oracleconnectivity.Jar pf




    java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

    - it means class not found. Check your classpath

    Class "oracle.jdbc.OracleDriver" is in ojdbc14.jar

  • RELEVANCY SCORE 3.96

    DB:3.96:Problem In Publication Class. 8k




    hi,

    I have a java Program for creating Publication on server.I am trying to run it on command Prompt.Compilation is Ok but whenever I run,It shows a ExceptionInIntilizer error.It is unable to create the object of ConsolidateManager Class.
    I have classpath set for Olite jar,Consolidator jar,devmgr jar,ojdbc14 jar,classes12.jar.

    Plz Provide some solution.

    Thanks
    Mohit

    DB:3.96:Problem In Publication Class. 8k

    our batch script for development is
    @echo off

    if not %2x==x goto :ok
    echo Usage: fusionbci2 [Repository_Password] [Drop/Create/Modify]

    goto :done

    :ok

    set OLITE_HOME=c:\oracle\olite
    set JAVA_HOME=c:\oracle\ora10g\jdk

    rem enable the appropriate JDBC_URL for the environment
    rem development
    set JDBC_URL=jdbc:oracle:thin:@server:1521:cdbd

    SET CLASSPATH=%OLITE_HOME%\mobile\sdk\bin\webtogo.jar;%OLITE_HOME%\mobile\sdk\bin\msql.jar;%OLITE_HOME%\mobile\classes\share.jar;c:\sqldeveloper\jdbc\lib\ojdbc14.jar;%OLITE_HOME%\mobile\classes\consolidator.jar;%OLITE_HOME%\mobile\classes\classgen.jar;%OLITE_HOME%\mobile\classes\servlet.jar;%OLITE_HOME%\mobile\server\bin\jzlib.jar;%OLITE_HOME%\mobile_oc4j\j2ee\mobileserver\applications\mobileserver\admin-web\WEB-INF\lib\console.jar;%OLITE_HOME%\mobile\classes\xmlparserv2.jar;%OLITE_HOME%\mobile\classes\jssl-1_2.jar;%OLITE_HOME%\mobile\classes\javax-ssl-1_2.jar;%OLITE_HOME%\mobile\server\bin\devmgr.jar;%OLITE_HOME%\mobile\server\bin\aes.jar;%OLITE_HOME%\mobile\classes\phaos.jar;.

    %JAVA_HOME%\bin\javac -deprecation fusionbci2.java

    %JAVA_HOME%\bin\java fusionbci2 %1 %JDBC_URL% %2

    :done

    for the releases we use a shell script as the servers are linux, with a third parameter for the environment that sets the classpaths, oracle homes and jdbc connections

  • RELEVANCY SCORE 3.88

    DB:3.88:Question On Classpath a3


    Hi,

    I can run the application use this command line:

    java -classpath .;C:\oracle\ora92\jdbc\lib\ojdbc14.jar TestClassForNameApp

    If I use the batch containing the following:

    set CLASSPATH = .;C:\oracle\ora92\jdbc\lib\ojdbc14.jar
    java TestClassForNameApp

    I get this message:

    Can't find class oracle.jdbc.OracleDriver

    Could anyone please explain to me?

    Thanks.

    myao1

    DB:3.88:Question On Classpath a3

    set CLASSPATH = .;C:\oracle\ora92\jdbc\lib\ojdbc14.jarType this at the command line, then type "set" by itself on the next command line. You will see that your CLASSPATH variable has not been set. Next, type the following string at the command line:

    set CLASSPATH=.;C:\oracle\ora92\jdbc\lib\ojdbc14.jar

    and type "set" on the command line to see what effect it had.

  • RELEVANCY SCORE 3.77

    DB:3.77:Re: Classpath Inside A Jar File... 3z


    So, sub-directories within the application JAR file are already in the classpath?

    If so, all I really need to do is add the ojdbc14.jar file to the manifest classpath?
    If this is the case, can you tell me what the correct syntax is that I need to add to the manifest classpath in order for it to include the external JAR file that is in the same directory?

    Sorry if I'm being a little dense. Thank you for your patience. :)

    DB:3.77:Re: Classpath Inside A Jar File... 3z

    Thanks DrClap......that was just for a thought exercise, nothing I really need to worry about. Cheers!

  • RELEVANCY SCORE 3.73

    DB:3.73:Classnotfoundexception: Oracle.Jdbc.Driver.Oracledriver .. a7


    Hello! I am trying to write a java applet that would connect to my database an then execute some queries. When i try to connect to the DB i get ClassNotFoundException: oracle.jdbc.driver.OracleDriver ..
    I have found java code for this here(http://www.java2s.com/Code/Java/Database-SQL-JDBC/AppletandOracleJDBC.htm) so i am quite sure that it is not a code problem.
    I have checked that ojdbc14.jar file is in C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib and set my CLASSPATH to C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar too (is that ok??? Do i have to download classes12.jar as well?? I have jdk1.6.0_12).
    Also i have to tell you that i have written a java program which connects normally to the database and executes any queries without any exception.However,each time i try to run the HTML page with the java applet inside i get ClassNotFoundException: oracle.jdbc.driver.OracleDriver .. exception. When i write java oracle.jdbc.driver.OracleDriver to check if the driver is ok i get an error: Exception in thread 'main' java.lang.NoSuchMethodError :main.
    I would appreciate any help.Thanx in advance for any answers...

    DB:3.73:Classnotfoundexception: Oracle.Jdbc.Driver.Oracledriver .. a7

    Hello! I am trying to write a java applet that would connect to my database an then execute some queries. When i try to connect to the DB i get ClassNotFoundException: oracle.jdbc.driver.OracleDriver ..
    I have found java code for this here(http://www.java2s.com/Code/Java/Database-SQL-JDBC/AppletandOracleJDBC.htm) so i am quite sure that it is not a code problem.
    I have checked that ojdbc14.jar file is in C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib and set my CLASSPATH to C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar too (is that ok??? Do i have to download classes12.jar as well?? I have jdk1.6.0_12).
    Also i have to tell you that i have written a java program which connects normally to the database and executes any queries without any exception.However,each time i try to run the HTML page with the java applet inside i get ClassNotFoundException: oracle.jdbc.driver.OracleDriver .. exception. When i write java oracle.jdbc.driver.OracleDriver to check if the driver is ok i get an error: Exception in thread 'main' java.lang.NoSuchMethodError :main.
    I would appreciate any help.Thanx in advance for any answers...

  • RELEVANCY SCORE 3.70

    DB:3.70:Classpath Problem Instatiating Oracle Driver zz


    Hi everybody,

    I have made a little desktop application that fetches sum data in a oracle database and processes it. The program runs fine when I run it from my IDE. I have downloaded the oracle driver classes ojdbc14.jar . My problem is that I cant seem to set the classpath correct when running the application from commandline.

    I use the command:
    java -classpath .:ojdbc14.jar:jdom.jar QueryBox

    where jdom.jar is for postprocessing the data i fetch out, and QueryBox is the GUI that starts the application.

    The program is started correctly but when I come down to this part in the code:

    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());Then an execption occurs because for some reason it cannot find the OracleDriver class when im runnin from commandline. Any help wud be much appreciated!

    DB:3.70:Classpath Problem Instatiating Oracle Driver zz

    Don't register the driver that way - just do this:

    Class.forName("oracle.jdbc.driver.OracleDriver");That registers the driver class. - MOD

  • RELEVANCY SCORE 3.67

    DB:3.67:Problem Using Ojdbc14.Jar In Jdev 11g 3x


    Hi

    I have an application created in 10g.
    I was trying to create the same in 11g and encountered this problem with the ojdbc14.jar.

    The jar has two classes OracleDataSource and OracleConnectionCacheImpl inside the same package.
    OracleConnectionCacheImpl is inherited from OracleDataSource.
    OracleDataSource has a protected variable called m_dataSourceName.
    The child class, OracleConnectionCacheImpl used this variable.

    I have this jar included in my classpath.
    When i run the application, it throws a runtime error.
    Following is the stack trace.

    java.lang.NoSuchFieldError: m_dataSourceName
    at oracle.jdbc.pool.OracleConnectionCacheImpl.(OracleConnectionCacheImpl.java:189)
    at oracle.apps.snw.hubserver.common.XhubConnectionPool.(XhubConnectionPool.java:46) ------------------------------------- from here its my code
    at oracle.apps.snw.hubserver.common.XhubConnectionPoolManager.addConnectionPool(XhubConnectionPoolManager.java:168)
    at oracle.apps.snw.hubserver.common.XhubConnectionPoolManager.getConnection(XhubConnectionPoolManager.java:201)
    at oracle.apps.snw.hubserver.util.SystemParameters.reloadAllParameters(SystemParameters.java:294)
    at oracle.apps.snw.hubserver.util.SystemParameters.(SystemParameters.java:34)
    at oracle.apps.snw.hubserver.util.SystemParameters.getInstance(SystemParameters.java:48)
    at oracle.apps.snw.hubserver.common.XhubConnectionPoolManager.addConnectionPool(XhubConnectionPoolManager.java:155)
    at oracle.apps.snw.hubserver.common.XhubConnectionPoolManager.getConnection(XhubConnectionPoolManager.java:201)
    at oracle.apps.snw.common.util.LanguageQueryBasedNameValueCache.queryAllLanguages(LanguageQueryBasedNameValueCache.java:125)
    at oracle.apps.snw.common.util.LanguageQueryBasedNameValueCache.setCacheParameters(LanguageQueryBasedNameValueCache.java:77)
    at oracle.apps.snw.common.util.LanguageQueryBasedNameValueCache.(LanguageQueryBasedNameValueCache.java:53)
    at oracle.apps.snw.uicommon.TextProvider.populateTextCache(TextProvider.java:100)
    at oracle.apps.snw.uicommon.TextProvider.getTextMessage(TextProvider.java:123)
    at oracle.apps.snw.uicommon.TextProvider.handleGetObject(TextProvider.java:113)
    at java.util.ResourceBundle.getObject(ResourceBundle.java:378)
    at oracle.cabo.ui.data.BundleDataObject.selectValue(Unknown Source)
    at oracle.cabo.ui.data.DataBoundValue.getValue(Unknown Source)
    at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)

    Can anyone tell me why this error occurs?
    I have checked the Oracle JDBC library of JDev 11g and found that it has ojdbc6.jar
    Is there any compatibility problem with this jar migrating from 10g to 11g?

    Found this related link but could not relate it much.
    Please explain

    JDBC problem: java.lang.NoSuchFieldError: CONNECTION_PROPERTY_THIN_NET_CONN

    Thanks

    DB:3.67:Problem Using Ojdbc14.Jar In Jdev 11g 3x

    I guess you can't use ojdbc14.jar that easy. Some dependencies form ojdbc14.jar are not available under 11g. That 's the reason you have ojdbc6.jar under 11g.

    Timo

  • RELEVANCY SCORE 3.64

    DB:3.64:Jdev9033, Sqlj And Ant jk


    Hi, can anybody help me with this?

    In this project we use JDev9033, JDK1.4.2_02, SQLJ, Ant1.54 and Oracle 9.2.0.1 client. Now I have a problem integrating OJC and Ant, since we want to use Ant from within JDev to build the project.

    I have set up the paths and class paths according to Oracle 9i SQLJ Developers Guide (Release 2). If I compile from JDev without Ant, JDev compiles the projects *.java and *.sqlj classes corretly.

    I have set the build.properties and build.xml file according to the paths specified in the build.xml file, which JDev can generate for me. And I have included jdev.jar and ojc.jar in the class path.

    Any way I get the exception with the -debug flag set i Ant:

    BUILD FAILED
    file:D:/JDev/GCSSMLIS/Tests/build.xml:166: Compiler Adapter 'oracle.jdeveloper.compiler.ant.teskdefs.OjcAdapter' can't be found.
    at org.apache.tools.ant.taskdefs.compilers.CompilerAdapterFactory.resolveClassName(CompilerAdapterFactory.java:195)

    In build.properties I have:
    # COMPILATION SETTINGS
    compiler=oracle.jdeveloper.compiler.ant.teskdefs.OjcAdapter
    source="1.4"
    target="1.4"
    deprecation="on"
    optimize="off"
    debug="on"
    optimize=off

    and in build.xml:

    javac
    compiler="${compiler}"
    srcdir="${comp.dir}"
    destdir="${build.dir}"
    includes="**/*.java, **/*TEST*.java, **/Test*.java"

    classpath refid="classpath" /
    /javac

    with classpath:

    path id="classpath"
    fileset dir="${javac.path}"
    include name="*.jar" /
    /fileset
    fileset dir="${jdev.home}/sqlj/lib"
    include name="*.jar" /
    /fileset
    pathelement location="${jdev.home}/jdev/lib/jdev.jar" /
    pathelement location="${jdev.home}/jdev/lib/ojc.jar" /
    pathelement location="${ora.home}/jdbc/lib/ojdbc14.jar" /
    pathelement location="${ant.path}/optional.jar"/
    pathelement location="${junit.path}/junit.jar" /
    /path

    Regards
    Flemming

    DB:3.64:Jdev9033, Sqlj And Ant jk

    Matthew,

    Thank for your replies. I manages to get rid of the Ant error by using the first method. I would expect the second to work to.

    I do not expect the OjcAdapter to translate the sqlj files into java files. I have read those chapters in the SQLJ Developers Guide.

    I would like to do obtain is the following:

    1) Use Ant as build system. I do not care, if Ant is external or internal to JDeveloper since both version are 1.5.3. But we have a lot of other steps like ftp to development server, running JUnit, updating CVS and VSS, documentation and so on, so I need Ant to make one build file that every body in the project can use.

    2) Use jre/sdk 1.4.2, sqlj and Oracle client 9.2.0. So I have to translate the projects sqlj files to x.generate.java files before I pass all projects files to a Java compiler.

    3) I tried to build an Ant precompile task in this way:
    a) copy all java and sqlj files from src directory to compile directory.
    b) From the Ant task run the sqlj translator on the compile directory
    c) pass the translated files to javac or ojc

    Since I can translate and compile the project with jdsk1.4.2 from the Jdev Make/Recompile menu point I assume I should be able to write Ant tasks to behave as I have want it to.

    Flemming

  • RELEVANCY SCORE 3.60

    DB:3.60:Apexexport Help 3z


    C:\apex\utilitiesset classpath=classpath;c:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar;c:\apex\utilities\

    C:\apex\utilitiesjava oracle.apex.APEXExport -db 192.168.1.10:1521:XE -user ****
    -password **** -instance
    Exception in thread "main" java.sql.SQLException: ORA-00942: a tabela ou view n
    o existe

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
    java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
    dStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
    nt.java:1038)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
    redStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
    nt.java:1133)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
    aredStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
    dStatement.java:3329)
    at oracle.apex.APEXExport.ExportFiles(APEXExport.java:66)
    at oracle.apex.APEXExport.main(APEXExport.java:326)

    I run the same cmd with the app parameter and there is no problem with the export.
    What is wrong here?

    C:\apex\utilitiesset classpath=classpath;c:\oraclexe\app\oracle\product\10.2.0\
    server\jdbc\lib\ojdbc14.jar;c:\apex\utilities\

    C:\apex\utilitiesjava oracle.apex.APEXExport -db 192.168.1.10:1521:XE -user ****
    -password **** -applicationid 102
    Exporting application 102
    Completed at Tue Mar 31 10:46:41 BRT 2009

    C:\apex\utilities

    DB:3.60:Apexexport Help 3z

    C:\apex\utilitiesset classpath=classpath;c:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar;c:\apex\utilities\

    C:\apex\utilitiesjava oracle.apex.APEXExport -db 192.168.1.10:1521:XE -user ****
    -password **** -instance
    Exception in thread "main" java.sql.SQLException: ORA-00942: a tabela ou view n
    o existe

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
    java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
    dStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
    nt.java:1038)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
    redStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
    nt.java:1133)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
    aredStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
    dStatement.java:3329)
    at oracle.apex.APEXExport.ExportFiles(APEXExport.java:66)
    at oracle.apex.APEXExport.main(APEXExport.java:326)

    I run the same cmd with the app parameter and there is no problem with the export.
    What is wrong here?

    C:\apex\utilitiesset classpath=classpath;c:\oraclexe\app\oracle\product\10.2.0\
    server\jdbc\lib\ojdbc14.jar;c:\apex\utilities\

    C:\apex\utilitiesjava oracle.apex.APEXExport -db 192.168.1.10:1521:XE -user ****
    -password **** -applicationid 102
    Exporting application 102
    Completed at Tue Mar 31 10:46:41 BRT 2009

    C:\apex\utilities

  • RELEVANCY SCORE 3.57

    DB:3.57:Making Jar Work With Oci Drivers dm


    My application (appl.jar) needs to work with the thick driver of oracle 9i and oracle 10g.

    My Environment settings:
    CLASSPATH = %ORACLE_HOME%\jdbc\lib\ojdbc14.jar;

    The manifest file in the jar has only the Main-Class attribute set.
    Main-Class: x.y.z.ApplicationMainClass

    When I run my application using the command: java -jar appl.jar

    I get the following error:

    java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:141)

    Does anyone have suggestions on why the jar is not seeing the ojdbc14.jar from the environment settings.

    The application works when I issue the following command:
    java -jar %CLASSPATH%;appl.jar x.y.z.ApplicationMainClass

    Thanks in advance.

    DB:3.57:Making Jar Work With Oci Drivers dm

    From the documentation

    -jar
    ...
    When you use this option, the JAR file is the source of all user classes, and other user class path settings are ignored.

    which is why, IMHO, you should just give up on the -jar option. I feel that it is a pretty poor implementation. Basically you'd have to put the files from the Oracle jar into your jar for this to work. Note that I said the files - you can't put jars within jars and have it work the way you would think of it logically.

  • RELEVANCY SCORE 3.56

    DB:3.56:Re: Problem With Jdbc Driver a7


    add the classes12.jar or classes12.zip in to ur classpath variable...

    classes12.jar file hainvg that OracleDriver class...

    DB:3.56:Re: Problem With Jdbc Driver a7

    org.apache.jasper.JasperException: JDBC Driver class not found: oracle.jdbc.driver.OracleDriver org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) What can be the reason for that exception if "ojdbc14.zip" is in lib folder of my project and "oracle.jdbc.driver.OracleDriver" could be found.

  • RELEVANCY SCORE 3.52

    DB:3.52:Jar Archive Run Problem kj


    Hi
    Can I start my jar app with:
    java -jar app.jar -cp classpath
    or I should set classpath var and run:
    java -jar app.jar

    DB:3.52:Jar Archive Run Problem kj

    Hi
    Can I start my jar app with:
    java -jar app.jar -cp classpath
    or I should set classpath var and run:
    java -jar app.jar

  • RELEVANCY SCORE 3.51

    DB:3.51:Unable To Import Oracle.Jdbc.Oracleresultset Package 9f


    hai

    I had a problem importing oracle.jdbc.oracleresultset package to my jsp page.

    I am using oracle 10g, and tomcat 5 as web server.

    I did set the classpath
    to these

    C:\Documents and Settings\MULLAPUDIset CLASSPATH=C:\oracle\product\10.2.0\db_1\
    jdbc\lib\ojdbc14.jar;C:\oracle\product\10.2.0\db_1\ord\jlib\ordim.jar;C:\oracle\
    product\10.2.0\db_1\sqlj\lib\runtime12.jar;

    when i am executing it is saying that package not available.

    DB:3.51:Unable To Import Oracle.Jdbc.Oracleresultset Package 9f

    1) If you are using a "thin" connection ("thin" is in your DD URL), then you probably only need ojdbc14.jar
    2) J2EE applications don't respect the external CLASSPATH, and aren't supposed to; instead, you normally copy the jar to the right location.

    http://tomcat.apache.org/tomcat-5.0-doc/appdev/deployment.html

  • RELEVANCY SCORE 3.51

    DB:3.51:Jdbc ==≫ Ora-01017: Invalid Username/Password; Logon Denied 81


    Hi,
    can anyone help me by the following problem?

    I've installed Oracle Database Express Edition 10g Release 2 (10.2) - Beta on Win2k sp4.
    I can access with sqlplus:
    sqlplus ANONYMOUS/anonymous@//localhost:1521/XE AS SYSDBA
    sqlplus HR/tiger@//localhost:1521/XE AS SYSDBA

    But if i try to access in Java, jdk (build 1.4.2_10-b03) with:

    import java.sql.*;
    import java.util.Properties;

    class TestOracle1 {
    //set xsql_bin = C:\db\oraclexe\app\oracle\product\10.2.0\server\BIN
    //set classpath = %xsql_bin%\..\jdbc\lib\ojdbc14.jar;%classpath%
    //set classpath = %xsql_bin%\..\jlib\orai18n.jar;%classpath%
    public static void main (String [] args)
    throws ClassNotFoundException, SQLException {

    Class.forName ("oracle.jdbc.driver.OracleDriver");

    Properties prop = new Properties ();
    prop.put ("internal_logon", "sysdba");

    Connection con = DriverManager.getConnection (
    "jdbc:oracle:thin:hr/tiger@//localhost:1521/XE",
    //"jdbc:oracle:thin:ANONYMOUS/anonymous@//localhost:1521/XE",
    prop);
    Statement stmt = con.createStatement ();

    con.close ();
    }
    }

    i become:
    Exception in thread "main" java.sql.SQLException:
    ORA-01017: invalid username/password; logon denied

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
    at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:288)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
    at oracle.jdbc.driver.PhysicalConnection.init(PhysicalConnection.java:414)

    at oracle.jdbc.driver.T4CConnection.init(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(DriverManager.java:512)
    at java.sql.DriverManager.getConnection(DriverManager.java:140)
    at TestOracle1.main(TestOracle1.java:22)

    Thanks

    DB:3.51:Jdbc ==≫ Ora-01017: Invalid Username/Password; Logon Denied 81

    I running into precisely the same problem, also on Oracle XE. Did you ever get it resolved?

  • RELEVANCY SCORE 3.49

    DB:3.49:Re: Abstractmethoderror At Run Time With Ibm Jre 1.5 And Oracle 10g Databas f7


    Guess, this is a problem with IBM VM.

    Look at:
    ojdbc14.jar (10.2.0.2.0) with JDK1.5

    ==
    Ashok

    DB:3.49:Re: Abstractmethoderror At Run Time With Ibm Jre 1.5 And Oracle 10g Databas f7

    One of our batch that runs in multithreaded architecture fails with following stack trace. This batch used run with no issues against Oracle 9i database but when we started running it against Oracle 10g database we see this error. The same JDBC driver was used when tests ran against Oracle 9i and Oracle 10g databases. The following is the environment information: OS: Linux 32 bit JDK: IBM JRE 1.5 JDBC Driver: oracle-10.2.0.1.0.jar Any help is greatly appreciated. 20070829 114557 LOG4J ERROR sun/util/calendar/AbstractCalendar.getFixedDate(Lsun/util/calendar/CalendarDate;)J java.lang.AbstractMethodError: sun/util/calendar/AbstractCalendar.getFixedDate(Lsun/util/calendar/CalendarDate;)J at sun.util.calendar.AbstractCalendar.getTime(AbstractCalendar.java:186) at sun.util.calendar.ZoneInfo.getOffset(ZoneInfo.java:391) at oracle.jdbc.driver.DateCommonBinder.zoneOffset(OraclePreparedStatement.java:15409) at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:15547) at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:15772) at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2866) at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2151) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3280) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)

  • RELEVANCY SCORE 3.48

    DB:3.48:Re: Problem To Establish Connection What The Wrong With This 9z


    "ojdbc14.jar is in my claspath." - how are you adding the JAR to the CLASSPATH?

    I think mixing database and user interface code is a bad idea. I'd recommend that you get that Swing dialog out of that method.

    Can you log onto Oracle using SQL*Plus like this:

    sqlplus /nolog return
    connect administrator/allah@database

    If not, then your database set up has a problem.

    I'd recommend that you have your app log in using an ID other than admin.

    %

    DB:3.48:Re: Problem To Establish Connection What The Wrong With This 9z

    Now I follow what you mean. Yes, it's always a good idea to ascertain that SQL*Plus works by opening it and trying to connect to the database. If SQL*Plus can't connect, Java won't be able to, either.

    Get on the machine that's hosting Oracle and type "netstat -a" to see if the Oracle listener is indeed up and listening on port 1521. If there's no listener, a connection's not possible.

    %

  • RELEVANCY SCORE 3.47

    DB:3.47:Thin Client Supportability j3


    Hi,
    2 questions, please.

    - is ojdbc14.jar supported with the application compiled and ran with the Java 1.5?
    - is ojdbc14.jar within client application forward compatible with the Oracle 11g?

    thanx in advance.

    DB:3.47:Thin Client Supportability j3

    Hi,

    The answer is Yes for both questions;
    See JDBC compatibility matrix on http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html

    Kuassi
    - blog http://db360.blogspot.com
    - book http://www.amazon.com/exec/obidos/ASIN/1555583296
    - http://www.savedarfur.org/content

  • RELEVANCY SCORE 3.46

    DB:3.46:Re: My Little Jdbc Problem... 9a


    Try with adding classes12.jar in your classpath

    --Balaji S

    DB:3.46:Re: My Little Jdbc Problem... 9a

    Hi all, I'm noob. I'm trying to connect to the default db in oracle lite 10g_3 via JDBC. From shell, I can access the db by typing msql system/manager@jdbc:polite:politeHow to access in a java class using JDBC? I tried with the following:import java.sql.*; public class Try{ public static void main(String args[]){ Connection conn=null; Statement st=null; try{ DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); } catch(Exception e1){ System.out.println("E1"); System.out.flush(); e1.printStackTrace(); } try{ String url="jdbc:polite:polite"; conn =DriverManager.getConnection( url, "system", "manager"); } catch(Exception e2){ System.out.println("E2"); System.out.flush(); e2.printStackTrace(); } } }compiling with (ojdbc14.jar is in the same directory of class Try.java):javac -classpath .;.\ojdbc14.jar Try.javaand executing with: java -classpath .;.\ojdbc14.jar Trybut i got the following error when running: " E2 java.sql.SQLException: No suitable driver found for jdbc:polite:polite at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Try.main(Try.java:27) " My Java version is 1.6.0_05 Can somebody help, please? Thx...

  • RELEVANCY SCORE 3.45

    DB:3.45:Openoffice.Org &Amp; Jdbc sf


    Hi,

    I'm trying my best to connect OO.o to Oracle 10R2, using JDBC. Both, client and server, run on Linux. I've downloaded ojdbc14.jar and added it to my classpath:
    export CLASSPATH=/local/JDBC/ojdbc14.jar:$CLASSPATH

    However, when I try to test 'oracle.jdbc.OracleDriver.class' within OO.o Base, it states:
    The JDBC driver could not be loaded.

    If I eventually get the driver to load, my connection string will be:
    jdbc:oracle:thin:@192.168.1.102:1521:db_instance_name

    Can anyone please help me get this working? Thanks!

    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/readme_10201.html

    Since the driver doesn't load

    DB:3.45:Openoffice.Org &Amp; Jdbc sf

    Weird. Nobody in the Linux forums seems to know either. Why would a connection work as root user, but not as regular user?

  • RELEVANCY SCORE 3.45

    DB:3.45:Was7 With Ojdbc14.Jar Issue px


    Hi All

    We migrated our application into WAS7 from WAS6.1. I am facing java.lang.IllegalAccessException while connecting DB. it was working fine with WAS6.1 and OJDBC14.jar..after migrated part of my application is working fine with OJDBC6.jar in WAS7. I am not sure what is blocking me in WAS7 with OJDBC14.jar.. Can someone help me on this?

    Error:
    java.lang.IllegalAccessException: Class com.abc.Utils can not access a member of class oracle.jdbc.driver.OracleResultSet with modifiers "public"

    DB:3.45:Was7 With Ojdbc14.Jar Issue px

    How this could be related to oracle database please mark your thread as answered and open it in the right forum which mean in this case

    http://www.ibm.com/developerworks/forums/forum.jspa?forumID=266

    also rp provide with link to do that.

  • RELEVANCY SCORE 3.44

    DB:3.44:Java.Lang.Noclassdeffounderror Using Datasource As Client In Wls 8.1 sc



    Hi,

    I am trying to access a WL 8.1 JDBC data source, using the Oracle thin driver
    for an Oracle 9i database. I have ojdbc14.jar and weblogic.jar in my client classpath;
    I've also tried putting ojdbc14.jar explicitly in the server classpath. The client
    gets the data source using JNDI with no problem, but then when it executes getConnection
    it gets a java.lang.NoClassDefFoundError (stack trace below).

    This sounds similar to the problem someone else had recently with 7.0, except
    that adding the Oracle JDBC to the client classpath doesn't seem to fix it. Btw,
    oracle.sql.BfileDBAccess is definitely in ojdbc14.jar on both the client and the
    server.

    Monica

    java.lang.NoClassDefFoundError: oracle/sql/BfileDBAccess

    at java.lang.Class.getDeclaredMethods0(Native Method)

    at java.lang.Class.privateGetDeclaredMethods(Class.java:1627)

    at java.lang.Class.privateGetPublicMethods(Class.java:1655)

    at java.lang.Class.privateGetPublicMethods(Class.java:1665)

    at java.lang.Class.getMethods(Class.java:815)

    at weblogic.rmi.utils.Utilities.getRemoteMethods(Utilities.java:269)

    at weblogic.rmi.internal.StubGenerator.init(StubGenerator.java:90)

    at weblogic.rmi.internal.StubGenerator.init(StubGenerator.java:68)

    at weblogic.rmi.internal.StubGenerator.getStubOnClient(StubGenerator.java:689)

    at weblogic.rmi.internal.StubGenerator.getStubClass(StubGenerator.java:666)

    at weblogic.rmi.internal.StubGenerator.generateStub(StubGenerator.java:712)

    at weblogic.rmi.internal.StubGenerator.generateStub(StubGenerator.java:699)

    at weblogic.rmi.extensions.StubFactory.getStub(StubFactory.java:76)

    at weblogic.rmi.utils.io.RemoteObjectReplacer.resolveObject(RemoteObjectReplacer.java:222)

    at weblogic.rmi.internal.StubInfo.readResolve(StubInfo.java:142)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:324)

    at java.io.ObjectStreamClass.invokeReadResolve(ObjectStreamClass.java:911)

    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1655)

    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)

    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)

    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)

    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)

    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)

    at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324)

    at weblogic.common.internal.ChunkedObjectInputStream.readObject(ChunkedObjectInputStream.java:111)

    at weblogic.rjvm.MsgAbbrevInputStream.readObject(MsgAbbrevInputStream.java:95)

    at weblogic.rmi.internal.ObjectIO.readObject(ObjectIO.java:56)

    at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:159)

    at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:126)

    at weblogic.jdbc.common.internal.RmiDataSource_810_WLStub.getConnection(Unknown
    Source)

    at com.callsource.util.DBConnect.getConnection(DBConnect.java:37)

    at com.callsource.provisioning.persistence.customer.CustomerPersister.getCompanyByID(CustomerPersister.java:28)

    at com.callsource.provisioning.persistence.customer.CustomerPersister.getCustomerByID(CustomerPersister.java:74)

    at com.callsource.provisioning.persistence.customer.CustomerPersister.getCSCustomerByID(CustomerPersister.java:127)

    at com.callsource.provisioning.persistence.customer.CustomerHome.getCSCustomerByID(CustomerHome.java:27)

    at com.callsource.provisioning.session.TestUserSessionBean.setUp(TestUserSessionBean.java:30)

    at junit.framework.TestCase.runBare(TestCase.java:125)

    at junit.framework.TestResult$1.protect(TestResult.java:106)

    at junit.framework.TestResult.runProtected(TestResult.java:124)

    at junit.framework.TestResult.run(TestResult.java:109)

    at junit.framework.TestCase.run(TestCase.java:118)

    at junit.framework.TestSuite.runTest(TestSuite.java:208)

    at junit.framework.TestSuite.run(TestSuite.java:203)

    at com.borland.jbuilder.unittest.JBTestRunner.run(JBTestRunner.java:206)

    at com.borland.jbuilder.unittest.JBTestRunner.initiateTest(JBTestRunner.java:248)

    at com.borland.jbuilder.unittest.JBTestRunner.main(JBTestRunner.java:554)

    DB:3.44:Java.Lang.Noclassdeffounderror Using Datasource As Client In Wls 8.1 sc

    1) http://commerce.bea.com/showproduct.jsp?family=WLPmajor=8.1minor=4

    2)Make sure you add your JDBC drivers to the beginning of CLASSPATH in either setDomainenv.cmd or setEnv.cmd

    3)What really helped was BEA support and playing with BEA's JDBC example that shows how to create and deploy and use a data source.

    http://dev2dev.bea.com/codelibrary/code/examples_jdbc.jsp

  • RELEVANCY SCORE 3.44

    DB:3.44:Clasess.Jar Or Ojdbc14.Jar km


    We are currently on 9i and using oracle12.jar in server class path. After moving to 10G do we need to change to ojdbc14.jar or can we continue with classes12.jar .

    DB:3.44:Clasess.Jar Or Ojdbc14.Jar km

    For JDK 1.3, use classes12.jar.

    Kuassi

  • RELEVANCY SCORE 3.44

    DB:3.44:Database Driver Problem f8



    I am trying to configure few datasources in my environment and getting below driver problem.

    i have tried with ojdbc6.jar file and ojdbc14.jar file in the classpath.

    If i use ojdbc6.jar file i will get class not found exception like below with sealing violation ..etc where as if i use ojdbc14.jar file i will get class cast exception. Basically what i understood is it's driver mismatch or something but not able to identify where could be the problem. I have tried all the ways, from my side if anyone have any idea about this or any clue please suggest me. I can give you more clarity on the problem if required.

    Few extra details :-

    java version - 1.6.0.20

    Jboss version - 5.1

    Caused by: java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver
    at oracle.jdbc.pool.OracleDataSource.init(OracleDataSource.java:85)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at java.lang.Class.newInstance0(Class.java:355)
    at java.lang.Class.newInstance(Class.java:308)
    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:481)
    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
    ... 98 more
    Caused by: java.lang.ClassNotFoundException: Unexpected error during load of: oracle.jdbc.driver.OracleDriver, msg=Sealing violation for package oracle.jdbc.driver
    at org.jboss.classloader.spi.base.ClassLoaderManager.process(ClassLoaderManager.java:181)
    at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:276)
    at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:1138)
    at org.jboss.classloader.spi.base.BaseClassLoader.loadClassFromDomain(BaseClassLoader.java:862)
    at org.jboss.classloader.spi.base.BaseClassLoader.doLoadClass(BaseClassLoader.java:502)
    at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:447)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
    ... 107 more

    Here is my one of DS.xml file

    datasources
    local-tx-datasource
    jndi-namejdbc/JNDI NAME/jndi-name
    connection-urljdbc:orcale:thin:@servername:port:schema_name/connection-url
    driver-classoracle.jdbc.pool.OracleDataSource/driver-class
    security-domainDataSourceDBLogin/security-domain
    exception-sorter-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter/exception-sorter-class-name
    metadata
    type-mappingOracle11g/type-mapping
    /metadata
    min-pool-size5/min-pool-size
    max-pool-size20/max-pool-size
    idle-timeout-minutes15/idle-timeout-minutes
    /local-tx-datasource
    /datasources

    DB:3.44:Database Driver Problem f8


    Hi All,

    I found the problem. it's very silly but made me to think in all different ways. Thank u guys and really appreciate your thoughts because of this silly mistake i learned few other things

    connection-urljdbc:orcale:thin:@servername:port:schema_name/connection-url

    in my DS.xml i used incorrect spelling of "oracle" like above.

  • RELEVANCY SCORE 3.43

    DB:3.43:Ojdbc14.Jar And Nls_Charset x1


    I use nls_charset12.jar and classes12.jar with JDK 1.3 and JDK1.2

    When we use JDK14: ojdbc14.jar.

    Nls_charset include in ojdbc14.jar?

    DB:3.43:Ojdbc14.Jar And Nls_Charset x1

    I believe that you should use nls_charset12.jar with ojdbc14.jar for 9.2.0.3 .

    This is from the JDBC FAQ - http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#02_03

    nls_charset11.jar
    Contains the classes to support all Oracle character sets in Advanced Data Types (objects) when using a Java 1.1 VM. If the database character set is one other than US7ASCII, W8DEC, or ShiftJIS, and the application uses ADTs, then you must include this class in your classpath. Or you can unzip this file and add the appropriate file to your classpath. The files are named with the Oracle character set number.

    nls_charset12.jar
    Same as nls_charset11.jar except for use with Java 1.2, 1.3, and 1.4 VMs. Not used with Oracle 10.1.0 and later. Use orai18n.jar instead.

    Nat

  • RELEVANCY SCORE 3.43

    DB:3.43:Error Opening Oracle Sql Developer 1.2.1 93


    In my IDE, I saw extensions pane with title "Entensions - Log" which has
    the following contents:

    oracle.ide.db
    Warning: Classpath entry \DISTAPPS$\ORACLE\v10\Oracle10g\jdbc\lib\ojdbc14.jar not found
    Warning: Classpath entry \DISTAPPS$\ORACLE\v10\Oracle10g\jlib\orai18n.jar not found

    oracle.jdeveloper.db.connection
    Warning: Classpath entry \DISTAPPS$\ORACLE\v10\Oracle10g\jdbc\lib\ojdbc14.jar not found
    Warning: Classpath entry \DISTAPPS$\ORACLE\v10\Oracle10g\jlib\orai18n.jar not found

    (I am runing it on windows XP, the problem happened after I killed a running Oracle SQL Developer session. Now I cannot connect to anything even I tried to reinstall Oracle SQL Developer again) Anybody had the same issue, is there any way to fix it.

    Thanks,

    -caoy

    DB:3.43:Error Opening Oracle Sql Developer 1.2.1 93

    Oracle SQL Developer 1.2.0 is working correctly at Argonne National Lab with Oracle 10g Client Version 10.2.1 and Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit. The correct UNC and java class path is:

    \\Canary\DISTAPPS$\ORACLE\V10\Ora10g\jdbc\lib.

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 17 16:23:58 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    SQL exit

    Successfully tested Oracle SQL Developer to this same database and retrieved data correctly.

    Please see me in my office.

    H. Johnstad
    CIS 2-5069
    hjohnstad@anl.gov

  • RELEVANCY SCORE 3.42

    DB:3.42:No Ocijdbc10 In Java.Library.Path xa


    Hello,

    i used AQ on Oracle10g and i used http to access AQ.

    i created the servlet (AQServlet). Compile step no problem but i got the error "no ocijdbc10 in java.library.path" when i perform the request to AQServlet

    the $CLASSPATH point to $ORACLE_HOME/jdbc/lib/ojdbc14.jar already

    How do i solve this problem?

    Thanks

    DB:3.42:No Ocijdbc10 In Java.Library.Path xa

    AQServlets work with Tomcat in 10.1.0.2 Linux and 9.2.0.1 w2k.

    Corrected CLASSPATH and LD_LIBRARY_PATH below.

    Note: Per aqjmsREADME.txt LD_LIBRARY_PATH must contain the directory containing the OCI JDBC libraries (libocijdbc*.so).

    Associated web posts:
    Oracle 10.2 JDBC Dev Guide and Ref: http://download-west.oracle.com/docs/cd/B19306_01/java.102/b14355/toc.htm

    Oracle Java AQ API (901): http://sqltech.cl/doc/oracle9i/appdev.901/a88898/oracle_aq_xml.htm

    Oracle AQ Servlet Cfg (902): http://www.oracle.com/technology/sample_code/tech/java/codesnippet/aq/AQServletConfiguration.htm

    Oracle OCI 10.1 Mac: no ocijdbc10 in java.library.path

    Oracle 817: java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path

    Program to display java.library.path:
    /**
    From: http://lists.apple.com/archives/java-dev/2005/May/msg00388.html
    To compile and run:
    javac -classpath /oracle/10g/jdbc/lib/ojdbc14.jar ConnectionTest.java
    java -cp .:/oracle/10g/jdbc/lib/ojdbc14.jar ConnectionTest
    **/
    import java.sql.Connection;
    import java.sql.DriverManager;

    public class ConnectionTest {

    public static void main(String[] args) {
    try {
    System.out.println("This is System.getProperty() on java.library.path");
    System.out.println(System.getProperty("java.library.path"));
    System.out.println("That was System.getProperty() on java.library.path");

    System.out.println("Now see if connecting throws an exception");

    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection connection =
    DriverManager.getConnection("jdbc:oracle:oci:@SID", "username", "password");

    System.out.println("Connecting did NOT throw an exception");

    } catch (Exception e) {
    System.out.println(System.getProperty("Caught exception:"));
    e.printStackTrace();
    }

    Required JMS CLASSPATH and Servlet deployed libraries (note no classes12):
    /oracle/10g/jdbc/lib/nls_charset12.jar
    /oracle/10g/jdbc/lib/ojdbc14.jar (unnecessary in w2k)
    /oracle/10g/jlib/jndi.jar
    /oracle/10g/rdbms/jlib/aqapi.jar
    /oracle/10g/rdbms/jlib/jmscommon.jar
    /oracle/10g/rdbms/jlib/aqxml.jar
    /oracle/10g/10g/lib/xsu12.jar
    /oracle/10g/rdbms/jlib/xdb.jar
    /oracle/10g/lib/xmlparserv2.jar
    /oracle/10g/lib/xschema.jar
    /oracle/10g/lib/servlet.jar
    /oracle/10g/jlib/jta.jar
    /oracle/10g/lib/http_client.jar
    /oracle/10g/jlib/javax-ssl-1_2.jar
    /oracle/10g/jlib/jssl-1_2.jar

    LD_LIBRARY_PATH:
    /oracle/10g/lib
    /oracle/10g/jdbc/lib
    /oracle/10g/ctx/lib (may be optional)
    /oracle/10g/lib/libocijdbc10.so (may be unnecessary with /oracle/10g/lib)
    /oracle/10g/jdbc/lib/ojdbc14.jar (n/n in w2k maybe n/n with libocijdbc10.so)

  • RELEVANCY SCORE 3.41

    DB:3.41:Created Jar-File Doesn't Find Other Jars kc


    Hi,
    I built an application using jars (among others the ojdbc14.jar) - working "perfectly" in eclipse.

    But when I create a jar - I receive an "Class-not-found-Exception", when the
    Class.forName("oracle.jdbc.driver.OracleDriver"); is invoked.

    I tried using newInstance() but it didn't work.

    The classpath seems to be correct:
    ?xml version="1.0" encoding="UTF-8"?
    classpath
    classpathentry kind="src" path=""/
    classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/
    classpathentry exported="true" kind="lib" path="ojdbc14.jar"/
    ...
    classpathentry kind="output" path=""/
    /classpathI also "included" the jar(s) in the manifest:
    Bundle-ClassPath: ojdbc14.jarAnd of cause they are included in the jar.

    So - where is the bug? Do I have to use another command than the forName to load the driver?

    Thanks for any tip.

    adicko

  • RELEVANCY SCORE 3.40

    DB:3.40:Problem With Jdbc Connection And Jar File dk


    Hi,

    In my application I've set up a jdbc connection this way:
    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@myserver:1521:SID", "user_name", "password"); In the Project Properties I've added ojdbc14.jar in the Libraries.
    The whole application is running without any errors in JDeveloper.

    Then I've created a deployment to JAR File. For the Main Class I've browsed for my java class and also added the ojdbc14.jar in addition Manifest Files.
    When running the jar file on any other pc (so outside JDeveloper) it seems that the program exits without any error after it tries to build up the connection.

    Is it maybe a problem that the ojdbc14.jar file is not deployed with my jar??? If yes, how to include it there?

    Has anybody any idea, what I've done wrong?

    Thanks
    chrissy

    DB:3.40:Problem With Jdbc Connection And Jar File dk

    What I do, every time I need to deploy a jar file, and recommend to you is:

    1. Install Java Virtual Machine in destination PC
    2. Copy jar file into "shared files" folder
    3. Copy "lib" carpet into "shared files" folder
    4. Look for ..//jdbc/lib carpet and copy all ojdc??.jar files into "lib" carpet.

    This is what I've done always and neve got problems.

    Hasta la vista, amigo.

  • RELEVANCY SCORE 3.39

    DB:3.39:Unable To Run .Jar Outside Jdeveloper sa


    Hi all,

    I have a relatively simple client app connectiong to 10g with JDBC. It runs fine inside JDev but when I create a jar and try to run that with java -jar jarfilename I get the famous

    Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource

    I have ojdbc14.jar in the classpath. I also tried including it in the java command:
    java -cp "C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar" -jar jarfilename with the same result.

    If I use the same command that JDev uses - C:\oracle\jdevstudio10133\jdk\bin\javaw.exe -client -classpath "... I get nothing - just the command prompt back.

    The program is supposed to just pop up a file finder and once the user has picked the folder, it'll print out a bunch of stuff as it loads it into the database.

    In my path, I'm pointing to the ...\Java\jdk1.5.0_14\bin.

    Please help
    Jim Greetham

    DB:3.39:Unable To Run .Jar Outside Jdeveloper sa

    I used the JDev command C:\oracle\jdevstudio10133\jdk\bin\javaw.exe -client -classpath "..." main class and it works. However, if I change from specifying the main class to the -jar jar name, I get nothing. Also, in the first case, the System.out.println(...) doesn't show up in the command window.

    Now, If I use java -cp "..." main class it works and the output shows in the command window. If I try the java -cp "..." -jar jar name, I get the java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource.

    Hope this helps the diagnosis.

    Jim

  • RELEVANCY SCORE 3.39

    DB:3.39:Java.Lang.Unsatisfiedlinkerror: No Ocijdbc10 In Java.Library.Path 3j


    I use oracle v8.1.7
    Windows XP
    Elipse sdk3.11
    CLASSPATH to classes12.zip and ojdbc14.jar
    and have java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
    when url = jdbc:oracle:oci8:@SLAVA

    DB:3.39:Java.Lang.Unsatisfiedlinkerror: No Ocijdbc10 In Java.Library.Path 3j

    Juan,
    Using the OCI driver means you need to have Oracle client software installed on the client machine -- as well as java. Using the "thin" driver means you only need java installed on the client machine.

    Perhaps you could post the entire error message and stack trace you are getting, as well as the section of your code that is causing the error?

    Have you read the JDBC Developer's Guide and Reference?

    Good Luck,
    Avi.

  • RELEVANCY SCORE 3.38

    DB:3.38:Jdbc Problem With Java Web Start If Driver Is Included As Extension md


    Hi,

    I experienced a problem with Oracle JDBC Driver version - 9.0.2.0.0
    as of Wed Feb 19 15:32:24 2003 if I move the associated ojdbc14.jar
    from my applications jnlp file to an extension jnlp file I get
    an exception, i.e.

    app.jnlp looks somehow as follows:
    ...
    resources
    j2se version="1.4.2+" href="http://java.sun.com/products/autodl/j2se" initial-heap-size="24m" max-heap-size="256m"/
    jar href="lib/app-rt.jar"/
    !-- move jdbc driver lib to thirdparty jnlp
    jar href="lib/ojdbc14.jar"/
    --
    extension name="thirdparty" href="thirdparty.jnlp"/
    /resources
    application-desc main-class="xcnf.mainPackage.MainAdmin"/
    ...

    thirdparty.jnlp looks somehow as follows:
    ...
    resources
    jar href="lib/ojdbc14.jar"/
    jar href="lib/jdom.jar"/
    /resources
    component-desc/
    ...

    The exception is:

    java.lang.NullPointerException

    at oracle.jdbc.ttc7.O3log.marshal(O3log.java:612)

    at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:258)

    at oracle.jdbc.driver.OracleConnection.init(OracleConnection.java:360)

    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)

    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)

    at java.sql.DriverManager.getConnection(Unknown Source)

    at java.sql.DriverManager.getConnection(Unknown Source)

    If I don't use the extension mechanism, i.e. library ojdbc14.jar
    is included in app.jnlp, everything works fine.

    I'm very concerned that there is a general problem with the
    extension mechanism. If I understood the documentation, using the
    extension mechanism should be similar to adding furher libs to
    the classpath.

    Any ideas? Every answer, comment is appreciated!

    DB:3.38:Jdbc Problem With Java Web Start If Driver Is Included As Extension md

    Generally speaking, having the jar inline in your jnlp file or externally referenced as a component extension should be the same.
    First of all, what version of Java Web Start are you running?
    Are there any properties listed in the main jnlp file ?
    Are there any properties in the extension jnlp file ?
    Do both main and extension jnlp file request all-permission ?

    /Dietz

  • RELEVANCY SCORE 3.37

    DB:3.37:Classes12.Jar Or Ojdbc14.Jar 3j


    We are currently on 9i and using oracle12.jar in server class path. After moving to 10G do we need to change to ojdbc14.jar or can we continue with classes12.jar .

    DB:3.37:Classes12.Jar Or Ojdbc14.Jar 3j

    We are currently on 9i and using oracle12.jar in server class path. After moving to 10G do we need to change to ojdbc14.jar or can we continue with classes12.jar .

  • RELEVANCY SCORE 3.35

    DB:3.35:Oci Unsatisfiedlinkerror And Oc4j 904 sf


    jdk1.4.2x
    OC4J904 stand alone
    ifs (cmsdk-9.0.3x)

    I am using IFS to store files/attachments for our app. I am getting the following error when I try to upload the file:

    java.lang.UnsatisfiedLinkError: make_c_state
    at oracle.jdbc.oci8.OCIDBAccess.make_c_state(Native Method)
    at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:458)
    at oracle.jdbc.driver.OracleConnection.init(OracleConnection.java:377)
    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
    at java.sql.DriverManager.getConnection(DriverManager.java:512)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at oracle.ifs.server.LibraryConnection.init(LibraryConnection.java:247)
    at oracle.ifs.server.ConnectionPool.constructLibraryConnection(ConnectionPool.java:712)
    at oracle.ifs.server.ConnectionPool.createLibraryConnection(ConnectionPool.java:673)
    at oracle.ifs.server.ConnectionPool.init(ConnectionPool.java:311)
    at oracle.ifs.server.S_LibraryService.resetConnectionPools(S_LibraryService.java:3719)
    at oracle.ifs.server.S_LibraryService.init(S_LibraryService.java:1215)
    at oracle.ifs.server.S_LibraryService.startService(S_LibraryService.java:1586)
    at oracle.ifs.beans.LibraryService.startService(LibraryService.java:352)
    ....
    ===============================

    After extensive research (complete with head banging against monitor), I have tracked the problem to OC4J and how it is loading its classpath.
    IFS uses OCI and that requires a 9.2+ version of the jdbc driver when used with jdk 1.4+. OC4J904 comes with and uses classes12.jar and classes12dms.jar from the OC4J_HOME/jdbc/lib dir. These two jars contain an older (9.0.x I think) version of the oci jdbc driver and is incompatible with our setup and gives us the error shown above.
    I have tried many different approaches to getting oc4j.jar to use our preferred ojdbc14.jar (make it appear before classes12 in the classpath) file instead of classes12.jar/classes12dms.jar, but it insists on loading them from the jdbc/lib dir. If I remove them, OC4J won't start.

    Solution #1: start OC4J with:
    java -classpath "path-to-ojdbc14-9.2.0.3.jar;.\oc4j.jar" com.evermind.server.OC4JServer

    instead of using standard:
    java -jar oc4j.jar

    This works by forcing the ojdbc.jar ahead of all others in the classpath and OC4J finds the compatible OCI classes it needs. I don't like it because it puts an odd dependency in our startup file and is obscure and IMO, a hack.

    Solution #2:
    I moved ojdbc14.jar into OC4J_HOME/jdbc/lib dir, removed classes12dms.jar, and renamed ojdbc14.jar to classes12dms.jar. All works perfectly. Again, this is a hack and relies on obscure dependencies to work. Not a long term solution.

    So what is the correct way to do this? How do I force OC4J to not use classes12.jar/classes12dms.jar and use the jar of my choosing instead. I have looked through my application.xml and find no reference to the jdbc/lib dir or classes12xxx.jar.

    TIA,
    Eric

    DB:3.35:Oci Unsatisfiedlinkerror And Oc4j 904 sf

    Thx for the reply Avi. I searched OTN but never saw your post! It is exactly what I was looking for. Thx again.

    Eric

  • RELEVANCY SCORE 3.34

    DB:3.34:Jdbccheckup ms


    Hi,

    I'm a novice JDBC developper and java,
    and i'm trying to verify a connection to an Oracle database with the furnished example.

    Compiling this code is ok (JdbcCheskup.class is created), but execution give the error:

    Exception in thread "main" java.lang.NoClassDefFoundError: jdbccheckup

    I do have classes12.zip and ojdbc14.jar in my CLASSPATH.

    I use JDK 1.4.0_01.

    Any idea is appreciated.

    Yves

    DB:3.34:Jdbccheckup ms

    Hi Yves ,

    Add the current directory also to your classpath.

    info: ojdbc14.jar must be used only if JDK1.4 , for JDK1.2 or 1.3 use classes12.jar. At a time only either one of these jars must only be in the classpath.

    Follow these steps.,

    set classpath=%ORACLE_HOME%/jdbc/lib/classes12.jar;.;javac JdbcCheckup.javajava JdbcCheckupnote: All steps are case-sensitive.

    Hope this helps

    Regards
    Elango.

  • RELEVANCY SCORE 3.34

    DB:3.34:Re: It Must Work, But It Doesn't 3c


    The problem is that you don't understand CLASSPATH. Run your code like this:

    java -classpath .;ojdbc14.jar EmployeeThat'll work. The dot in the CLASSPATH tells the class loader to look in the current directory. MOD

    DB:3.34:Re: It Must Work, But It Doesn't 3c

    I had seted the classpath under the DOS promt as
    following:You are supposed to use one of those zip files, not both.

    And there are newer driver versions which are jar files (not zip) for Oracle 9/10

  • RELEVANCY SCORE 3.34

    DB:3.34:Problem With Setting Classpath ma


    #!/bin/bash

    CLASSPATH=.
    #CLASSPATH=${CLASSPATH}:${INSTALL_PATH}home/squidlog/CopyFile.java
    #CLASSPATH=${CLASSPATH}:${INSTALL_PATH}usr/java/latest/lib/*.jar
    CLASSPATH=${CLASSPATH}:${INSTALL_PATH} usr/java/jre-1.6.0_05

    javac CopyFile.java

    echo "CLASSPATH=$CLASSPATH"

    #home/wbiadmin/JRE1.4.2/j2re1.4.2_15/bin/java CopyFile

    /usr/java/j2re1.6.0_05/java CopyFile

    Please check whether my shellscript is correct
    I get error saying bad interpreter

    DB:3.34:Problem With Setting Classpath ma

    hi,

    #!/bin/bash

    CLASSPATH="$CLASSPATH":. # add your jar files each seperated by column (:)

    $JAVA_HOME=/usr/java/JDK1.6 #change according to your jdk

    $JAVA_HOME/bin/javac CopyFile.java

    $JAVA_HOME/bin/java CopyFileRegards,
    Ram.

  • RELEVANCY SCORE 3.32

    DB:3.32:Exception In Thread "Main" Java.Lang.Noclassdeffounderror: a1


    Hello Friends,

    I am trying to install BPEL, ESB, and OWSM schemas in the 10g database. While running irca.bat (for windows env) i am getting following classpath error.

    Exception in thread "main" java.lang.NoClassDefFoundError: D:\oracle\product\10/2/0\db_1\jdbc\lib\ojdbc14/jar

    I understand it is not able to find the ojdb14.jar file so i will have to set the classpath. i know how to set it up but not sure what should it be set to? Can you please help me to resolve this problem? Following are the places where i do see the ojdbc14 java executable file located on my system -

    D:\jdevstudiobase10134\jdbc
    D:\oracle\product\10.2.0\db_1\install\patches\5923165\files\jdbc
    D:\oracle\product\10.2.0\db_1\jdbc
    D:\OracleDB11gN\product\11.2.0\dbhome_1\owb\wf

    Please help.

    Thanks.

    DB:3.32:Exception In Thread "Main" Java.Lang.Noclassdeffounderror: a1

    Hello Friends,

    I am trying to install BPEL, ESB, and OWSM schemas in the 10g database. While running irca.bat (for windows env) i am getting following classpath error.

    Exception in thread "main" java.lang.NoClassDefFoundError: D:\oracle\product\10/2/0\db_1\jdbc\lib\ojdbc14/jar

    I understand it is not able to find the ojdb14.jar file so i will have to set the classpath. i know how to set it up but not sure what should it be set to? Can you please help me to resolve this problem? Following are the places where i do see the ojdbc14 java executable file located on my system -

    D:\jdevstudiobase10134\jdbc
    D:\oracle\product\10.2.0\db_1\install\patches\5923165\files\jdbc
    D:\oracle\product\10.2.0\db_1\jdbc
    D:\OracleDB11gN\product\11.2.0\dbhome_1\owb\wf

    Please help.

    Thanks.

  • RELEVANCY SCORE 3.32

    DB:3.32:Instant Client 10 Jar File Issue fx


    I'm following the instructions to install Instant Client 10, but the Jar files won't run on Windows.

    classes12 and ojdbc14 both give me "Failed to load Main-Class manifest attribute....", and when I check the manifest file, this info is in fact missing, along with the classpath.

    The instructions don't indicate anything about this. I'm wondering if I'm missing something here. I have the newest Java installed.

    DB:3.32:Instant Client 10 Jar File Issue fx

    What exactly are you trying to do? Install Client or execute classes?
    Once you instal your client it is so, if there were no problems on the installation there are no issues to solve.
    Which client did you install? On the Oracle Universal Installer there are several kinds of clients, regular and instant client.
    What do you need this client for?
    Once you have installed, I figure out you are trying to do some java programming, aren't you? How are you trying to use those classes?

  • RELEVANCY SCORE 3.31

    DB:3.31:Steps To Load Oracle Jdbc Thin Driver Onto Tomcat 8z


    I have Oracle JDBC working with thin driver on my local Tomcat container and now need to put it on a server but forgot how I set it up and want to make sure I do it correctly when I put it on the server.

    Please advise if this is correct?
    1- Load the thin driver (ojdbc14.jar ) in Tomcat 4.1.27 Container into the common/lib directory

    2- Set the classpath on the Windows server to allow me to use the ojdbc14.jar driver?
    If so then I need to do this using Windows DOS where I add the thin driver to my Classpath?
    Set CLASSPATH=%CLASSPATH%;C:\TomcatHome\common\lib\servlet-api.jar;C:\TomcatHome\common\lib\ojdbc14.jar

    Or do I NOT need to set the classpath and just restart the Tomcat container??

    DB:3.31:Steps To Load Oracle Jdbc Thin Driver Onto Tomcat 8z

    Thanks,

    I loaded the ojdbc14.jar file in common/lib and restarted the container and I can now connect to Oracle.

    What you mean by not needing ojdbc14 for compilation and it would be better to use a build tool[b] to do what?

  • RELEVANCY SCORE 3.31

    DB:3.31:Ora-00600: Internal Error Code, Arguments: [Ttcgcshnd-1], [0], [], [], [], z7


    Hello people....

    I have an error in a Oracle Database 10g Release 10.1.0.5.0 - 64bit Production, the error is:

    ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [],

    I have read Metalink, and one solution is execute this script:

    alter system set event='10841 trace name context forever' scope=spfile;

    And I have read some forums too, and there said that the problem is with the CLASSPATH, for example:

    When i remove the classes12.zip in the classpath and i put ojdbc14.jar, now the database is connected, without showing error.

    But I dont know what step is more correct

    What do you think?

  • RELEVANCY SCORE 3.30

    DB:3.30:Jconn2.Jar Not Preloaded In Wls 8.1 After All s8



    The following statement appears in the 8.1 version of your "Programming WebLogic
    JDBC" documentation:

    "The 9.2.0 version of the Oracle Thin driver (ojdbc14.jar) and the 4.5 (jConnect.jar)
    and 5.5 (jconn2.jar) versions of the Sybase jConnect driver are installed in the
    WL_HOME\server\lib folder (where WL_HOME is the folder where WebLogic Platform
    is installed) with weblogic.jar. The manifest in weblogic.jar lists these files
    so that they are loaded when weblogic.jar is loaded (when the server starts).
    Therefore, you do not need to add these JDBC drivers to your CLASSPATH."

    I checked the manifest.mf file in the weblogic.jar file for my WLS 8.1 installation.
    It contains the following in its classpath entry:

    Class-Path: wlcipher.jar webservices.jar xmlx.jar ojdbc14.jar Eccpress
    oAsn1.jar EccpressoCore.jar EccpressoJcae.jar ant/ant.jar ant/optiona
    l.jar ant/jakarta-oro-2.0.4.jar

    Where's the jconn2.jar as promised? When I try to create a JDBC connection pool
    using "Sybase's Driver (Type 4) Versions:5.X" in the console, I get the following
    error: "JDBC driver is not on the CLASSPATH". This should work every time.

    Thanks very much. --Tom

  • RELEVANCY SCORE 3.30

    DB:3.30:Error While Running A Oa Framework Page Process Exited With Exit Code 1. mk


    Hi all,
    I downloaded the Patch 4573517 from Metalink for JDEV with OA extension release 11i.I followed all the instruction of the setup init and installed the Jdev,also mytutorial pages got compiled successfully,but when i trie dto run the page

    Run Run test_fwktutorial.jsp from the main menu.

    it gives me error.The error is as follows
    [Starting OC4J using the following ports: HTTP=8988, RMI=23891, JMS=9227.]

    C:\D drive\OA_2008\jdevbin\jdk\bin\javaw.exe -client -classpath C:\D drive\OA_2008\jdevbin\j2ee\home\oc4j.jar;C:\D drive\OA_2008\jdevbin\jdev\lib\jdev-oc4j.jar -Xbootclasspath/p:C:\D drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip -DFND_JDBC_STMT_CACHE_SIZE=200 -DCACHENODBINIT=true -DRUN_FROM_JDEV=true -mx256m -Doracle.j2ee.dont.use.memory.archive=false -Xverify:none -Doracle.j2ee.dont.use.memory.archive=true -Doracle.j2ee.http.socket.timeout=500 com.evermind.server.OC4JServer -config C:\D drive\OA_2008\jdevhome\jdev\system9.0.3.5.1437\oc4j-config\server.xml
    [waiting for the server to complete its initialization...]

    java.lang.NoClassDefFoundError: drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14/jar;C:\D

    Exception in thread "main"
    Process exited with exit code 1.

    I am not understanding why it is going in exception.One reason which i doubthere is the line

    java.lang.NoClassDefFoundError: drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14/jar;C:\D

    here in this line the last word is ojdbc14/jar,i think it should have been ojdbc14.jar.

    Can any body please help me out on how to correct this problem.Thanks
    Manish

  • RELEVANCY SCORE 3.30

    DB:3.30:Jdbc Driver Version 1c


    hi all,
    i just downloaded ojdbc5.jar since my ojdbc14.jar was throwing errors while working with BLOB's for oracle 11g database. after getting the upgrade ojdbc5.jar i still get the same driver version (reported by getDriverVersion() method) as when i had the old ojdbc14.jar file.

    Driver name: Oracle JDBC driver
    Driver version: 9.2.0.1.0

    CLASSPATH=C:\oracle\ora92\jdbc\lib\ojdbc5.jar;

    have included the new driver in both my classpath and my IDE (netbeans 6.7.1) so i dont understand why the same old version of oracle driver is being picked up by the JRE ??

    any help would be much appreciated.

    ta.

    DB:3.30:Jdbc Driver Version 1c

    Hi,

    check ${JAVA_HOME}/lib, ${JAVA_HOME}/lib/ext directories for possible old drivers. Also, you can always execute
    Connection conn = ... // get connection
    System.out.println(conn.getClass().getProtectionDomain().getCodeSource());and get real location of the driver in use.

  • RELEVANCY SCORE 3.30

    DB:3.30:Problem Implementing Ojdbc14.Jar cx


    I am developing a web app that connects to an Oracle 9i database. I am using JDeveloper 9.0.3, the latest version I could find. I use JDK 1.4.1 as the current language.

    I am not able to get CATSEARCH to work with this web app and the OJDBC14.jar. It appears that the Dev environment is always looking for classes12.jar. I verified this by renaming the OJDBC1.jar to classes12.jar. I then ran into fewer problems, but CATSEARCH is still not working. After some extensive work I have found the problem to be something with JDeveloper. I discovered this by taking the exact same code to a JBuilder environment and building it there. It works flawlessly.

    My question is How do I get JDeveloper, OJDBC14.jar, and CATSEARCH to all work together?

    Thanks,
    Bradley Dorner

    DB:3.30:Problem Implementing Ojdbc14.Jar cx

    Try editing your project to run with CLASSIC vs. OJVM and see if that fixes the issue.

    Rob

  • RELEVANCY SCORE 3.29

    DB:3.29:Scanning Java Webstart Application Classpath kz


    Ok, i got a problem...
    I made a java framework, it scan my classpath looking for service Providers Impl, work to java app, web app but with java web start, i can't access the jars (main jar and resources)... any help?!

    example:

    (classpath scanner framework)
    String classPath = System.getProperty("java.class.path");
    URL base = getClass().getClassLoader().getResource("/../lib/");
    if(base != null) classPath += PATH_SEPARATOR+base.getPath().replaceAll(SPACE, SIMPLE_SPACE);
    base = getClass().getClassLoader().getResource("/../classes/");
    if(base != null) classPath += PATH_SEPARATOR+base.getPath().replaceAll(SPACE, SIMPLE_SPACE);
    File f = null;
    String[] paths = classPath.split(PATH_SEPARATOR);What i need to do? I need access the follow jars (declared in my jnlp).
    jar href="senhas-crypto.jar" main="true"/
    jar href="looks-1.3.1.jar"/
    jar href="pimpas-xml-dom4j-1.0-SNAPSHOT.jar"/
    jar href="pimpas-xml-1.0-SNAPSHOT.jar"/
    jar href="pimpas-logging-1.0-SNAPSHOT.jar"/
    jar href="pimpas-core-1.0-SNAPSHOT.jar"/
    jar href="log4j-1.2.11.jar"/
    jar href="pimpas-util-1.0-SNAPSHOT.jar"/Tkz.

    DB:3.29:Scanning Java Webstart Application Classpath kz

    Since your jars arn't loaded by the application ClassLoader, you can't find them on the classpath. In fact, those files may not even be on the client machine.
    If you are using Java 6, you can get the class loader (Thread.currentThread().getCOntextClassLoader();) and case it to a URLClassLoader, then call URLClassLoader.getURLs() to get a list of the urls.
    you can open these urls and read from them and underneath the caching code will return the contents from the cache if they are cached.

    /Andy

  • RELEVANCY SCORE 3.29

    DB:3.29:Connecting To The Oracle Server 9k


    I want to write a small application which will connect to the Oracle Server (10g).
    I have downloaded the ojdbc14.jar from the Oracle site. What should I do with it now ?
    Someone told me that you have to add it to classpath. Which classpath ? the systems ? or in the project itself ?
    and how will I be able to connect to it ? I mean which api(s) should I use.
    Can anyone help me please

    DB:3.29:Connecting To The Oracle Server 9k

    It should be in the classpath of your application that connects to DB.

  • RELEVANCY SCORE 3.28

    DB:3.28:Unable To Run The Test_Fwktutorial.Jsp Oaf Page.Process Exit With Code 1 jf


    Hi all,
    I downloaded the Patch 4573517 from Metalink for JDEV with OA extension release 11i.I followed all the instruction of the setup init and installed the Jdev,also mytutorial pages got compiled successfully,but when i trie dto run the page

    Run Run test_fwktutorial.jsp from the main menu.

    it gives me error.The error is as follows
    [Starting OC4J using the following ports: HTTP=8988, RMI=23891, JMS=9227.]

    C:\D drive\OA_2008\jdevbin\jdk\bin\javaw.exe -client -classpath C:\D drive\OA_2008\jdevbin\j2ee\home\oc4j.jar;C:\D drive\OA_2008\jdevbin\jdev\lib\jdev-oc4j.jar -Xbootclasspath/p:C:\D drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\D drive\OA_2008\jdevbin\jdev\appslibrt\nls_charset12.zip -DFND_JDBC_STMT_CACHE_SIZE=200 -DCACHENODBINIT=true -DRUN_FROM_JDEV=true -mx256m -Doracle.j2ee.dont.use.memory.archive=false -Xverify:none -Doracle.j2ee.dont.use.memory.archive=true -Doracle.j2ee.http.socket.timeout=500 com.evermind.server.OC4JServer -config C:\D drive\OA_2008\jdevhome\jdev\system9.0.3.5.1437\oc4j-config\server.xml
    [waiting for the server to complete its initialization...]

    java.lang.NoClassDefFoundError: drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14/jar;C:\D

    Exception in thread "main"
    Process exited with exit code 1.

    I am not understanding why it is going in exception.One reason which i doubthere is the line

    java.lang.NoClassDefFoundError: drive\OA_2008\jdevbin\jdev\appslibrt\ojdbc14/jar;C:\D

    here in this line the last word is ojdbc14/jar,i think it should have been ojdbc14.jar.

    Can any body please help me out on how to correct this problem.
    Thanks
    Manish

    DB:3.28:Unable To Run The Test_Fwktutorial.Jsp Oaf Page.Process Exit With Code 1 jf

    Hi George,
    It was the perfect catch,The OA page has started running

    Thanks

  • RELEVANCY SCORE 3.28

    DB:3.28:Aqjmsexception: Jms-120 Dequeue Fail + Linked Nullpointerexception pz


    Hello to all,

    Maybe this will help.

    What we have:
    - jms queue with single consumer and SYS.AQ$_JMS_MESSAGE on Oracle 10.2.0.5.0
    - java (1.7) client with connection via oracle thin client [included libs: aqapi13.jar, jms.jar, jta.jar, ojdbc14.jar]
    - queue sender
    - queue receiver

    What we want:
    - send text message to queue
    - receive message from queue

    What happens:
    - send message - ok
    - receive message - AQjmsException: JMS-120 dequeue fail + linked NullPointerException - AQjmsTextMessage.readTextMessageContainer

    Solution:
    - clear queue on server by using:
    po_t dbms_aqadm.aq$_purge_options_t;
    dbms_aqadm.purge_queue_table('QUEUE_TABLE_NAME', NULL, po_t);
    - add orai18n.jar to client classpath
    - recompile client
    - send message - ok
    - receive message - ok

    With best wishes.

    DB:3.28:Aqjmsexception: Jms-120 Dequeue Fail + Linked Nullpointerexception pz

    Hello to all,

    Maybe this will help.

    What we have:
    - jms queue with single consumer and SYS.AQ$_JMS_MESSAGE on Oracle 10.2.0.5.0
    - java (1.7) client with connection via oracle thin client [included libs: aqapi13.jar, jms.jar, jta.jar, ojdbc14.jar]
    - queue sender
    - queue receiver

    What we want:
    - send text message to queue
    - receive message from queue

    What happens:
    - send message - ok
    - receive message - AQjmsException: JMS-120 dequeue fail + linked NullPointerException - AQjmsTextMessage.readTextMessageContainer

    Solution:
    - clear queue on server by using:
    po_t dbms_aqadm.aq$_purge_options_t;
    dbms_aqadm.purge_queue_table('QUEUE_TABLE_NAME', NULL, po_t);
    - add orai18n.jar to client classpath
    - recompile client
    - send message - ok
    - receive message - ok

    With best wishes.

  • RELEVANCY SCORE 3.27

    DB:3.27:Add Library To A Classpath xf


    i have an executable jar and 3 other library jar in same directory

    i want to run the jar with 3 jar library on classpath;

    i run using batch file

    here's what i do:

    cd path
    java -cp .;a.jar;b.jar;c.jar -jar myexecutable.jar

    but it keep say that the library jar not present..

    what possibly cause my problem?
    Thanks

  • RELEVANCY SCORE 3.27

    DB:3.27:Does Wls8.1 Install With Oracle Jdbc Drivers In The Classpath By Default? zd


    I just went through the 8.1 install tonight and it looks to me like the
    oracle jars are in the default weblogic classpath.

    set
    WEBLOGIC_CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_s
    p.jar;%WL_HOME%\server\lib\weblogic.jar;%WL_HOME%\server\lib\ojdbc14.jar

    Why is that? I don't have oracle, and with just learning how to use wls, it
    took me a bit of time to finally figure this piece out (trying to get MySQL
    drivers loaded). Not everyone has Oracle installed, so why put it on the
    classpath for all servers/domains when they startup?

    Thanks.

    DB:3.27:Does Wls8.1 Install With Oracle Jdbc Drivers In The Classpath By Default? zd

    I'm not sure what the best practice is.

    The Oracle driver is set in
    bea/weblogic81/common/commEnv.cmd or commEnv.sh.

    There is a WEBLOGIC_CLASSPATH that has the jars in it and I always
    put my stuff at the beginning.

    I suspect that the preferred way of doing this is to update
    /bea/weblogic81/samples/domains/examples/startExamplesServer.cmd
    or whatever script is used to start the server.

    "Flip" [remove]phenry_w@hotmail.com wrote in message news:3f1e9f19@newsgroups.bea.com...
    Hey Stephen, thanks for the reply.

    You got it to work without probs? COOL! : Where did you stick the driver
    and where did you put the jar reference (in which cmd/sh file and where
    abouts in the file)? Inquiring minds want to know! : I tried looking
    on the web, but I was referenced to some PRE_CLASSPATH params, as well, as
    putting it into my own directories... I'm just looking to find out what dir
    is the best practise to dump the jar file into and where to put the
    reference in a classpath.

    One small note, I do dev in WIN and run production on linux (that might
    change soon, but that's another question, and another server :).

    Thanks.

    PS BEA, nice domain config wizard with 8.1! Very sweet, I like the
    integrated connection pool and datasource creation!

    "Stephen Felts" Steve@spam.com wrote in message
    news:3f1e907f$1@newsgroups.bea.com...
    The Oracle driver (client jar) is shipped in the box. Having it in theCLASSPATH makes it easier
    for customers that use it.
    If you don't use it and you want to use another driver, it won't get inthe way
    since your alternate driver will have a different classname.

    I installed and ran MySQL with no problems.

    "Flip" !no_spam!phenry_w@hotmail.com wrote in messagenews:3f1def67@newsgroups.bea.com...
    I just went through the 8.1 install tonight and it looks to me like the
    oracle jars are in the default weblogic classpath.

    setWEBLOGIC_CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_s
    p.jar;%WL_HOME%\server\lib\weblogic.jar;%WL_HOME%\server\lib\ojdbc14.jar

    Why is that? I don't have oracle, and with just learning how to usewls, it
    took me a bit of time to finally figure this piece out (trying to getMySQL
    drivers loaded). Not everyone has Oracle installed, so why put it onthe
    classpath for all servers/domains when they startup?

    Thanks.

  • RELEVANCY SCORE 3.27

    DB:3.27:Java.Lang.Noclassdeffounderror 77


    I have Oracle 9.2.0.3 and Java 1.4.1_03 and I try to start follow programm:

    import java.sql.*;
    //import oracle.jdbc.*;

    public class jdbctest {
    public static void main(String[] argc)
    throws ClassNotFoundException, SQLException {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    //DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver() );

    Connection conn = DriverManager.getConnection("jdbc:oracle:thin@host:1521:oradb", "guest", "test");

    Statement stmt = conn.createStatement();
    ResultSet rset = stmt.executeQuery("select 'Hello' || USER || '!' Test from dual");

    while(rset.next() )
    System.out.println(rset.getString(1) );

    rset.close();
    stmt.close();
    conn.close();
    }
    }

    After java jdbctest I get an error: "Exception in thread "main" java.lang.NoClassDefFoundError: jdbctest".
    C:\oracle\ora92\jdbc\lib\ojdbc14.jar is defined in CLASSPATH.
    I tried also java -classpath c:\oracle\ora92\jdbc\lib\ojdbc14.jar jdbctest - it comes the same error.
    When I unkomment "import oracle.jdbc.*", I get an error "package oracle.jdbc does not exist".
    I tried also to copy ojdbc14.jar in a folder where is the source file. It dosn't help.
    Have anybody any idea, what can I do to resolve this problem?

    Any help will be approtiate.
    With regards,
    Andrej.

    DB:3.27:Java.Lang.Noclassdeffounderror 77

    I think the problem was on my IDE (NetBeans). I compiled and started the program with javac/java without -classpath (the idea to include source directory path in CLASSPATH was very helpful) and it works correctly.
    Thank you for your help.
    With regards,
    Andrej.

  • RELEVANCY SCORE 3.26

    DB:3.26:Oracle Xe Jdbc Connection Problem jz


    OS - Windows XP Home Edition
    JDK 1.6
    Apache 6.x

    All the above three software I have installed on the single computer.

    1. I set the ojdbc14.jar in the classpath
    2. wrote the db connection code. the code compiles fine.
    3. when I try to execute the java code it gives the classdefnotfound.

    However I am able to connect to the Oracle with the SQL Plus.

    A. Tnsping returns fine but with a message that the "TNS-12541: TNS:no listener"
    B. When I try to start the listener with "net start OracleXETNSListener" , it says the
    listener is already running.
    C. I am unable to access the XE from the HTTP page.
    C. Since apache uses the 8080 port I configured the database to use 8081 port by
    following command. "exec dbms_xdb.sethttpport("8081"; "

    Help me. what is going on here. Why am I not able to connect to XE with Java code

    DB:3.26:Oracle Xe Jdbc Connection Problem jz

    1. All the softwares are installed on the single machine.
    2. Access HTTP homepage is also a problem. I am not able to access the DB homepage
    from HTTP.

  • RELEVANCY SCORE 3.26

    DB:3.26:Jdbc And Classpath Problems On Openvms mx


    Hello,

    I'm working on an OpenVMS server and I got a simpler Java application that needs to establish a connection to an Oracle database, the application works perfectly well on Windows but when I moved to OpenVMS I got some problems with the oracle driver.

    I believe Im using the correct driver, I already checked on the oracle site according to my java version (1.4.2) and my database version (oracle 9i 9.2.0.7.0)

    This is the error:

    $java -jar miss.jar "DnBProcess"
    About to start loading parameters for the MISS Proxy.
    Successfully load parameters for the MISS Proxy.
    About to load interface settings for DnBProcess
    Settings for DnBProcess succesffully loaded.
    About to load interface DnBProcess
    About to start loading parameters for DnB Interface.
    Successfully load parameters for DnB Interface.
    Interface DnBProcess succesffully loaded.
    About to execute interface DnBProcess
    Connecting to the database...
    java.lang.NoClassDefFoundError: oracle/jdbc/OracleDriver
    at miss.DnBProcess.ExecuteQueryToFile(DnBProcess.java:85)
    at miss.DnBProcess.Execute(DnBProcess.java:178)
    at miss.Proxy.ExecuteInterface(Proxy.java:160)
    at miss.Proxy.main(Proxy.java:207)

    I know is a classpath problem, and my classpath on VMS looks like this:

    define JAVA$CLASSPATH .,SYS$COMMON:[JAVA$142.LIB]TOOLS.JAR,SYS$COMMON:[JAVA$142.LIB]DT.JAR,SYS$COMMON:[JAVA$142.JRE.LIB]RT.JAR, USER1:[MONTEALEGRE.TEST.LIBS]OJDBC14.JAR,USER1:[MONTEALEGRE.TEST.MISS.LIBS]OJDBC14.JAR,[]

    As you can see I added the ojdbc14.jar in different folders but my application seems not to find it.

    Does anyone know how to set the classpath properly on VMS? Or maybe give me some tips that could lead me to find a solution to this problem.

    Thanks.

    Ileana.

    DB:3.26:Jdbc And Classpath Problems On Openvms mx

    Ileana,
    Perhaps you could post your manifest file here?
    You may have made a mistake.

    Good Luck,
    Avi.

  • RELEVANCY SCORE 3.25

    DB:3.25:Compiling Xdk Xslsample Demo 3p


    Can you tell me what I'm doing wrong. I can't complie a demo that came with the XML Develepor Kit. It appears to be a problem withe the CLASSPATH but xmlparserv2.jar is in the CLASSPATH along with the other libraries mentioned in the documentation.

    Thank you

    I downloaded and extracted xdk_hpux64_10_1_0_2_0_production.tar.gz, converted env.ch to env.sh and ran it
    ------------------------------------------------------------------------------------------------------
    /finrpts/development/bin/taxpro_comp/fin_to_star/bin (herring) $ . env.sh

    CLASSPATH=.:/u01/app/oracle/product/10.2.0/jdbc/lib/ojdbc14.jar:/u01/app/oracle/product/10.2.0/jlib/orai18n.jar:/finrpts/development/bin/taxpro_comp/fin_to_star/lib/xmlparserv2.jar:/finrpts/development/bin/taxpro_comp/fin_to_star/lib/xschema.jar:/finrpts/development/bin/taxpro_comp/fin_to_star/lib/xsu12.jar:/finrpts/development/bin/taxpro_comp/fin_to_star/lib/oraclexsql.jar:/finrpts/development/bin/taxpro_comp/fin_to_star/lib/classgen.jar

    I tried to compile the XSLSample and recieved the following errors.
    -----------------------------------------------------------------------------------------------
    /finrpts/development/bin/taxpro_comp/fin_to_star/xdk/demo/java/parser/xslt (herring) $ javac XSLSample.java

    /finrpts/development/bin/taxpro_comp/fin_to_star/xdk/demo/java/parser/xslt (herring) $ javac XSLSample.java

    XSLSample.java:16: package oracle.xml.parser.v2 does not exist
    import oracle.xml.parser.v2.DOMParser;
    ^
    XSLSample.java:17: package oracle.xml.parser.v2 does not exist
    import oracle.xml.parser.v2.XMLDocument;
    ^
    XSLSample.java:18: package oracle.xml.parser.v2 does not exist
    import oracle.xml.parser.v2.XMLDocumentFragment;
    ^
    XSLSample.java:19: package oracle.xml.parser.v2 does not exist
    import oracle.xml.parser.v2.XSLStylesheet;
    ^
    XSLSample.java:20: package oracle.xml.parser.v2 does not exist
    import oracle.xml.parser.v2.XSLProcessor;

    DB:3.25:Compiling Xdk Xslsample Demo 3p

    package oracle.xml.parser.v2 does not exist
    Add xmlparserv2.jar to classpath.

  • RELEVANCY SCORE 3.25

    DB:3.25:Java.Lang.Unsupportedoperationexception 1k


    I have a weblogic 11g application server, when i deploy an adf 10g application everything goes fine, but when i run the application i get an error:

    java.lang.UnsupportedOperationException
    at javax.faces.context.ExternalContext.setRequest(ExternalContext.java:357)

    i have set my libraries in the: setDomainEnv.sh

    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/adfbinding.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/adfmweb.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/adfm.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/adfshare.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/bc4jdomorcl.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/bc4jimdomains.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/collections.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/ordim.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/lib/ordhttp.jar

    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/adf-controller.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/adf-controller-api.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/adf-controller-rt-common.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/adf-controller-schema.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/adf-faces-databinding-rt.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/adf-richclient-api-11.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/bc4jhtml.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/datatags.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/graphtags.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/org.apache.commons.logging_1.0.4.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/trinidad-api.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/testproject/trinidad-impl.jar

    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/adf-faces-api.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/adf-faces-impl.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/adfm_10g.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/bc4j-mbeans_11.1.1.5.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/bc4juixtags.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/commons-beanutils.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/commons-collections.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/commons-digester.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/commons-logging.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/commons-logging-api.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/jhsadfrt-10.1.3.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/jsf-api-1.2.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/jsf-impl.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/jstl.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/log4j-1.2.7.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/oracle.jheadstart.addins.jag.10.1.3.jar
    CLASSPATH=${CLASSPATH}:${WL_HOME}/ADF/adf10glibs/poi-2.5.1-final-20040804.jar

    i know this is somekind of version problem with the weblogic application server and the loaded libraries, but i cannot figured it out!

    does somebody has this problem or know how to fix this!

    DB:3.25:Java.Lang.Unsupportedoperationexception 1k

    thank you for your suggestion, but it didn't fix the problem!

  • RELEVANCY SCORE 3.24

    DB:3.24:Trouble Connecting To Oracle Db sd


    Hi, I am a totally new programmer and I have decided to learn java.

    I have written a small program that connects to an oracle 9i database and creates a table. Below.

    My problem is that it will not run because I think I haven't declared the database drivers in the class path.

    Could someone please tell me what jar/zip file I need to make this program work.

    Secondly what do I type in the command line to execute the program with the class path decalred.

    Is it something like;

    java -classpath .;ojdbc14.jar CreateCoffees

    Thanks in advance.
    import java.sql.*;

    public class CreateCoffees {
    public static void main(String args[]) {

    String url = "jdbc:oracle:thin:@ff-nb-35:1521:ffnb35";
    Connection con;
    String createString;
    createString = "create table COFFEES " +
    "(COF_NAME VARCHAR(32), " +
    "SUP_ID INTEGER, " +
    "PRICE FLOAT, " +
    "SALES INTEGER, " +
    "TOTAL INTEGER)";
    Statement stmt;

    try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch(java.lang.ClassNotFoundException e) {
    System.err.print("ClassNotFoundException: ");
    System.err.println(e.getMessage());
    }

    try {
    con = DriverManager.getConnection(url, "testDB", "test");
    stmt = con.createStatement();
    stmt.executeUpdate(createString);
    stmt.close();
    con.close();

    } catch(SQLException ex) {
    System.err.println("SQLException: " + ex.getMessage());
    }
    }
    }I have tried ojdbc14.jar and stored it in the same folder as my CreateCoffees.class.

    The stack I am getting from the command line is below;

    C:\Documents and Settings\morrisg\Desktop\Java\myJava\New Folderjava -classpath
    .;ojdbc14.jar CreateCoffees
    Exception in thread "main" java.lang.UnsupportedClassVersionError: CreateCoffees
    (Unsupported major.minor version 50.0)
    at java.lang.ClassLoader.defineClass0(Native Method)
    at java.lang.ClassLoader.defineClass(ClassLoader.java:539)
    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:12
    3)
    at java.net.URLClassLoader.defineClass(URLClassLoader.java:251)
    at java.net.URLClassLoader.access$100(URLClassLoader.java:55)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:194)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

    Edited by: Chuck_Morris on Sep 29, 2007 6:24 AM

    DB:3.24:Trouble Connecting To Oracle Db sd

    duffymo wrote:
    My mistake - I thought javac had a -version flag, too.

    %It does on 1.5 and later. :o)

    ~

  • RELEVANCY SCORE 3.24

    DB:3.24:Re: Connection Reset By Peer (Jdk/Jre 1.5.0_06, Oracle 10.2.0.2) sp


    With JDK 5.0 use ojdbc5.jar instead of ojdbc14.jar.

    DB:3.24:Re: Connection Reset By Peer (Jdk/Jre 1.5.0_06, Oracle 10.2.0.2) sp

    I keep getting the "Oracle says: Io exception: Connection reset by peer: socket write error" to my jdbc thin client connection. I have talked to our dba's and they don't see anything wrong on the oracle side. Network people say the network is good. Was this bug fixed in newer versions of ojdbc14.jar?

  • RELEVANCY SCORE 3.24

    DB:3.24:Oracle 9.2.0.6 Client Jdbc Oci Driver Compatibility Issue With Jrockit 1.4. ps


    I have weblogic server 8.1 sp4 running on Linux E3.0 using JRockit 1.4.2_5.
    I cannot seem to get the Oracle driver ojdbc14.jar to work. Yes I have added $ORACLE_HOME/bin to my classpath prior to any weblogic classes, I added $ORACLE_HOME/lib and $ORACLE_HOME/jdbc/lib to my LD_LIBRARY_PATH with no luck.

    I get the error "no ojdbc10 in java.library.path".

    I keep reading in the JDBC driver notes that the driver is compatible with different version of JDK 1.x but not JRockit. Perhaps Oracle 10 has this fixed.

    Anyone experiences the same problem ? I am stuck ..

    DB:3.24:Oracle 9.2.0.6 Client Jdbc Oci Driver Compatibility Issue With Jrockit 1.4. ps

    I have weblogic server 8.1 sp4 running on Linux E3.0 using JRockit 1.4.2_5.
    I cannot seem to get the Oracle driver ojdbc14.jar to work. Yes I have added $ORACLE_HOME/bin to my classpath prior to any weblogic classes, I added $ORACLE_HOME/lib and $ORACLE_HOME/jdbc/lib to my LD_LIBRARY_PATH with no luck.

    I get the error "no ojdbc10 in java.library.path".

    I keep reading in the JDBC driver notes that the driver is compatible with different version of JDK 1.x but not JRockit. Perhaps Oracle 10 has this fixed.

    Anyone experiences the same problem ? I am stuck ..

  • RELEVANCY SCORE 3.23

    DB:3.23:Re: Package Oracle Does Not Exist a9


    Because your system CLASSPATH is totally ignored. You shouldn't even have one. javac and java ignore it; IDEs like Eclipse ignore it; app servers like Tomcat and WebLogic ignore it. It's useless.

    Where is the ojdbc14.jar file? That's where oracle.jdbc.driver.OracleDriver class is. Add the path to that JAR to your CLASSPATH using the -classpath option when you run java.exe.

    %

    DB:3.23:Re: Package Oracle Does Not Exist a9

    Thank you very much for the help duffymo..

    1. Can i not set the ojdbc14.jar fiel permanentlyYou can, but you've already learned that Java ignores it. Why do you persist?

    ly in the CLASS path
    2. jdbc:oracle:thin:@hostname:1521:database
    this gives me OpenDB error..Then you don't have the thin JDBC driver. Which one do you have?

    but if i use
    jdbc:oracle:thin:@hostname:1527:database
    my query is getting executedOK, this tells me that someone installed your Oracle listener to use port 1527, which is not the default port. 1521 is the default. You did the right thing by using the one that you were given.

    Since you're getting your query executed now, all is well.

    %

  • RELEVANCY SCORE 3.22

    DB:3.22:Help Me Out With This Error zm


    Hi,
    Can anybody help me out and tell why this error come out when i'm tryring to run the oracle sample on clob

    bash-2.03$ sh run.sh
    run.sh: CLASSPATH=.:/oracle/OraHome1/jdbc/lib/classes12.zip:/oracle/OraHome1/jdbc/lib/classes12.jar:/oracle/OraHome1/jdbc/lib/ojdbc14.jar:: is not an identifier

    What does this mean?

    DB:3.22:Help Me Out With This Error zm

    Hi,
    Can anybody help me out and tell why this error come out when i'm tryring to run the oracle sample on clob

    bash-2.03$ sh run.sh
    run.sh: CLASSPATH=.:/oracle/OraHome1/jdbc/lib/classes12.zip:/oracle/OraHome1/jdbc/lib/classes12.jar:/oracle/OraHome1/jdbc/lib/ojdbc14.jar:: is not an identifier

    What does this mean?

  • RELEVANCY SCORE 3.22

    DB:3.22:Problema With Oracle sd


    Hi, I'm using

    driver: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@#HOSTNAME:1521:#DATABASE

    with classes12.jar, nls_charset12.jar and ojdbc14.jar

    I can connect and see the tables from db, but i can't see the data from the tables.... How can resolve this problem ?.

    DB:3.22:Problema With Oracle sd

    Hi Gaston,

    As i have told earlier, Oracle 10GR2 JDBC driver is not suitable for Creator NOW.

    I have checked out Oracle 10G Release2 driver (10.2.0.1), it fails even for simple databinding in Creator. It doesn't support preparedStatement.getMetaData().

    I believe, popular deployment containers (Sun AppServer, JBoss, WebLogic, WebSpshere and Oracle AppServer) do bundle DataDirect JDBC Drivers in their product. So, it could easy to use the bundled JDBC driver in Creator and would suggest using DataDirect drivers bundled in the containers.

    -Sakthi

  • RELEVANCY SCORE 3.22

    DB:3.22:Running Jpximport Outside Jdeveloper 99


    Dear,

    I am running jpximport outside JDeveloper with classes in the classpath icluding
    ojdbc14.jar
    collections.zip
    xmlparserv2.jar
    oamdsdt.jar
    mdsdt.jar
    mdsrt.jar
    rt.jar
    The import is finished successfully but with error message

    Error: java.lang.AbstractMethodError: oracle.xml.parser.v2.XMLDocument.createEle
    mentNS(Ljava/lang/String;Ljava/lang/String;)Lorg/w3c/dom/Element;

    This is from jdk1.4. I tried switching with jdk1.3 changing ojdbc14.jar with classes12.jar and rt.jar from jdk1.3 - but with the same result.
    From within JDeveloper envirenment I don't have any errors.

    Anybody has an idea?

    Thank you.

    Anatoliy

    DB:3.22:Running Jpximport Outside Jdeveloper 99

    Dear,

    I am running jpximport outside JDeveloper with classes in the classpath icluding
    ojdbc14.jar
    collections.zip
    xmlparserv2.jar
    oamdsdt.jar
    mdsdt.jar
    mdsrt.jar
    rt.jar
    The import is finished successfully but with error message

    Error: java.lang.AbstractMethodError: oracle.xml.parser.v2.XMLDocument.createEle
    mentNS(Ljava/lang/String;Ljava/lang/String;)Lorg/w3c/dom/Element;

    This is from jdk1.4. I tried switching with jdk1.3 changing ojdbc14.jar with classes12.jar and rt.jar from jdk1.3 - but with the same result.
    From within JDeveloper envirenment I don't have any errors.

    Anybody has an idea?

    Thank you.

    Anatoliy

  • RELEVANCY SCORE 3.22

    DB:3.22:Blob Insertion In Oracle 10g Database Using Ojdbc14 (10g Drivers) 9p


    Hello!
    I have a situation where I am trying to insert a blob data into oracle 10g database using oracle thin
    10g drivers, bojdbc14.jar/b in bweblogic 8.1 sp2/b. I have the following error happening very intermittently.
    ubjava.sql.SQLException: OALL8 is in an inconsistent state./b/u
    And this is leading to the ub"No more data to read from socket"/b/u error when I am trying to
    insert the BLOB into the database. I have gone through the bug list of SP2 and have realised there is the
    following issue fixed in SP3.

    bCR124933/b
    bAn Oracle BLOB sometimes used a pooled connection after the connection pool determined that
    the connection was available for reassignment.
    Code was added to ensure the BLOB is completely processed before closing the pool connection or
    ending the transaction./b

    I believe the problem arises when we try to insert BLOB into database using a refreshed connection
    from the pool.We have upgraded weblogic 8.1 from SP2 to SP4 service pack inorder to come over the above problem.
    But this still continues to behave intermittently.
    We put ojdbc14.jar in our classpath and Weblogic startup classpath looks like the following :-

    WLS_CLASSPATH=${WLS_DOMAIN_DIR}/appslib/server.jar:$PRE_CLASSPATH:${WLS_WEBLOGIC_HOME}/server/lib/weblogic.jar:
    ${WLS_WEBLOGIC_HOME}/server/lib/ojdbc14.jar:${WLS_WEBLOGIC_HOME}/server/lib:${WLS_JAVA_HOME}/lib/tools.jar:
    ${WLS_JAVA_HOME}/jre/lib/rt.jar:${WLS_WEBLOGIC_HOME}/server/lib/webservices.jar:${WLS_CONFIG_DIR}:
    ${WLS_CUSTLIB_DIR}:${WLS_BIN_DIR}:$POST_CLASSPATH
    export WLS_CLASSPATH
    CLASSPATH=${WLS_CLASSPATH}:${APP_CLASSPATH}
    export CLASSPATH

    After upgrade to SP4, there are new ojdbc14_g.jar(debug jar) and orai18n.jar jars in the ${WLS_WEBLOGIC_HOME}/server/ext/jdbc/oracle/10g directory added.

    Please let me know if I need to update classpath with the new 10g jars in the ext/lib directory or any suggestions
    to insert BLOB using the ojdbc14 10G drivers, Weblogic 8.1 environment would be appreciated.

    Following is the stack trace of the errors that I recieve:

    Oct 6, 2005 1:29:36 PM EDT Error JDBC BEA-001112 Test "select count(*) from DUAL" set up for pool
    "MHUBPoolStage" failed with exception: "java.sql.SQLException: OALL8 is in an inconsistent state".
    Oct 6, 2005 1:29:36 PM EDT Info JDBC BEA-001128 Connection for pool "MHUBPoolStage" closed.
    Oct 6, 2005 1:29:36 PM EDT Info JDBC BEA-001067 Connection for pool "MHUBPoolStage" refreshed.

    Oct 6, 2005 1:29:36 PM EDT Info EJB BEA-010051
    java.rmi.RemoteException: TransactionRequestManager.requestTransaction():
    Caught PersistnceException com.mortgagehub.busobj.PersistenceException: -5258: No more data to read from socket

    Please let me know if there is anything that I am missing.

    Thanks
    Pradeep G

    DB:3.22:Blob Insertion In Oracle 10g Database Using Ojdbc14 (10g Drivers) 9p

    pradeep g wrote:

    Joe,
    1 - Are you sure to get a pool connection, use it, and close it
    (including all it's subobjects like blobs), all within a single
    user-invoke?
    With in a single call, we have the following steps. Create a the
    connection from pool, delete a blob using PS, close PS and use
    the same connection to create a PS, and insert a BLOB again and
    then close the connection and PS. This code has never been touched
    in past year or so and we have recently migrated our systems to
    weblogic 81 servers from weblogic 61 and Oracle 9 to Oracle 10G.
    Do you want me to change this into a single call and do and update.
    Is it going to make any difference?That sounds good, and you're saying it always worked in 6.1, right?
    Mostly I'm just looking for code like this;

    myMethod()
    {
    Connection c = null;
    try {
    c = ds.getConnection();
    .... do all the JDBC...
    ...don't pass the Blob anywhere that expects to use it later....
    ps.close();
    } finally {
    c.close(); // Just close the connection. No need to close anything else here...
    }
    }

    2.We have reservations to try with weblogic oracle drivers as there
    is other place our code breaks while interacting with stored procedures.Ok. Yes, there are differences in how to get ResultSets from Oracle
    procedures between the drivers. If this isn't the issue, let me know.
    The reason I would ask that you try the driver we provide, if only for
    a test of this blob thing, is that if the problem happens there too,
    we may assume a WLS/user code problem, and the BEA dirver has a spy
    mode which records every JDBC call, so we could debug easier. On the
    other hand, if the BEA dirver works, we know it's an oracle-owned issue.

    If you turn off the statement caching in the 8.1 pool, does the problem
    go away?

    thanks
    Joe

    Thanks
    PradeepPradeep G Ok, then answer my other questions: 1 - Are you sure to get a pool connection, use it, and close it (including all it's subobjects like blobs), all within a single user-invoke? 2 - Can you duplicate this using our driver for oracle instead of Oracle's driver? thanks Joe

  • RELEVANCY SCORE 3.21

    DB:3.21:Oracle Driver Jdbc 77


    hi,

    I have problems to use it ojdbc14.jar with tomcat 4.1 and oracle 9i 2.0.
    I configured server.xml with tag ResourceParams ....
    and web.xml with the tag resource-ref.
    The lib common/lib contains ojdbc14.jar commons-collections.jar, commons-dbcp-1.1.jar and
    commons-pool-1.1.jar.

    the context of the web application is found and the name jndi too. But I always have the message
    "Cannot create JDBC driver of class 'oracle.jdbc ... ' for connect URL '...'" when I recover connection

    somebody already encountered this problem?

    help!!!
    thank you

    DB:3.21:Oracle Driver Jdbc 77

    hi,

    I have problems to use it ojdbc14.jar with tomcat 4.1 and oracle 9i 2.0.
    I configured server.xml with tag ResourceParams ....
    and web.xml with the tag resource-ref.
    The lib common/lib contains ojdbc14.jar commons-collections.jar, commons-dbcp-1.1.jar and
    commons-pool-1.1.jar.

    the context of the web application is found and the name jndi too. But I always have the message
    "Cannot create JDBC driver of class 'oracle.jdbc ... ' for connect URL '...'" when I recover connection

    somebody already encountered this problem?

    help!!!
    thank you

  • RELEVANCY SCORE 3.20

    DB:3.20:Newbie Trying To Connect To Oracle Using Ojdbc14 xs


    Hey Programming Pals;

    I am trying to connect to a remote oracle data base.

    I have installed oracle client (allowing me to be able to connect with PL/SQL developer).

    Now I need to connect with JDBC.

    I down loaded ojdbc14 and put it in my tomcat bin directory.

    I than made an entry in path and in classpath to this jar file.

    Here is the code I am using to try and connect with:

    try
    { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    }
    catch (ClassNotFoundException c)
    {
    System.out.println("Could not load the ODBC driver:" + c);
    }

    Here is the error I am getting:

    An error occurred at line: 38 in the jsp file: /jsp/form.jsp

    Generated servlet error:
    [javac] Compiling 1 source file

    D:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\jhtp5\jsp\form_jsp.java:85: package ojdbc14.oracle.jdbc.driver does not exist
    DriverManager.registerDriver(new ojdbc14.oracle.jdbc.driver.OracleDriver());

    I browsed through the jar and verified this path exists. Why can't the jvm find it?

    Here are my system variables:

    CLASSPATH:
    .;D:\Program Files\Apache Group\Tomcat 4.1\bin\ojdbc14.jar

    PATH:
    D:\Program Files\Apache Group\Tomcat 4.1\bin\ojdbc14.jar;D:\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

    Any help would be appreciated.

    Luke

    DB:3.20:Newbie Trying To Connect To Oracle Using Ojdbc14 xs

    Tomcat doesn't use the System classpath.
    Put the ojdbc14.jar file in the web-inf/lib directory of your web application, restart Tomcat, and try again.

    Cheers,
    evnafets

  • RELEVANCY SCORE 3.20

    DB:3.20:Get Japanese Data From Oracle Table Using Thin Driver And Write Into File df


    Hi,

    I wrote a program to get japanese data from oracle table and write into a file. When I used ojdbc14.jar of version 9.0.2.0.0 then I am able to write data file with japanase data. But when I tried with ojdbc14.jar of version 10.2.0.3.0 then I found junked data into my data file.

    Is there any issue in ojdbc14.jar of version 10.2.0.3.0.?

    Please guide me to solve this problem.

    Thanks

    DB:3.20:Get Japanese Data From Oracle Table Using Thin Driver And Write Into File df

    You have a driver that works with the database(s) that you need to get the data from?

    Then the solution is to use it.

  • RELEVANCY SCORE 3.20

    DB:3.20:Will The Jdbc Driver "Ojdbc14.Jar" Be Certificated With Jdk 1.6? d9


    From the download page, we can find "ojdbc14.jar (1,545,954 bytes) - classes for use with JDK 1.4 and 1.5".
    Will Oracle go on certificating it with JDK 1.6 in the expected future? Otherwise, in customers JRE1.6 env, how should use ojdbc14.jar? Is there any incompatibility problems?

    DB:3.20:Will The Jdbc Driver "Ojdbc14.Jar" Be Certificated With Jdk 1.6? d9

    Looking at this scenario we can confirm that ojdbc6.jar can be used in oracle 10.2 using patch from oracle site.
    but in my weblogic i already used ojdbc6.jar but my oracle 10.2 has ojdbc14.jar.

    Thus it is giving "Closed Connection" ORA-17008 error which is unsolvable.

    Has this problem been addressed in ojdbc6.jar when I use it in my oracle 10.2 or i need to install 11G as well so the jar works fine and I never get "Closed Connection" ORA-17008 error and my production systems just go ok and my client satisfied.

  • RELEVANCY SCORE 3.20

    DB:3.20:Does Anybody Know Step To Install Jdbc Driver? 79


    Hi
    All,

    I have windows xp and i want to install jdbc driver for jdk 1.5.. I have downloaded ojdbc14.jar. but I don't know how to execute that file. I have tried with

    java -jar ojdbc14.jar

    it gives me following output
    C:\java -jar c:\ojdbc14.jar
    Failed to load Main-Class manifest attribute from
    c:\ojdbc14.jar

    so it is not working.

    does anybody know step to install JDBC driver?

    Thanks,
    Vishal

    Message was edited by:
    vishal patel

    Message was edited by:
    vishal patel

    DB:3.20:Does Anybody Know Step To Install Jdbc Driver? 79

    The JDBC drivers aren't "installed" like application software. The ojdbc.jar file is a library that contains the driver. To use it in a Java program, two steps are required:

    (1) Invoke the driver (using the Class.forName() method is most common), and
    (2) include the library in the class path when you run your program.

    Here is a sample program I have put together to illustrate:
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;

    public class JDBCTest {
    public static void main(String args[]) throws SQLException, ClassNotFoundException {
    Class.forName("oracle.jdbc.OracleDriver");

    String dbString = "jdbc:oracle:thin:@localhost:1521:xe";
    String username = "forums";
    String password = "forums";

    Connection connection = DriverManager.getConnection(dbString, username, password);

    Statement statement = connection.createStatement();

    ResultSet rs = statement.executeQuery("select 'hi' as my_column from dual");

    while(rs.next())
    System.out.println(rs.getString("MY_COLUMN"));

    rs.close();
    statement.close();
    connection.close();
    }
    }Below, I compile and run this program. You can see the necessity of including the JAR in the class path:
    C:\workspacejavac JDBCTest.java

    C:\workspacejava JDBCTest
    Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at JDBCTest.main(JDBCTest.java:9)

    C:\workspacejava -cp ojdbc14.jar;. JDBCTest
    hi

    C:\workspaceAlthough no classes in this JAR file are explicitly used by the program (other than the Class.forName() line), it is necessary. Without it, the JVM will return the following error message (to see this first-hand, simply comment out the Class.forName() line in the above program):
    C:\workspacejava -cp ojdbc14.jar;. JDBCTest
    Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:xe
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at JDBCTest.main(JDBCTest.java:15)Kind regards,

    Christopher L. Simons

  • RELEVANCY SCORE 3.20

    DB:3.20:Merging Manifest Files Doesnt Work Correctly, When Creating A Jar 9j


    Hi,

    I've been frustrating over this problem a few hours now and still cant get it to work, so
    I thought, I'll try my changes here.

    I have a small java project, with a few classes, including a main method.
    I added a jar deployment to my project, set the main class property, because I also use
    some external libs I merge another manifest file that includes the following:
    Class-Path: lib/bitclasses.jar lib/mail.jar lib/ojdbc14.jar lib/activation.jarThis is the only method I found to work so far, to get to include the libs in my manifest.

    Anyway, if I build the jar file, the manifest will look like this
    Manifest-Version: 1.0
    Class-Path: lib/bitclasses.jar lib/mail.jar lib/ojdbc14.jar lib/activa
    tion.jar
    Created-By: Oracle JDeveloper 10.1.3.3.0
    Main-Class: nl.rsm.zaalReservering.citrix2oracleSomehow jdev cuts-off the class-path line, very frustrating

    doest anybody know why it does that? And am I doing the correct thing, to create a runnable jar file, the only way is to add stuff to the manifest file, right? setting classpath from mt java.exe .... isnt the way to go here?

    DB:3.20:Merging Manifest Files Doesnt Work Correctly, When Creating A Jar 9j

    Hi,

    I've been frustrating over this problem a few hours now and still cant get it to work, so
    I thought, I'll try my changes here.

    I have a small java project, with a few classes, including a main method.
    I added a jar deployment to my project, set the main class property, because I also use
    some external libs I merge another manifest file that includes the following:
    Class-Path: lib/bitclasses.jar lib/mail.jar lib/ojdbc14.jar lib/activation.jarThis is the only method I found to work so far, to get to include the libs in my manifest.

    Anyway, if I build the jar file, the manifest will look like this
    Manifest-Version: 1.0
    Class-Path: lib/bitclasses.jar lib/mail.jar lib/ojdbc14.jar lib/activa
    tion.jar
    Created-By: Oracle JDeveloper 10.1.3.3.0
    Main-Class: nl.rsm.zaalReservering.citrix2oracleSomehow jdev cuts-off the class-path line, very frustrating

    doest anybody know why it does that? And am I doing the correct thing, to create a runnable jar file, the only way is to add stuff to the manifest file, right? setting classpath from mt java.exe .... isnt the way to go here?

  • RELEVANCY SCORE 3.19

    DB:3.19:Noclassdeffounderror Connecting To Oracle9i x8


    I am trying to connect to an Oracle9i database through a java program and/or applet. I am using Java 2 SDK 1.4.1_01 on a Windows NT 4.0 machine with the Oracle client loaded. I am trying to register the oracle drive in the ojdbc14.jar file. I have looked at every posting I can find of other people having the same problem and getting the error message: java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver. I have placed the jar file in c:\j2sdk1.4.1_01\jre\lib. I have placed the path in the CLASSPATH environment variable under Control Panel | System. I have rebooted many times. The class compiles fine because it knows where the jar file is. I can connect fine with the JdbcOdbcDriver. Here is the code:

    import java.sql.*;
    import java.io.*;
    import oracle.jdbc.*;

    public class test extends java.applet.Applet
    {
    // Hold the connection to the database
    public void init()
    {
    Connection conn;

    // Register the driver.
    try
    {
    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
    // Connect to the database.
    conn = DriverManager.getConnection("jdbc:oracle:thin:@rccora1:1521:rccoe9i","tking","123abc");

    Statement statement = conn.createStatement();
    }
    catch (Exception e)
    { System.out.println("Exception: " + e);
    }

    }
    }

    This code is short and sweet. Not much to it. I have racked my brains to much. Can anyone please help me with this problem? Setting the classpath has seemed to have fixed everyone elses problem.

    DB:3.19:Noclassdeffounderror Connecting To Oracle9i x8

    Hello Terry, u have not really supplied enough info. what exactly r u compiling? and how?: ide?, command-line?, some build system (ant highly recommended). all of these will affect ur outcome. have tried a much simpler example at the windows command prompt? this means no applet, browser or html forms just a simple: java.sql.Connection. i am running 9.2.0.1.0 on a linux box and i tried using the classes12.zip file which did not work. i thought maybe since this is linux box i should use classes12.jar which did work. maybe u could try classes.zip since u r on a windoz box. otn docs reference: classes12.zip and classes12.jar. hope this helps, david brown, webitplanet.com.

  • RELEVANCY SCORE 3.19

    DB:3.19:Problem With Jdbc zm


    I've copied in the ojdbc14.jar driver from the oracle website which allows me to access my sql database. I've put this in my C:\j2sdk1.4.2_10\lib folder. When I try to compile a file i type in this to compile the file JEmp.java

    javac ?classpath %classpath%;c:\j2sdk1.4.2_10\lib\ojdbc14.jar JEmp.java

    When i do this i get this message:
    javac: invalid flag: ?classpath

    Does anyone have any idea why this is not working.
    P.S. if anyone could tell me how to get this working in JCreator it would be even better

  • RELEVANCY SCORE 3.19

    DB:3.19:Classnotfound Error With Oracle 10g...Please Help! xf


    Hello everyone!

    I am currently using jdk 1.4.2_10 with Oracle 10g. I tried to connect to the database, like this:

    try{

    String driverName = "oracle.jdbc.driver.OracleDriver";

    String serverName = "***.***.*.*";
    String portNumber = "****";
    String sid = "****";

    String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
    String usr = "*****";
    String pwd = "*****";

    //Load the JDBC driver
    Class.forName(driverName);
    //Connect to the base
    connect = DriverManager.getConnection(url,usr,pwd);
    }
    catch(ClassNotFoundException e){
    System.out.println("Error---No database driver");
    }
    catch(SQLException s){
    System.out.println("Error---No connection to the database");
    }

    Here is what's in my classpath, (i added the ojdbc14.jar) :
    c:\oracle\product\10.2.0\client_2\jdbc\lib\ojdbc14.jar;
    C:\Program Files\QuickTime\QTSystem\QTJava.zip

    Can anyone please help me?
    It's really a problem, i've been searching for 2 days now.....

    thank you

    DB:3.19:Classnotfound Error With Oracle 10g...Please Help! xf

    Hello everyone!

    I am currently using jdk 1.4.2_10 with Oracle 10g. I tried to connect to the database, like this:

    try{

    String driverName = "oracle.jdbc.driver.OracleDriver";

    String serverName = "***.***.*.*";
    String portNumber = "****";
    String sid = "****";

    String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
    String usr = "*****";
    String pwd = "*****";

    //Load the JDBC driver
    Class.forName(driverName);
    //Connect to the base
    connect = DriverManager.getConnection(url,usr,pwd);
    }
    catch(ClassNotFoundException e){
    System.out.println("Error---No database driver");
    }
    catch(SQLException s){
    System.out.println("Error---No connection to the database");
    }

    Here is what's in my classpath, (i added the ojdbc14.jar) :
    c:\oracle\product\10.2.0\client_2\jdbc\lib\ojdbc14.jar;
    C:\Program Files\QuickTime\QTSystem\QTJava.zip

    Can anyone please help me?
    It's really a problem, i've been searching for 2 days now.....

    thank you

  • RELEVANCY SCORE 3.18

    DB:3.18:Jdbc Compatibility xf


    Hi,

    Is the JDBC driver ojdbc14.jar supposed to be compatible with Oracle 8.1.7 ? Thanks,

    Rgds,
    Nicolas

    DB:3.18:Jdbc Compatibility xf

    Should be backwards compatible.

    The 14 in the JAR name has to do with the JVM, not the database.

    Try it - I think it should work.

    %

  • RELEVANCY SCORE 3.17

    DB:3.17:The Import Javax.Ejb Cannot Be Resolved.....Help Me! 11


    I have set up eclipse (Version: 3.4.0) and I have installed the J2EE SDK 5 (with java_app_platform_sdk-5_05-windows file).

    I have these environment variables:
    JAVA_HOME: C:\Sun\SDK\jdk

    J2EE_HOME: C:\Sun\SDK

    JRE_HOME: C:\Sun\SDK\jdk\jre

    CLASSPATH: C:\Sun\SDK\lib\j2ee.jar;
    C:\Sun\SDK\jdk\bin;
    C:\Java\jre1.6.0_05\lib\ext\QTJava.zip;
    C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar

    PATH: %JAVA_HOME%\bin;
    %J2EE_HOME%\bin;
    %JRE_HOME%\bin;
    C:\Program Files\SSH Communications Security\SSH Secure Shell;
    C:\Program Files\ESTsoft\ALZip

    The problem is that when my EJBs are being compiled, I get errors that point to my import statements (here are some examples}:

    import javax.naming.*;
    import java.rmi.*;
    import javax.rmi.*;
    import javax.ejb.*;

    The error message states "the import javax.ejb cannot be resolved"

    As you can see, I have my j2ee.jar in the classpath. Can anyone see what is wrong?

    Thank you in advace!

    DB:3.17:The Import Javax.Ejb Cannot Be Resolved.....Help Me! 11

    try: in your project properties choose 'Java Build Path' and add javaee.jar (from J2EE_HOME\lib) as external jar

  • RELEVANCY SCORE 3.16

    DB:3.16:Ora 00600 Error.. 8d


    hi,
    iam getting the ora00600 error while connecting to oracle from database IDEs and also while retrieving record via EJB. i have found much on the net and tried with jconn2.jar and ojdbc14.jar in the classpath too. please tell me what should i do to resolve.

    regards,
    manish

    DB:3.16:Ora 00600 Error.. 8d

    And when you looked it up what part of the fact that it is an internal error to oracle did you not understand?

    Internal error means something happened that oracle did not intend to happen and is usually some sort of oracle programming error. And there is nothing you can do to fix it.

    Your course of action is to localize it, then report it to oracle.

    And given that you have localized it you can then try alternatives to processing (order identifiers different, name identifiers different. Split one statement into two, etc.)

    Once you find that you use it. Unless you have a support contract with Oracle that requires them to find it and fix it. Then it is there problem.

  • RELEVANCY SCORE 3.16

    DB:3.16:Is The Use Of The Wrong Ojdbc14.Jar Version The Solution? sk


    Hi All,

    I'm getting weird results using the function "ResultSetMetaData.getColumnName" with different versions of the ojdbc14.jar driver in the 10.2.0.3 database. From my java program (JDK 1.4) I always execute the same query (really complex and big) using the same parameter and with one driver I get rubbish in the result and with another it works fine as I tried to sum up bellow:

    - ojdbc14.jar (1,545,954 bytes for the DB 10g Release 2 (10.2.0.3) ): Returns rubbish in the first two column names. I should use this driver since it is designed for my DB version !!!

    - ojdbc14.jar (1,378,346 bytes from the DB 10g 10.1.0.5): Works properly returning the right column name however is not designed for my database version.

    Does anyone experience the same kind of problem between driver versions of ojdbc14.jar? Can I use without lost or break other features or functions the ojdbc14.jar that is not designed for my db?

    Thanks in advance.

    Regards,
    Leandro

    DB:3.16:Is The Use Of The Wrong Ojdbc14.Jar Version The Solution? sk

    Leandro

    Even still not understanding exactly the differences between these two driver versionsNew drivers usually introduce new features (incl. performance enhancements), bug fixes and support for new versions.

    But at the same time they might introduce new bugs (as you are experiencing) and eventually drop support for older DB/JDK versions (as you notice with the 11g driver).

    So, if you are not specifically interested in one of the new stuff introduced with 10.2, you can use the 10.1 driver.

    HTH
    Chris

  • RELEVANCY SCORE 3.16

    DB:3.16:"Apparently Wrong Driver Class Specified For Url: Class: Ora xd



    Hello,I'm deploying a Seam application with Eclipse at JBoss Server 4.2.3. My database is Oracle 10g XE. I've added to the project classpath the ojdbc14.jar I've found at its installation.This is my datasource configuration:

    datasources
    local-tx-datasource
    jndi-namereincideDatasource/jndi-name
    connection-urljdbc:oracle:thin:@localhost:1521:XE/connection-url
    driver-classoracle.jdbc.driver.OracleDriver/driver-class
    user-name***/user-name
    password***/password
    /local-tx-datasource
    /datasources

  • RELEVANCY SCORE 3.16

    DB:3.16:Error Connection From Java Application. sj


    Hello.
    I have a problem:
    i want connection to Oracle Database XE from Java Application.
    Using JDBC Driver from a ORACLE_HOME/jdbc/lib/ojdbc14.jar directory.
    I add path to environment variables CLASSPATH:
    ORACLE_HOME/jdbc/lib/ojdbc14.jar
    ORACLE_HOME/jlib/orai18n.jar
    and to PATH: ORACLE_HOME\bin
    I use J2SE 1.5.
    Here my code:
    OracleDataSource ods = new OracleDataSource();
    ods.setURL("jdbc:oracle:thin:hr/hr@//localhost:1521/XE");
    Connection conn = ods.getConnection(); //error
    Error:
    Exception in thread "main" java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
    ORA-12705: Cannot access NLS data files or invalid environment specified

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
    at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
    at oracle.jdbc.driver.PhysicalConnection.init(PhysicalConnection.java:414)
    at oracle.jdbc.driver.T4CConnection.init(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
    at test.Test.main(Test.java:40)
    Please, help me!

    DB:3.16:Error Connection From Java Application. sj

    user517796,
    Pardon me if I am stating the obvious, but did you download the "Western European" edition, or the "Universal" edition? I believe that if you want to use the Russian locale, you need the "Universal" edition.

    Also, have you tried asking your question on the XE Forum?

    Good Luck,
    Avi.

  • RELEVANCY SCORE 3.16

    DB:3.16:Dots Getting Replaced By /. cj


    Hey Java Gurus,

    I am running this batch script which has the name start_icalc_server.bat and I am having a strange problem. I am trying to add some to add some libraries to the classpath and then run my code.

    This is the script that I am using

    echo starting MRSI PL Calculator ....

    set LIB_DIR=C:\java\lib
    set APP_DIR=C:\MRSI\workspace\MRSI_PROJECT
    set CONF_DIR=C:\MRSI\workspace\MRSI_PROJECT\conf

    C:\bea\jdk142_11\bin\java -Xms512m -Xmx512m -classpath %LIB_DIR%\MRSI-PLCalculator.jar; %APP_DIR%\classes;%LIB_DIR%\log4j-1.2.8.jar;%LIB_DIR%\commons-lang-2.3.jar;%LIB_DIR%\commons-dbutils-1.1.jar;%LIB_DIR%\commons-dbcp-1.2.1.jar;%LIB_DIR%\commons-pool-1.3.jar;%LIB_DIR%\commons-logging-api.jar;%LIB_DIR%\backport-util-concurrent.jar;%LIB_DIR%\spring.jar;%LIB_DIR%\ojdbc14.jar -Dlog4j.configuration=%CONF_DIR%\MRSI_log4j_pc.xml -Dmrsi.applicationContextPath=%CONF_DIR%\spring_calc.xml -Dmrsi.applicationContextNamespace=pc com.citigroup.riskciti.mrsi.icalc.DefaultCalculationService %*Now when I run this script from the command line this is the output that I get

    C:\MRSI\workspace\MRSI_PROJECT\scriptsstart_icalc_server.bat

    C:\MRSI\workspace\MRSI_PROJECT\scriptsecho starting MRSI PL Calculator ....
    starting MRSI PL Calculator ....

    C:\MRSI\workspace\MRSI_PROJECT\scriptsset LIB_DIR=C:\java\lib

    C:\MRSI\workspace\MRSI_PROJECT\scriptsset APP_DIR=C:\MRSI\workspace\MRSI_PROJECT

    C:\MRSI\workspace\MRSI_PROJECT\scriptsset CONF_DIR=C:\MRSI\workspace\MRSI_PROJECT\conf

    C:\MRSI\workspace\MRSI_PROJECT\scriptsC:\bea\jdk142_11\bin\java -Xms512m -Xmx51
    2m -classpath C:\java\lib\MRSI-PLCalculator.jar; C:\MRSI\workspace\MRSI_PROJECT\
    classes;C:\java\lib\log4j-1.2.8.jar;C:\java\lib\commons-lang-2.3.jar;C:\java\lib
    \{color:#ff0000}commons-dbutils-1.1.jar{color};C:\java\lib\commons-dbcp-1.2.1.jar;C:\java\lib\commons-
    pool-1.3.jar;C:\java\lib\commons-logging-api.jar;C:\java\lib\backport-util-concu
    rrent.jar;C:\java\lib\spring.jar;C:\java\lib\ojdbc14.jar -Dlog4j.configuration=C
    :\MRSI\workspace\MRSI_PROJECT\conf\MRSI_log4j_pc.xml -Dmrsi.applicationContextPa
    th=C:\MRSI\workspace\MRSI_PROJECT\conf\spring_calc.xml -Dmrsi.applicationContext
    Namespace=pc com.citigroup.riskciti.mrsi.icalc.DefaultCalculationService
    {color:#800080}
    Exception in thread "main" java.lang.NoClassDefFoundError: C:\MRSI\workspace\MRS
    I_PROJECT\classes;C:\java\lib\log4j-1/2/8/jar;C:\java\lib\commons-lang-2/3/jar;C
    :\java\lib\{color:#ff0000}commons-dbutils-1/1/jar{color};C:\java\lib\commons-dbcp-1/2/1/jar;C:\java\li
    b\commons-pool-1/3/jar;C:\java\lib\commons-logging-api/jar;C:\java\lib\backport-
    util-concurrent/jar;C:\java\lib\spring/jar;C:\java\lib\ojdbc14/jar{color}The problem is coming due to the .getting replaces by "/" for example {color:#ff0000}commons-dbutils-1.1.jar{color} becomes {color:#ff0000}commons-dbutils-1/1/jar

    {color:#000000}Please help me to remove this problem

    Thanks

    {color}{color}

    DB:3.16:Dots Getting Replaced By /. cj

    cool_dude1984 wrote:
    Thanks a lot..It Works :)Good to hear that, and you're welcome.

  • RELEVANCY SCORE 3.16

    DB:3.16:Websphere Jndi Access Problem From Outside Client k9


    Hi all
    I am new to sphere.I prepared a datasource with jndi name jdbc/oracle.I want to access that data source from outside client.
    here is the code
    import java.sql.*;
    import javax.sql.*;
    import java.io.*;
    import javax.naming.*;
    import java.util.*;
    public class Second{
    public static void main(String args[]){
    try{
    Hashtable h=new Hashtable();
    h.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
    h.put(Context.PROVIDER_URL,"iiop://localhost:2809/");
    Context ic=new InitialContext(h);
    DataSource ds=(DataSource)ic.lookup("jdbc/oracle");
    }catch(Exception e){
    System.out.println(e);
    }
    }
    }

    I set the class path as
    set classpath=classpath;ojdbc14.jar;naming.jar;ras.jar;wsexception.jar;bootstrap.jar;hlcbe101.jar;hl14.jar;ecore.jar;hlcore.jar;common.jar.

    still I am getting an exception Class Not Found and asking to include another jar file

    Here is the exception code.

    com.ibm.ws.naming.util.CommonHelpers
    WARNING: jndiproviderProperties
    com.ibm.ws.naming.util.CommonHelpers
    WARNING: jndiproviderProperties
    com.ibm.websphere.naming.WsnInitialContextFactory
    WARNING: noInitCtxFactoryImpl.
    javax.naming.ConfigurationException: The property com.ibm.ws.naming.wsn.factory.initial is not set.The most likely cause is that the jar which contains the file com/ibm/websphere/naming/jndiprovider.properties cannot be found by the class loader.

    Please help me.

    Thank you,
    Nayik

    Message was edited by:
    nayik

    DB:3.16:Websphere Jndi Access Problem From Outside Client k9

    Hi all
    I am new to sphere.I prepared a datasource with jndi name jdbc/oracle.I want to access that data source from outside client.
    here is the code
    import java.sql.*;
    import javax.sql.*;
    import java.io.*;
    import javax.naming.*;
    import java.util.*;
    public class Second{
    public static void main(String args[]){
    try{
    Hashtable h=new Hashtable();
    h.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
    h.put(Context.PROVIDER_URL,"iiop://localhost:2809/");
    Context ic=new InitialContext(h);
    DataSource ds=(DataSource)ic.lookup("jdbc/oracle");
    }catch(Exception e){
    System.out.println(e);
    }
    }
    }

    I set the class path as
    set classpath=classpath;ojdbc14.jar;naming.jar;ras.jar;wsexception.jar;bootstrap.jar;hlcbe101.jar;hl14.jar;ecore.jar;hlcore.jar;common.jar.

    still I am getting an exception Class Not Found and asking to include another jar file

    Here is the exception code.

    com.ibm.ws.naming.util.CommonHelpers
    WARNING: jndiproviderProperties
    com.ibm.ws.naming.util.CommonHelpers
    WARNING: jndiproviderProperties
    com.ibm.websphere.naming.WsnInitialContextFactory
    WARNING: noInitCtxFactoryImpl.
    javax.naming.ConfigurationException: The property com.ibm.ws.naming.wsn.factory.initial is not set.The most likely cause is that the jar which contains the file com/ibm/websphere/naming/jndiprovider.properties cannot be found by the class loader.

    Please help me.

    Thank you,
    Nayik

    Message was edited by:
    nayik

  • RELEVANCY SCORE 3.16

    DB:3.16:Re: Weird Behavior With Ojdbc14.Jar zk


    What are the data types of the 5 columns that you're binding? Are they really VARCHAR2 columns?

    Justin

    DB:3.16:Re: Weird Behavior With Ojdbc14.Jar zk

    I have a prepared statement that executes very fast or very slow depending on the version of ojdbc14.jar that I use. I'm using Oracle 10.2.0.2 running on some sort of a Unix machine. The prepared statement contains 5 placeholders and I'm treating them all as strings -- preparedStatement.setString(n,value). The query is a count(*) and the table is a materialized view. Manifest file info: With this version of ojdbc14.jar the query returns in ~2 seconds Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0" Implementation-Time: "Mon Jul 28 16:25:43 2003" With this version of ojdbc14.jar the query returns in ~90 seconds Specification-Version: Oracle JDBC Driver version - "10.2.0.2.0" Implementation-Time: Tue Jan 24 08:55:21 2006 Additionally, when said query is run from Toad it takes ~12 seconds. Weird! Any ideas? ------- Update ------- More info: We're using straiht up jdbc (no orm), we're using Websphere and these times are taken from the app running on my Windows XP machine. Timing is very similar when app is deployed to Unix machine. using classes12.zip works well too! (~ 2 secs) Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0" ----------------------- Implementation-Time: "Mon Jul 28 16:21:15 2003" Message was edited by: David - added more info user618411 Message was edited by: Added more info user618411

  • RELEVANCY SCORE 3.15

    DB:3.15:Re: Help With Jdbc pj


    The ojdbc14.jar would be in the jdbc directory.

    DB:3.15:Re: Help With Jdbc pj

    Hello. I dont speak very good english but i will try to explain my problem. I have java and oracle 10g Express Edition and i want to connect them. What i have to download to connect java with my database??Somebody could show me some example of that??Thank you

  • RELEVANCY SCORE 3.15

    DB:3.15:How To Create Deployment Profile For Executable Jar File ? s7


    Hi

    I need to create executable JAR file. My program works in JDeveloper 11G but doesn't after deploy it to jar file. After invoking from cmd:

    java -jar ExecutableJarTest.jar

    I got following exeption:

    java.io.FileNotFoundException: file:\E:\Testy-11g\ExecutableJarTest\ExecutableJarTest\deploy\ExecutableJarTest.jar!\kuba
    \demo\connection.properties (Nazwa pliku, nazwa katalogu lub sk-adnia etykiety woluminu jest niepoprawna)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.lt;initgt;(Unknown Source)
    at java.io.FileInputStream.lt;initgt;(Unknown Source)
    at kuba.demo.DBUtil.lt;initgt;(DBUtil.java:28)
    at kuba.demo.ExecutableTestCase.main(ExecutableTestCase.java:15)
    Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
    at kuba.demo.DBUtil.getDataSource(DBUtil.java:37)
    at kuba.demo.ExecutableTestCase.main(ExecutableTestCase.java:16)
    Caused by: java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    ... 2 more

    There are two problems with classpath I think:

    1) Program can not find connection.properties file
    2) Program can not find Oracle Driver ( ojdbc14.jar ) that is embeded inside my executable JAR.

    I think that it requires proper deployment profile. I created simple [test case to download|http://www.zilp.pl/z/test01/Members/jakubp/Folder.2007-06-22.2113643678/File.2009-02-04.6985128679/download] (change extension to .zip) that reproduces problem.

    Kuba

    DB:3.15:How To Create Deployment Profile For Executable Jar File ? s7

    Hi,

    I load properties file using following code:

    public DBUtil(){

    props = new Properties();

    URL url = getClass().getResource("connection.properties");

    String filePath = url.getPath();

    try {

    props.load(new FileInputStream(filePath));

    } catch (IOException e) { e.printStackTrace(); }

    }I think there are required some additional params in MANIFEST.MF file but I comlely don't know whats should it be.

    Kuba

  • RELEVANCY SCORE 3.15

    DB:3.15:Fatal Error With Ojdbc14.Jar And Sun 1.5.06 Jvm k9


    Hi,

    Using "Oracle JDBC Driver version - 10.1.0.5.0" (ojdbc14.jar)
    with Java HotSpot(TM) Server VM (1.5.0_06-b05 mixed mode)
    on Linux, we experienced a systematic fatal crash of our server,
    due to this combination.

    ________________________________________________________
    An unexpected error has been detected by HotSpot Virtual Machine
    [...]
    Current CompileTask:
    opto:1878 oracle.sql.NUMBER.toBytes(Ljava/lang/String;I)[B (1034 bytes)
    ________________________________________________________

    Searching the web, we have found that this is a recurring problem
    since Sun Java 1.4

    We would at least expect Oracle to mention this problem in
    the release notes, and (better) make its so-widely used driver
    work with Sun JVM.
    Really disappointing...

    DB:3.15:Fatal Error With Ojdbc14.Jar And Sun 1.5.06 Jvm k9

    Eric,

    Since the issue it's actually found in Sun bug database, you could expect it to be solved in a later release of the JDK - say update 11, for instance.

    I had a problem with BigDecimals and JDBC when I used same version:1.5.0_06-b05 and It got solved in the update 7 version.

    luck,

    RB

  • RELEVANCY SCORE 3.12

    DB:3.12:Re: Oracle Rdb Driver For Java xs


    You have to download the JDBC JAR from Oracle. Google for "Oracle JDBC download". You might have to register, but it's free. The latest is ojdbc14.jar.

    Take that JAR and put it in your project CLASSPATH.

    If you don't know about JDBC, Google for the JDBC tutorial.

    %

    DB:3.12:Re: Oracle Rdb Driver For Java xs

    wow thanks!
    this is exactly what i've been looking for.
    thank you so much :-)

  • RELEVANCY SCORE 3.11

    DB:3.11:Unable To Run Jar File With The Libraries It Needs To Work With 9s


    Hi there,

    I'm working with
    - Windows XP
    - NetBeans 5.0
    - J2dk 1.4.2_13.

    I'm able to run this application from NetBeans, in my PC (testing environment) showing its nice swing window.

    However, I need to deploy it to the production environment where netbeans cannot be installed. So I'm preparing the jars in order to execute it from command prompt. Currently I'm unable to run it, in my PC's command prompt:

    I put the files in folder C:\Temp.

    The files in this folder are:
    - EdiferJcoWindow.jar (jar with the main class)
    - ojdbc14.jar (jdbc libs for connection to oracle)
    - swing-layout-1.0.jar (swing libs)
    - sapjco.jar (SAP libs)

    I'm trying to execute like this:

    C:\TempC:\j2sdk1.4.2_13\bin\java -classpath ojdbc14.jar;swing-layout-1.0.jar;sapjco.jar -jar EdiferJcoWindow.jar
    Exception in thread "main" java.lang.NoClassDefFoundError: org/jdesktop/layout/GroupLayout$Group

    The manifest inside EdiferJcoWindow.jar has this:
    Manifest-Version: 1.0
    Ant-Version: Apache Ant 1.6.5
    Created-By: 1.4.2_13-b06 (Sun Microsystems Inc.)
    Main-Class: ediferjcowindow.JanelaPrincipal
    Class-Path: lib/swing-layout-1.0.jar lib/sapjco.jar lib/ojdbc14.jar li
    b/sapjco.jar lib/swing-layout-1.0.jar
    X-COMMENT: Main-Class will be added automatically by build

    Also,
    - swing-layout-1.0.jar has a GroupLayout$Group.class with path org\jdesktop\layout\
    - EdiferJcoWindow.jar has a JanelaPrincipal.class with path ediferjcowindow\

    Any help is deeply appreciated.
    MGoncalv

    DB:3.11:Unable To Run Jar File With The Libraries It Needs To Work With 9s

    I found out what was wrong... when executing jars the valid classpath is the one inside the main jar file EdiferJcoWindow.jar.

    So after putting the onther jars in a subfolder lib the application executed sucessfully with java -jar EdiferJcoWindow.jar.

    Caso closed.
    MGoncalves

  • RELEVANCY SCORE 3.11

    DB:3.11:Ojdbc14.Jar And Nls k3


    Hi,
    I was wondering how can I determine the NLS to be used with ojdbc14.jar.
    I saw that if an oracle client is installed it will use the registry key NLS_LANG in order to determine which character set to use, but how can I tell my thin driver (ojdbc14.jar) which character set to use?

    DB:3.11:Ojdbc14.Jar And Nls k3

    Uri,

    It is the language portion of the NLS_LANG that is controlling the default sorting behavior when you run your query on the client. With your current language setting "American" you are getting a binary sort. If you were to set the language to "Hebrew" you would get a Hebrew sort. The linguistic behavior between Oracle and Java is different in many cases. You can use the GDK to Match the sorting behavior you have in Oracle. http://www.oracle.com/technology/tech/globalization/pdf/TWP_AppDev_Global_GDK_Building_Global_Applications_10gR1_1103.pdf

  • RELEVANCY SCORE 3.10

    DB:3.10:Jdbc Problem 1k


    i have installed oracle instant client via a basic installation on a RHEL4
    set my CLASSPATH env to point to ojdbc14.jar, but still i get this exception whenever i try to connect to the database

    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:164)

    i've tried this on windows and it works , the driver is registered with no problems.
    any help is appreciated

    DB:3.10:Jdbc Problem 1k

    Then you haven't set the CLASSPATH properly.

  • RELEVANCY SCORE 3.09

    DB:3.09:Packaging An Application That Uses Oracle Drivers 8a


    I need to package an application into an executable file, or at least an executable jar file. I am using JBuilder for development. Of course everything works correctly with finding drivers and connecting to the database using JBuilder. I used JBuilder's Archive Wizard to create a jar, then turn it into an executable jar. It also makes executables (ie. .exe files) for me.

    However, I have tried several combinations and it just can't find the drivers. It always throws a ClassNotFoundException. I have tried including the drivers files and as resources when making the jar. I have even tried putting them directly in when using command line:
    set classpath = c:\ojdbc14.jar
    java -classpath c:\ojdbc14.jar -jar myApp.jarand it still says it cannot find the drivers.

    Any advice would be greatly appreciated!

    Thanks!
    Amber

    DB:3.09:Packaging An Application That Uses Oracle Drivers 8a

    Hello Amber;

    I am trying to connect to oracle through java. The java application is build with JBuilder and the oracle driver, i.e. classes12.jar and ojdbc14.jar, are added in the CLASSPATH.

    When I create a class without JBuilder as stand alone class, it works fine. But when I use the same code in the my JBuilder application, it does not load the driver, gives ClassNotFound exception.

    Please specify, is there a special way to access databse from jbuilder. Do I have to include drivers in Jbuilder, if yes, then how? or it is due to some other problem

    Your help will be greatly appreciated.

    Regards
    Ali Hammad

  • RELEVANCY SCORE 3.09

    DB:3.09:No Suitable Driver Found For Jdbc:Oracle:Oci:@ ma


    Hello, I am able to compile my java program and run it. If I create an executable jar
    and try to run it I get an error - No suitable driver found for jdbc:oracle:oci:@.

    The classpath = .;C:\oracle\ora92\jdbc\lib\ojdbc14.jar;;C:\oracle\ora92\jdbc\lib\ojdbc14.jar;C:\Program Files\Java\jdk1.6.0\bin;C:\Program Files\Java\jre1.6.0_01\bin

    I load the driver using this code.
    //load the oracle JDBC Driver.
    Class.forName("oracle.jdbc.driver.OracleDriver");

    And try to get a connection using this code
    conn = DriverManager.getConnection("jdbc:oracle:oci:@", userIdTextField.getText(), PasswordField.getText() );

    I have tried classes11 and classes12 jar files but same error.
    I get the same error if I set the classpath at run time with -classpath.

    Any ideas or suggestions would be a great help. I have been trying to solve this for 2 days.

    Thanks
    Sami

    DB:3.09:No Suitable Driver Found For Jdbc:Oracle:Oci:@ ma

    Sami,
    Your CLASSPATH is wrong and your database connection URL is wrong and class "oracle.jdbc.driver.OracleDriver" has been deprecated.

    Please refer to The Java Tutorials for details on how to define CLASSPATH and whether you require it at all, anyway.

    Please refer to the following Web page for more details regarding deprecation of class "oracle.jdbc.driver.OracleDriver" as well as sample code and Oracle JDBC documentation:

    http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html

    Good Luck,
    Avi.

  • RELEVANCY SCORE 3.09

    DB:3.09:Updateattestation Problem While Upgrading To Oim 9.1.0.2 aj


    I'm going through the instructions for upgrading OIM 9.1.0.1 to 9.1.0.2 on RH Linux 4 update 5.

    I get to the part where I need to run UpdateAttestation.sh.

    I use the following command in XLHOME\setup
    ./UpgradeAttestation.sh "/u01/oracle/product/9.1.0/OIMServer/xellerate/ext/ojdbc14.jar" "jdbc:oracle:thin:@172.20.16.139:1521:oim" oim_manager password

    The script looks like this:

    #!/bin/sh
    XLHOME=@loc
    JAVA_HOME=@java_home
    JAVA_OPTIONS="-DXL.HomeDir=$XLHOME \
    -Djava.security.auth.login.config=$XLHOME/config/authwl.conf \
    -Dlog4j.configuration=$XLHOME/config/log.properties \
    -Djava.awt.headless=true"
    CLASSPATH="$XLHOME/lib/xlAttestation.jar:$XLHOME/lib/xlVO.jar:$XLHOME/lib/xlAPI.jar:$XLHOME/ext/jdbcpool-0.99.$
    if [ -z "$4" ]
    then
    echo "USAGE : UpgradeAttestation.sh driver DBURL OIM DB USERNAME OIM DB PASSWORD"
    exit -1
    else
    $JAVA_HOME/bin/java -classpath "$CLASSPATH" com.thortech.xl.attestation.AttestationUpgrade $1 $2 $3 $fi

    On running this I get:
    ./UA2.sh: line 15: @java_home/bin/java: No such file or directory

    My $JAVA_HOME is set correctly ...

    So I updated the script to hardwire for my java_home and to hardwire the XLHOME directory, so it now looks like this:
    #!/bin/sh
    XLHOME=/u01/oracle/product/9.1.0/OIMServer/xellerate/
    #JAVA_HOME=@java_home
    JAVA_OPTIONS="-DXL.HomeDir=$XLHOME \
    -Djava.security.auth.login.config=$XLHOME/config/authwl.conf \
    -Dlog4j.configuration=$XLHOME/config/log.properties \
    -Djava.awt.headless=true"
    CLASSPATH="$XLHOME/lib/xlAttestation.jar:$XLHOME/lib/xlVO.jar:$XLHOME/lib/xlAPI.jar:$XLHOME/ext/jdbcpool-0.99.$
    if [ -z "$4" ]
    then
    echo "USAGE : UpgradeAttestation.sh driver DBURL OIM DB USERNAME OIM DB PASSWORD"
    exit -1
    else
    $JAVA_HOME/bin/java -classpath "$CLASSPATH" com.thortech.xl.attestation.AttestationUpgrade $1 $2 $3 $fi

    Now, I get this:
    java.lang.ClassNotFoundException: /u01/oracle/product/9.1.0/OIMServer/xellerate/ext/ojdbc14.jar
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:141)
    at com.thortech.xl.attestation.AttestationUpgrade.main(Unknown Source)

    When I look in:
    /u01/oracle/product/9.1.0/OIMServer/xellerate/ext/
    I see ojdbc14.jar OK.

    All the directories in the class path check out and have the .jar files as specified.

    What is going wrong?

    Any help gratefully received,
    Hugh

    Edited by: user5607497 on 22-Sep-2010 05:23

    DB:3.09:Updateattestation Problem While Upgrading To Oim 9.1.0.2 aj

    "Skip the script if upgrading from 9.1.0.1, it's not required" say Oracle. It is if you are upgrading from 9.1.0.

  • RELEVANCY SCORE 3.09

    DB:3.09:Jdbc Driver j3


    n am installed Oracle 10g 10.1.0.2

    now im having a look at the jdbc drivers. This is the list avaialable at oracle

    Oracle Database 10g 10.1.0.2 JDBC Drivers
    JavaDoc (6,022,949 bytes)
    README

    JDBC Thin for All Platforms
    classes12.jar (1,417,089 bytes) - for use with JDK 1.2 and JDK 1.3

    classes12_g.jar (1,794,418 bytes) - same as classes12.jar, except that classes were compiled with "javac -g" and contain some tracing information.

    classes12dms.jar (1,424,743 bytes) - same as classes12.jar, except that it contains additional code`to support Oracle Dynamic Monitoring Service.

    classes12dms_g.jar (1,802,368 bytes) - same as classes12dms.jar except that classes were compiled with "javac -g" and contain some tracing information.

    ojdbc14.jar (1,352,918 bytes) - classes for use with JDK 1.4

    ojdbc14_g.jar (1,691,855 bytes) - same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information.

    ocrs12.jar (54,030 bytes) - classes that implement the javax.sql.rowset interfaces, like CachedRowSet and WebRowSet. To be used with JDK 1.2, 1.3, and 1.4.

    orai18n.jar (5,018,093 bytes) - NLS classes for use with JDK 1.2, 1.3 and 1.4. This jar file replaces the old nls_charset jar/zip files.

    demo.tar (532,480 bytes) - contains sample JDBC programs.

    i am using jdk 1.5 . which version should i download?

    and also after downloading i just have to include the driver jar to my classpath right?

    there is a folder where in have downloaded the installer for oracle 10g called
    Access Bridge which also has a installer. what is that?

    DB:3.09:Jdbc Driver j3

    Hi,
    1. the classes12.jar will work fine.
    however going forward Oracle will be using driver
    naming convention as in ojdbc14.jar.

    2. So I would suggest go for ojdbc14.jar. You are
    using jdk1.5, and that will not be a problem.
    3. If you are trying to access an oracle database
    from your java application, just add the ojdbc14.jar
    to classpath (full jar name, not just the directory
    it is in), you can leave the installer it will not be
    needed.

    Hope this helps.
    Regards
    Ayusman

    nullthank you. ( the dukes )

    what about this

    there is a folder in the oracle 10g i have downloaded called Access Bridge which also has a installer. What is this access bridge?

  • RELEVANCY SCORE 3.09

    DB:3.09:How To Find All Jdbc Drivers Contained In All Jars From A Given Path 89


    I want to find all JDBC drivers contained in all jars from a given path or from classpath.
    For example in path :

    "D:\app\jdbc\" I have :
    ojdbc14.jar
    postgresql-8.1dev-403.jdbc3.jar

    In
    ojdbc14.jar is "oracle.jdbc.driver.OracleDriver"
    and in
    postgresql-8.1dev-403.jdbc3.jar is "org.postgresql.Driver"

    How can I build an array wich contain "oracle.jdbc.driver.OracleDriver" and "org.postgresql.Driver" ?

    Any ideea ?
    Thanks!

    DB:3.09:How To Find All Jdbc Drivers Contained In All Jars From A Given Path 89

    I am a beginer in Java, so:

    how can I read names of all files from a path ?

  • RELEVANCY SCORE 3.09

    DB:3.09:Problem Importing Oracle.Jdbc.Pool.Oracledatasource And Sealing Violation 8s


    Hi there;
    It's been two days that i have been trying to fix this issue due , probably to its complexity.
    I have written a web application that i managed to deploy and run using Sun Application Server 8.That was a week or so. Now i had to modify some details in my database, since i use an Oracle Db that i access through my web app.
    The first time everything went fine. Now the problem is that i keep receiving the "sealing violation error" when i add ojdbc14. in my project library. But when i remove it, my app shows "can't import oracle.jdbc.pool.OracleDataSource".
    Since i am sure that i may be wrong but something is not right here as well, i tried to write a simple program to connect to my Oracle db, without putting ojdbc14.jar in the project library and ignoring the "oracle.jdbc.pool.OracleDataSource" error that shows in the Ide. With this the project runs and the table is loaded. Surprisingly!
    After some tries, and after getting back to the ide, i cant run the same program again. I made no change.
    My classpath is fine with myoracle\...\ojdbc14.jar as well as my path.
    I am using Oracle 10gR2. Could someone tell me what is wrong here? I have read some threads already about "sealing violation". How can I fix this runtime error? How can I import "oracle.jdbc.pool.OracleDataSource" without putting ojdbc14.jar in the project library?

    DB:3.09:Problem Importing Oracle.Jdbc.Pool.Oracledatasource And Sealing Violation 8s

    Thank you for your help. Bur finaly, i've managed to figure out what is wrong with the ojdbc14 driver and sun creator environnement. Here is trick:
    In order to overcome the "Sealing Violation Error":
    First:I put the jar file ojdbc14 in the sun application server lib folder and in my project directory lib folder.
    Second: I add the ojdbc14.jar in my project library
    next: I build and run the project.
    I now received the "Sealing Error message".
    next: I stop the sun application server;
    next: I remove the ojdbc14.jar from the \build\web\WEB-INF\lib folder of my project folder;
    next: I remove the ojdbc14.jar from my project library
    next: Here i will receive the compile error about the "oracledatasource thing".
    next: just ignore this "OracleDatasource" error
    next: I start the sun server and run the project.
    Next: Here we go! Everything work!
    I hope this trick will help many developper.

  • RELEVANCY SCORE 3.09

    DB:3.09:Problems In Connection To Database 9m


    Hi,

    I want connect a database Oracle 9 with Portal Server 6.

    I have configurated the pool like:

    name: csPool
    datasource classname: oracle.jdbc.pool.OracleConnectionPoolDataSource
    user: editor
    password: editor
    url: jdbc:oracle:thin@//mymachine:1521:csedic

    And the data source like:
    jdbc/csDataSource

    In classpath of JVM I have added: the ojdbc14.jar for the drivers.

    But in the log when I install the portlets I obtain:
    The extended error returned =
    csDataSource Datasource not found!

    Where is the problem?

    Thanks.

    DB:3.09:Problems In Connection To Database 9m

    You probably need to add the data source to your web.xml file.
    resource-ref
    descriptionDB Connection/description
    res-ref-namejdbc/csDataSource/res-ref-name
    res-typejavax.sql.DataSource/res-type
    res-authContainer/res-auth
    /resource-ref- Jim

  • RELEVANCY SCORE 3.09

    DB:3.09:Migrating Owner Libs From 4.2 To As7, How? sk



    Hi there friends

    I've configurated my own lib directories on JBossAS-4.2.0, just to avoid confusions.

    Thus, I set into jboss-service.xml:

    !-- Load all jars from the JBOSS_DIST/server/config/lib directory. This

    can be restricted to specific jars by specifying them in the archives

    attribute.

    --

    classpath codebase="${jboss.server.lib.url:lib}" archives="*"/

    classpath codebase="${jboss.server.libmylibs.url:libmylibs}" archives="*"/

    so into "myserver/myserver/libmylibs" there are some files:

    PersonProfitWsClient-2.1.0.jar CommonsBeanUtils-1.6.0.jar

    CommonsDigester-1.8.0.jar CommonsDiscovery-0.2.jar

    CommonsFileUpload-1.1.1.jar CommonsIo-1.1.jar

    CommonsLang-2.1.0.jar CommonsNet-1.4.1.jar

    CommonsValidator-1.1.3.jar ComunsMine-3.0.2.jar

    Json-0.4.1.jar Logon-2.0.3.jar

    MQetClient-6.0.2.jar Ojdbc14-10.2.0.4.jar

    PersistenceApi-1.0.0.jar Provider-1.0.0.jar

    MyBean-1.2.0.jar Axis-1.3.0.jar

    and so on ...

    But in AS7 standalone, how should I leave available these libraries to applications?

    Would be by creating my directory structure bellow modules, such as:

    "jboss7/modules/my/own/libs" and to specify a module.xml ?

    module xmlns="urn:jboss:module:1.0" name="my.own.libs"

    resources

    !-- Insert resources here --

    resource-root path="repeatingToEachOneBellow.jar"/

    PersonProfitWsClient-2.1.0.jar CommonsBeanUtils-1.6.0.jar

    CommonsDigester-1.8.0.jar CommonsDiscovery-0.2.jar

    CommonsFileUpload-1.1.1.jar CommonsIo-1.1.jar

    CommonsLang-2.1.0.jar CommonsNet-1.4.1.jar

    CommonsValidator-1.1.3.jar ComunsMine-3.0.2.jar

    Json-0.4.1.jar Logon-2.0.3.jar

    MQetClient-6.0.2.jar Ojdbc14-10.2.0.4.jar

    PersistenceApi-1.0.0.jar Provider-1.0.0.jar

    MyBean-1.2.0.jar Axis-1.3.0.jar

    /resources

    dependencies

    module name="?? ?? ??"/

    /dependencies

    /module

    Thank you in advance

    Douglas Matheus

    DB:3.09:Migrating Owner Libs From 4.2 To As7, How? sk


    The way you describe above is the correct way to do it, in terms of what needs to go in the dependencies section it will depend on which app server classes these libraries expect to see. At the very least they will need a dep on javax.api.

    The easiest way to figure this out is probably to just create to module and watch for NoClassDefFoundErrors .

  • RELEVANCY SCORE 3.09

    DB:3.09:Problems Setting Classpath 7a


    Hi Experts,

    I have problems trying to run a simple java program on linux redhat. I am using JDK6 update14.
    The problem is just connecting to Oracle DB using JDBC thin driver and retrieve the data from a table.

    Here is the problem:

    $ls -lh /home/juser/jdbc/
    -rwxrwxrwx 1 juser juser 1.5M Jul 29 17:00 ojdbc14.jar

    $export CLASSPATH=/home/juser/jdbc/ojdbc14.jar

    $pwd
    /home/juser/programs/OracleConnect

    $javac OracleConnect1.java
    javac runs fine, and .class file is generated. If CLASSPATH is not set correctly, I will get:OracleConnect1.java:2: package oracle.jdbc does not exist
    import oracle.jdbc.*;
    ^
    OracleConnect1.java:11: package oracle.jdbc.driver does not exist
    DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());
    ^
    2 errors

    -- Now, I will run the program:

    $ java OracleConnect1
    Exception in thread "main" java.lang.NoClassDefFoundError: OracleConnect1
    Caused by: java.lang.ClassNotFoundException: OracleConnect1
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    Could not find the main class: OracleConnect1. Program will exit.

    -- Strange thing that its not complaining about anything for the JDBC classes, but for the class name itself, which is not correct.

    -- But, it still seems to be a CLASSPATH problem. Check this example:

    $pwd
    /home/juser/programs/HelloWorld

    $cat HelloWorld.java

    public class HelloWorld{
    // Hello World program
    public static void main (String[] args){
    System.out.println("Hello Sweet World");
    }
    }

    $echo $CLASSPATH
    /home/juser/jdbc/ojdbc14.jar

    $javac HelloWorld.java
    Compile successfull and .class file created.$ java HelloWorld
    Exception in thread "main" java.lang.NoClassDefFoundError: HelloWorld
    Caused by: java.lang.ClassNotFoundException: HelloWorld
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    Could not find the main class: HelloWorld. Program will exit.

    *** I have no idea, what the problem is. May be its a stupid thing I am doing, but I realy dont know. ***

    N.B, there is no problem with the JAR file, I took it and used on windows, and everything compiled and ran successfully. Also, I have downloaded and set another jdbc jar file and still the same problem.Edited by: JavaMoh on Jul 30, 2009 5:41 AM

    Edited by: JavaMoh on Jul 30, 2009 5:42 AM

    DB:3.09:Problems Setting Classpath 7a

    The class path has to include the base directory containing your own class files, as well as required libraries.

  • RELEVANCY SCORE 3.08

    DB:3.08:Problems With Ojdbc14.Jar(10.2.0.3.0) In Websphere5.1 Appserver 8d


    we are using ojdbc14.jar(10.2.0.3.0) for Oracle 10g driver. we have some problem with the driver.

    when i am exceuting large procedures/functions it is throwing Non-Application Error -5678678 ArrayIndexOutBoudsException (or) Null pointer Exception in WAS(WebSphere5.1).

    this problem not occured when i am using ojdbc14.jar(9.0.2.0.0) in Oracle 10g database.

    if anyone knows the problem please advise me.

    DB:3.08:Problems With Ojdbc14.Jar(10.2.0.3.0) In Websphere5.1 Appserver 8d

    we are using ojdbc14.jar(10.2.0.3.0) for Oracle 10g driver. we have some problem with the driver.

    when i am exceuting large procedures/functions it is throwing Non-Application Error -5678678 ArrayIndexOutBoudsException (or) Null pointer Exception in WAS(WebSphere5.1).

    this problem not occured when i am using ojdbc14.jar(9.0.2.0.0) in Oracle 10g database.

    if anyone knows the problem please advise me.

  • RELEVANCY SCORE 3.08

    DB:3.08:Re: Problem With Ojdbc14.Jar ps


    You shouldn't be using LONGs anymore (not for quite a while in fact).
    Oracle are leaving them to slowly rot away...should be using LOBs of some description.

    DB:3.08:Re: Problem With Ojdbc14.Jar ps

    Hi, We have a J2ee application installed on JBoss4.0.4 and Oracle10g as the database. We have used ojdbc14.jar as my database driver. We have used PL/SQL. Our problem is that in one of our standalone procedures, we receive a string of values from database exceeding 4500 characters. It is declared as Long datatype, as an out parameter in the procedure. When i try to execute it from frontend it gives an error saying "Character buffer too small". This string has to be passed to another procedure from frontend as an input parameter (declared as varchar2). When i use the same code with classes12.jar it works perfectly fine. However, I cannot use classes12.jar as I am not allowed to change the driver as this could impact other code. The same problem can be solved using Array or some other datatypes but this will result in changing code at many places. Can you let me know what may be the exact problem? Can you help me with getting rid of the error without changing the driver and the code? Thanks in Advance.

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Set Ojdbc14.Jar On Oracle 10gapplication Server cf


    Hi ,
    I want to use ojdbc14.jar as my JDBC driver, so how i can
    set a classpath up to ojdbc14.jar on Oracle 10g Application Server

    Thanks

    DB:3.08:How To Set Ojdbc14.Jar On Oracle 10gapplication Server cf

    hi yogesh,

    this is the Oracle Portal Content Management Forum. Please post your Application Server specific questin in the following Forum:
    Oracle Application Server - General

    thanks,
    Christian

  • RELEVANCY SCORE 3.08

    DB:3.08:Package Does Not Exist Error 8j


    Hi,

    I am a second year student taking my first Java course and I am getting a "package does not exist" error. I am trying to create a stand alone Java application that needs to connect to an oracle database. I am running oracle 10g on a windows xp machine with Java 5 update 9.

    I have verified that the ojdbc14 driver is installed. I know that this is normally a classpath problem but I am sure that the classpath is set correctly, I have included it here:

    .;C:\Program Files\Java\jre1.5.0_09\lib\ext\QTJava.zip;C:\Program Files\Java\jdk1.5.0_09\bin\javac.exe;C:\Program Files\Java\jdk1.5.0_09\lib\ojdbc14.jar;E:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar

    Drive E is a local hard drive, not a mapped drive.

    The exact error is "package oracle.jdbc does not exist" and is generated from the following code:

    import java.sql.*;
    import javax.sql.*;

    class Dal {
    public static void main (String args []) throws SQLException
    {
    try{
    String dataSource = "jdbc:odbc:kucsec";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    Connection conn = DriverManager.getConnection(dataSource, "system", "password");
    Statement st = conn.createStatement();
    ResultSet rs = st.executeQuery("Select * from cardStatus");

    DriverManager.registerDriver2(new oracle.jdbc.OracleDriver());

    System.out.println ("working"); // Print col 1

    }
    catch(SQLException s){
    System.out.println("didn't work");
    System.out.println(s.toString());

    }
    catch(Exception e){
    System.out.println(e.toString());
    System.out.println(e.getMessage());
    }

    }
    }

    I don't think I missed anything but I hvae been trying to resolve this for three days now and would appreciate any help you can offer.

    Thanks.

    DB:3.08:Package Does Not Exist Error 8j

    Sorry, it was your solution fixed the error. The fix
    from cotton.m didn't work.Actually let me rephrase.

    Mine works fine.

    You just didn't fix the incorrect class name that you gave.