Oracle Test Jdbc Thin Connection

By the way before running this Java program to connect Oracle database make sure your Oracle database server is running and you have JDBC thin driver in your classpath like ojdbc6. This post uses the Local (No Agent), JREE Agent, and the Standalone Collocated Agent as Physical Agents. SQOOP CONNECTIONS: Sqoop is a tool designed to transfer data between Hadoop and relational databases. Connecting Database using a JPA implementation. I was (and still am) convinced that JDBC thin is nice for applets, but that an application server shoudl use thick. Hello I had a problem I can connect oracle by Toad, and I already did the next step: 1-register the oracle jdbc driver via the KNIME preferences … It's ok. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. jdbc library, consult Using java. Because it is 100% Java, this driver is platform independent and can also run from a Web Browser. What if OCI calls from sqlplus are successful and we have end users complain the JDBC connections are failing. to connect to other Oracle databases. To connect a Java application with MySQL database using Thin Driver. When possible, the newest version of the Oracle JDBC driver should be used. Click "Test Connection" again. Oracle oci Driver; Oracle thin Driver; For connecting java application with the oracle database, we need to follow below steps. Comment to the Relique drive: The problem is that the driver is not fully implemented (missing a lot of functions, i. Test a JDBC connection to Oracle database Many tools use JDBC to talk SQL to a database server. Connection conn = DriverManager. 4 API out of the top Google hits when searching for the Java docs of some class or other. I had success in doing the test to JDBC driver, I did as follows: Driver Class (fully qualified) oracle. ora here and I'll use SQLcl with the thin JDBC. The last packet sent successfully to the server was 0 milliseconds ago. class forname oracle jdbc oracledriver code for connecting database in java code for database connectivity in java code for jdbc connection code for jdbc connection in java code to connect to. The JDBC Oracle Call Interface (OCI) driver accesses Oracle and RAC-specific native code (that is, non-Java) libraries on the client or middle tier, providing a richer set of functions, and some performance boost compared to the JDBC Thin driver, especially in RAC. How to run. Is there any way to connect to PDB using hibernate. OracleDriver (thin). In BW designer 5. jar Fill in the connection properties and copy the connection string to the clipboard. Here I used the local machine IP address. ora entry to be used. zip, copied it to the lib folder and renamed it to classes12. ora file for the connection or is it using the oracle jdbc thin driver? I'd double check - cos the connection string should be pretty similar in both ReadyAPI! as SQL Developer. Either double-click the JAR file or execute the jar file from the command-line. There can be additional security settings that your DBA could help with. The samples directory contains sample programs for a particular Oracle JDBC driver. When i try both of the procedures, only one is successful (the one without a parameter). When using the ORACLE JDBC thin driver to access a database server instance, it fails with the following Exception: java. After Connection created. Simple tutorial for using JDBC The JDBC ( Java Database Connectivity) API defines interfaces and classes for writing database applications in Java by making database connections. xml for what driver version is used. Here is my test program which used both options. Connecting Database using a JPA implementation. Oracle Database Tips by Donald BurlesonJuly 15, 2015 How to test jdbc connection to oracle from unix. 3) JDBC driver for use with JDK™ 1. SQLException: Protocol violation. jar > Hi, there > > I try to connect to Oracle 9i using JDBC thin driver, but > I got error: "Non SQL error: Could not load class > oralce. NL Exception on 10g RAC JDBC. Test Data Encryption Integrity. Among the files in the directory, ojdbc6. AOL/J JDBC code is the code that handles JDBC connection, it is often the first area to be blamed, but the JDBC connection pool can only drop database connections where the calling application has released the JDBC connection it holds in the pool, so it often turns out to be an issue higher up the code stack. The two most common methods of connecting to Oracle databases via JDBC are the Oracle Thin JDBC driver and the Oracle OCI JDBC driver. One of the programs, JdbcCheckup. AOL/J JDBC code. 0, the JDBC thin driver has the ability to renegociate the SSL handshake and hence no longer needs to reconnect through a different port. There are three pieces of. 1 indicates the database host that you are connecting to. Oracle corporation has provided two Jdbc driver software for connection java application to a database of oracle server. Problem in Oracle thin drivers configuration , I am not able connect to Database using Oracle thin drivers when trying to configure JDBC installation in tibco designer 5. The DataDirect Connect for JDBC Oracle driver can transparently take advantage of server load balancing provided by an Oracle RAC without any changes to the application. Oracle provides drivers that enable users to make JDBC connections to Oracle databases. Test Oracle JDBC Driver Installation: 8. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. For this test I've created a new user in my Autonomous Transaction Processing cloud service. jar > Hi, there > > I try to connect to Oracle 9i using JDBC thin driver, but > I got error: "Non SQL error: Could not load class > oralce. OAF database connection Write your connection name and connection type is oracle (jdbc) Then press Next button when you press the test connection the test is. To connect with individual databases, JDBC (the Java Database Connectivity API) requires drivers for each database. A JDBC driver is a software component enabling a Java application to interact with a database. OracleDriver Cause : Missing JDBC driver Resolve: 1. Test is my main DB and pdborcl is my PDB. We would like it to use integrated security (I call it Active Directory, TIBCO seems to like integrated security). Can anybody please help me out. java, is designed to test JDBC and the database connection. If you can connect to the database from sqlplus via port 1521, this does not necissarily mean that you can connect in JDBC via the same port. How can I connect to the database? I thought I can do it with the OLEDB Monitor but I have only a jdbc connection string with username and passwort but this is not included. One of the programs, JdbcCheckup. TDI Server Side Configuration In this environment, I used the Oracle Thin JDBC client. Oracle provides this download free of charge, but may require you to register on the Oracle site to proceed with the download. You can see the new oracle DB connection appears in the "Data Source Explorer" view. jdbc:oracle:thin:@oracle. The wallet and keystore files are included in the client credentials. MySQL Connector/J 8. Using JDBC you can send SQL, PL/SQL statements to almost any relational database. Using a newer set of drivers from Oracle solves the problem. Set objConnection = CreateObject("ADODB. We need to be able to use Synonyms to execute stored procedures. Webucator provides instructor-led training to students throughout the US and Canada. (b)Set the driver connection properties(e. 3 and not having any issue with oracle connection. If you are testing a connection to WebLogic, check the WebLogic Server log. I need assistance with establishing a JDBC connection to an oracle database in VBS. Knowing the JDBC Driver Connection URL strings is mandatory if you want to connect to a relational database system from a Java application. you can test you connection is valid or not with Connection#isValid(int timeout) returns true if the connection has not been closed and is still valid. jar) from: 2 - Create a database user in your ORACLE database; 3- Create a SPL project in your Streams server; 4 - Make the SPL application; 5 - Run the SPL application; 6 - check the SQL message; Edit me. All you need is to include the required jar in the classpath. (c)Set the connection pool properties(e. Different database + products may require different SQL syntax. For numeric. OracleDriver (ojdbc14. New JDBC URL Syntax for Oracle 10g JDBC Driver. Fast Connection Failover (FCF) Test Client Using 11g JDBC Driver and 11g RAC Cluster [ID 566573. If the Oracle instance is not configured for MTS, you are probably encountering a different problem. The reason for my asking this is I have seen some connection string incarnations I did not think could work. Add the jdbc jar (download the jdbc jar from the internet) file related to the version of database to the test plan as shown below: From the config element, add JDBC Connection Configuration as shown below for the Postgres database:. Oracle provides this download free of charge, but may require you to register on the Oracle site to proceed with the download. Now if I bring down the node 1 of oracle rac the failover to next node (as mentioned in connection url) does not happens and jboss throws lots of exception. 3 any ideas?. What if OCI calls from sqlplus are successful and we have end users complain the JDBC connections are failing. Hello, I have a request to monitor a database entry with a sql select statement. Bonjour, J'ai installer ORACLE dont j'ai créer une base de données et j'ai installer netbeans IDE avev le jdk et je veux créer un client java qui se connecte avec cet base en utilisant le. Always remember that one copy of this JAR is available when you install Oracle Client or Server in your machine. You can use R to analyse data from many different data sources including external files or databases. Because it is written entirely in Java, this driver is platform-independent. This WikiBooks page is written around a very old version of the library and most of the examples here will not work with newer versions. jdbc-oracle - JDBC jdbc-oracle Hi! sub: image insertion in oracle: I inserted the image in oracle database using java through jdbc-odbc bridge driver Successfully. OracleDataSource class. I don't want to change manually values for "Hive Metastore Database Host" and "Hive Metastore Database Name" everytime when a primary and a standby Oracle DB's are switched over (their roles will be swapped). JDBC technology is an API (included in both J2SE and J2EE releases) that provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files. The reason for my asking this is I have seen some connection string incarnations I did not think could work. If you want to use the DriverManager class to create connection objects, you need to know how to make a connection URL that provides access information to the Oracle server. 0\dbhome_1\jdbc\lib" or Download the ojdbc driver from internet. Hence the reason I wrote this simple JDBC connection tool. This tutorial uses the Oracle Database 11g Release 2 (11. ora file for the connection or is it using the oracle jdbc thin driver? I'd double check - cos the connection string should be pretty similar in both ReadyAPI! as SQL Developer. Firstly, you need to specify the driver. SQLRecoverableException: IO Error: The service in process is not supported. Actually there is no way to get a real distributed transaction, like a real oracle database link, so speaking by example:. Working environment Test Case 1: ojdbc6. Creating a JMeter script is same in both Postgres and Oracle Databases. Data Source definition: Driver: oracle. jdbc on Clojure Documentation. All you have to do is to implement a few functions (getTables and getColumns in CsvDatabaseMetadata class - you have to create a result set with names of csv files as a tables (in getTables) and the result set with names of columns - parse the first line of csv file). 0 implementation) Oracle Wallet Configuration The following steps need to be performed on the server where oracle server installation is available. 2 and java version "1. OracleDriver ( selected from drop down). Stored procedures are part and parcel of any database application that enables a lot of business logic to be stored as application logic in the database in compiled form. Re: JDBC Driver Class Not Found: oracle. What's your OS' default locale? It seems it's not recognized by the jdbc driver. ora and establish a connection using sqlplus. Using a newer set of drivers from Oracle solves the problem. properties which is part of the wallet zip file makes it easy to pass all the JKS and wallet related properties. Using JDBC, the Universal Connection Pool (UCP) and the embedded JVM (OJVM) through technical articles, white papers, code samples, FAQs and more. Oracle Database Tips by Donald BurlesonJuly 15, 2015 How to test jdbc connection to oracle from unix. For numeric. The first string is the URL for the database including the protocol (jdbc), the vendor (oracle), the driver (thin), the server (dbaprod1), the port number (1521), and a server instance (SHR1_PRD). After creating a DBaaS instance in the Oracle Public Cloud, an 12. Thin driver. 1 indicates the database host that you are connecting to. Oracle JDBC thin driver supporting JDK 1. The only exception is a JDBC Thin connection. Well, that's a JDBC url, so it would be understood only by the Java compiler i. forName("com. Different database + products may require different SQL syntax. Testing JDBC and the Database Connection: JdbcCheckup. Try change the default locale to en_US or you can try adding "-Duser. I am able to create, insert, update the tables in this DB. I have a project where we need to connect to Oracle database using a JSP web page. To connect to an Oracle database, you need the Oracle drivers. + + The jdbc database connection is examined to see if it matches with the + regular expressions specified in any of the defined matchers. All you have to do is to implement a few functions (getTables and getColumns in CsvDatabaseMetadata class - you have to create a result set with names of csv files as a tables (in getTables) and the result set with names of columns - parse the first line of csv file). OracleDriver. Re: JDBC Driver Class Not Found: oracle. Install Oracle DB. working with oracle 11g release 11. From the Connection type list, select URL only. In order to make a connection to a specific database system, it requires doing the following 2 steps:. We install Oracle client, add entry in tnsnames. Oracle JDBC Test How to test by adding the Oracle JDBC driver to your classpath. HHH000342: Could not obtain connection to query metadata : Failed to get driver instance for jdbcUrl=jdbc:oracle:thin://test. Java: Connecting to Oracle Database using Thin Driver. 6 to connect to a Oracle 11g Enterprise Edition Release 11. Using JDBC, the Universal Connection Pool (UCP) and the embedded JVM (OJVM) through technical articles, white papers, code samples, FAQs and more. Oracle support for Kerberos authentication via JDBC has been available since Oracle 11g Release 1 (11. When I execute this the only console output I get isWhat am I doing wrong?: Java - JDBC Thin to Oracle. The Oracle Thin driver requires no software other than the driver jar file. Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets. We need to connect the external Oracle DB with JDBC connector, because BI need to connect to the target Oracle. NOTE: this is an early version. Using the JDBC OCI driver allows the tnsnames. The JDBC Thin Driver used in this method is a JDBC Type 4 driver that uses Java to connect directly to Oracle via the TNS protocol. Re: jdbc connection for Oracle RAC database by mbastarache » Tue Oct 19, 2010 7:46 pm Yes I'm sure that I use the jdbc thin driver and with this driver you don't need to install any oracle client. The Tnsnames. Close the above window, next provide connection information. 3) JDBC driver for use with JDK™ 1. The following article describes how to set up a kerberized connection to Oracle for QuerySurge Agents deployed on Linux. Close the connection 1. Connection string for oracle JDBC thin driver Connection string of type 4 driver to connect with oracle database. OracleDriver"); Connection conn = DriverManager. What are the various acceptable JDBC connection strings that can be used to connect to an Oracle database? Which connection string is commonly used? Please explain what the purpose of each different connection string is. Join the DZone community and get the full member experience. SQLRecoverableException: IO Error: The Network Adapter could not establish the connection. This tutorial shows how to set up a data source and connect to an Oracle ® database using the Database Explorer app or the command line. jar from instant client 12. Copy the JDBC driver JAR file to a local physical drive, not a mounted volume. , Windows) and database systems (for example, MySQL, PostgreSQL, Oracle). jar Fill in the connection properties and copy the connection string to the clipboard. Do we have any command to connect to database using JDBC drivers. Oracle JDBC Connection - Response was NULL. An IPC connection is much faster than a network connection. Connection string for oracle JDBC thin driver Connection string of type 4 driver to connect with oracle database. The thin driver needs 3 parameters to make the connection: IP address or hostname of the database server, the port on which the Oracle service is listening (usually 1521) and the SID of the database instance. How can I connect to the database? I thought I can do it with the OLEDB Monitor but I have only a jdbc connection string with username and passwort but this is not included. To use the thin driver, a TNS connect descriptor is required from the tnsnames. ,defaultNChar,includeSynonyms). In this case the message "CTJTD1022I ORACLE instance down, or connection failed to: jdbc:oracle:thin:@:1521" is due to an incorrect configuration of Taddm sensors related to the ORACLE JDBC DRIVE version. Oracle 12c Thin Driver connection string example and Windows install guide. You can find the Oracle JDBC driver in C:\oraclexe\app\oracle\product\11. I am able to create, insert, update the tables in this DB. at oracle. Re: jdbc connection for Oracle RAC database by mbastarache » Tue Oct 19, 2010 7:46 pm Yes I'm sure that I use the jdbc thin driver and with this driver you don't need to install any oracle client. jar & ojdbc14. If you start experiencing problems when dealing with custom workflows or working with issues that have long descriptions, comments or custom field values, try adding the element SetBigStringTryClob=true as a child of the element in your dbconfig. Test Register Oracle JDBC Driver: 14. Oracle's JDBC Thin driver is a Type 4 driver that uses Java sockets to connect directly to Oracle. Data Source definition: Driver: oracle. Data Virtuality Pipes is an easy to use data integration tool. OracleDriver Hi Pavan that's the correct connection string also there is a blog on this linking it here for reference How to configure Oracle 12c's Pluggable Database as External DataStorage for ThingWorx. Java JDBC is an API used to connect with database and perform all database related operations. The issue is this: - Correctly set up an Oracle database connection pool in jboss. Using JDBC you can send SQL, PL/SQL statements to almost any relational database. I have used the following code but not successful in connecting to Oracle DB. Get Column Names From ResultSet for Oracle: 11. Encapsulate the Connection-related operations that every JDBC program seems to use: 9. If you selected the JDBC connection type, you will typically enter values similar to these samples, where “hostname” is the hostname of your DB server and “yourDatabase” is the name of the database you want to connect to:. The code assumes that there is Oracle database running on 192. Steps for Oracle On the computer where the Oracle client is installed, go to the ORACLE_HOME/jdbc/lib directory. forName( oracle. How to retrieve a record from an existing table in oracle database using JDBC API? JDBC Java 8 Object Oriented Programming Programming Database You can update/modify the existing contents of a record in a table using the UPDATE query. I tested it directly (without a proxy) successfully but i do not know how can i. JDBC Statement and ResultSet. 1) , but no luck. SOLUTION: The issue got resolved by below steps :. Execute the JAR file with the following 3 parameters with schema name, password and JDBC connection details:. This tutorial uses the Oracle Database 11g Release 2 (11. DriverManager class manages the JDBC drivers that are installed on the system. Additionally, MySQL Connector/J 8. The JDBC Thin driver allows a direct connection to the database by providing an implementation of SQL*Net on top of Java sockets. The oracle jdbc drivers is fine when I use the oracle type to set the connection in a normal oracle database connection. What are the various acceptable JDBC connection strings that can be used to connect to an Oracle database? Which connection string is commonly used? Please explain what the purpose of each different connection string is. SQLException: Io exception: The Network Adapter could not establish the connection. jar or ojdbc6_g. Old JDBC drivers do work, but new drivers do not work. Count row in Oracle: 10. For an Oracle database, the syntax of the URL is: oracle:thin:@hostname:port:database_name. For numeric. Before working with JDBC API to interact with database (to be specific Oracle database for this example), we need to set up Oracle database and create required things like. This tutorial shows how to set up a data source and connect to an Oracle ® database using the Database Explorer app or the command line. This tool is simple to use, it takes the following to build the URL for connection to Oracle:. The JDBC Thin Driver used in this method is a JDBC Type 4 driver that uses Java to connect directly to Oracle via the TNS protocol. Oracle JDBC Driver load: 12. The following article describes how to set up a kerberized connection to Oracle for QuerySurge Agents deployed on Linux. What if OCI calls from sqlplus are successful and we have end users complain the JDBC connections are failing. 1 with a host name of amrood, and your Oracle listener is configured to listen on port 1521, and your database name is EMP, then complete database URL would be −. Knowing the JDBC Driver Connection URL strings is mandatory if you want to connect to a relational database system from a Java application. load oracle jdbc drivers, because are already shipped in the oracle JVM. 1) and added JDBC configuration configuration to my testplan with the following settings: JDBC Driver Class : oracle. Go to Vontu/Protect/config. getTables). forName("com. When I execute this the only console output I get isWhat am I doing wrong?: Java - JDBC Thin to Oracle. java:1374) at weblogic. Data Source definition: Driver: oracle. Introduction The Java DataBase Connectivity API is a set of classes allowing a straightforward and vendor-neutral access to database management systems. Did you configure the jdbc-driver before adding the datasource? I'd suggest that you use jboss-cli or web console for adding jdbc-driver and datasources. The last packet sent successfully to the server was 0 milliseconds ago. Create XMLType Data: In this step, we will create a test table in Oracle 11g R2 database XMLTYPE column and populate it with XML Data. execute(PreparedStatement. Enter the User Name and Password for the database, click Test Connection… to verify the connection is successful, and then click Finish The data source is now set up and you can create a new data set and run queries against the Oracle database. Install Oracle DB follow installation page instructions. Go to Oracle jdbc driver page and get suitable version. The JDBC Thin driver communicates with the server using TTC, a protocol developed by Oracle to access data from Oracle Database. The JDBC Thin driver gives the user process a direct connection to Oracle by implementing a form of TCP/IP imitating Oracle Net and TTC on top of Java sockets. If the JDBC connector suceed, BI will create a UD which use the datasource we create in Visual admin to connect to the external Oracle DB. To connect to an Oracle database, download the Oracle Thin Driver. Go to Oracle jdbc driver page and get suitable version. Simple java program to connect to Oracle server. If you haven’t read this post, it is a good idea to catch up now. If the JDBC driver does not support connection timeouts, the value of this field is ignored. Driver") method is used to load the driver class for MySQL database. Oracle provides this download free of charge, but may require you to register on the Oracle site to proceed with the download. Attempting to compile a small java program that connects with Oracle thin, and then with an OCI connection. CS: Java Class not found in classpath : oracle. Sqlexception: Io Exception: The Network Adapter Could NotEstablish The Connection" While Connecting to Oracle Database 11g [ID947653. uk to manipulate the data from Java programs. JDBC Thin Driver Connection Via Wallet and with LDAP Fails with ORA-1017 (Doc ID 2067207. The server-side Oracle JDBC driver does not have connection pooling as the server driver can have only one connection which is to the logged-in session. I am familiar with VBA and ADODB connections but I am new to VBS and JDBC. I don't believe that LDAP would be valid in the connection string. Most JDBC drivers support connection timeouts. Hello, I have a request to monitor a database entry with a sql select statement. I am unable to connect to the oracle database I tried all the possible ways that are mentioned in the examples/docs ,but I am unable to connect by using thin driver. > failover a JDBC thin client connection using FCF? > > I did a test where my java program connected to the database and ("jdbc:oracle:thin:@(DESCRIPTION. (b)Set the driver connection properties(e. JDBC Tester JDBC Tester is a software that allows to prove JDBC connections and SQL statements. I am able to create, insert, update the tables in this DB. The Tnsnames. OracleDriver Welcome to the internetstuff gets perpetuated as "the answer" even though that answer is now out dated by several years. OracleDriver. 0 on Solaris with separate MySQL and Tomcat Server. JDBC, Oracle object/collection, dbms_pickler, NOPARALLEL sys. The two most common methods of connecting to Oracle databases via JDBC are the Oracle Thin JDBC driver and the Oracle OCI JDBC driver. The class12. OracleDriver ( selected from drop down). Both of the method has been published as a procedure in oracle. Install Oracle Driver and Execute Resultset: 15. I'd like to be able to specify a FAILOVER JDBC connection string which might access both primary and standby Oracle cluster. Maybe you are thinking about the type-4 JDBC thin drivers, you can install them and have connection to Oracle (assuming you install the Oracle type-4 drivers) because the type-4 drivers have the Oracle client burned into them already. 7 authentication, and unless our DBAs prefer OS_ROLES, our plan is to have the menu pick invoke a setuid program, which we hope will authenticate against an externally identified Oracle user associated with the unix owner of the setuid program, which Oracle user will also have EXECUTE privilege on any. Get Parameter MetaData From Oracle JDBC Driver: 7. Install Oracle Driver and Execute Resultset: 15. 0 implementation) Oracle Wallet Configuration The following steps need to be performed on the server where oracle server installation is available. This article will show you example about how to connect Oracle DB use JDBC driver. OracleDataSource before getting a connection. properties in a text editor such as notepad and look for the parameter "jdbc. have you copied the oracle classes12. To add a connection in the AWS Glue console, choose Add connection. Hello, I have a request to monitor a database entry with a sql select statement. Secure Sockets Layer (SSL) can be used to secure the connection between the middle tier "client", WebLogic Server (WLS) in this case, and the Oracle database server. These protocols are both lightweight versions of their server counterparts. 3, and the other is Oracle 8. For OCI, I think you need the Oracle SQL Client software installed, as well. 2) create a SQL query on the previous created connection, 1 record is 1 email. e your Java Program and back end i. ' I do not like this subjective statement in an official Oracle FAQ. The question is (esp. A JDBC driver is a software component enabling a Java application to interact with a database. Install Oracle DB. We need to connect the external Oracle DB with JDBC connector, because BI need to connect to the target Oracle. Connection URL: The connection URL for the oracle database is jdbc:oracle:thin:@localhost:1521:FacingIssuesOnITDB here jdbc is the API, oracle is the database, localhost is the server name on which oracle is running, we may also use IP address, 1521 is the port number and FacingIssuesOnITDB is the database name. Philip, This string is controlled by the JDBC RT connection string so you should check that. borru ) Hi i have the same problem installing informatica power center 9. Insert Data into Oracle From Excel JDBC - POI Example Program Excel to Oracle - JDBC - Introduction In this post, we will take you through a simple example, in which we will read data from a. x with Oracle JDBC Thin-Client Drivers (Type 4). Only JDBC drivers that support connection timeouts can use this field. You need to follow the following steps Load Driver Class: The Driver Class for MySQL database is com. Using JDBC drivers you can access the the Oracle database at oracle. Historically it's just been done using a single instance of a database and the connect string looks something like this: jdbc:oracle:thin:@node1. TestStep Properties Configuration. Re: Unable to connect to Oracle using JDBC thin driver 3004 Mar 1, 2001 2:27 PM ( in response to 3004 ) Harini, I noticed that you did not specify the test table WebLogic should use for testing the database connection. 9\lib and that was solved. Always updated to ensure flexibility and remove risks.