Tag: java

How to get the list of java processes along with their PID(process id) that are running on UAT server under a specfic account?

Problem: A jar file was failed to deploy on a UAT server. Reason: Because when we are trying to rename it,it is showing “cannot rename the file it is been used by another user”. step choosen in order to solve the problem log on UAT server(xxx). we need the list of java processes along with […]

Connecting to SQL Server using Hibernate

How to connect to the Sql Server database by using Hibernate in Netbeans 6.7.1? Please advice. The dialect is disabled for me.

Hibernate, Stored Procedures and Invalid Parameter Index Error

I have a SQL Server Stored Procedure that looks like this: CREATE PROCEDURE [dbo].[my_stored_procedure] ( @num INT, @name VARCHAR(50), @start_date DATETIME, @end_date DATETIME ) AS BEGIN … END And an Entity Object with a NamedNativeQuery that looks like this: @Entity @NamedNativeQuery( name = “myObject.myStoredProcedure”, query = “call my_stored_procedure(:num, :name, :start_date, :end_date)”, callable = true, readOnly=true, […]

Jdbcrowset bug ? return nullpointer exception!

package CrimeFile; import com.sun.rowset.JdbcRowSetImpl; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.sql.rowset.JdbcRowSet; /** * * @author singgum3b */ public class test { /** * @param args the command line arguments */ public static void main(String[] args) { try { // TODO code application logic here JdbcRowSet jrsi=new JdbcRowSetImpl(); jrsi.setUrl(“jdbc:sqlserver://localhost:1433;databaseName=CrimeFile”); jrsi.setUsername(“sa”); jrsi.setPassword(“hellokitty”); jrsi.setCommand(“select * from dbo.Target”); […]

How to Generate Matching MD5 Hash: SQL Server nvarchar Field vs. ColdFusion

I am trying to figure out how to generate a matching MD 5 hash value between SQL Server and ColdFusion. The root cause appears to be that the SQL Server field is an nvarchar datatype, which seems to mean I need to do something with the encoding of the string I would hash in ColdFusion […]

Hibernate SQL In clause making CPU usage to 100%

In my java application I am using SQL server and Hibernate3 with EJB. When I tried to execute a select query with In clause, the DB server CPU usage reaches to 100%. But when I tried to run the same query in SQL management studio, the query is running without any CPU spikes. Application server […]

Connecting NetBeans 8.0.2 to Microsoft SQL Server Management Studio

I am working on an app in NetBeans for a class and need the GUI to be able to communicate to a database that I created in Microsoft SQL Server Management Studio. The GUI need to be able to take user information and import it to the database. It also needs to be able to […]

Cannot connect to Sql Server via Android Test

I have created simple android tests with UiAutomator. In these tests I want to confirm that some data were added in the database. In my pc I can connect to the database, but in the virtual android device I get the following error: java.lang.ClassNotFoundException: Didn’t find class “net.sourceforge.jtds.jdbc.Driver” on path: /system/framework/android.test.runner.jar:/system/framework/uiautomator.jar::/data/local/tmp/Tests.jar when loading the driver: […]

How to save “Finger Print” in database

I need to save finger print type “.ftp” in MSSQL database. How can I do that? What data type should I use in creating MSSQL database? I am using Java application to get the finger print. Please help!

How do I resolve mssql resetting connections

I keep getting this error randomly when I test an application with mssql and don’t have an idea of what I can do to correct the issue. Exception [EclipseLink-4002] (Eclipse Persistence Services – 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:a2fb508d-0e8e-48b0-92ed-2d1f262b4db1 Error Code: 0 My setup consists of Eclipselink as the ORM sqljdbc v4.1 sql […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.