• RELEVANCY SCORE 3.57

    DB:3.57:Soa+Osb 11g In Same Domain (Linux) f8





    I'm trying to create a SOA+OSB 11g domain.
    I start ./config.sh in console mode because i have remote access whit ssh.

    A error occurs when i try to config the JDBC Data Sources.
    I notice that the presented number of options are greater then the real number options himself. I have 11 options but there are 12 real option and when i try to alter one is present a NullPointerException.

    There are some workaround to install a OSB+SOA in console mode?

    **************

    Configure JDBC Data Sources:
    ----------------------------

    Edit the configuration of JDBC data sources. A data source contains a pool of database connections. Applications look up a data source in the JNDI tree, request a connection, use it, and
    return it to the connection pool.
    | Name | Value |
    _|________________________________________________________|_________________________________________________________________________________________________|
    1| *Name: | wlsbjmsrpDataSource |
    2| *JDBC driver params vendor: | Derby |
    3| *JDBC driver params driver: | Derby's Driver (Type 4) Versions:Any |
    | *JDBC driver params class name: | org.apache.derby.jdbc.ClientDriver |
    4| *JDBC driver params dbms name: | N/A |
    5| *JDBC driver params dbms host: | localhost |
    6| *JDBC driver params dbms port: | 1527 |
    | *JDBC driver params jDBC url: | jdbc:derby://localhost:1527/$DbmsName$;create=true;ServerName=localhost;databaseName=$DbmsName$ |
    7| *JDBC driver params user name: | DEV_SOAINFRA |
    8| JDBC driver params user password encrypted: | ******* |
    9| JDBC driver params confirm user password encrypted: | ******* |
    | JDBC driver params known properties: | user=DEV_SOAINFRA;portNumber=1527;databaseName=$DbmsName$;create=true;serverName=4 |
    10| JDBC driver params additional properties: | create=true;portNumber=1527;serverName=localhost |
    11| JDBC data source params jNDI name: | wlsbjmsrpDataSource |
    12| *JDBC data source params global transactions protocol: | LoggingLastResource |

    Use above value or select another option:
    1 - Modify "Name"
    2 - Modify "JDBC driver params vendor"
    3 - Modify "JDBC driver params driver"
    4 - Modify "JDBC driver params dbms host"
    5 - Modify "JDBC driver params dbms port"
    6 - Modify "JDBC driver params user name"
    7 - Modify "JDBC driver params user password encrypted"
    8 - Modify "JDBC driver params confirm user password encrypted"
    9 - Modify "JDBC driver params additional properties"
    10 - Modify "JDBC data source params jNDI name"
    11 - Modify "JDBC data source params global transactions protocol"

    Edited by: user10366953 on 8/Nov/2010 7:16

    DB:3.57:Soa+Osb 11g In Same Domain (Linux) f8

    I took another hack... er, approach. I created the domain using the GUI wizard on the machine in the closer Amazon region, pointing it at the local DB which is identical except for IP. Then I edited the jdbc config's IP address, tar'd up the domain directory and transported it to the other Amazon instance. Thereby bypassing both config wizard bugs.

  • RELEVANCY SCORE 3.34

    DB:3.34:Jdbc Question c1





    is JDBC-ODBC bridge driver different from JDBC driver? If i use the JDBC_ODBC bridge driver, then can i still use the features of JDBC driver?

    Thanks!

    DB:3.34:Jdbc Question c1

    The jdbc odbc bridge allows you to access your odbc connection via java. As a straight jdbc connection will connect right to the database without having to go through odbc which will give you more speed if you can accomplish this without having to use odbc.

    Paul

  • RELEVANCY SCORE 3.24

    DB:3.24:Can Not Start Programm Using Jdbc(Mysql) - Driver Not Found! 3p





    Hello! I don`t khow how to use JDBC(MySQL) Driver! Jdev talk me that Driver not found. How can I add driver?

    DB:3.24:Can Not Start Programm Using Jdbc(Mysql) - Driver Not Found! 3p

    I can help u through oracle but not mySql . i think it is also similar to ur problem.

    if u want to get a jdbc drivet u need to go to the

    oracle\ora92\jdbc\lib\classes111 and classes 12 .zip fles

    the above files are zip files .u have get those files into ur working directory and then unzip them then set ur classpath to these files path. it deffinetly works.

    becouse i got the same situation , i have resolved it.

    ok
    do ur best.

    bye

    sudheer

  • RELEVANCY SCORE 3.24

    DB:3.24:Using 8.1.7 And 9i Jdbc Driver In The Same Java Client jd



    How can I use two different Oracle JDBC drivers in the same Java application? Since the different versions have the same class names, the first driver in the classpath is the one that gets used.

    No - the 9i drivers are NOT backwards compatible.

    The 9i driver returns wrong meta-data when used against a 7.x database. It also tries to use TO_TIMESTAMP() which does not exist in the 8.x STANDARD package

    DB:3.24:Using 8.1.7 And 9i Jdbc Driver In The Same Java Client jd

    Hi MIchael,
    This is just a guess, but you will probably have to use different "Thread"s and different class loaders for each "Thread". Have one "Thread" that deals with your version 7 database, another one for your version 8 database, and so on. Remember also, that (loaded) classes cannot be unloaded -- unless you remove the class loader that loaded them.

    There are many resources available on the Internet regarding threads and class loaders in java. An Internet search should be sufficient.

    Good Luck,
    Avi.

  • RELEVANCY SCORE 3.22

    DB:3.22:Ms Access Database Jdbc Driver c9


    Hi..i have a java webservice that run on sun java system application server on LINUX. This webservice should access an ms access database (*.mdb) file on the same machine. What jdbc driver should i use?
    If you can suggest a freeware jdbc driver, then it would be better.

    thanks in advance.

    DB:3.22:Ms Access Database Jdbc Driver c9

    but using JDBC-ODBC driver is not RecommandedThat does not overrule the fact that it's free. A
    type 4 driver for MS Access is available too.
    http://www.hxtt.com/access.htmlThere are four possible solutions.
    1. Use the above driver - which is not free.
    2. Use a proxy driver, which will require a windows machine (thus not on the same machine.)
    3. Use a different database
    4. Write your own ODBC MS Access driver for linux.

  • RELEVANCY SCORE 3.22

    DB:3.22:Creating A New Driver/Datasource In Visual Administrator 1f



    Hello,

    I have been struggling to create a Data Source for a SQL Server DB in Visual Admin. I did the following.

    1) Created a new Driver MSSQL, added to it msutil.jar, mssqlserver.jar and msbase.jar.

    2) Created a new data source gave it a name, description

    - Selected the MSSQL driver which I just created

    - JDBC Version 1.x

    - Driver class:

    com.microsoft.jdbc.sqlserver.SQLServerDriver.class

    - Database URL:

    jdbc:microsoft:sqlserver://xxx.xxx.xx.xx:1433;databaseName=TestDB

    3)Tried both Open SQL and Vendor SQL as database engines.

    4) Gave the appropriate user id and password

    With the above configuration when I entered a SQL Statement in the 'DB Initialization' tab and executed it, I got a SQL Server Driver Class not found exception.

    My second configuration was to use the JDBC Version 2.0

    with the following settings:

    1) Use the same MSSQL driver which I created

    2) JDBC Version 2.0

    3) Object Factory: com.microsoft.jdbcx.sqlServer.SQLServerDataSourceFactory

    4) DataSource Type: ConnectionPoolDataSource

    5) CPDS classname: com.microsoft.jdbcx.sqlServer.SQLServerDataSource

    6) Gave the required key, values in the 'Additional' Tab

    7) Chose Vendor SQL as the SQL Engine.

    With the second configuration I can connect and talk to the database.

    Why would I not be able to connect to the DB in my first configuration? Are there any other configuration steps I am missing for using the JDBC 1.0?

    Thanks,

    Asheesh

    DB:3.22:Creating A New Driver/Datasource In Visual Administrator 1f


    Hi Asheesh,

    just put com.microsoft.jdbc.sqlserver.SQLServerDriver in the Driver Class instead of com.microsoft.jdbc.sqlserver.SQLServerDriver.class

  • RELEVANCY SCORE 3.19

    DB:3.19:Fastest Oracle Jdbc Driver ff


    All,

    I have an OCI based application inserting LONG data faster than my JDBC application. I am using the oracle oracle.jdbc.driver.OracleDriver driver. Can some one suggest what will be the best JDBC driver for me to use to be close with the OCI driver

    Thanks

    DB:3.19:Fastest Oracle Jdbc Driver ff

    10.2.0.3 is my database and it is XMLDB enabled. Thanks man .. I saw the answer. thin driver !!

    Thanks

    Message was edited by:
    uraees

  • RELEVANCY SCORE 3.14

    DB:3.14:Oracle10gr2 Jdbc Driver With Oracle9ir2 Database cf


    We are currently running Oracle9iR2 (9.2.0.1). We would like to use the support for auto-generated keys that the 10gR2 JDBC driver offers. Can we use the fully JDBC 3.0 compliant 10gR2 driver when accessing our 9iR2 database?

    Also, from where can I download the 10gR2 JDBC driver? It's not available off the 10g JDBC Drivers page.

    Thank you in advance for your help.

    Paul Morusiewicz

    DB:3.14:Oracle10gr2 Jdbc Driver With Oracle9ir2 Database cf

    I believe the support for the "auto-generated-keys" feature is a combination of both JDBC driver and database server. Hence I believe the feature is only supported with an Oracle 10g database -- but I'm only guessing.

    Good Luck,
    Avi.

  • RELEVANCY SCORE 3.14

    DB:3.14:Jb8 And Mysql x9


    how do i configure jbuilder 8 to use the mysql jdbc device driver. thanks

    DB:3.14:Jb8 And Mysql x9

    go to PROJECT --- ProjectProperties---RequiredLibraries (3rd tab at the botton area)---- add---- new (give a name) ----- then add the jar or zip file to this library entry.
    Good luck
    Sekar

  • RELEVANCY SCORE 3.13

    DB:3.13:Jdbc Datasource Creation dz


    Hi Evryone,

    I am trying to deploy my application in remote server, configuration working fine and i tested my application running fine. When i tried for database component page i am getting below error

    Caused By: javax.naming.NameNotFoundException: Unable to resolve 'jdbc.ConnDS'.
    Resolved 'jdbc'; remaining name 'ConnDS'

    I will expain what i done.

    Created datasource in my WLS-datasource with JNDI name jdbc/ConnDS

    And also i changed my model - appmodule configuration with jdbcDataSource for AppMouduleLocal and Shared both.

    In Application properties - deployment removed Auto Generate and Sybchronize weblogic-jdbc.xml unchecked.

    in my base_domain -config-jdbc i seen jdbc_Data_Source-0-34-jdbc.xml
    ?xml version='1.0' encoding='UTF-8'?
    jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd"
    nameJDBC Data Source-0/name
    jdbc-driver-params
    urljdbc:oracle:thin:@127.0.0.1:1521/XE/url
    driver-nameoracle.jdbc.xa.client.OracleXADataSource/driver-name
    properties
    property
    nameuser/name
    valuehr/value
    /property
    /properties
    password-encrypted{AES}Xy48qy9vdmA42jqmFvQSAtilBH9qHvBer5El7DLdElA=/password-encrypted
    /jdbc-driver-params
    jdbc-connection-pool-params
    test-table-nameSQL SELECT 1 FROM DUAL/test-table-name
    /jdbc-connection-pool-params
    jdbc-data-source-params
    jndi-namejdbc/ConnDS/jndi-name
    row-prefetchfalse/row-prefetch
    stream-chunk-size256/stream-chunk-size
    global-transactions-protocolTwoPhaseCommit/global-transactions-protocol
    /jdbc-data-source-params
    /jdbc-data-source

    and also in base_domain - config -config.xml i have below statement
    jdbc-system-resource
    nameJDBC Data Source-0/name
    targetADFServer,AdminServer/target
    descriptor-file-namejdbc/JDBC_Data_Source-0-3407-jdbc.xml/descriptor-file-name
    /jdbc-system-resource

    Now i run my application and access the databased page getting the error.

    Caused By: javax.naming.NameNotFoundException: Unable to resolve 'jdbc.ConnDS'. Resolved 'jdbc'; remaining name 'ConnDS'

    can anyone help out me. Its urgent for me.

    TIA

    DB:3.13:Jdbc Datasource Creation dz

    Hi Evryone,

    Now i am getting. After restart my Server i am able to getting DS. But on my server getting incomplete datasource for Conn. Actually this is my DatabaseNavigator name.

    TIA

  • RELEVANCY SCORE 3.11

    DB:3.11:Jdbc Error Handling cd


    --
    I am really confused of JDBC error messages. Becouse of the
    system topology, app server and the database are all in saperate
    systems, and i have to use network connections on JDBC. So I am
    not really sure about the exceptions thrown by the application
    becouse, there is not enough explanations of the error messages.
    Any help needed...

    Note :

    1. Connection reset by peer
    2. No route to host
    3. ORA-000060 dead lock ( this is the only one related with
    oracle)

    JDBC Driver :
    JDBC thin driver for Oracle 7.x.x.x
    null

    DB:3.11:Jdbc Error Handling cd

    --

    Our 8.1.6 drivers should have enhanced error handling
    features.
    - All exceptions will have ORA nos.
    - Exception Chaining
    - SQLWarning etc...

    Serkan TAS (guest) wrote:
    : I am really confused of JDBC error messages. Becouse of the
    : system topology, app server and the database are all in
    saperate
    : systems, and i have to use network connections on JDBC. So I am
    : not really sure about the exceptions thrown by the application
    : becouse, there is not enough explanations of the error
    messages.
    : Any help needed...
    : Note :
    : 1. Connection reset by peer
    : 2. No route to host
    : 3. ORA-000060 dead lock ( this is the only one related with
    : oracle)
    : JDBC Driver :
    : JDBC thin driver for Oracle 7.x.x.x

    _________________________
    Oracle Technology Network
    http://technet.oracle.com
    null

  • RELEVANCY SCORE 3.11

    DB:3.11:Oracle Jdbc Driver Vs Weblogic Oracle Jdbc Driver jz



    Where can I find performance comparison information for weblogic JDBC driver v/s
    Oracle JDBC driver? (For all types)

    Thanks

    Shirish

    DB:3.11:Oracle Jdbc Driver Vs Weblogic Oracle Jdbc Driver jz

    Shirish Bathe wrote:

    Where can I find performance comparison information for weblogic JDBC driver v/s
    Oracle JDBC driver? (For all types)
    Thanks
    ShirishThere's no standard benchmark for JDBC, and depending on what you want to do
    there may be a difference one way or the other. There won't be a clear winner in
    all cases. I recommend using the latest appropriate thin (all-Java) driver from oracle
    for your DBMS version. Obtain it from their site.
    Joe

  • RELEVANCY SCORE 3.08

    DB:3.08:Jdbc 3m


    Is there a JDBC driver use for Java 1.3? If so, how can I get it?

    Thanks,
    RT

    DB:3.08:Jdbc 3m

    Is there a JDBC driver use for Java 1.3? If so, how can I get it?

    Thanks,
    RT

  • RELEVANCY SCORE 3.08

    DB:3.08:Jdbc-Thin, 100% Java 3p


    Cant find the JDBC-Thin, 100% Java for Oracle 8.0.5.1.0. Is there another 100% thin driver I can use?

    DB:3.08:Jdbc-Thin, 100% Java 3p

    Cant find the JDBC-Thin, 100% Java for Oracle 8.0.5.1.0. Is there another 100% thin driver I can use?

  • RELEVANCY SCORE 3.07

    DB:3.07:Connection To Progress Database V7.3 a1


    I need to connect to Progress database v7.3 from java application.
    Can I use Progress JDBC driver (Progress SQL-92 JDBC driver - used for connecting to Progress DB v9 ) for connecting to Progress database v7.3 ? Or is there any other specific jdbc driver available for connecting to Progress V7.3 ?

    Thanks
    Selwyn

  • RELEVANCY SCORE 3.07

    DB:3.07:Please Help Me Connect To Oracle 10g Using Jdbc From Within A Java App 73


    I have recently installed Oracle 10g Express Edition for Windows. Its working well.

    I need to use JDBC to connect to the database from within a java app.
    How do I find the name of the JDBC driver? and URL?
    I think Oracle 10g Express Edition has a JDBC driver but I can not find the name of the driver.

    I looked in:
    C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib

    I could load the JDBC driver through the properties or preferences

    public static Connection getConnection()
    throws SQLException, IOException
    { Properties props = new Properties();
    String fileName = "MakeDB.properties";
    FileInputStream in = new FileInputStream(fileName);
    props.load(in);
    String drivers = props.getProperty("jdbc.drivers");
    if (drivers != null)
    System.setProperty("jdbc.drivers", drivers);
    String url = props.getProperty("jdbc.url");
    String username = props.getProperty("jdbc.username");
    String password = props.getProperty("jdbc.password");

    return
    DriverManager.getConnection(url, username, password);
    }

    The MakeDB.properties file would need to contain something like:
    jdbc.drivers=com.?????.jdbc.jdbcDriver
    jdbc.url=jdbc:???:???
    jdbc.username=hr
    jdbc.password=hr

    ----------------------------------------------------------------------
    I could load the JDBC driver by hard coding the driver class.

    try {

    // Step 1: Load the JDBC driver.
    Class.forName("oracle.jdbc.driver.OracleDriver");

    // Step 2: Establish the connection to the database.
    String url = "jdbc:???:
    Connection conn = DriverManager.getConnection(url,"user1","password");

    } catch (Exception e) {
    System.err.println("Got an exception! ");
    System.err.println(e.getMessage());
    }
    ---------------------------------
    Could some one please help find the name of the JDBC driver and URL for Oracle 10g Express Edition for Windows.

    Thanks
    PhilJamesDonovan@hotmail.com

    DB:3.07:Please Help Me Connect To Oracle 10g Using Jdbc From Within A Java App 73

    try this:
    try {
    Class.forName("oracle.jdbc.OracleDriver");
    }
    catch (ClassNotFoundException e){
    System.out.println("ClassNotfoundException!!!!!!");
    e.printStackTrace();
    }
    String url = "jdbc:oracle:thin:@localhost:1521:XE";
    Connection conn = null;
    try {
    conn = DriverManager.getConnection(url,"HR","hr");
    }
    catch (SQLException sqle){
    System.out.println("SQLException !!!!!!!");
    sqle.printStackTrace();
    }

    ...

    sasami

  • RELEVANCY SCORE 3.07

    DB:3.07:Jdbc Driver For Oracle 8 m1


    Hi,
    I am using Oracle 8 Personal edition for win 98.Where can i find jdbc drivers to connect to the Oracle 8 database.?
    Thank You.

    DB:3.07:Jdbc Driver For Oracle 8 m1

    Win98? You poor rascal.

    Must be an old JDK. I don't think JDK 1.4 will run on Win 9x.

    Download drivers here:

    http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html

    Make sure the driver you get corresponds to your JDK. - MOD

  • RELEVANCY SCORE 3.05

    DB:3.05:Jdbc Upgrade W/ Xsql Servlet 71


    Will the next release be certified with classes12.zip - the latest Oracle JDBC drivers?

    How can I also use the JDBC-OCI driver?

    null

    DB:3.05:Jdbc Upgrade W/ Xsql Servlet 71

    XSQL 1.0.0.0 works fine with classes12.zip

    You just have to make sure that if you use that, you also download the corresponding
    XML SQL Utility jar file for the JDBC 2.0
    driver in the XSU12.zip download.

    By default, to work with both 8.1.5 and 8.1.6 out of the box, XSQL Servlet ships with the JDBC 1.x driver and the XML SQL utility XSU111.zip's oraclexmlsql.jar that
    goes with JDBC 1.x

    Using the JDBC OCI driver is just a matter of:
    (1) Using the appropriate dburl in your
    XSQLConfig.xml file's connection
    definition, and
    (2) Making sure the native DLL's or
    shared libraries on which the OCI
    JDBC driver depends are in the SYSTEM
    path of your Servlet engine (not CLASSPATH).

  • RELEVANCY SCORE 3.05

    DB:3.05:Jdbc-Odbc Bridge And Creating Jdbc Driver For Ide's (E.G. Creator) pc


    Hi all,

    I have an old ODBC driver for an old database (Faircom), I have connected using the JDBC-ODBC bridge.

    How do i create a "JDBC-Driver" so that i can connect to this data source from IDEs. e.g. Sun creator requires the JDBC driver jars..

    Do i need to use the new(ish) Bridge enhancement
    javax.sql.DataSource ( sun.jdbc.odbc.ee.DataSource )

    thanks
    Rob.

    DB:3.05:Jdbc-Odbc Bridge And Creating Jdbc Driver For Ide's (E.G. Creator) pc

    Pyrrhicv

    Welcome to the forum. Please don't post in threads that are long dead. When you have a question, start your own topic. Feel free to provide a link to an old post that may be relevant to your problem.

    I'm locking this thread now. It's nearly 3 years old.

    db

  • RELEVANCY SCORE 3.05

    DB:3.05:Oracle Oci Performance jc


    Hi all,

    We would like to find out which setup gives us which performance, so we can pick the best
    for various circumstances. But first we need to establish some facts:

    Our previous setup:

    - HPUX11, Oracle 7.3 / 8.1.7, C++, oci 7.3 / oci 8 as contained in the oracle installation
    There was a slowdown between OCI for 7.3 and OCI for 8.1.7. This forced us to use the 7.3
    protocol against our 8.1.7 database.

    When we used the OCI driver with C++
    on previous projects the Oracle process said (LOCAL=YES) and was a child process of the
    application it served. We'd like to get this effect back

    Our current setup:

    - HPUX11, Oracle 9.0.1 / 9.1, java 1.3.1, oracle12.zip/ocijdbc9.sl as contained in the oracle
    installation. The database and the applications will run on the same machine. Clients will
    not do any direct database access.

    Question that arose. We need to answer these both theoretically and practically.

    1. Is the 'oci8' driver faster than the 'thin' driver ? (preliminary tests showed the opposite)
    2. Is there an OCI 7.3 version of the JDBC OCI driver available? (this was faster than oci8, see above)
    3. Can the thin driver use tnsnames.ora instead of host:port:sid ?
    4. Can the thin driver connect to the database by something other than a tcp-socket-connection?
    When we use the thin driver the Oracle-Process, that is spawned to handle the request,
    says (LOCAL=NO) and its parent is process 1 (init). We'd like again local child process, see above)
    5. How can we get the oci8 driver to use something other than a tcp-socket-connetion?
    6. What's the correct syntax for the beq-protocol or is that (as I heard) not available for hpux?
    7. What's the correct syntax/setup for IPC/TCP-Loopback and what are their advantages/disadvantages?
    8. Is it at all possible to expect the java application to talk to it's server process using shared
    memory and IPC instead of TCP-sockets?
    9. What other considerations are possible to generically speed up JDBC, as this seems to take up
    the bulk of our processing time. We do use bulk fetches and Oracle-bulk updates. When we
    activate Oracle-Tracing and analyze the results the times are negligible when compared to the
    total JDBC time as measured in the application (factor 1 to 10 or so).

    regards,

    Frieder Schenke

    DB:3.05:Oracle Oci Performance jc

    I can't help you on the HP issues, but have you tried bumping up the FetchSize for ResultSets returning large numbers or rows?
    I have seen favorable performance increases with the "thin" driver on this.

    -Peter

  • RELEVANCY SCORE 3.04

    DB:3.04:Oracle Jdbc Driver Recommendations 1c


    Can anyone recommend a JDBC driver for use with
    Kodo 3.2.2 and Oracle 9.2.0? Commercial or
    otherwise. I have tried the following drivers
    and each is unsatisfactory in it's own way:

    Oracle JDBC 9.2: Doesn't sufficiently support SQL batching.
    (causes exception when BatchLimit=-1 is set)

    Oracle JDBC 10.1: Doesn't sufficiently support SQL batching.
    (causes exception when BatchLimit=-1 is set)

    Oracle JDBC 9.0.1: Doesn't sufficiently support SQL
    batching together With Prepared Statement Batching
    (if BatchLimit=-1 Then MaxCachedStatements must be 0.
    If MaxCachedStatements is non-zero, then BatchLimit
    must be 0, otherwise, boom!)

    DataDirect JDBC 3.4: Works ok, but performance
    Is nothing to write home about. In one of my tests
    it is 300% slower than using Oracle JDBC 9.0.1

    Thanks for any insights.

    ..droo.

    DB:3.04:Oracle Jdbc Driver Recommendations 1c

    Of course, I meant Prepared Statement Caching
    (not prepared statement batching)

  • RELEVANCY SCORE 3.04

    DB:3.04:Need Help 33


    Can I use a same Instance of Driver, for many simultaneous JDBC connection ?

    DB:3.04:Need Help 33

    What is better for performance? Using pooled connections or the same conn for every operations?

  • RELEVANCY SCORE 3.03

    DB:3.03:Mac Osx Jdbc Type 4 Driver xc


    If I use Mac OSX and I install jdk 1.4.1.
    Can I use type 4 JDBC driver for jdk1.4 rather than type 4 driver for mac jdk 1.2?

    DB:3.03:Mac Osx Jdbc Type 4 Driver xc

    If I use Mac OSX and I install jdk 1.4.1.
    Can I use type 4 JDBC driver for jdk1.4 rather than type 4 driver for mac jdk 1.2?

  • RELEVANCY SCORE 3.03

    DB:3.03:Fastest Jdbc Driver To Work With Xml Data 9p


    All,

    I have an OCI based application inserting LONG (XML) data faster than my JDBC application. I am using the oracle oracle.jdbc.driver.OracleDriver . Can some one suggest me what will be the best JDBC driver to use to get a closer performance with the OCI driver

    Thanks

  • RELEVANCY SCORE 3.03

    DB:3.03:Jdeveloper And Jdbc 81


    Hi all
    If I use jdeveloper 3.2 , does it include jdbc or where can I get a jdbc driver ?
    And if I use jdeveloper 9 , does it contain a jdbc driver ?
    Thanks

    DB:3.03:Jdeveloper And Jdbc 81

    Yes, all versions of JDeveloper come with the Oracle JDBC drivers included.

    Rob
    Team JDev

  • RELEVANCY SCORE 3.03

    DB:3.03:Wrong Error Message Was Returned From Jdbc Drivermanager. a9


    Hi all.I deployed 3 jdbc drivers(oracle, mssql, tibero which is korean dbms) into SAP PI.when I try to connect to oracle by jdbc, I got the error message about tibero failure from JDBC Adapter.I read some article about this issue.They said that JDBC DriverManager will try to connect other jdbc after failure connection of one jdbc driver.for example,1. DriverManager try to connect to oracle.2. password error.3. return "password error" message from oracle.4. DriverManager try to connect to MSSQL.5. wrong connect url and driver name.6. return "wrong url" message from MSSQL.7. DriverManager try to connect to TIBERO.8. wrong connect url and driver name.9. return "wrong url" message from TIBERO.10. save the log latest error message into PIhow can I solve this issue?

    DB:3.03:Wrong Error Message Was Returned From Jdbc Drivermanager. a9

    Hi, Actually according to the JDBC API the driver, which does not recognize the URL should return null and not throw an exception.The driver should return "null" if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn. The driver should throw an SQLException if it is the right driver to connect to the given URL but has trouble connecting to the database.If the tibero driver was compliant with the API the real exception would be visible to the end user.Best RegardsVyara

  • RELEVANCY SCORE 3.03

    DB:3.03:Jdbc Sybase xj


    where can i download driver jdbc for sybase ?

    DB:3.03:Jdbc Sybase xj

    1. Go to there website
    2. search for JDBC
    3. Find the jconn2 driver

  • RELEVANCY SCORE 3.03

    DB:3.03:Jdbc fz


    How do i use the JDBC-ODBC Bridge driver connect to the DBMS??

    DB:3.03:Jdbc fz

    http://java.sun.com/docs/books/tutorial/jdbc/basics/

  • RELEVANCY SCORE 3.02

    DB:3.02:Configuring Jdbc Driver For Jdbc System zc



    I have installed Enterprise Portal 6.0 with MS SQL Server 2000 as the backend database.As while Configuring a JDBC IView,SQL Server driver is required.

    1. Is there any default driver that comes with portal

    installation which i can use or do we have to

    configure the driver seperately,If yes then where to

    configure the driver.

    2. Can i connect to any other database , other than the

    default database which is used during the EP

    installation which in my case is My SQL Server 2000.

    If let us say i want to create an JDBC IView for a

    Oracle database.Where should i copy my oracle driver

    files or how should i configure my oracle drivers

    (classes12.jar) which i can use while creating a JDBC

    System.

    Can anybody please help me on this Issue or any docs

    available on this ?

    DB:3.02:Configuring Jdbc Driver For Jdbc System zc


    I can't find the folder for NetWeaver2004s sp09

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Use A Jdbc Driver In Caf jx



    Hi, all.

    I tried to make a ws to access DB with CAF, but I had no idea how to use a jdbc driver(.jar).

    Can anyone do me a favor? Thx

    PS: my server is ce7.1

    Edited by: Louis HUANG on Jul 27, 2009 1:09 PM

    DB:3.01:How To Use A Jdbc Driver In Caf jx


    hi

    If you want to interact with db tables in caf,try like this.

    it may work..

    Using EJB call database tables using jdbc driver.

    Expose EJB as webservice.

    and using External service option of caf utilise this webservice in caf,do the necessary mappings..

    you can search in sdn,how to call DB tables in EJB..

    Regards

    sowmya.

  • RELEVANCY SCORE 3.01

    DB:3.01:Where To Download The Jdbc-Odbc Driver That Can Upate Excel File? 7s


    i use the sun's jdbc-odbc driver to manipulate the excel record, i can only retrieve the record.

    DB:3.01:Where To Download The Jdbc-Odbc Driver That Can Upate Excel File? 7s

    The jdbc-odbc bridge allows you to perform most of the SQL commands, as select, insert, update, delete etc. So you should be able to update an excel file.

  • RELEVANCY SCORE 3.01

    DB:3.01:Jdbc Driver For Oracle 7 7s


    I have a client program that connects to Oracle 8 and 9 using the oracle.jdbc.OracleDriver that comes with Oracle 8.

    I use the same driver for both Oracle 8 and 9 and it works fine. I am only using it to query the metadata of the database using the DatabaseMetadata interface.

    Does anyone know if I can use the same driver for Oracle 7? I need to use the thin driver since I cannot assume that my code is running on a computer where a thin client is installed.

    Thanks,
    Hayden Marchant

    DB:3.01:Jdbc Driver For Oracle 7 7s

    You may or may not be able to connect to a Oracle 7 DB with your driver. I've had problems using an Oracle 8 driver to connect to an Oracle 7 DB.

    --------------------
    http://www.geocities.com/shrm_phr/index.html

  • RELEVANCY SCORE 3.01

    DB:3.01:About Date Timestamp Column Data Type mp


    In past 2 days, I tried to get to know how Oracle JDBC driver deal with table's column with Date or Timestamp data type. I have finished some test. I'd like to show the result below.

    The main issue is difference behavior between driver version 9i and 10g.

    Runtime Environments:

    1, Sun JDK 1.4.2_04

    2, Oracle Application Server 10.1.0.2
    Installed at D:/oc4j1012

    3, Oracle JDBC Driver 10g :
    quote from D:/oc4j1012/jdbc/lib/ojdbc14.jar/META-INF/MANIFEST.MF

    Implementation-Version: "Oracle JDBC Driver version - 10.1.0.3.0"
    Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
    Specification-Version: "Oracle JDBC Driver version - 10.1.0.3.0"
    Implementation-Title: "ojdbc14.jar"
    Implementation-Time: "Mon Nov 22 12:08:18 2004"

    4, Oracle JDBC Driver 9.2.0.1.0 :
    quote from D:/oracle/ora92/jdbc/lib/ojdbc14.jar/META-INF/MANIFEST.MF

    Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
    Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0"
    Specification-Vendor: "Oracle Corporation" .
    Implementation-Title: "ojdbc14_g.jar"
    Implementation-Version: "Oracle JDBC Driver version - 9.0.2.0.0"
    Implementation-Vendor: "Oracle Corporation"
    Implementation-Time: "Thu Apr 25 23:48:25 2002"

    5, Oracle JDBC Driver 9.2.0.5.0:
    I download this ojdbc14.jar from otn web site.

    Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
    Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0"
    Specification-Vendor: "Oracle Corporation" .
    Implementation-Title: "ojdbc14.jar"
    Implementation-Version: "Oracle JDBC Driver version - 9.0.2.0.0"
    Implementation-Vendor: "Oracle Corporation"
    Implementation-Time: "Tue Apr 6 01:10:57 2004"

    6, Database Server and Table

    Database Server:

    Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.6.0 - Production

    Table for test:

    CREATE TABLE AA_TEMP
    (
    D1 DATE,
    D2 TIMESTAMP(3)
    )

    INSERT INTO AA_TEMP (D1, D2 ) VALUES ( TO_Date( '04/20/2005 12:22:22', 'MM/DD/YYYY HH:MI:SS AM'), 2005-4-20 22:22:35.000000);

    7, The test program executes a simple query, select * from AA_TEMP.

    Resultset rs = ......

    ResultSetMetaData rsmd = rs.getMetaData();

    int t1 = rsmd.getColumnType(1)
    int t2 = rsmd.getColumnType(2)

    Object o1 = rs.getObject(1)
    Object o2 = rs.getObject(2)

    String c1 = o1.getClass().getName();
    String c2 = o2.getClass().getName();

    8, Test result
    case 1) When using driver version 9.0.2.1.0
    t1 = 91 (java.sql.Types.DATE)
    c1 = java.sql.Timestamp

    t2 = 93 (java.sql.Types.TIMESTAMP)
    c2 = oracle.sql.TIMESTAMP

    case 2) When using driver version 9.0.2.5.0
    t1 = 91 (java.sql.Types.DATE)
    c1 = java.sql.Timestamp

    t2 = 93 (java.sql.Types.TIMESTAMP)
    c2 = oracle.sql.DATE

    case 3) When using driver version 10g, just put D:/oc4j1012/jdbc/lib/ojdbc14.jar into CLASSPATH
    t1 = 91 (java.sql.Types.DATE)
    c1 = java.sql.Date. Only data of part of year, month, day, even if this column data include hour, minute, second component

    t2 = 93 (java.sql.Types.TIMESTAMP)
    c2 = oracle.sql.TIMESTAMP

    case 4) When using driver version 10g, just put D:/oc4j1012/j2ee/home/oc4j.jar into CLASSPATH, don't put D:/oc4j1012/jdbc/lib/ojdbc14.jar into CLASSPATH directly.
    t1 = 91 (java.sql.Types.DATE)
    c1 = java.sql.Date. Only data of part of year, month, day, even if this column data include hour, minute, second component

    t2 = 93 (java.sql.Types.TIMESTAMP)
    c2 = java.sql.Timestamp

    According to JDBC specification, Date mapped into java.sql.Date, Timestamp mapped into java.sql.Timestamp

    Only in last case, the driver fully apply for JDBC specification. I notice in this case, actually, the program runs just like in Oracle Application Server environment. I just put D:/oc4j1012/j2ee/home/oc4j.jar into CLASSPATH, I don't put D:/oc4j1012/jdbc/lib/ojdbc14.jar into CLASSPATH directly. It must be oc4j.jar makes the mystery. Does it a mystery? It does'nt. But It's so funny.

    oc4j.jar reference other jar files at runtime. Quote from oc4j.jar/META-INF/MANIFEST.MF:
    Main-Class: com.evermind.server.OC4JServer
    Class-Path: lib/ejb.jar lib/servlet.jar lib/ojsp.jar lib/jndi.jar lib/
    jdbc.jar iiop.jar iiop_gen_bin.jar lib/jms.jar lib/jta.jar lib/jmxri
    .jar lib/javax77.jar lib/javax88.jar ../../opmn/lib/ons.jar ../../op
    mn/lib/optic.jar ../../lib/dms.jar ../../dms/lib/dms.jar ../../diagno
    stics/lib/ojdl.jar ../../dms/diagnostics/lib/ojdl.jar lib/connector.
    jar lib/bcel.jar lib/cos.jar lib/jsse.jar ../../oracle/lib/jsse.jar
    lib/jnet.jar lib/jcert.jar lib/activation.jar lib/mail.jar ../../java
    vm/lib/jasper.zip ../../lib/xmlparserv2.jar ../../oracle/lib/xmlparse
    rv2.jar ../../jdbc/lib/orai18n.jar ../../oracle/jdbc/lib/orai18n.jar
    lib/jaxp.jar lib/jaas.jar jazn.jar ../../jdbc/lib/classes12dms.jar ..
    /../oracle/jdbc/lib/classes12dms.jar ../../jdbc/lib/nls_charset12.jar
    ../../oracle/jdbc/lib/nls_charset12.jar jaxb-rt-1.0-ea.jar ../../so
    ap/lib/soap.jar ../../webservices/lib/wsserver.jar ../../webservices/
    lib/wsdl.jar ../../rdbms/jlib/aqapi.jar lib/jem.jar ../../javacache/l
    ib/cache.jar lib/http_client.jar ../../jlib/jssl-1_1.jar ../../oracle
    /jlib/jssl-1_1.jar ../../jlib/repository.jar ../../oracle/jlib/reposi
    tory.jar lib/jaasmodules.jar ../../sqlj/lib/runtime12ee.jar ../../sql
    j/lib/translator.jar lib/crimson.jar ../../jlib/ojpcs.jar ../../oracl
    e/jlib/ojpcs.jar ../../jlib/ojpcp.jar ../../oracle/jlib/ojpcp.jar ../
    ../jlib/ojpse.jar ../../oracle/jlib/ojpse.jar ../../jlib/ojpsmime.jar
    ../../oracle/jlib/ojpsmime.jar ../../jlib/ojpcms.jar ../../oracle/jl
    ib/ojpcms.jar

    9, If my program runs under non OAS(Oracle Application Server) system, How should I deal with Date or Timestamp data type?

    DB:3.01:About Date Timestamp Column Data Type mp

    Hi, Avi. many thanks. Good guy!

    I have finished test with driver v9.0.5.0 and v10.1.0.4.0
    It's ok to use getTimestamp() instead of getObject().

    But I still have to test the code with Sybase Driver and other DBMS driver. It's part of a persistence framework.

  • RELEVANCY SCORE 2.99

    DB:2.99:Jdbc-Odbc Bridge Driver Removed In Java 8, What Is Best Alternative For Accessing Ms Access Databases? mx


    Since Oracle has removed the JDBC-ODBC Bridge driver for accessing MS Access databases using Java, they recommend using vendor-specific drivers that use JDBC technology instead of the Bridge. This gives me the impression that either Microsoft or another
    third party has created a driver out there somewhere for accessing MS Access databases.
    I am in the process of looking into this, but in the meantime, does anyone know if Microsoft offers a JDBC driver for accessing an Access database, or if some other alternative is out there?
    Thanks.
    More info:http://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/
    http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html

    DB:2.99:Jdbc-Odbc Bridge Driver Removed In Java 8, What Is Best Alternative For Accessing Ms Access Databases? mx

    Hi,
    As far as I know, there has JDBC for SQL server in Microsoft, but Microsoft doesn’t support JDBC driver for Access database now.
    You can just use JDBC-ODBC Bridge driver to connect Access database, or you can also post feedback to Microsoft.
    Regards,

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

    Click
    HERE to participate the survey.

  • RELEVANCY SCORE 2.99

    DB:2.99:Which Solution Is Best For My Project z9


    Dear Sir:
    Now i am trying to rewrite my odbc/c/oracle project into jdbc/java/oracle one.
    the project environment is simple, i run Oracle 8.1.7 in my personal computer, that is all.

    1. i found the jdbc drivers in Oracle, but i still can't figure out which one is best for my need.

    1. JDBC-Thin, 100% Java
    2.JDBC-OCI / NT Note: Oracle 8.1.7 Client must be installed before the OCI driver can be used.
    3. NLS-zip, 100% Java
    4. JavaDoc

    2. should i learn SQLJ or jdbc will be enough?
    3. where should i look about how to use jdbc driver before i start to program jdbc?

    thank you...

    DB:2.99:Which Solution Is Best For My Project z9

    1. i found the jdbc drivers in Oracle, but i still
    can't figure out which one is best for my need.

    1. JDBC-Thin, 100% Java
    2.JDBC-OCI / NT Note: Oracle 8.1.7 Client must be
    be installed before the OCI driver can be used.
    3. NLS-zip, 100% Java
    4. JavaDoc I normally use the thin driver simply because its simpler to install. Just copy a single file to the client machine. In the past I've used the OCI driver because the blob handling of the thin driver wasn't good enough, however this may no longer be the case. I think NLS.zip is something to do with handling character sets - I've always used English so I've had no need for this file. JavaDoc is further documentation for the drivers.

    2. should i learn SQLJ or jdbc will be enough?Probably best to start with JDBC and then move on to SQLJ. JDBC is more widely used at the present.

    3. where should i look about how to use jdbc driver
    before i start to program jdbc?Take a look through the tutorials and FAQ here http://java.sun.com/j2se/1.3/docs/guide/jdbc/index.html and theres some more stuff here http://www.mindprod.com/jdbc.html

    thank you... No problem.

    Col

  • RELEVANCY SCORE 2.99

    DB:2.99:Create New Daba Base Over Jdbc-Driver 1m


    Hi,

    i use the mySql-DB with the mm.mysql.jdbc-1.2c-JDBC-Driver.

    Its working fine!

    But how can I create a new database thru the JDBC-Driver?

    Thanks
    Daniel :-)

    DB:2.99:Create New Daba Base Over Jdbc-Driver 1m

    i don't know if this wil work but with a access database with ODBC it works like this.....

    try
    {
    Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
    connection = DriverManager.getConnection(
    url, username, password );
    }

    catch ( ClassNotFoundException cnfex )
    {
    System.err.println(
    "Failed to load JDBC/ODBC driver." );
    cnfex.printStackTrace();
    System.exit( 1 ); // terminate program
    }

    catch ( SQLException sqlex )
    {
    System.err.println( "Unable to connect" );
    sqlex.printStackTrace();
    }

    Statement stmt = connection.createStatement();

    stmt.executeUpdate("CREATE TABLE TABLENAME(ROWNAME TYPEDATA(xx), rowname VARCHAR(19))");

    connection.close();

  • RELEVANCY SCORE 2.98

    DB:2.98:Can I Force Jdbc Driver Use Utf-8 Charset To Encode? 9s


    The similiar way is in MySQL, like

    jdbc:mysql://localhost:3306/test?useUnicode=trueamp;characterEncoding=UTF-8

    Thanks,

    DB:2.98:Can I Force Jdbc Driver Use Utf-8 Charset To Encode? 9s

    You must describe your requirements in more details. There is generally nothing special in reading/writing into a database that has UTF-8 (AL32UTF8) as its database character set. Data is read into/written from String variables, which are encoded in UTF-16 by Java design. JDBC transparently converts between UTF-16 and UTF-8.

    If you want to output a string into a file in UTF-8 encoding, it is no longer an Oracle problem but a normal Java programming issue. You need to create an appropriate OutputStreamWriter for your FileOutputStream.

    new OutputStreamWriter( new FileOutputStream(file), "UTF-8" );

    -- Sergiusz

  • RELEVANCY SCORE 2.98

    DB:2.98:Question Regarding Coldfusion Jdbc Driver fk


    Hi Guys,

    I have a few questions regarding database access using JDBC
    type 4 driver.
    1. Is JDBC type 4 driver provided with ColdFusion MX actually
    a DataDirect JDBC driver?
    2. Now I had some problems with insert data into a table. Is
    it any way we can trace the database connection? How to turn on
    trace using this driver? I am specifically interested in version
    3.5.

    Thank you,
    Shan

    DB:2.98:Question Regarding Coldfusion Jdbc Driver fk

    Btw,

    This is a Coldfusion MX running on a JBoss 4.0.1 SP1
    server.

  • RELEVANCY SCORE 2.98

    DB:2.98:Download Jdbc Driver 7z


    From where i can download the JDBC driver for using java 2 methods.

    DB:2.98:Download Jdbc Driver 7z

    what is the default driver provided with jdk1.2.2?? does that support conn. pooling, updateable rowsets?
    thanks in advance.

  • RELEVANCY SCORE 2.98

    DB:2.98:Which Oracle Jdbc Driver To Use With Wsad 5.1.2? a9


    Hi,

    I will appreciate if someone could help me with:

    1) Whether I should select "Oracle JDBC Driver" or "Oracle JDBC Driver (XA)" as the JDBC Provider Type. The rest in the list (Thin oci8 ) are deprecated.

    2) When I go to create a datasource, for either of the above JDBC provider type, I get the options:
    - User defined JDBC provider
    - Oracle JDBC provider
    - Oracle JDBC Thin Driver
    - Oracle JDBC oci8 Driver

    Why do I have the Thin and Oci8 option here, when those were shown as deprecated under JDBC Provider Type?

    Please help to clear up this confusion.

    -Nimmi

    DB:2.98:Which Oracle Jdbc Driver To Use With Wsad 5.1.2? a9

    This is what I did for my DS settings

    1. select Oracle JDBC Driver
    2. set Classes12.jar in Websphre classpath - (Oracle thin driver)
    3. create DS with option User defined JDBC provider

    means I have added Thin driver provided by Oracle , instead of deprecated Thin driver from IBM.

  • RELEVANCY SCORE 2.98

    DB:2.98:Jdbc 2.0 Driver 8k


    i'm presently using jdbc 1.2 driver to connect to oracle 8.0.5 wish u use certain methods of the resultset interface of java API which this driver doesn't support...please tell me where i can download the jdbc 2.0
    driver.

    DB:2.98:Jdbc 2.0 Driver 8k

    i have set the classpath copied the zip files for JDBC 2.0, but still i'm unable to use the resultset interface methods such as 'previous()', beforefirst(),afterLast()...etc.
    what could be the possible error.
    The error displayed on screen is 'javax.servlet.Servlet Exception'...

  • RELEVANCY SCORE 2.98

    DB:2.98:This Jdbc 2.0 Method Is Not Implemented x1


    I tried to use jDriver for MSSQL and use the following jdbc code :

    stmt.prepareStatement(" SELECT xxxx FROM yyyyy WHERE zzzz = ? FOR UPDATE "
    ,ResultSet.TYPE_FORWARD_ONLY,
    ResultSet.CONCUR_UPDATABLE );

    stmt.setCharacterStream (n, value);

    Both get this exception : This JDBC 2.0 method is not implemented

    Is jDriver a JDBC 1.x driver only. Thanks.

    Chris

    DB:2.98:This Jdbc 2.0 Method Is Not Implemented x1

    Yes, our MS driver is in fact jdbc1.0-compliant only. For a more
    current driver you can try the free one from MS, or www.inetsoftware.de
    Joe

    Christopher wrote:

    I tried to use jDriver for MSSQL and use the following jdbc code :

    stmt.prepareStatement(" SELECT xxxx FROM yyyyy WHERE zzzz = ? FOR UPDATE "
    ,ResultSet.TYPE_FORWARD_ONLY,
    ResultSet.CONCUR_UPDATABLE );

    stmt.setCharacterStream (n, value);

    Both get this exception : This JDBC 2.0 method is not implemented

    Is jDriver a JDBC 1.x driver only. Thanks.

    Chris

  • RELEVANCY SCORE 2.98

    DB:2.98:Jdbc Driver Update ka


    Hi
    I want to update my JDBC driver version. It is now 9.0.1.4.0.
    My application uses \jdev\jdbc\lib\classes12.jar and \jdev\jdbc\lib\nls_charset12.jar.
    but the new version for Oracle DB 10.2.0.2.0 includes classes12.jar but not nls_charset12.jar.Well,I don't know what can I do?
    1. update only classes12.jar?
    2. do not update nls_charset12.jar or use another jar instead of it.
    Thanks for helps.

    DB:2.98:Jdbc Driver Update ka

    Hi
    I want to update my JDBC driver version. It is now 9.0.1.4.0.
    My application uses \jdev\jdbc\lib\classes12.jar and \jdev\jdbc\lib\nls_charset12.jar.
    but the new version for Oracle DB 10.2.0.2.0 includes classes12.jar but not nls_charset12.jar.Well,I don't know what can I do?
    1. update only classes12.jar?
    2. do not update nls_charset12.jar or use another jar instead of it.
    Thanks for helps.

  • RELEVANCY SCORE 2.97

    DB:2.97:Jdbc Network Driver 93


    Hello Friends i didn't know how to use jdbc 3rd type driver can any one send
    usefull example .

    DB:2.97:Jdbc Network Driver 93

    Google for jdbc tutorial.

    For driver installation, read the driver's manual.

  • RELEVANCY SCORE 2.97

    DB:2.97:Oracle Driver xm


    hi!!

    I need to use a jdbc connection to a Oracle database.
    I have done in the IDE with de datasource the connection, but now I want to do with stored procedures in jdbc writting my own code. Here it is the variables of the stored procedure.

    cs.registerOutParameter(1, Types.OTHER);
    cs.setObject(1, rs);
    cs.setInt(2, p_oficina);
    cs.setInt(3, p_producto);
    cs.setInt(4, p_cuenta);
    cs.setDate(5, p_fdesde);
    cs.setDate(6, p_fhasta);
    cs.setInt(7, p_gestor);I read that I have to put cs.registerOutParameter(1, OracleTypes.CURSOR); , but I can't find oracle.jdbc.driver.* to import.
    Do you know where i can find o how I can do?

    Thanks!!!

    DB:2.97:Oracle Driver xm

    Hi!!!

    I done well my connection with the stored procedure.
    I have asked you in your Post topic. I can't copy here all the code because security problems, but I can help you in all.

    Byeee and thanks every body.

  • RELEVANCY SCORE 2.97

    DB:2.97:What Represent "Total Jdbc Connections" In Oas? cj


    Hi,

    In my Oracle Enterprise Manager, in the Home tab of my application instance, I'm seeing the following information for the JDBC Usage
    Open JDBC Connections 1
    Total JDBC Connections 7
    Active Transactions 0
    Transaction Commits 0
    Transaction Rollbacks 0

    Q: What really represent Total JDBC Connections?
    Total JDBC Connection displays the total number of JDBC connection opened, presently in use, or is some cumulative number of JDBC connections?

    Executing my application I notice that this number is increasing progressively in time.
    For example, after 6 days, in production environment I can attain:
    Open JDBC Connections 52
    Total JDBC Connections _551 592_

    Q: Can this be a problem of my application? (Somehow related with some connection leak or resource leak of my application)

    Thanks,
    Ivat

    DB:2.97:What Represent "Total Jdbc Connections" In Oas? cj

    Hi again,

    Ive done a few tests with a stand alone version of OAS (10.1.3.4.0), with the same page JSP, and you are right, it seams that after the inactivity time the Total JDBC Connection is coming back at zero.
    There is a little (maybe big) difference: the driver that I use on my server is a Thin driver, on my Solaris server is a OCI driver (with the RAC, TAF activated).

    I realy want to know if I have a JDBC connection leak or not.

    Thanks,
    OD

  • RELEVANCY SCORE 2.97

    DB:2.97:Obiee With Jdbc Driver 77


    Hi Experts,

    We need to connect OBIEE with Data access layer using JDBC driver. Is there any way we can use JDBC driver.

    We dont want to use BI Publisher.

    Thanks,

  • RELEVANCY SCORE 2.97

    DB:2.97:Microsoft Sql Server 7 Jdbc Driver m9


    Anyone know where I can download a good JDBC driver for Microsoft SQL Server 7. Thanks.

    DB:2.97:Microsoft Sql Server 7 Jdbc Driver m9

    Maybe just use Sun's JDBC-ODBC bridge?That driver should not be used in production code, it is a reference implemenation only. Look here instead:

    http://servlet.java.sun.com/products/jdbc/drivers

  • RELEVANCY SCORE 2.97

    DB:2.97:Ending Up With Stuck Thread. 39


    Below is the log from my managed weblogic server. This is how one of my datasource looks like

    ..........
    jdbc-driver-params
    urloracle.fec.url/url
    driver-nameoracle.jdbc.pool.OracleDataSource/driver-name
    properties
    property
    nameuser/name
    valuedbuser/value
    /property
    property
    nameprotocol/name
    valuethin/value
    /property
    /properties
    password-encryptedpassword/password-encrypted
    /jdbc-driver-params
    jdbc-connection-pool-params
    initial-capacity5/initial-capacity
    max-capacity80/max-capacity
    shrink-frequency-seconds10/shrink-frequency-seconds
    test-frequency-seconds5/test-frequency-seconds
    test-connections-on-reservetrue/test-connections-on-reserve
    ignore-in-use-connections-enabledfalse/ignore-in-use-connections-enabled
    test-table-nameSQL SELECT 1 FROM DUAL/test-table-name
    seconds-to-trust-an-idle-pool-connection0/seconds-to-trust-an-idle-pool-connection
    statement-timeout120/statement-timeout
    /jdbc-connection-pool-params
    jdbc-data-source-params
    jndi-nameDBDataSource/jndi-name
    global-transactions-protocolEmulateTwoPhaseCommit/global-transactions-protocol
    /jdbc-data-source-params
    /jdbc-data-source

    I am trying to see how my application fails over when I do RAC node failure by node eviction. The first time I simulate RAC node fail ,weblogic seems to be doing fine. Upon second failure I encounter this in logs after successively getting weblogic.jdbc.extensions.PoolDisabledSQLException:

    My questions are:

    1. Why is this error caused ?
    2.what can I do to see whats going on.

    Thread-165 "[STUCK] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'" alive, in native, blocked, priority=1, DAEMON {
    -- Blocked trying to get lock: oracle.jdbc.driver.T4CConnection@14edb9b[thin lock]
    jrockit.vm.Threads.sleep(Native Method)
    jrockit.vm.Locks.waitForThinRelease(Unknown Source)
    jrockit.vm.Locks.monitorEnterSecondStage(Unknown Source)
    jrockit.vm.Locks.monitorEnter(Unknown Source)
    oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1139)
    weblogic.jdbc.common.internal.ConnectionEnv.destroyForFlush(ConnectionEnv.java:451)
    weblogic.jdbc.common.internal.ConnectionEnv.destroy(ConnectionEnv.java:430)
    weblogic.common.resourcepool.ResourcePoolImpl.destroyAllResources(ResourcePoolImpl.java:1351)
    *^-- Holding lock: weblogic.jdbc.common.internal.ConnectionPool@11e5f9a[recursive lock]* weblogic.common.resourcepool.ResourcePoolImpl.incrementTestFailCount(ResourcePoolImpl.java:1528)
    *^-- Holding lock: weblogic.jdbc.common.internal.ConnectionPool@11e5f9a[thin lock]* weblogic.common.resourcepool.ResourcePoolImpl.checkResource(ResourcePoolImpl.java:1457)
    weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(ResourcePoolImpl.java:1372)
    weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(ResourcePoolImpl.java:1362)
    weblogic.common.resourcepool.ResourcePoolImpl.testUnusedResources(ResourcePoolImpl.java:1767)
    weblogic.common.resourcepool.ResourcePoolImpl.access$700(ResourcePoolImpl.java:37)
    weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:1935)
    weblogic.timers.internal.TimerImpl.run(TimerImpl.java:265)
    weblogic.work.ServerWorkManagerImpl$WorkAdapterImpl.run(ServerWorkManagerImpl.java:518)
    weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
    jrockit.vm.RNI.c2java(Native Method)

    Edited by: user10917799 on May 4, 2010 8:43 AM

    DB:2.97:Ending Up With Stuck Thread. 39

    Below is the log from my managed weblogic server. This is how one of my datasource looks like

    ..........
    jdbc-driver-params
    urloracle.fec.url/url
    driver-nameoracle.jdbc.pool.OracleDataSource/driver-name
    properties
    property
    nameuser/name
    valuedbuser/value
    /property
    property
    nameprotocol/name
    valuethin/value
    /property
    /properties
    password-encryptedpassword/password-encrypted
    /jdbc-driver-params
    jdbc-connection-pool-params
    initial-capacity5/initial-capacity
    max-capacity80/max-capacity
    shrink-frequency-seconds10/shrink-frequency-seconds
    test-frequency-seconds5/test-frequency-seconds
    test-connections-on-reservetrue/test-connections-on-reserve
    ignore-in-use-connections-enabledfalse/ignore-in-use-connections-enabled
    test-table-nameSQL SELECT 1 FROM DUAL/test-table-name
    seconds-to-trust-an-idle-pool-connection0/seconds-to-trust-an-idle-pool-connection
    statement-timeout120/statement-timeout
    /jdbc-connection-pool-params
    jdbc-data-source-params
    jndi-nameDBDataSource/jndi-name
    global-transactions-protocolEmulateTwoPhaseCommit/global-transactions-protocol
    /jdbc-data-source-params
    /jdbc-data-source

    I am trying to see how my application fails over when I do RAC node failure by node eviction. The first time I simulate RAC node fail ,weblogic seems to be doing fine. Upon second failure I encounter this in logs after successively getting weblogic.jdbc.extensions.PoolDisabledSQLException:

    My questions are:

    1. Why is this error caused ?
    2.what can I do to see whats going on.

    Thread-165 "[STUCK] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'" alive, in native, blocked, priority=1, DAEMON {
    -- Blocked trying to get lock: oracle.jdbc.driver.T4CConnection@14edb9b[thin lock]
    jrockit.vm.Threads.sleep(Native Method)
    jrockit.vm.Locks.waitForThinRelease(Unknown Source)
    jrockit.vm.Locks.monitorEnterSecondStage(Unknown Source)
    jrockit.vm.Locks.monitorEnter(Unknown Source)
    oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1139)
    weblogic.jdbc.common.internal.ConnectionEnv.destroyForFlush(ConnectionEnv.java:451)
    weblogic.jdbc.common.internal.ConnectionEnv.destroy(ConnectionEnv.java:430)
    weblogic.common.resourcepool.ResourcePoolImpl.destroyAllResources(ResourcePoolImpl.java:1351)
    *^-- Holding lock: weblogic.jdbc.common.internal.ConnectionPool@11e5f9a[recursive lock]* weblogic.common.resourcepool.ResourcePoolImpl.incrementTestFailCount(ResourcePoolImpl.java:1528)
    *^-- Holding lock: weblogic.jdbc.common.internal.ConnectionPool@11e5f9a[thin lock]* weblogic.common.resourcepool.ResourcePoolImpl.checkResource(ResourcePoolImpl.java:1457)
    weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(ResourcePoolImpl.java:1372)
    weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(ResourcePoolImpl.java:1362)
    weblogic.common.resourcepool.ResourcePoolImpl.testUnusedResources(ResourcePoolImpl.java:1767)
    weblogic.common.resourcepool.ResourcePoolImpl.access$700(ResourcePoolImpl.java:37)
    weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:1935)
    weblogic.timers.internal.TimerImpl.run(TimerImpl.java:265)
    weblogic.work.ServerWorkManagerImpl$WorkAdapterImpl.run(ServerWorkManagerImpl.java:518)
    weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
    jrockit.vm.RNI.c2java(Native Method)

    Edited by: user10917799 on May 4, 2010 8:43 AM

  • RELEVANCY SCORE 2.97

    DB:2.97:Should Executebatch Call Clearparameters ? 97


    I have found on page 131 of the JDBC API Tutorial and Ref, 2nd edition, that executeBatch should call clearBatch after a successful execute. However, should it also call clearParameters?

    I have tried the ODBC to JDBC Bridge and it appears executeBatch calls clearParameters. If you try to do an executeUpdate after an executeBatch, the previous parameters set by a set method are not used for the executeUpdate.

    My question if from a JDBC Driver implementors view point. I know the sequence of commands below is not typical and is not the preferred way of doing things but as an implementor you have to handle the wierd cases.

    Consider the following sequence:

    1 PreparedStatement p =
    con.prepareStatement("update TABLE 1 set COL1 = ? where COL2 = ?");
    2 p.setString(1, "ABC");
    3 p.setInt(2, 3);
    4 cnt = p.executeUpdate();// executes with parms ABC,3
    5 p.addBatch(); // save batch command with parms ABC,3
    6 p.setInt(2, 4);
    7 int [] countArr = p.executeBatch(); // executes with parms ABC,3
    8 cnt = p.executeUpdate(); // Bridge executes with parms = ABC,3

    I think the Bridge should use parms ABC,4 for line 8, not ABC,3. It appears the Bridge is doing a clearParameters after the executeUpdate at line 7 and using whatever parameters are "left over" on the server from the last execute. In fact if you code a p.clearParameters() call after line 7, the execution result is the same for line 8.

    Any input is appreciated, including what other JDBC Drivers do.

    DB:2.97:Should Executebatch Call Clearparameters ? 97

    I don't think the JDBC spec imposes any rules on this, so each driver does it its own way, although what happens in your case seems confusing.

    Alin.

  • RELEVANCY SCORE 2.97

    DB:2.97:Jar am


    i want to create a jar file for an application that use a jdbc driver, can i get only one jar file that include Myclass file and the jdbc driver?

    DB:2.97:Jar am

    Yup. Unjar the jdbc jar and add its packages to your app's jar.

    Regards

  • RELEVANCY SCORE 2.97

    DB:2.97:Help! Config Sql2000 Driver In J2ee. d7


    i use microsoft sql2000 server database.
    download sql2000 jdbc driver.
    i want use jdbc catalog 4 ---jdbc driver
    who can tell me how to config sql2000 driver in j2ee ?
    thanks.

    DB:2.97:Help! Config Sql2000 Driver In J2ee. d7

    Use deploytool - Tools - Server Configuration - Data sources - Standard and follow the instructions in the help document

    James Chiang

  • RELEVANCY SCORE 2.97

    DB:2.97:Adding A Jdbc Driver In Sun Java System Web Server 7 3x


    I'm trying to configure JDBC database connection pooling for a Microsoft SQL Server 2005 Express Edition though the Sun Java System Web Server 7 administration console. I don't want to use the MSSQL JDBC driver that comes bundled with the SJSWS 7. So I've downloaded the lastest MSSQL JDBC driver from the Microsoft website and put in the "lib" subdirectory of the SJSWS installation directory. So when I go to add a new JDBC resource through the administration console, the newly added MSSQL database driver doesn't appear in the "Driver Vendor" drop-down box.

    How do I add the downloaded JDBC driver to the server so that it appears in the "Driver Vendor" drop-down under "Create JDBC resource".

    DB:2.97:Adding A Jdbc Driver In Sun Java System Web Server 7 3x

    Check this documentation from MS on using the JDBC driver with DataSource

    http://msdn2.microsoft.com/en-us/library/ms379052.aspx

    SJS Web Server 7.0 should work with any driver that has support for javax.sql.DataSource. The great majority of drivers do.

    So instead of using the driver name, use the DataSource class name:

    com.microsoft.sqlserver.jdbc.SQLServerDataSource

    The properties to add should be:

    user=username
    password=password
    servername=sql_server_hostname
    portnumber=sql_server_port
    databasename=databasename

    In general, all the setters required to get the datasource configured can be set as properties.

  • RELEVANCY SCORE 2.97

    DB:2.97:Savepoint In Jdbc 9p


    Hi,

    I'm working with oracle 8.1.6, JDK 1.3.1 and jdbc driver classes12.zip .
    How can I use savepoints with JDBC ?
    Can I use ojdbc14.jar for oracle 8i ?

    thanks,
    Guy.

  • RELEVANCY SCORE 2.96

    DB:2.96:Jdbc Thin Connections With Ssl And Client Certificates ka


    Hi ,
    we are going have a look at JDBC Thin Connections with SSL and client certificates.

    I have two questions:

    1. Is it possible to use SSL connections from JDBC Thin Driver and which release of the driver introduced it

    2. Is it possible to use client certificates with JDBC Thin Driver and which release of the driver introduced it

    Thanks for your help
    regards
    Markus Reichert

    DB:2.96:Jdbc Thin Connections With Ssl And Client Certificates ka

    Hi ,
    we are going have a look at JDBC Thin Connections with SSL and client certificates.

    I have two questions:

    1. Is it possible to use SSL connections from JDBC Thin Driver and which release of the driver introduced it

    2. Is it possible to use client certificates with JDBC Thin Driver and which release of the driver introduced it

    Thanks for your help
    regards
    Markus Reichert

  • RELEVANCY SCORE 2.96

    DB:2.96:Jdbc Driver 10.1.0.2.0 Versus Bc4j fj


    I tried to use Oracle JDBC Driver 10.1.0.2.0 with BC4J (JDeveloper 9.0.3.4), due to some bugs inside 9.0.1.4.
    But I meet some error:
    oracle.jbo.AttributeLoadException: JBO-27021: Selhalo nacten hodnoty CustomDatum na indexu 1 s objektem java typu oracle.jbo.domain.Number z duvodu java.sql.SQLException.
    (This error never occurred before with older version of JDBC driver.)

    Can be BC4J used with newer version of Oracle JDBC Driver? Is some combinations guaranteed? Have you any experiences with newer version of JDBC Driver?

    Thank you very much for any hints.
    Jan

    DB:2.96:Jdbc Driver 10.1.0.2.0 Versus Bc4j fj

    Rob,

    I hunted through the docs and can't seem to find which JDBC drivers are certified -- I hope I'm missing something.

    My case is that our client is forcing a move from the 9iAS 9.0.3 line using 8.1.7.4 database to Caucho Resin. They use the 9.2.0.4 DB version now and use that version of the JDBC driver on their Resin app server. They recommend the OCI (non-thin) version -- however, we are having trouble with that when updating the PS_TXN table.

    (getting java.sql.SQLException: ORA-00001: unique constraint (FISTSPROD2.PS_TXN_PK) violated
    ORA-06512: at line 1)

    Anyway, it would be great if I could find certification lists matrices for JDev/BC4J versions: 9.0.3.4, 9.0.4 and 9.0.5.1 to see which ones are compatible with the target JDBC driver. They are currently using the 9.2.0.4 (OCI) in Windows, given their belief that the OCI driver is more reliable in their RAC configuration.

    Metalink doesn't seem to have it on the certification and the JDev docs prior to 9.0.5.1 are not as clear (from what I can see).

    I'm trying to use whichever JDev gets me there the easiest...

    Thanks,

    Jeff

    Thanks,

    Jeff

  • RELEVANCY SCORE 2.96

    DB:2.96:Jdbc-Odbc Driver 9k


    where can I download the JDBC-ODBC driver? Thank you.

    DB:2.96:Jdbc-Odbc Driver 9k

    it comes with jdk, just use sun.jdbc.odbc.JdbcOdbcDriver as the drivername

  • RELEVANCY SCORE 2.96

    DB:2.96:Deployable Data Sources In Jboss 7.1.1 (Deployment Of Driver And Datasource) pj



    Hi,

    I'm having problems deploying a datasource along with the jdbc driver in a war (OracleDriver). I'm running a standalone server.

    This posting suggests that this is possible:

    http://www.mastertheboss.com/jboss-datasource/jboss-as-7-deployable-datasources

    Is this correct?

    I've got the ojdb6.jar in the WEB-INF/lib folder and I've got a mysource-ds.xml file in WEB-INF.

    The deployment of the JDBC driver seems to fail with:

    1:42:10,497 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)

    11:42:10,497 DEBUG [org.jboss.as.security] (MSC service thread 1-3) Cannot create permissions with 'null' metaData for id=frigg.war

    This seems to be a JACC security issue? I havn't figured out how to supply the needed metaData.

    The deployment of the war fails with:

    "JBAS014771: Services with missing/unavailable dependencies" = ["jboss.data-source.jboss/datasources/jdbc/FriggDbjboss.jdbc-driver.ojdbc6_jarMissing[jboss.data-source.jboss/datasources/jdbc/FriggDbjboss.jdbc-driver.ojdbc6_jar]"]}

    I'm not seeing that the -ds.xml file is being processed in the logs...if I add an invalid tag, I get a parse exception, so I guess it is being processed.

    here is my -ds.xml file:

    ?xml version="1.0" encoding="UTF-8"?

    datasources xmlns="http://www.jboss.org/ironjacamar/schema"

    datasource jta="false" jndi-name="java:jboss/datasources/jdbc/FriggDb" pool-name="friggPool" enabled="true" use-ccm="false"

    connection-urljdbc:oracle:thin:@192.168.5.55:1521:xe/connection-url

    driver-classoracle.jdbc.OracleDriver/driver-class

    driverojdbc6.jar/driver

    pool

    max-pool-size30/max-pool-size

    /pool

    security

    user-namefoo/user-name

    passwordbar/password

    /security

    /datasource

    /datasources

    If the deployment succeeds what driver name is it given?

    Thanks!

    -Robert

    DB:2.96:Deployable Data Sources In Jboss 7.1.1 (Deployment Of Driver And Datasource) pj


    Hi,

    I'm having problems deploying a datasource along with the jdbc driver in a war (OracleDriver). I'm running a standalone server.

    This posting suggests that this is possible:

    http://www.mastertheboss.com/jboss-datasource/jboss-as-7-deployable-datasources

    Is this correct?

    I've got the ojdb6.jar in the WEB-INF/lib folder and I've got a mysource-ds.xml file in WEB-INF.

    The deployment of the JDBC driver seems to fail with:

    1:42:10,497 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)

    11:42:10,497 DEBUG [org.jboss.as.security] (MSC service thread 1-3) Cannot create permissions with 'null' metaData for id=frigg.war

    This seems to be a JACC security issue? I havn't figured out how to supply the needed metaData.

    The deployment of the war fails with:

    "JBAS014771: Services with missing/unavailable dependencies" = ["jboss.data-source.jboss/datasources/jdbc/FriggDbjboss.jdbc-driver.ojdbc6_jarMissing[jboss.data-source.jboss/datasources/jdbc/FriggDbjboss.jdbc-driver.ojdbc6_jar]"]}

    I'm not seeing that the -ds.xml file is being processed in the logs...if I add an invalid tag, I get a parse exception, so I guess it is being processed.

    here is my -ds.xml file:

    ?xml version="1.0" encoding="UTF-8"?

    datasources xmlns="http://www.jboss.org/ironjacamar/schema"

    datasource jta="false" jndi-name="java:jboss/datasources/jdbc/FriggDb" pool-name="friggPool" enabled="true" use-ccm="false"

    connection-urljdbc:oracle:thin:@192.168.5.55:1521:xe/connection-url

    driver-classoracle.jdbc.OracleDriver/driver-class

    driverojdbc6.jar/driver

    pool

    max-pool-size30/max-pool-size

    /pool

    security

    user-namefoo/user-name

    passwordbar/password

    /security

    /datasource

    /datasources

    If the deployment succeeds what driver name is it given?

    Thanks!

    -Robert

  • RELEVANCY SCORE 2.96

    DB:2.96:Componet Information 39


    When I run Universal installer in Oracle 10g, I got the following list of cmponent_
    1. Oracle database 10g 10.2.0.1.0

    2. Oracle Enterprise manager Console DB 10.2.0.1.0

    3. Enterprise edition option 10.2.0.1.0

    4. Oracle Net Services 10.2.0.1.0

    5. Oracle call Interface

    6. Oracle Programmer 10.2.0.1.0

    7. Oracle XML Development Kit 10.2.0.1.0

    8. Oracle windows interface 10.2.0.1.0

    9. iSQL *plus 10.2.0.1.0

    10. Installation Configuration files 10.2.0.1.0

    11. Oracle Universal Installer 10.2.0.1.0

    12. Oracle one off patch installer 10.2.0.1.0

    13. Oracle JDBC thin driver for JDK1.2 10.2.0.1.0.

    Can anybody give me use and description of each of these component? Thanx in advance.

    DB:2.96:Componet Information 39

    Please read the concepts guides to have overviews. You can search for such information here;

    http://www.oracle.com/pls/db102/search?word=Oracle+database+partno=

    Adith

  • RELEVANCY SCORE 2.96

    DB:2.96:Getting Error While Connecting Sql Server 2008 Via Jdbc Driver From Java Application xz


    Hi All,
    I am getting below error while connecting Java application from JDBC driver to reading SQL Server 2005 database. I alredy updated JDVC 3.0 driver in my machine and use KB artical http://support.microsoft.com/kb/915834
    but still not solve this issue. I can easily insert data in database but getting error while reading it.

    Caused by:
    java.sql.SQLException:
    [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (): Data type 0x38 is unknown.

  • RELEVANCY SCORE 2.95

    DB:2.95:Jdbc Driver For Ms Access df


    Where can I download a free JDBC driver for MS Access?

    DB:2.95:Jdbc Driver For Ms Access df

    I Think MS Acess uses ODBC. If you installed Access and Java, you should already have the JDBC-ODBC bridge driver. It is available free from Sun.

  • RELEVANCY SCORE 2.95

    DB:2.95:J2ee 1.4: How To Add A Jdbc Driver? 1a


    In older J2EE there was a j2eeadmin -addJDBCDriver function. but how can i add a JDBC driver to the Sun Appserver 8? In the admin console, i can set up connection pool/datasource but ic an#t find a "add JDBC driver".

    DB:2.95:J2ee 1.4: How To Add A Jdbc Driver? 1a

    You can also just add the classes to domains1/domain/lib/ext

    This is a bit less errorprone than modifying the classpath suffix for adding new drivers.

    For properties, you will want to consult your driver docs for specific details as to which DataSource properties are relevant for what you are trying to do.

    in the fcs developers guide we tried to list the properties that we used when testing internally

  • RELEVANCY SCORE 2.95

    DB:2.95:Which Jdbc Driver Can I Use zf


    Hi to all
    For my pplication iam using
    Java 1.6 , postgresql 8.1
    which Jdbc driver can i use .Which driver more suitable for that requirement?

    DB:2.95:Which Jdbc Driver Can I Use zf

    duffymo wrote:
    True. I'd prefer jTDS to Microsoft's offering for SQL Server. But the general rule is a good one.

    %Agreed, since the advent of JDBC, I've only used a 3rd party driver once, and it was for some funky reason that is probably rare.

  • RELEVANCY SCORE 2.95

    DB:2.95:Using Thin Jdbc Driver 33


    Hai

    I want to use thin jdbc driver

    con=DriverManager.getConnection(
    "jdbc:oracle:thin:@machine_hosting_database:1521:database_name","scott","tiger");

    What i want to know is :

    1) WHAT IS THE MACHINE_HOSTING DADABASE AND PORT NO, AND HOW I CAN KNOW THAT FOR MY SYSTM

    my database and tomcat r installed on the same system

    thanks,
    BYE.

    DB:2.95:Using Thin Jdbc Driver 33

    waht about sid number,it is showing some thing like 'PLSExtProc'.

    When i tryed with this it is saying no more data to read from socket

    thanks

  • RELEVANCY SCORE 2.95

    DB:2.95:Getting Driver While Connecting To Oracle. z1



    HiI am trying to import Oracle tables into Teiid designer.Steps i performed:1) Created a new model project Named "Portfolio"2) Right clicked on this and within the pop-menu i selected Import3) Then i used Metadata from JDBC database this opens a window "Import Database via JDBC"4) Then i clicked on the Source Button.5) The I clicked on Add button to add new source.6) Then I gave Name as "Oracle JDBC"7) Then i selected Driver as ODBC via DSN.8) I updated the URL with the DSN i use in my application to connect to Oracle9) Then i provided the User Name.10) When i tested the connection it says "Connection succeeded".11) Then control came back to Import Database Via JDBC where i can see the DSN which i specified in step 8.12) Then i clicked Next and it open up with the "select database Metadata" and different tables types.13) I selected all and clicked Next.14) I see all the tables within the schema.15) I selected only 2 tables clicked Next..then i got the below error.[Microsoft][ODBC driver for oracle]Driver not capableI am using windows xp.I tried using SQL Server by following same above steps, there i can't see the database which i used in DSN. I only master database.So i am almost dead in water... I spent 1 full day to figure it out..but getting same problem over and over...The question which i have is am i following the right direction!!! is there any better way to do this??Thanks -- Vijaya Kadiyala

    DB:2.95:Getting Driver While Connecting To Oracle. z1


    Hi RameshThank you for your quick turn around. I will use this driver and will post more log information around using DSN.Thanks -- Vjwww.DotNetVJ.com

  • RELEVANCY SCORE 2.94

    DB:2.94:Jdbc Oracle9i 8d


    where can i find the jdbc driver for oracle9i

    DB:2.94:Jdbc Oracle9i 8d

    Get it at http://learnat.sait.ab.ca/ict/CMPP263_watson/Root%20level%20pages/assignments.htm

    Click on either classes11.zip or classes12.zip and give me my dam dollars!!!! lol, jk

  • RELEVANCY SCORE 2.94

    DB:2.94:Problem About Jdbc x3


    when I use JDBC-ODBC bridge to assess ms sqlserver 7.0,the driver always returns extra blanks on varchar column.For example,when the column length is 10 and the value is 'abc',the getString() always returns 'abc' with extra 7 blanks,exactly 10 bytes.I have tried some other drivers including MS sqlserver jdbc driver and j-connect and tds,the results are same.
    have anybody encountered such problem?can anybody please help me? thanks a lot!

    DB:2.94:Problem About Jdbc x3

    Thank you for answer my question.
    but the problem is so curious!I download the jturbo driver and use it,but the symptom is the same,can anybody please tell me the reason?
    I am using jdkse 1.4,win98,ms sqlserver 7.0 on winnt 4.0
    I use other program such as visual foxpro and powerbuilder and isql,the result are correct.so I think this is not sqlserver's problem.

  • RELEVANCY SCORE 2.94

    DB:2.94:Linux And 8.1.7 Jdbc Driver ms


    Where can I download the Oracle 8.1.7 jdbc driver for Linux?

    DB:2.94:Linux And 8.1.7 Jdbc Driver ms

    The Oracle JDBC driver comes with Oracle Client.

  • RELEVANCY SCORE 2.94

    DB:2.94:Can't Registeroutparameter Of Cursor Type In Sql Server 2000 cz


    Hi, there,

    I'm using SQL Server 2000 and a type 4 JDBC driver for it from JRun 3.1. I wrote a stored procedure which has a Cursor (ResultSet) as an output parameter. But I used callStmt.registerOutParameter(1, java.sql.Types.OTHER);
    I got an exception:
    callable stmt class: allaire.jrun.db.jdbc.base.BaseCallableStatement

    java.sql.SQLException: [JRun][SQLServer JDBC Driver]The specified SQL type is not supported by this driver.

    I definitely want the cursor to be an output parameter in my SQL 2000 store procedure, rather than defining a store procedure without an output Cursor parameter and then use callStmt.getResultSet();
    Does any one knows a way to register an output parameter of type CURSOR in SQL Server 2000 JDBC?

    I know that with in Oracle JDBC driver, you can do this:
    callStmt.registerOutParameter(1, OracleTypes.CURSOR);
    ButI failed to find a equivalent in SQL Server 2000 JDBC driver.

    Thanks a lot.

    DB:2.94:Can't Registeroutparameter Of Cursor Type In Sql Server 2000 cz

    If you found any solution to this, would you please let me know too? It'll help a tonne.

  • RELEVANCY SCORE 2.93

    DB:2.93:Can I Use Jdbc Driver 8.1.7 To Access The Oracle 8.0.6 And Oracle 7.3.4.3? fp


    Thanks

    DB:2.93:Can I Use Jdbc Driver 8.1.7 To Access The Oracle 8.0.6 And Oracle 7.3.4.3? fp

    you can

    http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/getsta.htm#1008206

  • RELEVANCY SCORE 2.93

    DB:2.93:Help!: Jdbc Driver Classes12.Zip s8


    I use Oracle8i v. 8.1.6 release 2 under Linux platform (RH 7).
    I found out that there's no 'classes12.zip' file (the JDBC Driver supports JDK1.2) in my $ORACLE_HOME/jdbc/lib. It only got:
    classes111.zip
    classes111_g.zip
    jndi.zip
    jta.zip
    nls_charset11.zip

    What should I do?
    Is there any download/cure for this?

    Thank you.

    DB:2.93:Help!: Jdbc Driver Classes12.Zip s8

    Hi,
    download at http://otn.oracle.com/software

  • RELEVANCY SCORE 2.93

    DB:2.93:Strange 9.2.0.3 Jdbc Driver Behaviour kf


    Hello,

    I've tried to test 2 jdbc driver releases with my oracle database and i've a strange behaviour.
    The 9.2.0.3 jdbc driver takes lot of time when I do a preparedStatement and I use a timestamp as parameter.

    First test with old driver :

    =============
    Database Product Name is ... Oracle
    Database Product Version is Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
    JServer Release 8.1.7.4.0 - Production
    =============
    JDBC Driver Name is ........ Oracle JDBC driver
    JDBC Driver Version is ..... 8.1.6.2.0
    JDBC Driver Major Version is 8
    JDBC Driver Minor Version is 1
    =============
    == Time in executeQuery : 61 ms

    Second Test with last driver :

    =============
    Database Product Name is ... Oracle
    Database Product Version is Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
    JServer Release 8.1.7.4.0 - Production
    =============
    JDBC Driver Name is ........ Oracle JDBC driver
    JDBC Driver Version is ..... 9.2.0.3.0
    JDBC Driver Major Version is 9
    JDBC Driver Minor Version is 2
    =============
    == Time in executeQuery : 50545 ms

    the program is the same. Just use a different jdbc driver release for execution.
    The problem doesn't appear when the parameter is not a timestamp.

    There is a solution ?

    Thank you

    DB:2.93:Strange 9.2.0.3 Jdbc Driver Behaviour kf

    Hi Chris,br
    I've noticed a related problem using the 9i JDBC Thin driver.br
    I have a similar situation where I want to select rows from a large table that has an index on a DATE column.br
    br
    If I use iPreparedStatement.setTimestamp(int, Timestamp)/i to bind a timestamp value, the index is not used (the query takes ~30,000 milliseconds to execute).br
    But if I use iPreparedStatement.setTimestamp(int, Timestamp, Calendar)/i instead, the bindex is now used/b (the query only takes ~900 milliseconds to execute).br
    br
    It appears that the iPreparedStatement.setTimestamp(int, Timestamp)/i is returning a different bind variable to iPreparedStatement.setTimestamp(int, Timestamp, Calendar)/i... br
    the question is why??br
    Matt

  • RELEVANCY SCORE 2.93

    DB:2.93:Character Set Conversion Java Stored Procedures Vs. Jdbc Applications ?! x1


    We have an Oracle 8i database with internal character set UTF-8. Inside
    a Java stored procedure I can access my XML document through JDBC
    and I get the document in UTF-8 format without conversion. When I use nearly
    the same code inside a standalone JDBC client application Oracle tries
    to convert the document to ISO-8859-1 although the NLS_LANG parameter
    is set correctly to ".UTF8". When I run sqlplus in the same client
    environment Oracle make no character set conversion - just with JDBC.
    I also tried working with the thin and the oci8 JDBC driver - without
    any success. I also tried different JDK's (1.1.6 - 1.3.0) - also without
    any success.

    Does anyone know a solution for this problem ?

    Kind regards,
    Andreas Jung

    DB:2.93:Character Set Conversion Java Stored Procedures Vs. Jdbc Applications ?! x1

    We have an Oracle 8i database with internal character set UTF-8. Inside
    a Java stored procedure I can access my XML document through JDBC
    and I get the document in UTF-8 format without conversion. When I use nearly
    the same code inside a standalone JDBC client application Oracle tries
    to convert the document to ISO-8859-1 although the NLS_LANG parameter
    is set correctly to ".UTF8". When I run sqlplus in the same client
    environment Oracle make no character set conversion - just with JDBC.
    I also tried working with the thin and the oci8 JDBC driver - without
    any success. I also tried different JDK's (1.1.6 - 1.3.0) - also without
    any success.

    Does anyone know a solution for this problem ?

    Kind regards,
    Andreas Jung

  • RELEVANCY SCORE 2.93

    DB:2.93:Unsupported Method Setfetchsize() When Using Oracle 7 Jdbc... d1


    When I use oracle 7 JDBC (7.3.4) thin driver to connect to database and create an web JSP application like in tutorial, an error occured:
    oracle.jdbc.driver.OracleStatement: unsupported method setFetchSize()

    I checked with the API and it's only a JDBC 2.0 method! So it means I cannot use oracle 7 JDBC driver to create a JSP application with just using the wizards? Any way to workaround without installing newer JDBC driver? Thank you

    DB:2.93:Unsupported Method Setfetchsize() When Using Oracle 7 Jdbc... d1

    Thanks for your reply. Then I have no way other than contact the server admin to upgrade it as I don't have right to upgrade it. But this leads to another problem. After I successfully developed a business component for an oracle 7.2.2 database and test it with the tester, an error "unsupported version: the minimum supported version is oracle 7.2.3" Is that true? Thanks

  • RELEVANCY SCORE 2.92

    DB:2.92:Jdbc Driver For Sql Server 7 sc


    Hi,

    Are there any JDBC Drivers for SQL Server 7. If so, any i can download with out paying it....

    Thanks in advance.

    DB:2.92:Jdbc Driver For Sql Server 7 sc

    http://jtds.sourceforge.net/

    or the JdbcOdbcDriver...

    or search Google...

  • RELEVANCY SCORE 2.92

    DB:2.92:Oracle 816, Jdk1.3 And Jdbc Oci8 Compatibility sp


    Hi,
    I'm using the oracle jdbc driver OCI8 for windows nt,
    (classes111.zip) with the java jdk1.1.8 on an oracle805 DB.

    All 's working well.
    But I have to deal with a new constraint, (imposed by an other java application running under the same aplication server) which is :
    = to use jdk1.3.1 and oracle 8.1.6.

    Therefore, I'm looking for a jdbc driver working with Oracle8.1.6 and JDK1.3.

    On the oracle site, I've found only the following JDBC drivers.
    1) Could you please explain me why Oracle doesn't provide a
    jdbc driver for oracle8.1.6 or/and JDK1.3.x ?
    2) Could you please tell me which driver I should use ?

    JDBC drivers from Oracle download site :
    -Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x for NT
    -Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.1.x for NT
    -Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.1.x for NT
    -Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.0.2 for NT
    -Version 8.0.5.2 JDBC(Thin and OCI) for NT
    -Version 8.0.4.0.6 for NT 4.0

    Thanks.

    g.nogier@innovatica.ch

    -------------------------------------
    JDK : 1.1.8
    -------------------------------------
    Oracle:
    -------------------------------------
    OCI8 :
    JDBC
    DRIVER
    -------------------------------------

    With the jdk1.3.1,
    - which oci8 oracle jdbc driver can I use ?
    -

    DB:2.92:Oracle 816, Jdk1.3 And Jdbc Oci8 Compatibility sp

    Hi,
    I'm using the oracle jdbc driver OCI8 for windows nt,
    (classes111.zip) with the java jdk1.1.8 on an oracle805 DB.

    All 's working well.
    But I have to deal with a new constraint, (imposed by an other java application running under the same aplication server) which is :
    = to use jdk1.3.1 and oracle 8.1.6.

    Therefore, I'm looking for a jdbc driver working with Oracle8.1.6 and JDK1.3.

    On the oracle site, I've found only the following JDBC drivers.
    1) Could you please explain me why Oracle doesn't provide a
    jdbc driver for oracle8.1.6 or/and JDK1.3.x ?
    2) Could you please tell me which driver I should use ?

    JDBC drivers from Oracle download site :
    -Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x for NT
    -Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.1.x for NT
    -Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.1.x for NT
    -Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.0.2 for NT
    -Version 8.0.5.2 JDBC(Thin and OCI) for NT
    -Version 8.0.4.0.6 for NT 4.0

    Thanks.

    g.nogier@innovatica.ch

    -------------------------------------
    JDK : 1.1.8
    -------------------------------------
    Oracle:
    -------------------------------------
    OCI8 :
    JDBC
    DRIVER
    -------------------------------------

    With the jdk1.3.1,
    - which oci8 oracle jdbc driver can I use ?
    -

  • RELEVANCY SCORE 2.92

    DB:2.92:Db2 Jdbc Error. Cli0601e pk


    Hallo,

    I am writing a jdbc application for Read / Write operation in Java. Here i implement several threads which perform Write+Read operations.

    Within each thread, there is a method called dbprocessing().

    which inturn calls DB2Write methods and then call DB2Read methods.
    Here i share a single connection between Write and Read Object., and i make sure they are closed at the end of the transaction.

    I receive this error for 1 or 2 threads out of 10 ,

    Error:[IBM][JDBC Driver] CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000

    Questions:

    1) i tried checking the connection obj, but its not null. can it be with Result set or with Statement/PreparedStatement.

    2) any suggestions for jdbc - db2 driver.

    Ref Configuration:

    1) IBM DB2 v 8 and FP (CSD 6.0)
    2) JDBC Driver - (java driver db2java.zip).

    DB:2.92:Db2 Jdbc Error. Cli0601e pk

    Hi,

    i did solve this problem on my own.

    i made a mistake in declaring the connection object as static. and hence since all the threads have the same.

    and i could then have one connection per thread, declaring them as not static.

    Srinu

    To have a better performance / better resource usage- we can share the statement object for multiple use of same SQL statements.

  • RELEVANCY SCORE 2.92

    DB:2.92:Jdbc Driver Requirements With Ifs? 1s


    I am trying to determine the JDBC driver requirements for use with iFS and I see conflicting information in iFS documention. The Installation Guide says that JDBC / OCI Driver for Java 1.1 is required, while the System Setup and Administration Guide shows that either the JDBC OCI Driver or thin driver are required. Can anyone provide clarity to this question?

    DB:2.92:Jdbc Driver Requirements With Ifs? 1s

    For 1.0, we have not certified with the thin driver. (It does work, though.)

  • RELEVANCY SCORE 2.92

    DB:2.92:Driver Class Name And Jdbc Url Format jz


    Hi,

    I'm trying to use the oracle jdbc driver to connect to an (what a surprise) oracle database.
    I need a 'driver class name' and the JDBC URL Format. But I cannot find these anywhere.

    Can anyone help me out here?

    Regards,
    Laurens

  • RELEVANCY SCORE 2.92

    DB:2.92:Oracle Thin Jdbc m9


    The download says that the thin driver is for NT. I develop on Windows 95 and Oracle is on a Unix computer.

    Can I use the thin JDBC driver?

    thanks.

    Marc

    DB:2.92:Oracle Thin Jdbc m9

    Marc:

    Yes. We developed an application on NT and deployed it to both NT and Win95 using the thin driver.
    Chris

  • RELEVANCY SCORE 2.92

    DB:2.92:Coldfusion Jdbc Driver Setting az


    I have coldfusionmx 7 installed on red hat linux enterprise 4
    .
    How can i change the coldfusion JDBC driver to oracle 10g
    JDBC driver, that's may be help me in solving problems " Net8
    protocol error" which occured when a stored procedure return ref
    cursor to coldfusion?

  • RELEVANCY SCORE 2.92

    DB:2.92:Tomcat4.0 Can't Find Jdbc Driver 3s


    i have added the JDBC driver to the /etc/profile (linux)
    for example:
    CLASSPATH=/urs/local/jdbc/class12.zip

    when i start tomcat,

    [root@testing bin]# ./startup.sh
    Using CLASSPATH: /usr/local/tomcat/bin/bootstrap.jar:/jdk/lib/tools.jar
    Using CATALINA_BASE: /usr/local/tomcat
    Using CATALINA_HOME: /usr/local/tomcat
    Using JAVA_HOME: /jdk
    it shows that tomcat can't find jdbc driver(/urs/local/jdbc/class12.zip) from the classpath.

    when i use tomcat 3.2.23,it can find the jdbc from the classpath.

    how can i set tomcat4.0 to find the jdbc??
    thans a lot!!

    DB:2.92:Tomcat4.0 Can't Find Jdbc Driver 3s

    in windows 2000,I use tomcat 4.0-b7,also can't load the oracle jdbc driver,
    I check the starup.bat and catalian.sh file,
    found that it when tomcat start,it only load jdk1.3 classpath,if you use another jdbc driver,just add your jdbc path to the bash file "classpath" .

    I think it is the same in linux.

  • RELEVANCY SCORE 2.91

    DB:2.91:Jdbc Driver s1



    How I can obtain the JDBC driver called "MSSQLServer4 version 5.1.0 for SQL Server
    7 and 2000", that is part of "BEA Weblogic Server version 5.1.0"?

    Thanks in advance.

    DB:2.91:Jdbc Driver s1


    How I can obtain the JDBC driver called "MSSQLServer4 version 5.1.0 for SQL Server
    7 and 2000", that is part of "BEA Weblogic Server version 5.1.0"?

    Thanks in advance.

  • RELEVANCY SCORE 2.91

    DB:2.91:Creating A Connection Pool ma


    Hi,
    I am a beginner and has just installed Sun Java System Application Server 8. I wanted to create a Connection Pool to MS SQL server 2000. I didnt know what parameters are to be given. Like the JDBC drivers to be used etc. Is there a free available driver? Can i use the JDBC - ODBC bridge driver? If yes, how?
    Thanx for all your time.
    Regards

    DB:2.91:Creating A Connection Pool ma

    Ok...

    Still trying to get this working... I changed the driver name. I've been using a different one. Now I'm getting a different error. Could someone post examples of properties AND values that they use?

    INFO: CORE5076: Using [Java HotSpot(TM) Server VM, Version 1.4.2_02] from [Sun Microsystems Inc.]
    INFO: JMS5023: JMS service successfully started. Instance Name = domain1_server1, Home = [C:\Sun\AppServer7\imq\bin].
    INFO: JTS5014: Recoverable JTS instance, serverId = [100]
    INFO: RAR5060: Install JDBC Datasources ...
    INFO: RAR5059: Binding [JDBC DataSource Name: jdbc/webValueCity, Pool Name: Orion_VC]
    INFO: JMS5015: Install JMS resources ...
    INFO: WEB0100: Loading web module [dbping] in virtual server [server1] at [dbping]
    INFO: HTTP3072: HTTP listener http-listener-1 [http://yutzid:80] ready to accept requests
    startup: server started successfully
    INFO: CORE3274: successful server startup
    INFO: CORE5053: Application onReady complete.
    INFO: CORE3282: stdout: dispatching
    INFO: CORE3282: stdout: Jndi name jdbc/webValueCity
    WARNING: CORE3283: stderr: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
    INFO: CORE3282: stdout: dispacthing ..... to jsp
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.sqlserver.tds.TDSConnection.init(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
    WARNING: CORE3283: stderr: at com.microsoft.jdbcx.base.BaseDataSource.getConnection(Unknown Source)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.JdbcUrlAllocator.createResource(JdbcUrlAllocator.java:88)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASNonSharedResourcePool.java:856)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResourcePool.java:416)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNonSharedResourcePool.java:625)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedResourcePool.java:520)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:263)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.JdbcXAConnection.init(JdbcXAConnection.java:74)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.Jdbc10XaAllocator.createResource(Jdbc10XaAllocator.java:94)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASNonSharedResourcePool.java:856)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResourcePool.java:416)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNonSharedResourcePool.java:625)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedResourcePool.java:520)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:263)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:170)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.JdbcDataSource.internalGetConnection(JdbcDataSource.java:241)
    WARNING: CORE3283: stderr: at com.sun.enterprise.resource.JdbcDataSource.getConnection(JdbcDataSource.java:98)
    WARNING: CORE3283: stderr: at Connect.doGet(Connect.java:158)
    WARNING: CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
    WARNING: CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrapperValve.java:720)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.java:118)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.java:278)
    WARNING: CORE3283: stderr: at java.security.AccessController.doPrivileged(Native Method)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:274)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:212)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203)
    WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
    WARNING: CORE3283: stderr: at com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java:157)
    WARNING: CORE3283: stderr: at com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)

  • RELEVANCY SCORE 2.91

    DB:2.91:Requirements For Jdbc Driver Needed For Soa 8 }Connection Pool c8


    Hi,

    I have an AS400 jdbc driver. This driver is JDBC API version 2.x. Also is a Driver Type 4.

    What are the requirements of a JDBC Driver needed for connection pool in SOA 8?

    Thanks.

    Lorenzo Jimenez

    DB:2.91:Requirements For Jdbc Driver Needed For Soa 8 }Connection Pool c8

    You can use pretty much any jdbc driver, including type 2 and type 4.

    You need to make sure your shared libraries needed by the driver are available to the appserver when you boot.

    Other than that, it is no different than configuring any other driver.

  • RELEVANCY SCORE 2.91

    DB:2.91:Which Odbc Driver For Personal Oracle8? ck


    --
    I'm using Personal Oracle8 and trying to connect via ODBC from a
    Java program using JDBC. I can connect to MS Access 7 via ODBC
    but I cannot connect to Personal Oracle8 using the delivered
    ODBC 8 driver (8.0.4.0). Looking through the technet product
    listing, the other ODBC 8 drivers only work with NT. I'm using a
    laptop with Windows98. I'm stumped. What should I use and where
    do I download it from please?

    Thanks in advance,
    Dave
    null

    DB:2.91:Which Odbc Driver For Personal Oracle8? ck

    --
    Are you connecting via a JDBC-ODBC bridge or just using the
    native JDBC driver? The ODBC drivers (or JDBC drivers for that
    matter) don't care if they run on WIndows 9x or NT. The problem
    here might be that you are using Personal Oracle. This version is
    not intended to be remotely connected to (i.e. from a remote
    machine) -- it is only intended for bequeath connections (i.e.
    processes local to the RDBMS). You CAN start a listener on the PO
    RDBMS (it isn't running by default), although that really isn't
    what it is intended to do (i.e. be a server). Try using the
    workgroup or enterprise server instead.

    The ODBC (and JDBC drivers) will need a listener running to
    connect remotely (which is probably the source of your trouble).
    null

  • RELEVANCY SCORE 2.90

    DB:2.90:Cannot Find Oracle 8.1.7.4 Jdbc Thin Driver On Download Page zf


    I cannot find oracle 8.1.7.4 JDBC thin driver for solaris platform from the JDBC driver download page. How can I obtain such JDBC thin driver ?

    DB:2.90:Cannot Find Oracle 8.1.7.4 Jdbc Thin Driver On Download Page zf

    Oracle Support advised me previously (TAR 2843333.999 at MetaLink) to post a feedback to technet site regarding this problem.

    Below is their advice :
    "
    Hi James

    These are the officially certified methods :

    1. Since there is no 8.1.7.2 or higher JDBC Drivers available on technet, You will have to give feedback in the technet
    site for providing 8.1.7.4 JDBC Drivers or 8.1.7.1B JDBC Drivers as Oracle Support DO NOT support software download on technet site.
    URL :
    http://otn.oracle.com/contact/content.html

    OR

    2. You can request for a 8.1.7 CD and download the patchset, Apply the patchset 8.1.7.1B or higher version
    and then extract the classes12.zip from the RDBMS 8.1.7.1B or higher. Then include this file in your classpath.

    The file from our Test servers was sent to you for testing purpose to confirm if the issue reproduces with 8174 drivers.

    I undertsand that the option of upgrading RDBMS is not preferrable. The Bug: 1454333 was logged for OCI Drivers, but this
    holds for Thin Driver as well, as the problem is with OraclePreparedStatement.class, OracleStatement.class, OracleCallableStatement.class The changes were made to these classes, hence it is not required to apply rdbms patch. But the Drivers are not available on Technet to download hence the above given methods can be used to get the drivers.
    Also the patchset can not be applied to only particular components like JDBC, hence you need to either apply for rdbms(on some test setup...to extract the file later)/ download it from technet.

    Regards,
    Oracle Support
    "

    Anyway, I will also post to forum 99 to see if I can get any help.

    Regards,
    James

  • RELEVANCY SCORE 2.90

    DB:2.90:Cannot Find 8.1.7.4 Jdbc Thin Driver From Download Page xz


    I cannot find oracle 8.1.7.4 JDBC thin driver for solaris platform from the JDBC driver download page. How can I obtain such JDBC thin driver ?

    DB:2.90:Cannot Find 8.1.7.4 Jdbc Thin Driver From Download Page xz

    No, we cannot use 9i drivers. Because we are using iPlanet's iAS as application server, and the iPlanet version we are using does not support oracle 9i. It only support oracle 8i.

    James

  • RELEVANCY SCORE 2.90

    DB:2.90:How Can I Use Two Datasource? ak



    Hi, I have jboss 3.0.7 and I lake to use two database conection, I try to use two datasource , db1-service.xml and db2-service.xml, the database is in SQL Server, but when y run Jboss server only one datasource is correct. What can I do to use both.Thanks for all.Urgent please!My xml files:jbosscmp-jdbc java:/DefaultDS datasource-mappingMS SQLSERVER2000/datasource-mapping create-tabletrue/create-table remove-tablefalse/remove-table tuned-updatestrue/tuned-updates read-onlyfalse/read-only time-out0/time-out pk-constrainttrue/pk-constraint fk-constraintfalse/fk-constraint row-lockingfalse/row-locking preferred-relation-mappingforeign-key/preferred-relation-mapping read-ahead on-load page-size1000/page-size eager-load-group*/eager-load-group /read-ahead list-cache-max1000/list-cache-max java:/DefaultDS2 datasource-mappingMS SQLSERVER2000/datasource-mapping create-tabletrue/create-table remove-tablefalse/remove-table tuned-updatestrue/tuned-updates read-onlyfalse/read-only time-out0/time-out pk-constrainttrue/pk-constraint fk-constraintfalse/fk-constraint row-lockingfalse/row-locking preferred-relation-mappingforeign-key/preferred-relation-mapping read-ahead on-load page-size1000/page-size eager-load-group*/eager-load-group /read-ahead list-cache-max1000/list-cache-max type-mappings type-mapping McKoi row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mappingTRUE/true-mapping false-mappingFALSE/false-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBOOLEAN/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeBIGINT/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeFLOAT/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(64)/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.lang.Object/java-type jdbc-typeJAVA_OBJECT/jdbc-type sql-typeJAVA_OBJECT/sql-type /type-mapping type-mapping InterBase row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeNUMERIC(18,0)/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeFLOAT/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE PRECISION/sql-type java-typejava.lang.Character/java-type jdbc-typeVARCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(64)/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.lang.Object/java-type jdbc-typeJAVA_OBJECT/jdbc-type sql-typeVARCHAR(2000)/sql-type /type-mapping type-mapping DB2 row-locking-template/ pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeSMALLINT/sql-type !-- DB2 does not appear to support columns of type "byte" Regrettably, this means they'll be serialized. java-typejava.lang.Byte/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR(1) FOR BIT DATA/sql-type -- java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeBIGINT/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeREAL/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(254)/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.lang.Object/java-type jdbc-typeJAVA_OBJECT/jdbc-type sql-typeBLOB(2000)/sql-type /type-mapping type-mapping Oracle9i !-- | Make sure that you have the Oracle 9i version of classes12.jar | or you will suffer -- row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length30/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 || ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstr(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllength(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqlinstr(?2, ?1, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeNUMBER(1)/sql-type java-typejava.lang.Byte/java-type jdbc-typeSMALLINT/jdbc-type sql-typeNUMBER(3)/sql-type java-typejava.lang.Short/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMBER(5)/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeNUMBER(10)/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeNUMBER(19)/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeNUMBER(38,7)/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeDECIMAL/jdbc-type sql-typeNUMBER(38,15)/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeNUMBER(38,15)/sql-type java-typejava.lang.Character/java-type jdbc-typeVARCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR2(255)/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP(3)/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP(9)/sql-type java-typejava.lang.Object/java-type jdbc-typeBLOB/jdbc-type sql-typeBLOB/sql-type !-- | Change this from BLOB to RAW(n) if you know your | serialized object will be = n bytes and n = 2000 -- /type-mapping type-mapping Oracle8 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length30/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 || ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstr(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllength(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqlinstr(?2, ?1, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeNUMBER(1)/sql-type java-typejava.lang.Byte/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMBER(3)/sql-type java-typejava.lang.Short/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMBER(5)/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeNUMBER(10)/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeNUMBER(19)/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeNUMBER(38,7)/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeDECIMAL/jdbc-type sql-typeNUMBER(38,15)/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeNUMBER(38,15)/sql-type java-typejava.lang.Character/java-type jdbc-typeVARCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR2(255)/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeDATE/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATE/sql-type java-typejava.lang.Object/java-type jdbc-typeBLOB/jdbc-type sql-typeBLOB/sql-type !-- | Change this from BLOB to RAW(n) if you know your | serialized object will be = n bytes and n = 2000 -- /type-mapping type-mapping Oracle7 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length30/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 || ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstr(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllength(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqlinstr(?2, ?1, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeNUMBER(1)/sql-type java-typejava.lang.Byte/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMBER(3)/sql-type java-typejava.lang.Short/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMBER(5)/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeNUMBER(10)/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeNUMBER(19)/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeNUMBER(38,7)/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeNUMBER(38,15)/sql-type java-typejava.lang.Character/java-type jdbc-typeVARCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR2(255)/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeDATE/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATE/sql-type java-typejava.lang.Object/java-type jdbc-typeLONGVARBINARY/jdbc-type sql-typeLONG RAW/sql-type !-- | Change this from LONG RAW to RAW(n) if you know your | serialized object will be = n bytes and n = 2000 | Oracle only permits one LONG type per table -- /type-mapping type-mapping Sybase row-locking-template/ pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBIT/sql-type !-- Current Sybase JDBC drivers (jConnect 5.2) don't support byte or short. Unfortunately they'll be serialized. java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeTINYINT/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type -- java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Long/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMERIC(38,0)/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeREAL/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE PRECISION/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(255)/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATETIME/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeSMALLDATETIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATETIME/sql-type java-typejava.lang.Object/java-type jdbc-typeJAVA_OBJECT/jdbc-type sql-typeIMAGE/sql-type /type-mapping type-mapping PostgreSQL row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mappingTRUE/true-mapping false-mappingFALSE/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 || ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllength(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sql(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(CAST(?1 AS double precision))/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Boolean/java-type jdbc-typeCHAR/jdbc-type sql-typeBOOLEAN/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeINT2/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeINT2/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINT4/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeINT8/sql-type java-typejava.lang.Float/java-type jdbc-typeFLOAT/jdbc-type sql-typeFLOAT(7)/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeFLOAT8/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR(1)/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeTEXT/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMERIC/sql-type java-typejava.lang.Object/java-type jdbc-typeVARBINARY/jdbc-type sql-typeBYTEA/sql-type /type-mapping type-mapping PostgreSQL 7.2 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mappingTRUE/true-mapping false-mappingFALSE/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 || ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllength(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sql(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(CAST(?1 AS double precision))/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Boolean/java-type jdbc-typeCHAR/jdbc-type sql-typeBOOLEAN/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeINT2/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeINT2/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINT4/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeINT8/sql-type java-typejava.lang.Float/java-type jdbc-typeFLOAT/jdbc-type sql-typeFLOAT(7)/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeFLOAT8/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR(1)/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeTEXT/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeNUMERIC/jdbc-type sql-typeNUMERIC/sql-type java-typejava.lang.Object/java-type jdbc-typeVARBINARY/jdbc-type sql-typeBYTEA/sql-type /type-mapping type-mapping Hypersonic SQL row-locking-template/ pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-template/ alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping(1=1)/true-mapping false-mapping(1=0)/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 || ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlSUBSTRING(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllcase(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqlLENGTH(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqlLOCATE(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlABS(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlSQRT(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlucase(?1)/function-sql /function-mapping java-typejava.lang.Byte/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBIT/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Object/java-type !-- hsqldb only supports directly serializable objects for sql type OBJECT -- jdbc-typeVARBINARY/jdbc-type sql-typeVARBINARY/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATE/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeREAL/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeBIGINT/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeDECIMAL/jdbc-type sql-typeDECIMAL/sql-type /type-mapping type-mapping PointBase row-locking-template/ pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mappingTRUE/true-mapping false-mappingFALSE/false-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeFLOAT/sql-type java-typejava.lang.Float/java-type jdbc-typeFLOAT/jdbc-type sql-typeFLOAT/sql-type java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBOOLEAN/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.lang.Byte/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Object/java-type jdbc-typeBLOB/jdbc-type sql-typeBLOB/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type /type-mapping type-mapping SOLID row-locking-template/ pk-constraint-templatePRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeTINYINT/sql-type java-typejava.lang.Short/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.lang.Object/java-type jdbc-typeBLOB/jdbc-type sql-typeBLOB/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBIT/sql-type java-typejava.lang.Float/java-type jdbc-typeFLOAT/jdbc-type sql-typeFLOAT/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeBIGINT/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type /type-mapping type-mapping mySQL row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedfalse/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping function-mapping function-nameconcat/function-name function-sqlconcat(?1, ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllength(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqllocate(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Float/java-type jdbc-typeFLOAT/jdbc-type sql-typeFLOAT/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.lang.Boolean/java-type jdbc-typeTINYINT/jdbc-type sql-typeTINYINT/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.lang.Object/java-type jdbc-typeBLOB/jdbc-type sql-typeLONGBLOB/sql-type !-- | Change this from LONGBLOB to BLOB if you know your | serialized object will be = 2^16 bytes -- java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeTIMESTAMP/sql-type !-- | This type is problematical because mysql does not have any | date/time types that store milliseconds. You should avoid it. -- java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeTINYINT/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeBIGINT/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(250) BINARY/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATETIME/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATETIME/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeTIME/sql-type /type-mapping type-mapping MS SQLSERVER row-locking-templateSELECT ?1 FROM ?2 with (rowlock) WHERE ?3/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 + ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstring(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllen(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqlcharindex(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeDOUBLE/sql-type java-typejava.lang.Long/java-type jdbc-typeDECIMAL/jdbc-type sql-typeDECIMAL(20)/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.lang.Object/java-type jdbc-typeJAVA_OBJECT/jdbc-type sql-typeIMAGE/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeTINYINT/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATETIME/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATETIME/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeDATETIME/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATETIME/sql-type java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBIT/sql-type java-typejava.lang.Float/java-type jdbc-typeFLOAT/jdbc-type sql-typeFLOAT/sql-type /type-mapping type-mapping MS SQLSERVER2000 row-locking-templateSELECT ?1 FROM ?2 with (rowlock) WHERE ?3/row-locking-template pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping function-mapping function-nameconcat/function-name function-sql(?1 + ?2)/function-sql /function-mapping function-mapping function-namesubstring/function-name function-sqlsubstring(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-namelcase/function-name function-sqllower(?1)/function-sql /function-mapping function-mapping function-namelength/function-name function-sqllen(?1)/function-sql /function-mapping function-mapping function-namelocate/function-name function-sqlcharindex(?1, ?2, ?3)/function-sql /function-mapping function-mapping function-nameabs/function-name function-sqlabs(?1)/function-sql /function-mapping function-mapping function-namesqrt/function-name function-sqlsqrt(?1)/function-sql /function-mapping function-mapping function-nameucase/function-name function-sqlupper(?1)/function-sql /function-mapping java-typejava.lang.Integer/java-type jdbc-typeINTEGER/jdbc-type sql-typeINTEGER/sql-type java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR/sql-type java-typejava.lang.Short/java-type jdbc-typeSMALLINT/jdbc-type sql-typeSMALLINT/sql-type java-typejava.lang.Long/java-type jdbc-typeBIGINT/jdbc-type sql-typeBIGINT/sql-type java-typejava.math.BigDecimal/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type java-typejava.lang.Object/java-type jdbc-typeLONGVARBINARY/jdbc-type sql-typeIMAGE/sql-type java-typejava.lang.Byte/java-type jdbc-typeTINYINT/jdbc-type sql-typeTINYINT/sql-type !-- | Note that you lose granularity here | Use a numeric type and store milliseconds if you really need it -- java-typejava.sql.Timestamp/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATETIME/sql-type java-typejava.sql.Date/java-type jdbc-typeDATE/jdbc-type sql-typeDATETIME/sql-type java-typejava.sql.Time/java-type jdbc-typeTIME/jdbc-type sql-typeDATETIME/sql-type java-typejava.util.Date/java-type jdbc-typeTIMESTAMP/jdbc-type sql-typeDATETIME/sql-type java-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeBIT/sql-type java-typejava.lang.Float/java-type jdbc-typeREAL/jdbc-type sql-typeREAL/sql-type java-typejava.lang.Double/java-type jdbc-typeDOUBLE/jdbc-type sql-typeFLOAT/sql-type /type-mapping type-mapping DB2/400 row-locking-template/ pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)/fk-constraint-template alias-header-prefixt/alias-header-prefix alias-header-suffix_/alias-header-suffix alias-max-length32/alias-max-length subquery-supportedtrue/subquery-supported true-mapping1/true-mapping false-mapping0/false-mapping java-typejava.lang.Character/java-type jdbc-typeCHAR/jdbc-type sql-typeCHAR(1)/sql-type java-typejava.lang.String/java-type jdbc-typeVARCHAR/jdbc-type sql-typeVARCHAR(256)/sql-type !-- Apparent DB2/400 doesn't handle Byte type either java-typejava.lang.Byte/java-type jdbc-typeCHAR/

    DB:2.90:How Can I Use Two Datasource? ak


    Hi Diana,in the META-INF/jbosscmp-jdbc.xml file you can have one datasource element in the defaults section and one for each entity bean. Simply define for each of your entity beans the jndi-name of the datasource it should use.Regards,Harald

  • RELEVANCY SCORE 2.90

    DB:2.90:Jdbc Driver Name And Jdbc Url For Ms Access On Remote Machine ps


    Hi,
    I have a MS Access database on remote machine. And I want to acess that database on local machine.
    I am trying to Achive this in ODI.
    In ODI the database access parametes are JDBC driver name and JDBC URL.
    Is there any way to use JDBC url for accessing Remote DB? If Yes how it can be used?

    PS:- ON remote machine ODI is not installed.

    Edited by: MaheshGx on Dec 8, 2011 3:27 AM

    DB:2.90:Jdbc Driver Name And Jdbc Url For Ms Access On Remote Machine ps

    Hi,
    I have a MS Access database on remote machine. And I want to acess that database on local machine.
    I am trying to Achive this in ODI.
    In ODI the database access parametes are JDBC driver name and JDBC URL.
    Is there any way to use JDBC url for accessing Remote DB? If Yes how it can be used?

    PS:- ON remote machine ODI is not installed.

    Edited by: MaheshGx on Dec 8, 2011 3:27 AM

  • RELEVANCY SCORE 2.90

    DB:2.90:Where To Find Jdbc Driver For Ms Sql Server 7? kk



    Hello,I am a newbie, Can someone provide me a link from where I can download a JDBC driver for MS SQL Server v7.Thanks aheadRam.

    DB:2.90:Where To Find Jdbc Driver For Ms Sql Server 7? kk


    apart from jdbc-odbc bridge provided by sun, there are several source to get mssql6.5/7 jdbc driver:a) http://industry.java.sun.com/products/jdbc/drivers I use the driver of ATINAV which is very easy-used and powerful, and full java-based with just jar file, support mssql6.5/7.0 with many features such as datasource, connection pool, ...b) there is a open source software: www.objectweb.com

  • RELEVANCY SCORE 2.90

    DB:2.90:Jdbc Driver Info? pj



    HI,

    i am configuring jdbc sender adapter,

    can anyone guide me in getting Java class of the JDBC driver that the JDBC adapter must load to be able to access the driver.

    thanks,

    DB:2.90:Jdbc Driver Info? pj


    Hi Pratibha,

    You could see this..

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how%20to%20install%20and%20configure%20external%20drivers%20for%20jdbc%20and%20jms%20adapters.doc

    cheers,

    Prashanth

  • RELEVANCY SCORE 2.89

    DB:2.89:Jdbc Driver For Oracle/Rdb ? ad


    I would like to know if there is a Jdbc driver I can use to access an Oracle/RDB database ? I have found none, but I wonder whether using an Oracle Jdbc Driver with the SQL*Net for RDB product would do the job or not ?
    Thanks in advance.

    DB:2.89:Jdbc Driver For Oracle/Rdb ? ad

    If you are Using RDB 7.1, you can use the thin JDBC driver through SQL*Net. Also, RDB Engineering is about to release a JDBC driver for RDB.

  • RELEVANCY SCORE 2.89

    DB:2.89:Oracle Express Edition And Jdbc Licensing Question m8


    Hi all,

    I am writing a web application that requires a database to work. I also will be selling this application. which leads me to these questions:

    1) legally can i use the oracle express edition?

    2) legally can i use the oracle JDBC driver?

    Thanks,

    DB:2.89:Oracle Express Edition And Jdbc Licensing Question m8

    Based on the discussions in the XE forum (confirmed by Oracle representatives in official capacity) as well as the license agreement (which you should take to your lawyer tp etermine how to set up the paperwork for your application):

    You can include the Oracle Express Edition in your application. You can charge for your application and give no money back to Oracle for the use of Oracle Express Edition. You can distribute the client-side JDBC that is included in XE as well.

    But - you can not hold Oracle responsible for the operation of the database, nor ask them for support or patches.

    As Eric says - join us over in the XE forum for more discussion of this.

  • RELEVANCY SCORE 2.89

    DB:2.89:Connect Mssql2000 By Microsoft Jdbc Through Ejb 7a


    Dear All,
    I use Microsft JDBC to connect MSSQL2000, however, I can't connect to DB. Here is my step

    1 Install the SQL Server 2000 Driver for JDBC Service Pack 2
    2 Copy msbase.jar msutil.jar mssqlserver.jar to %J2EE_HOME%/lib/System directory
    3 Set the environment classpath
    D:\Sun\j2sdkee1.3.1\lib\system\msbase.jar;
    D:\Sun\j2sdkee1.3.1\lib\system\mssqlserver.jar;
    D:\Sun\j2sdkee1.3.1\lib\system\msutil.jar
    4 Change the resource.properties
    jdbcDataSource.5.name=jdbc/MSSQL
    jdbcDataSource.5.url=jdbc\:microsoft\:sqlserver\://localhost\:1433
    jdbcDriver.1.name=com.microsoft.jdbc.sqlserver.SQLServerDriver
    5 J2EE -verbose
    6 set APPCPATH=XXAppClient.jar
    7 runclient -client XX.ear -name XXClient -textAuth

    Error come out Unable to connect to database. No suitable Driver

    Does anyone have idea of my problem / or Does anyone success to connect MSSQL through
    other method can provide for me / or Does anyone LINKS have steps to connect to MSSQL.

    THX IN ADVANCE, URGENTS

    DB:2.89:Connect Mssql2000 By Microsoft Jdbc Through Ejb 7a

    I would strongly suggest that you figure out how to do this in a java application rather than trying to figure out how to do it in a container.

    Until you know exactly what you need to do to define the driver and connect, you shouldn't try to use a container.

  • RELEVANCY SCORE 2.89

    DB:2.89:Jdbc Pool Max Capacity Not Resetting After Change - 10.3.5 On Redhat 5.8 k3


    Hello:We created an ADF Web Application which is deployed on WebLogic 10.3.5. After reaching 15 JDBC Connections the application fails with the following error:oracle.jbo.DMLException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-26061.The error code JBO-26061 points to the source of the problem being a limited number of JDBC connections. The default is 15 for Maximum Capacity for JDBC Connections. After increasing the Max Capacity to 60 and restarting WebLogic, our application still fails after 15 connections. The pdev-jdbc.xml file is showing the correct updates to WebLogic. See below: But still WebLogic still allows only 15 JDBC connections.Is there anything else that must be done to allow WebLogic to increase the JDBC connections? What am I missing?Thanks for the help.?xml version='1.0' encoding='UTF-8'?jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd" namepdev/name jdbc-driver-params urljdbc:oracle:thin:@mrdr.labs.xxx.local:1521:mxx3/url driver-nameoracle.jdbc.xa.client.OracleXADataSource/driver-name properties property nameuser/name valuept/value /property /properties password-encrypted{AES}YFupoK1B5g0at3wfdRqMMfJ7oJrkIr2Zs=/password-encrypted /jdbc-driver-params jdbc-connection-pool-params initial-capacity30/initial-capacity max-capacity60/max-capacity capacity-increment2/capacity-increment test-table-nameSQL SELECT 1 FROM DUAL/test-table-name statement-cache-size10/statement-cache-size statement-cache-typeLRU/statement-cache-type /jdbc-connection-pool-params jdbc-data-source-params jndi-namejdbc/pdevDS/jndi-name global-transactions-protocolTwoPhaseCommit/global-transactions-protocol /jdbc-data-source-params/jdbc-data-source

    DB:2.89:Jdbc Pool Max Capacity Not Resetting After Change - 10.3.5 On Redhat 5.8 k3

    Hello:Thanks for the reply...I tried your suggestion, but it did not make a difference.Thanks much for the reply.

  • RELEVANCY SCORE 2.89

    DB:2.89:Jdbc Driver For Ms-Access d7


    hi, this is ravi kiran.

    I am trying to connect to ms-access using jdbc, there is now way that i can use jdbc-odbc bridge to connect to ms-access(because it needs creation of a dsn).

    I have been searching for a freeware jdbc driver for ms-access, but i am not able to find one.

    Is there any jdbc driver for ms-access that is freeware.

    help me.

    thanx in advance.

    DB:2.89:Jdbc Driver For Ms-Access d7

    You can use JDBC-ODBC without creating a DSN in your system ODBC settings.

    http://forum.java.sun.com/thread.jspa?threadID=5123254start=4

  • RELEVANCY SCORE 2.89

    DB:2.89:Microsoft Sql Or Jdbc Database Driver 1z


    Hello,
    My Network Server Admin guy just sent me this:

    "I have added the JDBC driver, however I want to confirm
    prior to changing the xxxxxx datasource to use the JDBC driver.
    You would like us to change from the Microsoft SQL driver to
    the JDBC database driver?"

    Question is , Which database driver does MX 7 use in
    connecting to MS SQL Server 2005?

    Presently it looks like we use Microsoft ODBC driver, do we
    change to JDBC and why?

    Thanks

    DB:2.89:Microsoft Sql Or Jdbc Database Driver 1z

    To confirm what version of the JDBC drivers you are using,
    run this code:
    cfset jdbcDriver = CreateObject("java",
    "macromedia.jdbc.sqlserver.SQLServerDriver")
    cfoutput
    JDBC version =
    #jdbcDriver.getMajorVersion()#.#jdbcDriver.getMinorVersion()#/p
    /cfoutput
    3.5 are the latest JDBC drivers available for ColdFusion MX
    The Adobe drivers can be found here:
    http://www.adobe.com/go/42dcb10a
    The Microsoft JDBC Driver can be found
    here
    The TechNote for this can be found here:
    http://www.adobe.com/go/ded4216b

  • RELEVANCY SCORE 2.89

    DB:2.89:Jdbc And Oracle Vrsion d8



    Hello:

    I am on charge of an installed weblogic server. One of the things I wanted to
    check is the configuration of the JDBC connections. I have used a test program
    I found in metalink and I saw the following:

    D:\jdbcjava JDBCVersion

    =============
    Database Product Name ... Oracle

    Database Product Version Oracle7 Server Release 7.3.3.6.0 - Production Release

    With the distributed, parallel query and Parallel Server options
    PL/SQL Release 2.3.3.6.0 - Production

    =============
    JDBC Driver Name ........ Oracle JDBC driver

    JDBC Driver Version ..... 8.1.7.1.0

    JDBC Driver Major Version 8

    JDBC Driver Minor Version 1

    =============
    As you can see the version of th DB is different from the JDBC driver, is it right?

    Please send any answer to mario.camunas@hp.com

    RegardsThanks,
    Mario.

    DB:2.89:Jdbc And Oracle Vrsion d8

    Generally, a newer client can talk to old servers without a problem.
    For example, the latest 10g client can talk to 10g, 9.X, and 8.1.7.

    You do have a problem that the server release that you are running is no
    longer supported
    by Oracle (or BEA).

    "Mario" mario.camunas@hp.com wrote in message
    news:400bb266$1@newsgroups.bea.com...

    Hello:

    I am on charge of an installed weblogic server. One of the things I wantedto
    check is the configuration of the JDBC connections. I have used a testprogram
    I found in metalink and I saw the following:

    D:\jdbcjava JDBCVersion

    =============
    Database Product Name ... Oracle

    Database Product Version Oracle7 Server Release 7.3.3.6.0 - ProductionRelease

    With the distributed, parallel query and Parallel Server options
    PL/SQL Release 2.3.3.6.0 - Production

    =============
    JDBC Driver Name ........ Oracle JDBC driver

    JDBC Driver Version ..... 8.1.7.1.0

    JDBC Driver Major Version 8

    JDBC Driver Minor Version 1

    =============
    As you can see the version of th DB is different from the JDBC driver, isit right?

    Please send any answer to mario.camunas@hp.com

    RegardsThanks,
    Mario.

  • RELEVANCY SCORE 2.89

    DB:2.89:Can I Use Jdbc Driver 8.1.7 To Access The Oracle 8.0.6 And Oracle 7.3.4.3? af


    Urgent, thanks!

    DB:2.89:Can I Use Jdbc Driver 8.1.7 To Access The Oracle 8.0.6 And Oracle 7.3.4.3? af

    According to the docs you should be able to. Have a look here:

    http://download-uk.oracle.com/docs/cd/A97688_07/generic.903/a96654/getsta.htm#1008206

    Cheers, Hans

  • RELEVANCY SCORE 2.89

    DB:2.89:Windows And Linux App sd


    I've created a JDBC app to connect a Mysql database, for use both in Windows and Linux.
    Though I'm using the same code, the same driver, the same data and even the same computer, the app processes results 7 or 8 times faster in Windows than in Linux.
    Is this normal ?
    How can I speed JDBC results in Linux ?
    Thanks.

    DB:2.89:Windows And Linux App sd

    Wow, interesting find, but I don't have enough GUI experience to help you out.

    Others here probably do, so can anyone else please offer some suggestions here on why the OP is seeing a signficnat timing difference in loading a TextArea with a String value from a list?

  • RELEVANCY SCORE 2.89

    DB:2.89:Java And Sqlserver 7 dm


    Any suggestions for how I can use Java/JDBC with SQLServer 7? As far as I can tell, the MS jdbc drivers only support SQLServer 2000, and the only other driver I found was not cost free, which is unfortunately a requirement as well.

    Suggestions?

    DB:2.89:Java And Sqlserver 7 dm

    Cool, just downloaded it, look like it does just what I need. Thanks for that!!