Stack Overflow
Stack Overflow

Questions tagged [mssql-jdbc]

For specific questions on Microsoft's JDBC driver for their SQL Server product.

For specific questions on Microsoft's JDBC driver for their SQL Server product.

Microsoft JDBC Driver for SQL Server

Related tags:

603 questions
0
votes
1 answer

org.hibernate.exception.SQLGrammarException: could not initialize a collection:[com.app.core.Users.processDetatilses#12]

I am using database MSSQL Server, and whenever I making a statement Query query = createQuery("FROM Users WHERE permission=1").list(); it throws me an exception like org.hibernate.exception.SQLGrammarException: could not initialize a…
Shubhankar
  • 87
  • 3
  • 6
  • 16
0
votes
2 answers

How to Hold multiple results arrived from a procedure in hibernate

I am new to Hibernate Here my problem is I know how to call stored procedures of mssql using hibernate, so here I used native queries and I am calling this @NamedNativeQueries({ @NamedNativeQuery( name = "callProc", query = "EXEC SimpleProc…
RamBen
  • 990
  • 1
  • 9
  • 17
0
votes
0 answers

building an sql connection url in java

so I am attempting to connect to a database on a network through java and I am having difficulty getting a connection to the server. I believe my problem is with the connection url. I have tried a few different things to test it out, but nothing has…
Tapialj
  • 333
  • 2
  • 3
  • 11
0
votes
0 answers

Graphing with Java Swing - Threading and MSSQL

I have written a custom graphing class in java swing that will pull data from mssql server every 5 minutes and plot it for me. Here is my architecture TimerGraph <-- DataSource (MSSQL) <-- MSSQLManager <-- main My TimerGraph will tell the…
bustedware
  • 194
  • 1
  • 3
  • 18
0
votes
0 answers

In ColdFusion how to Convert LIMIT function query in MY SQL to MS SQL Server 2012

Please see below example: SELECT DCNumber,RegDate,gender,FirstName,LastName,(select count(*) from DriversRecord) as totalCount FROM DriversRecord LIMIT
Brusk
  • 1
  • 1
0
votes
1 answer

Ms Sql table to left join on Sybase table

Can anyone give me an idea on how to select from a table in another database? For example, in my MS SQL database I have a table named employee, and I want to create a query to left join on a Sybase database table employee.
Ralph G
  • 133
  • 1
  • 6
0
votes
0 answers

How acceletare logging to DB?

I have my own appender on groovy language, which writes all logging message to database. But when I use it, performance of my code falls by 25% and code runs 25% slower compared to working without this appender. How can I accelerate this procces?
AlexandrM
  • 137
  • 2
  • 11
0
votes
1 answer

Get generated ID from cursor after inserting a row

I've seen this(and similar) questions explaining how to insert and get the generated ID. Unfortunately, none of the solutions that I've found so far work in my current setting. My code is currently like the…
Cruncher
  • 7,641
  • 1
  • 31
  • 65
0
votes
1 answer

Why Resultset trimmed?

When referring to the stored procedure client get two Resultset. With the first all is well, but the second consists of 20 rows, client developers claim that the procedure returns about 1000. Connect connectObject = new Connect(); Connection…
Nekto
  • 11
  • 2
0
votes
0 answers

Connection MSSQL with jtds Error in Android

I want to make connection with jtds but I have an error such AsyncTask#1 RuntimeException An Error occured while executing doInBackground. How can I fixed? public class dbHelper extends AsyncTask { public dbHelper() throws…
user3423728
  • 51
  • 1
  • 1
  • 6
0
votes
0 answers

Escape value in MSSQL Server with Java

How can I escape a value for usage in a query to MSSQL Server? I know how it would be possible using JDBC but since I'm using SAP Business One DI API there is no way (I'm aware of) of using prepared statements. It would be sufficient to know how to…
ooxi
  • 3,159
  • 2
  • 28
  • 41
0
votes
0 answers

Running simple SELECT MS SQL Server query with JDBCTemplate using JTDS driver and c3p0 data source

I am connecting to MS SQL server with following datasource …
Amaresh
  • 331
  • 2
  • 5
  • 14
0
votes
2 answers

Unable to connect MS SQL server via Java Class

I am getting error when I try to connect database Error:com.microsoft.sqlserver.jdbc.SQLServerConnection cannot be cast to Ptakip.Connection Ptakip is my Package Connection is my Class Here is the Connection Class Code ; import…
user3498019
  • 95
  • 1
  • 2
  • 10
0
votes
1 answer

MS SQL formulating aggregation and time stamp query

time stamp meter name parameter name value 2014-02-18 18:58:00 1$SGP A 415.7806091308594 2014-02-18 18:58:00 1$SGP B 240.3373565673828 2014-02-18 18:58:01 2$SGP A …
Arun
  • 187
  • 11
0
votes
1 answer

MSSQL - fetch Auto increment column value and save it in a another column

This is Regarding MSSQL auto increment feature and i have following table created CREATE TABLE Order( [order_id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [original_order_id] [int] NOT NULL ) In here i have a situation where i need…
keth
  • 793
  • 2
  • 11
  • 36
1 2 3
…
40 41