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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Stedo
  • Content: Threads
  • Order by date
  1. Stedo

    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...
  2. Stedo

    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
  3. Stedo

    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
  4. Stedo

    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...
  5. Stedo

    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...
  6. Stedo

    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
    • Stedo
    • Thread
    • Replies: 5
    • Forum: Java
  7. Stedo

    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...
  8. Stedo

    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...
  9. Stedo

    JNDI Properties

    hi, I'm running a JBoss application server where I deploy a session bean on the server. I try to connect locally (server running on localhost) using a stand-alone client and everything works fine. Then I moved the server to a remote machine and deployed the same ear file. I changed the host in...
  10. Stedo

    Pass a list of records from a function

    hi, Is it possible to return a list of records from a Stored Procedure? For example, SELECT * FROM my_table If so what type do I use for returning these? Thanks Steve
  11. Stedo

    Postgres Functions

    hi, I've just started using postgres and I want to create Stored Procedures. So I have created a Function with no parameters which returns an int8. However when I try to call the function I get a 'can't find function' error. Even although I can clearly see the function in the database. Have I...
  12. Stedo

    Namespaces across assemblies

    hi, I'm writing a number of assemblies and because of problems with circular dependencies I have to split related objects into seperate assemblies. In order to maintain good organisation in the code I create namespaces for the objects and I want to have objects in different assemblies belong to...
  13. Stedo

    Why does TEXT take more storage than VARCHAR?

    hi, When designing databases I normally use VARCHAR for short fields and TEXT for very large text fields. Can anyone explain to me at a detailed level why VARCHAR is more effective that TEXT? Thanks Steve
  14. Stedo

    Mounted File Store vs Server

    hi, Not sure if this is the right thread, but I though I'd put the question anyway. I'm working with an architecture for an enterprise system. In the system we will have clients that need access to some very big files. I favored an architecture with a server which controls the security of...
  15. Stedo

    Server vs Remote File System Mount

    hi, Not sure if this is the right thread, but I though I'd put the question anyway. I'm working with an architecture for an enterprise system. In the system we will have clients that need access to some very big files. I favored an architecture with a server which controls the security of...
  16. Stedo

    Editing Stored Procedures in Query Analyser

    hi, A quick question. I am writing some procedures in the Enterprise manager for MS SQL. However the editing facilities are not great and I want to edit these procedures in Query Analyser. I can edit the procedures but I can't seem to save them back to the database. The procedures appear in a...
  17. Stedo

    SqlDataReader capture a RETURN code

    hi, I am working with the development of an application which called stored procedures on a MS SQL Server. I get data from the stored procedure using a SqlDataReader, and manage the transaction handling in the stored procedure itself. No problem there. However sometimes an error is caused...
  18. Stedo

    Newbie: Length of a VARCHAR

    hi, In T-SQL how do I get the length of a string? I tried LENGTH(item) but it doesn't seem to have the function. Thanks Steve
  19. Stedo

    Newbie: Transaction Commits

    hi, I am writing some stored procedures in T-SQL, the contain both selects and updates. I want to make these transaction safe. I place a TRANSACTION BEGIN at the start of the procedure, however I use RETURN at various points to exit the procedure based on different conditions. Where do I...
  20. Stedo

    Calling Transaction Safe Stored Proceedures

    hi, I am currently working in C# with set of stored procedures in an MS SQL database. When I do an update in the MS SQL database there is no problem as I create an SqlTransaction and call the commit method to run the command. This works find until I need to call a stored procedure which uses...

Part and Inventory Search

Back
Top