I am running a series of JUnits using Apache ANT using JDK 1.5.
All JUnits that use an Oracle JDBC driver give the UnsatisfiedLinkError shown below.
What native library is it looking for ...
In case management and workflow systems this seems to come up a lot. The need to provide a comprehensive list of each business message in the 'system' and provide its ...
I am getting the error: "The Network Adapter could not establish the connection" from a web application deployed in Oracle Application Server 10g. The database is local, so there shouldn't ...
This is my first Java application I am creating (using Eclipse IDE) and the second Oracle based app (I'm a .NET/MSSQL guy for years). The first Oracle app I wrote in ...
I am trying to fetch data from a category table through JDBC code its giving me the error
ORA:00600 internal error code arguments:[ttcgcshmd-1] [0][0][0]...
I Google it and found it may be DB ...
java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java)
I am getting this error when data in database is increased (nearly 3000). It works ...
Could somebody tell me what is causing this error when using sqlj in Oracle 11g. I am using Solaris 8 and I have tried changing JDK versions (tried both 1.5 and ...
I have a java application with jdbc connection, and it's no problem testing on my local Windows machine.
While running on the AIX database server(app and db on the same server and ...
I'm curious about something... is it possible for an Oracle 11 instance to be configured so that it does not return any ORA-?????? error messages?
I've issued many invalid queries ...
I had made connection to the remote oracle database through sqldeveloper on my system. Suddenly the power went down and I had to restart the system.
Now, when I am trying ...
I am using jdbc to connect to an Oracle 10g database. Building the connection in Eclipse/Java works fine. However when I move the code to a Lotus 8.5.2 agent I end ...
Could someone please help me on why i received the below error while trying to connect to Oracle db from java....
I had mentioned the cennection call as below:
i receive the below ...
I am calling a function from my java code and i am getting this exception. I have checked all the data types and everything else I can think of but I ...
I am getting ORA-01041 internal error HOSTDEF extension does not exit. Cause: The pointer to the HOSTDEF is null. when I first started Oracle 8.0 it ask me for the username, password and hostname. I know that there are some comman username, password and hostname. I uses system, manager and no host name (because I don't know what to enter in ...
Hi, Remove all the spaces before the callable statement and yur problem would be solved. I had a similar problem with the following statement: String greaterAreaQuery = " {CALL ? := MTG_GREATER_CITIES_FUNC(?)}"; when i removed the space between " and CALL, it was solved. Hope the same works for you also. regards, sonal
Hi all I was trying to connect to my oracle database with Type 4 driver....also added classes111.zip in my class path then ran the following java script to check my connection it gave me the following error Testing: jdbc:oracle:thin:somelogin/somepass@some.db.server.com:1521:jive An exception occurred while connecting and performing our test query. Refused:ROR=>>> I can't figure out the reason...can someone help me Thanks Kris ...
post your java code, so we can have a look at the actual statement. Maybe there is some spacing issues or something else that we might be able to see from the actual code. for your specific error message, this is what oracle says: ORA-00900 invalid SQL statement Cause: The statement is not recognized as a valid SQL statement. This error ...
Hi, I am getting the following error when I try to connect through source code, But query works fine when executed through SQLPLUS. Here is my code void query(String check) { ResultSet rs,rs1; try { Statement stat = connection.createStatement(); rs = stat.executeQuery(check); while (rs.next()) { String s = rs.getString("status"); System.out.println(" the output of check before update ie status is " + ...
Hello all, I've done a small application to migrate data from an Oracle Database to another Oracle Database. The problem is that after 700.000 rows read and inserted, I get a ORA-01654 error. java.sql.SQLException: ORA-01654: unable to extend index MYSCHEMA.PK_MKIMNOTIFICATION by 2397 in tablespace MYSCHEMA I understand from Google groups that I have to add a Datafile to to my tablespace. ...
Hi , i have written a oracle procedure and a java file. my oracle procedure returns an array to java. but while collecting the array in java it says "java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "SVM_220.t_id" " please have a look at the code below . please help me out in solving this problem. Thanks and Regards, Srikanth ...
It is definitely a classpath issue. You say you "converted" the ZIP to a JAR file. Did you simply rename it (which is the correct thing to do), or did you do something else? If you did something else, you might want to open the JAR file and make sure the classes and paths (packages) are OK. If everything in the ...
Good Morning world, Ok, I have to write an Oracle trigger in which I need to do a Select on the table a new record is being added to. I need to get the max value of a column and compare it with the value for that column for the new record. But running it gives a table mutating error, which ...
Hi, I'm trying to use a stored procedure-a function which cud accept the array of longs and return me the resultSet. After doing a lot of investigation on the web-i can successfully pass the array but while executing the code via SQL*Plus or Java/JDBC i m keep on getting this error: SQL> create or replace type NUM_ARRAY as table of number; ...
Hello, The code you received 12514 is an ORA message. It means that the servicename given in the connect descriptor is not known by the TNS listener. Verify you entered the right name in the connect descriptor. Also check that that name exists in your tnsnames.ora Lars [ August 18, 2005: Message edited by: Lars Vonk ]
hi, i am unable to get the data contents in to ResultSet when i use query like "select * from where condition" but if the same i query like "select sysdate from dual" it is executing Correctly do not know why? pls. can any one give me solutions my spec. are as follows: 1. Connecting from Oracle 8.1.7 to Oracle ...
I too have the same problem, we upgraded our database to Oracle9i Enterprise Edition Release 9.2.0.7.0. i tried with oracle 9i and 10g both ojdbc14.jar file and nothing helps. i am using a stmt.registerOutParameter(1, OracleTypes.CURSOR); to get an output as a cursor. BTW i am using weblogic 8.1 Any help on this
hi, i just set up the WSAD5.1 for the first time. i'm having a problem log into our application. i can see the login page, but after enter the user name and password, i got an error 500. i thought it might be the Datasource setup, but i checked many times they look find to me. somebody help, please! [7/26/06 16:01:54:109 ...
sir this is my jsp code this page give me right result in my browser when am using work group not internet or local network <%@ page import="java.sql.*,java.util.*" %> <% String url="jdbcracle:thin:@10.0.0.237:1521:aamir"; Connection con; Statement stmt; ResultSet rs; Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); con = DriverManager.getConnection(url,"muhammad","mfa786"); stmt=con.createStatement(); %> <% %>
Hi Jesper, Thanks its running. Actually, it was running through java -classpath .;classes12.jar dbAccess i am getting class not found error in when i use ojdbc14.jar but it compiled when i used ojdbc14.jar why it is so? Is there any problem ? I also want to know like I got code run in this way but in real life I have ...
warning: greenhorn = me. I am getting the following error message in my log file whenever I run my Java app which makes connections to an Oracle DB: SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=169869568)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4) (ARGS='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.###.###)(PORT=1521))) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))null))'))(ERROR=(CODE=303)(EMFI=1)))) I am sure the HOST is correct. I have also tried using the server name. Using google fu, I've found references to needing to use ...
Hi, I'm new in Java, and I'm trying to write a Java application connecting to Oracle 8i Enterprise Edition Release 8.1.6.0.0 database. I download classes12.zip on Oracle site and I use it in my Java classpath.Here's my code: import java.sql.*; public class ClasseDb2 { public ClasseDb2() { } public static void main( String [] args) throws SQLException { try { DriverManager.registerDriver ...
Hi, my code is working fine until the last executeUpdate. I'm trying to upload a file into the Oracle Database. public MyFile addFile(MyFile f, FormFile data) throws Exception { OracleConnection conn = null; PreparedStatement pstmt = null; String query = "INSERT into MY_FILE(SIZE, MIME_TYPE, NAME, FK_ID, FILE) VALUES (?, ?, ?, ?,empty_blob())"; try { conn = (OracleConnection)this.getConnexionBD(); pstmt = conn.prepareStatement (query); ...
My code is: import java.sql.*; import java.io.*; public class Oracle1 { public static void main(String[] args) { try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle"); String t1="lalu"; int t2=501; Statement s=c.createStatement(); s.executeUpdate("create table kbc(name varchar(20),salary number)"); s.close(); //taking the data from user and passing it to database via PreparedStatement & its setString() , setInt() method PreparedStatement ps=c.prepareStatement("insert into kbc values(?,?)"); ps.setString(1,t1); ps.setInt(2,t2); ps.executeUpdate(); ps.close(); //to ...
Hi all, I am using an instance of OracleConnectionCacheManager to connect to an Oracle database. Everything is working fine ; the only problem I have is that when the database goes down (for some reasons...) for few minutes, I have to restart the JAVA application because the connection pool is not reinitialized automatically. Does someone have a clue about the solution ...
Hello: I have a problem with oracle database, I need to insert records from us7ascii to W8MSWIN1252 database. I make a java program for this operation but euro sign is coverted to other and i can't see ok. I have tried to covert from unicode to java string etc and it doesn't work fine. Do i need special convert for this ...
probably your oracle database user does not have the correct privileges for creating a database. most DBA will create a user account to access the schema, such as the application, separate from the administrative user that is required for creating databases. In some cases the application's user account is even restricted from creating or dropping tables. Maybe contact your DBA and ...
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured ...
public class EnumTest { Day day; public EnumTest(Day day) { this.day = day; } public void tellItLikeItIs() { switch (day) { case MONDAY: System.out.println("Mondays are bad."); break; case FRIDAY: System.out.println("Fridays are better."); break; case SATURDAY: case SUNDAY: System.out.println("Weekends are best."); break; default: System.out.println("Midweek days are so-so."); break; } } public static void main(String[] args) { EnumTest firstDay = new EnumTest(Day.MONDAY); firstDay.tellItLikeItIs(); ...
Hi , I am developing an application in Weblogic 10.2 and java . The data is fetched in oracle and i storre it in vector and display the same in the webpage .Whenever an oracle error or exception occurs , i need that ORA message to be displayed on the page , instead i get the error from Weblogic server being ...
Hi paulaeunice, For paymenttransdate,paymenttransdate,rdocode fields you didnt mentioned any references,as u aliased the table names you sholud refer only by aliased names fro ex (X.paymenttransdate,X.paymenttransdate,X.rdocode ). if startdate and endate datatypes are of date type then you should write X.paymenttransdate > 'X.startdate' and X.paymenttransdate < '. X is the alias name for table. Are you trying to execute the sql statement ...
Hi, Im a newbie, using Oracle 10g enterprise edition, netbeans 6.5. Im unable to execute a SELECT query which contains multiple JOINS & UNIONS(lengthening upto 3800 chars) through code hence It flashes SP2-0027: Input is too long (> 2499 characters) - line ignored. Earlier i had same problem while executing the query on the web interfaced query browser(isqlplus), sqlplus prompt. Later ...
Hello I have a oracle database, and I have using netbeans to do a request to DB my sintax is the following: import java.sql.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { static String userName = "consul"; static String password = "consul"; public static void main (String[] args) throws Exception { Connection conn = null; try { //String url ...
Hi all, I am using an instance of OracleConnectionCacheManager to connect to an Oracle database. Everything is working fine when the database is ok ; the only problem I have is that when the database goes down (for some reasons...) for few seconds or few minutes (or more...), I have to restart the JAVA application because the connection pool is not ...