Search results for query: *

hi, Made the changes you suggested, everything works fine. Thanks Stephen

...create it. I have the following where I have decared anumber to be a NUMBER: IF anumber=1 THEN DROP TABLE MyTABLE; ELSE CREATE TABLE AS SELECT * FROM TABLE2; END IF; When I try to execute the code I get the following error: ERROR at line 11: ORA-06550: line 11, column 1: PLS-00103...

hi, Yes, there is a unique ID however the problem lies in that we have fields listed in a property table which are defined by the user. There can be a good many of these fields and these are stored as data rather than structure. For example, we have Product ID 11 and Product ID 22, these...

hi, I suspected as much, the real problem comes from an application we have which stores user defined fields in a structure similar to a properties table. What we want to do is have these transformed into a table like structure, while at the same time maintaining the flexibility of property...

hi, That's not really what I mean, for example I have the following table with the following values: Table: Properties Name | Value ======================= TYPE | High TYPE | Low NAME | Module Error NAME | Integration Error What I want to be...

hi, I want to take some data from a query and create a table from it. Something like this: SELECT values FROM tableA; ... now create a table with columns represented by the returned values. Is this possible?? I'm using Oracle 10g. Thanks for any help. Steve

hi, Can anyone tell me how a bean activates after a passivate? If I have transient data members and non-transient data memebers, which are loaded first on an activate? Thanks Stephen

hi, Well this is the question? I'm not sure. For the stateless beans there's no worries, but I have some stateful beans which are create for a specific client session and I don't know what happens to these if they are left hanging around? Is there some kind of time out I can set for these...

hi, Okay, I'm talking about the client side going down, not the server. The clients I have are Swing clients so they are not resident on the server side. So if someone powers down a client PC the connection to the server is left hanging. What I need to do is have some way to clean up the server...

hi, I ahve a question regarding cleaning up dead beans. I have a client app which uses beans on a server via a remote interface. When the app works normally everything is hey ho! The app removes the beans and cleans up after itself, but if the OS crashes or the app crashed or someone powers...

hi, Is it possible to return a Remote interface from a Local interface? I have a client which I want to have access to the Remote interface but not have access to the Home interface, so I want to create the Remote interface on the server and pass it to the client. But I don't know how to create...

hi, Sorted the problem. In my MySQL procedures you have to make a SELECT ... INTO if you don't want the result set returned. Thanks Steve

hi, The problem is like this, I have a stored procedure in MySQL which executes a number of SELECT statements. The stored procedure executes fine. The problem seems to be that when I try to obtain the ResultSet after execution I revceive the ResultSet for the SELECT statment in the stored...

hi, When executing a prepared statement, how do I get the returned last ResultSet? I have looked at getMoreResults() method however this only tells me that the result set was the last one after it has been closed. Can anyone help? Thanks Steve

hi, Thanks for the response but I've solved it now. Not really sure why it wasn't working before but after fiddling with the ejb-jar.xml file for ages it came good. Cheers Steve

hi, Okay, I figured it out, I can just use normal session beans with a local interface to connect to the database. Thanks Steve

hi, I'm having problems getting Local interfaces to work using JBoss. I have two session beans one bean with a remote interface called from a client and the other with a local interface with methods called from the first bean. HoweverI can't seem to get the local bean to bind to the correct...

hi, If I don't connect to the database through a bean what do I connect to the database through? Thanks Steve

hi, I'm writing a J2EE app and I want to interface with a database. I've been looking at Entity beans and all is well. However what I want to do is simply execute an SQL statement and get a vector of strings back. Do I have to use Entity Beans to do this? I have tried writing a finder function...

hi, Solved the problem. The problem was not on the client side, it was on the server side. The setting for the RMI host was set to localhost, so of course when JBoss send the RMI server address to the client it is set to localhost. Therefore the client was looking at localhost for the RMI...