Search Results

Search found 429 results on 18 pages for 'sqlexception'.

Page 7/18 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >

• Connection error in java website. Tnsping shows that the service is running

  - by user1439090

  I have a java website application running in windows 7 which uses oracle database for its functionalities. The database has default SID name orcl. When I use tnsping, I can see that the orcl service is active. Also most of the application is working fine except for one part. I was wondering if someone could help me with the following error:- 1.…

  Read the article

• A lock could not obtained within the time requested issue

  - by Wayne Daly

  The title is the error I'm getting, when I click load my program freezes. I assume its because I'm doing a statement inside a statement, but from what I see its the only solution to my issue. By loading I want to just repopulate the list of patients, but to do so I need to do their conditions also. The code works, the bottom method is what I'm…

  Read the article

• Is there a way to find out a database cursor is open or not in Java?

  - by Java Guy

  Is there a way in JDBC to find out the cursor opened or not in JAVA. We are getting an exception when tried to access an un opened cursor. java.sql.SQLException: Cursor is closed.

  Read the article

• how to detect sql server timeout from .NET application without using catch Exception

  - by haditeo

  Hi, In my current application, i am performing an update by invoking T-SQL Update command. The problem is when the same record is locked by other users at that time. At .NET application, the application will wait until SQL Server timeout, then it will throw the SqlException timeout. Is it possible to perform a check first whether a…

  Read the article

• JBoss warning - "Unable to fill pool"

  - by Marcus

  We're getting this random warning from JBoss.. any idea why? It happens at random times when there are no active threads. Everything works when any processing resumes. 13:49:31,764 WARN [JBossManagedConnectionPool] [ ] Unable to fill pool org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable:…

  Read the article

• LINQ timed out while the same query works great in SQL

  - by oshafran

  Hi I am getting Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. When I run the SAME query in the SQL query program I get result within…

  Read the article

• Trying to invoke a stored procedure with LINQ results in error

  - by Charles

  My application produces this error System.Data.SqlClient.SqlException: Login failed for user..This started after I added a stored proc in my dbml file. It works fine in my local enviroment, but throws that error when deploy to staging sever. the user it displays is foreign to me

  Read the article

• SQL Invalid Object Name 'AddressType'

  - by salvationishere

  I am getting the above error in my VS 2008 C# method when I try to invoke the SQL getColumnNames stored procedure from VS. This SP accepts one input parameter, the table name, and works successfully from SSMS. Currently I am selecting the AdventureWorks AddressType table for it to pull the column names from this table. I…

  Read the article

• SQL Server 2005: Invalid object name exception

  - by Craig Johnston

  In VS2005, I am using a DLL which accesses a SQL Server. The DLL returns a SQLException Invalid object name 'tableXYZ' but tableXYZ is a table in the database. Should it be looking for dbo.tableXYZ instead? Is this a permissions issue with the login being used?

  Read the article

• Spring's JdbcDaoSupport (using MySQL Connector/J) fails after executing sql that adds FK

  - by John

  I am using Spring's JdbcDaoSupport class with a DriverManagerDataSource using the MySQL Connector/J 5.0 driver (driverClassName=com.mysql.jdbc.driver). allowMultiQueries is set to true in the url. My application is an in-house tool we recently developed that executes sql scripts in a directory one-by-one (allows us to…

  Read the article

• Why is Model.scoped generating invalid SQL?

  - by Nicholas H.

  When I run Book.scoped({:conditions => ['books.index LIKE ?','%query%']}) I get: ActiveRecord::StatementInvalid: SQLite3::SQLException: near "index": syntax error: SELECT * FROM "books" WHERE (books.index like '%query%') What am I doing wrong?

  Read the article

• Error with connection in my database servlet

  - by Zerobu

  Hello, I am writing a Database servlet, all seems well except that there seems to be an error in my connection import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;…

  Read the article

• How to properly clean up JDBC resources in Java?

  - by user523086

  What is considered best practices when cleaning up JDBC resources and why? I kept the example short, thus just the cleaning up of the ResultSet. finally { if(rs != null) try{ rs.close(); } catch(SQLException ignored) {} } versus finally { try{ rs.close(); } catch(Exception ignored) {} } Personally I…

  Read the article

• How to create a database deadlock using jdbc and JUNIT

  - by Isawpalmetto

  I am trying to create a database deadlock and I am using JUnit. I have two concurrent tests running which are both updating the same row in a table over and over again in a loop. My idea is that you update say row A in Table A and then row B in Table B over and over again in one test. Then at the same time you…

  Read the article

• I've caught an exception!! Now what?

  - by Jonesy

  Hi folks, I've started using try catch blocks (bit late i know!) but now im not sure what to do with the exception once i've caught it. What do people usually do here? -- Jonesy Try connection.Open() Dim sqlCmd As New SqlCommand("do some SQL", connection) Dim sqlDa As New…

  Read the article

• Java - creating an oracle date field

  - by llm

  I have an Oracle Date type to which I need to insert the current date. I am using Java to generate this date but everything I've tried so far yeilds the following error: java.sql.SQLException: ORA-01843: not a valid month Can anyone suggest java code to generate a proper date?

  Read the article

• Query having 2 Where Clause

  - by Harsha M V

  i am trying to login and want to validate username and password against the records in the database. I am not sure how to pass two Where clause public Boolean login(String username, String password) throws SQLException { Cursor mCursor = db.query(TABLE_USERS, new String[] { ID, KEY_NAME,…

  Read the article

• Problem using generics in function

  - by JAVA

  Hi all, I have this functions and need to make it one function. The only difference is type of input variable sourceColumnValue. This variable can be String or Integer but the return value of function must be always Integer. I know I need to use Generics but can't do it. public Integer…

  Read the article

• SQL Exception error??

  - by Kyle Sevenoaks

  I just came into work and found this where our site should be: SQLException ERROR: connect failed [Native Error: Host 'linux7.fastname.no' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'] [User Info: Array] What does it mean? www.euroworker.no

  Read the article

• Problem using IIS 7 and SQL SERVER 2008

  - by Daniel

  I have problem using IIS 7 and SQL Server 2008. When I trying to show my website using IIS as webserver I get the message "[SqlException (0x80131904): Login failed for user..." When I using the webserver included in Visual Studio 2010 to show same website there is no problem to access the…

  Read the article

• Circular reference with entity manager factory

  - by CodesLikeA_Mokey

  Every time I try and start my app, I get this error on startup: SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name…

  Read the article

• MS Dynamics CRM trapping .NET error before I can handle it

  - by clifgriffin

  This is a fun one. I have written a custom search page that provides faster, more user friendly searches than the default Contacts view and also allows searching of Leads and Contacts simultaneously. It uses GridViews bound to SqlDataSources that query filtered views. I'm sure…

  Read the article

• Database Tutorial: The method open() is undefined for the type MainActivity.DBAdapter

  - by user2203633

  I am trying to do this database tutorial on SQLite Eclipse: https://www.youtube.com/watch?v=j-IV87qQ00M But I get a few errors at the end.. at db.ppen(); i get error: The method open() is undefined for the type MainActivity.DBAdapter and similar for insert record and close. …

  Read the article

• Troubleshooting SQL Azure Connectivity

  - by kaleidoscope

  Technorati Tags: Rituraj,Connectivity Issues with SQL Azure Troubleshooting SQL Azure Connectivity How to resolve some of the common connectivity error messages that you would see while connecting to SQL Azure A transport-level error has occurred when receiving results from…

  Read the article

• mysql jdbc got ArrayIndexOutOfBoundsException when database name length = 9

  - by Thang Hoang

  this code below will throw : Exception in thread "main" java.sql.SQLException: Unable to connect to any hosts due to exception: java.lang.ArrayIndexOutOfBoundsException: 40 mysql 5.1, jdbc driver 5.1.21 if I change connection string to any database have name's lengh != 9, it…

  Read the article

< Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >