Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
IF THEN ELSE problem
hi, Made the changes you suggested, everything works fine. Thanks Stephen- Stedo
- Post #3
- Forum: Oracle: All versions
-
IF THEN ELSE problem
hi, i have a simple problem. I am writing a script to check if a table exists, if so drop it otherwise 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...- Stedo
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Create columns from data
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...- Stedo
- Post #7
- Forum: Oracle: All versions
-
Create columns from data
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...- Stedo
- Post #5
- Forum: Oracle: All versions
-
Create columns from data
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...- Stedo
- Post #3
- Forum: Oracle: All versions
-
Create columns from data
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- Stedo
- Thread
- Replies: 7
- Forum: Oracle: All versions
-
How does a bean activate?
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 -
Cleaning dead beans
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... -
Cleaning dead beans
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... -
Cleaning dead beans
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... -
Returning a Remote interface from a Local interface
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... -
Last ResultSet in a PreparedStatement
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 -
Last ResultSet in a PreparedStatement
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... -
Last ResultSet in a PreparedStatement
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 -
JNDI and the Local Interface blues
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 -
SQL and Entity Beans
hi, Okay, I figured it out, I can just use normal session beans with a local interface to connect to the database. Thanks Steve -
JNDI and the Local Interface blues
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... -
SQL and Entity Beans
hi, If I don't connect to the database through a bean what do I connect to the database through? Thanks Steve -
SQL and Entity Beans
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... -
JNDI Properties
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...
