I'm trying to insert a record in a table that contains a field of LVARBINARY data type. I'm using 'setBinaryStream' method of PreparedStatement to set the data.
When I execute the command, I get the following error:
java.sql.SQLException: Bad file descriptor
at...
Is there anyway to disable the X button (close button) in the top of the form? I want to avoid that the form be closed this way.
Tks
---
Jonatan Schroeder
Medisoft Ltda. - Brazil
System Development
Project Coordination
I have no problems with creating the ejb-jar.xml or jboss.xml. My question was about ejb-ref. But, anywhere, I did already solve my problem. I was using "java:comp/env/..." to reference my EJB. I modified the reference to use directly the JNDI name for the EJB, and it works.
Even so...
During our development, we're going to call some session beans, but not by the normal way. We have the session bean A, that contains some data such like the name for the remote and home interface and JNDI Name for a session bean B. It also contains the name of a method that shall be called in...
I'm using the "classic" mutating table workaround, that uses an AFTER STATEMENT trigger to run the trigger (http://osi.oracle.com/~tkyte/Mutate/index.html). But in my trigger I have an UPDATE in the same table from trigger. In this second UPDATE, the package data is redefined, and I...
The situation is something like this:
create table a (
id number,
...
);
create table b (
id number,
a_id number,
...
);
The trigger for table B verifies if table A exists. In some situations, trigger for table A inserts a record in table B. In this case, when the trigger for...
I use Progress Java triggers. When I update table A, the trigger fires an update in table B. This fires the trigger for table B, that looks for the original record in table A. The problem is: in this point, the trigger returns an error, cause the record I want to find is already locked. But the...
Yeah, this is how it works, but I'd like that it changes also the size of the variable (:new.c). My question is: how to do that? In "C" I know it works so, but Java doesn't work so. If I call:
SQL> VAR x CHAR;
SQL> begin
2 x := 'aa';
3 end;
4 /
SQL> CALL d (:x);
SQL> PRINT...
I'm developing an application in Java, that accesses an Progress database. I want to create triggers in Java for the application, to make some validations and replications. Some triggers access other classes that I created. The call works fine, but when I modify the java class and re-deposit the...
I'm finding some problems in execution of java triggers (stored procedures). The scripts follow:
create table a (
b number(5),
c varchar2(10)
);
create or replace procedure d (e in out varchar2)
as language java
name 'TriggerOracle.atribuiValor(java.lang.String[])';
/
create or...
I'm developing an application in Java, that accesses an Progress database. I want to create triggers in Java for the application, to make some validations and replications.
1. Is there anyway to send the exception data to the application, such as the error message? I tried to update a table...
Maybe you can modify it with another temporary table.You can copy data from number what u want until eof.And then you insert your new data, then you copy your old data in temp table back to the origin table.Quite messy right ... But maybe can help.. see ya ..!
I need help.In some case i need to ignore some error in my program.Usually we must choose cancel,suspend,or ignore right.I don't want it shown if found an error.What i should i do ? It seems like ON ERROR RESUME NEXT in Visual Basic ...
Thanks ....
CS
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.