Search results for query: *

Hello, I have a table with two columns: One is an identity and one is dummyString. I would like to create a Stored Procedure which will make an INSERT to this table and than return the identity of the row that was just inserted. How do I do that? And by the way, is it possible to make an INSERT...

Hello, I need to manage a certain BigDecimal class member in a web application which will not be destroyed. This class member represents a key in a database which from few reasons I would like to manage on my own and I don't use EJBs. In order to implement that, I have created a private static...

Hello, Until today I had Windows XP + .NET framework I have installed for the use of few programs. Today I installed SP2. My question is if the SP2 includes the .NET framework inside it and I can remove the seperate installation I have at the PC?

Hello, Consider this simple query: SELECT number1, number2 FROM NUMBERS LEFT JOIN ITEMS ON NUMBERS.number1 = ITEMS.number2 Now, suppose NUMBERS Contain numbers from 1 till 10 for each year it has and ITEMS contains numbers from 1 till 9 for each year it has. I would expect the result to...

Hello, I have a certain Stored Procedure which process large amount of records. The SP is doing what it suppose to do OK but it is taking it long time to do it. Of course, part of the "blame" is the large amount of data but I think my SP implementation can be improved. Can someone here help me...

Hello, I am running a certain Stored Procedure using CallableStatament. . The boolean value from the execute() method return true only if a ResultSet was return yet this one doesn't return any ResultSet. So, my question is, how can I test if the Stored Procedure completed succefully?

Hello, I am running a Stored Procedure which doesn't generate any ResultSet. I would like to know from my code if the SP was completed succefully. Is it possible to return such indication at the end of the SP?

Hello, I am using sp_makewebtask SP in order to export query results to HTML. The query results are based onm some parameter available at the SP the uses sp_makewebtask. My question is: I woulk like to use these parameters as a Title of the generated HTML file. Is it possible to transfer them...

Hello, I have a String at this format: 1,2,3,... It's size varies, so it could be 1,2, or 1,2,3,4,5, The String always ends with "," and I would like to trim the last ",". How can I do it using SQL Functions?

Hello, Where at the HTML code I decide the encoding of the generated HTML file, such as UTF-8?

Hello, When writing a SELECT query in a Query Analyser it is possible to write the results to File. Is it also possible to do it inside a Stored Procedure's code? In case yes, Can I also control the format of the file, for example an HTML report?

Hello, I have a standard INSER statement. I would like to extend it to first check if the table exist. In case yes, the INSERT will occur. In case now, the table will be created AND it's Primary key and relsionships will be created as well before the INSERT. Then, the original INSERT will...

Hello, I am using this query: UPDATE COMMITTEES_REQUEST SET protocol_number = (SELECT MAX(protocol_number) FROM COMMITTEES_REQUEST WHERE code_committee = 1) WHERE record_number = 5 AND protocol_number IS NULL And I would like to refine it like this: protocol_number is a field which looks...

Hello, I would like to create a Stored Procedure which will create a table then update it's indexes and relationships. The problem is that when I write the CREATE TABLE and afterwards the ALTER TABLE it doesn't compile since the Table doesn't exist. So how can I creae a table and update it's...

Hello, I need to simulate a ceratin query on the Database. I need to do it from 20-30 Connections at the same time in order to test it's locking on the Databse. Can anyone show me such Stored Procedure which run this query simultaneously or can direct me to a freewere tool which will do that?

Hello, I have a sample code that imports com.sun.jndi.ldap.ctl.* yet I can't find it at any of my current jar files. Why isn't this jar supplied with the JSK and, where can I download this jar from?

Hello, I have a Documentum server which rides on top of an SQL Server. Currently when I try to open the Documentum (which in turns go to the SQL Server to retreive the data) I receive this error: Failed acquiring lock for Dbor As it said, the Documentum couldn't acquire lock for the SQL Server...

Hello, Every query I submit to the Active Directory I get maximim of 1000 results. I assume it is a configuration on top of the Active Directory. Anyone knows how can it be configured?

Hello, Suppose I created a security role at the ejb-jar.xml file: <security-role> <role-name> managers <role-name> </security-role> Now suppose I have an LDAP which contains a security group of managers with the managers users inside it. How do I actualy map the security role I declared at the...

Hello, I have a Database with many tables in it. Lately I encountered a problem that I can't open many of the tables there. If I try to see the records at the table through the EM, even if it contains 2-3 records it waits and waits until I receive "Timeout Expired" error. Why is that and how...