Search results for query: *

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

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, 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, 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, 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, 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, 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...

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

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

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

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

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

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

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

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

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

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

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