Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
1 vote
2 answers
1k views

Parameterized query is taking more than 30 min to execute in SQL Server Database using SQL Developer, non-parameterized taking 60sec

I am a java developer. I don't have a deeper knowledge on the database part (may be I should have). I am firing several complex queries from java to a SQL Server database & it is returning data ...
Sumit's user avatar
  • 121
0 votes
1 answer
669 views

Retrieving data from stored procedure's cursor

I want to use the ResultSet in java program to get data from Stored procedure's cursor. Is that possible with SQL Server? My code: CREATE PROCEDURE dbo.SampleProcedure AS DECLARE @FirstName ...
Rajeev's user avatar
  • 115
2 votes
2 answers
10k views

What does the bit data type map to in a Java Domain Object

When you have a column of the bit data type what Class would be used to represent that in a Java POJO mapping that table to an object which is using javax.persistence annotations? I tried Boolean, ...
anataliocs's user avatar
2 votes
2 answers
6k views

java.sql.SQLException: Login failed for user 'sa'

I am having trouble connecting to my SQL Server database through a jtds connection: Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/MnA;instance=SQLEXPRESS", "sa","...
user avatar