1. Getting exception while loading coderanch.com |
2. DB CONN. - EXCEPTION_ACCESS_VIOLATION coderanch.comI've developed a "batch process" which uses three different databases(two sql servers and one oracle). The application uses two different connection pools ; one for sql server and another one for oracle. The remaining sql server I've to connect using Data Source Name(DSN) defined in the data source. I am using sun's odbc-jdbc bridge mechanism/tool/driver to get connection and I am ... |
3. Handle Exceptions of database importing from dump coderanch.com |
4. illegalArgument exception coderanch.com |
5. JDBC Exception coderanch.com |
6. multiple primary key exception coderanch.comhai all i am getting an exception like MySQLSyntaxErrorException multiple primary key defined. my query is CREATE TABLE `first_item` ( `itemid` int(5) unsigned NOT NULL default '0', `subitemid` int(5) unsigned NOT NULL default '0', PRIMARY KEY (`itemid`,`subitemid`) ) i am using innodb as the database engine. can someone give me any suggestion please. thanks [ November 19, 2007: Message edited by: ... |
7. Newbie needs help with "Object has been closed" exception coderanch.comAloha ranchers, I'm starting to work with JDBC and MSSQL this week. This thread is related to this thread for those who are wondering... With help from a co-worker, I have successfully setup a JNDI datasource in Tomcat. I've also been able to connect to the server and run a simple stored procedure. After turning up the heat a bit, I've ... |
9. database exception coderanch.com |
10. ArrayIndex OutOfBounds Exception coderanch.comHI All, I'm face a problem with prepareStatement. when i run my code,the compiler will give me a "java.lang.ArrayIndexOutOfBoundsException: 28 oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:925) oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:608) oracle.jdbc.driver.OraclePreparedStatement. |
11. EXCEPTION_ACCESS_VIOLATION (0xc0000005) coderanch.com |
12. String Index Out of Bounds Exception coderanch.comPlese use code tags (button below the message window) on quoted code; it makes it much easier to read. If you don't have a ; inside your String then the indexOf(";") will come out as -1. If you try to get a substring and pass -1 as a parameter it is outwith the bounds of the String . . . voil ... |
13. Exception at JNDI coderanch.com |
14. Getting Exception as Could not find stored procedure 'sp_getNextMainGroup' coderanch.comHi All, I tried to call the stored procedure from java but I am getting Exception as : [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'sp_getNextMainGroup' I checked the DB there 'sp_getNextMainGroup' is already exist, even checked the permision of user for the DB every thing is fine. I unable to get the root cause of this Issue, can ... |
15. Class not found exception coderanch.com |
16. Handling database exception coderanch.comHello Listers, I have a question about how to "design error handling" for a generic class that accesses a database. I want to use try/catch/finally because if there is a problem during the flow, I would like to disconnect and destroy the connection (so that's why I don't want to declare a "throws") But at the same time, after closing the ... |
17. Exception in thread "main" coderanch.comHi Everyone, I have battled through the last 2 weeks installing tomcat and MySQL on my Mac. Now i feel like i am at the final hurdle, and yet again I am stumbling. I am following this tutorial to connect to MySQL database: http://lxuser.tripod.com/apache/jdbc_mysql.html When installing the connector i placed the .jar file in $JAVA_HOME/lib/ext Then I used this simple piece ... |
18. Exception: com.microsoft.jdbc coderanch.comHi, i didn't understand either of them..my sql jdbc driver is in C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC i have placed my jar files in: C:\apache-tomcat-5.5.23\webapps\ROOT\WEB-INF\lib i have kept my source code in C:\apache-tomcat-5.5.23\webapps\jbse\WEB-INF\classes\jbs i am using the same ip tht i hav specified in the URL.and my database name is data1 Thanks & Regards, Anubha. |
19. How to handle database exceptions coderanch.comI have a gui program that displays a table and allows users to click on diffrent fields and change the data. Almost all these fields are unique to one record though. If the use input a duplicate unique value and tries to comit the changes the database throws an error that basically does nothing but say "Dupplicate key" What I want ... |
22. class not found exception. coderanch.com |
23. exception handling coderanch.com |
24. Class not found Exception? coderanch.com |
25. What is the need for creating a Exception for DAO Layer coderanch.com |
26. Java Memory Heap Exception coderanch.comHuge result sets usually don't really have a place in web applications; are you really expecting users to wade through tens of thousands of results? Or just look through the first twenty and search again? The usual way to handle this is to use paging. Have a search through this forum, there are hundreds of examples. |
27. jar won't run outside of IDE: Throws exception: java.lang.NoClassDefFoundError: oracle/jdbc/OracleDr coderanch.comSo, basically, I need to be able to distribute my newly created java project for beta testing. I developed a console application in NetBeans that accesses a remote oracle 10i DB. The first thing I did when I built this (having never written software that connects to a database in my life) was to research how its done, download ojdbc6 drivers ... |
28. Missing IN or OUT parameter at Index:24 Exception after change in database version coderanch.comHi, I am facing an issue after we have got our database upgraded from oracle 10.2.0.3 to 10.2.0.4 with a patch deployment. The exception received is following. WARNING: error in adding model to batch Jul 24, 2009 11:28:58 AM AbstractDaoJdbcImpl addBatch WARNING: error in adding model to batch Jul 24, 2009 11:28:58 AM AbstractDaoJdbcImpl addBatch WARNING: Missing IN or OUT parameter ... |
29. Invalid Handle Exception coderanch.comI an using access database.When i tried to update data, i am getting invalid handle exception and How can i get no of columns from database? import java.sql.*; import java.util.*; public class StockDataBase { private static Statement s; private static Connection c; StockDataBase() { createConnection(); } public static void createConnection() { try { String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Stock.mdb;"; c ... |
30. Access Control Exception coderanch.com |
31. Exception while trying to add a new user to the database coderanch.comDear Sir, As per my requirement in my existing project I am adding a GID column and this GID column is inserted in the LOGIN_USER table. So I have only change my existing function addUserMasterData(). private void addUserMasterData(AbcUserValue user) throws AbcUserException, SQLException, EJBException { /* String sql = "INSERT INTO LOGIN_USER (LOGIN_NAME, PASSWORD,EMAIL,EMP_ID ) values (?, ?, ?, ?)";// //With out ... |
32. how to recognize integrity constraint from exception coderanch.com |
33. Nullpointer exception? coderanch.compackage web; import java.sql.*; import java.util.*; public class DAO { ArrayList al; Connection con; ResultSet rs; Statement st; public Connection getConnection() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MyData"); } catch(ClassNotFoundException cnfe) {} catch(SQLException se) {} return con; } public ArrayList getData() { try { con=getConnection(); st=con.createStatement(); rs=st.executeQuery("select * from jyoti"); while (rs.next()) { EntityBean eb=new EntityBean(); String name=rs.getString(1); eb.setName(name); int age=rs.getInt(2); eb.setAge(age); String ... |
34. exception related to data constraint coderanch.comFor a table that has "unique index" constraint --- for example the table has 10 columns. One of them is PK, I add another constraint that the combination of 5 columns has to be unique. Then when I use JDBC to insert a row, if it violates this constraint, what kind exception will be thrown ? will it be a regular ... |
35. Getting an Exception wile accessing data coderanch.comHi I'm just trying to access data for testing purpose only. For this i have created mysql data "test" and created a table "country" (srno, countryname). I have created following java class and trying to pull filed values from above table country. ShowParameters.java package com; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class ShowParameters{ public static void main(String args[]) ... |
36. Axis Web Service not catching 0RA-28001 DB Password Expired exception coderanch.comHi everybody, I am attempting to insert one row at a time to an Oracle DB, through an Axis Web Service. The DB connection is configured in the Tomcat server.xml. I am using preparedStatement.executeUpdate to run the insert query. It was working fine until the DB Password expired. The executeUpdate is returning 1 (ie. one row updated) but the data does ... |
37. Io exception: There is no process to read data written to a pipe. coderanch.com |
39. reg Network adaptor Exception coderanch.com |
40. exception coderanch.comi set the field to unique in mysql database. when i input data into the field, the alert message shown in mysql: can't insert duplicate value for that field. but when i input same data in that field from jsp and then submit form i would like to ask why the code don't fall to exception as i use try{ update ... |
41. class not found exception coderanch.comI am getting this exception: javax.servlet.ServletException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:286) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1484) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329) java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:169) com.jamesholmes.abc.SearchAction.execute(SearchAction.java:24) org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305) org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.24 logs. I am using Struts 1.3.10 , oracle XE, and Tomcat-6.0.24. ... |
43. which exception is thrown on duplicates coderanch.com |
44. io exception got minus one from a read call coderanch.com |
45. getting class not found exception coderanch.comHi friends still i am unable to resolve this issue. I set my class path to C:\bea\user_project\workspace\wlserver_10.3\server\ext\jdbc\oracle\11g\ojdbc5.jar; i am using weblogic 10.3 workspace and weblogic 10.3 server. package com.example.model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Driver { public static void main(String args[]) throws ClassNotFoundException, SQLException { System.out.println("Install Driver"); Class.forName(""); //Class.forName("weblogic.jdbc.oci.D iver"); //DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); System.out.println("Driver Installed ... |
47. Exception handling coderanch.comI don't think there will be any direct way to solve that issue. Your best bet is to avoid that exception by first cleaning the data or filtering it before inserting. Since you are inserting lakhs of records, inserting one record at a time will drastically increase the time taken to complete the job. So, that solution might not work for ... |
48. Communications link failure due to underlying exception coderanch.comHi, I am getting this exception frequently on console. I have increase Mysql time out period to 8 Hr also but it doesn't work. After restart tomcat it work for some time again this exceptions come on console. I am using Tomcat 6 with MySQL, and Torque =============================================================================== [11/21/10 12:02 AM WARNING] TorqueException while getting the new Connection org.apache.torque.TorqueException: com.mysql.jdbc.CommunicationsException: Communications ... |
49. exceptions occurring here coderanch.comWhile running a page a amazing group of exception is occuring. i Don't know why? INFO: oracle.sql.CLOB@7b1d52 SEVERE: ApplicationDispatcher[/IAC] PWC1231: Servlet.service() for servlet jsp threw exception java.sql.SQLException: Io exception: Unexpected packet at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333) at oracle.jdbc.ttc7.TTC7Protocol.getLobChunkSize(TTC7Protocol.java:3047) at oracle.sql.LobDBAccessImpl.getChunkSize(LobDBAccessImpl.java:686) at oracle.sql.CLOB.getChunkSize(CLOB.java:664) at oracle.sql.CLOB.getBufferSize(CLOB.java:689) at oracle.sql.CLOB.getAsciiStream(CLOB.java:342) at oracle.sql.CLOB.asciiStreamValue(CLOB.java:1350) at oracle.jdbc.driver.OracleStatement.getAsciiStreamValue(OracleStatement.java:5213) at oracle.jdbc.driver.OracleResultSetImpl.getAsciiStream(OracleResultSetImpl.java:682) at oracle.jdbc.driver.OracleResultSet.getAsciiStream(OracleResultSet.java:1637) at org.apache.jsp.MsgReprocess_jsp._jspService(MsgReprocess_jsp.java from :1145) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) ... |
50. Array index out of bounds exception coderanch.comHi All, I am working on this small project and am having an exception thrown. I had never seen this before even though this code had worked before without problems. First, here is the code String item; String columnName; Vector |
51. column not allowwd here - exception coderanch.com |
52. getGeneratedKeys() causing exception coderanch.com |
53. exception coderanch.com |
54. Getting EXception coderanch.comHere are my code............... package classes; import java.util.*; import java.sql.*; /** * * @author sonisan */ public class ccb_bean { ConnectionPool c; int Sno; String ccb_no; String ccb_desc; String file_dt; String release_dt; String comnts; String userName="root"; String password="root"; String url="jdbc:mysql://172.18.41.55/ccb"; Connection connection; public ccb_bean() { ccb_no= new String(); ccb_desc=new String(); file_dt=new String(); release_dt= new String(); comnts=new String(); } public ccb_bean(int Sno, ... |
55. how to handle nested exception coderanch.comHi, I am trying to connect to mysql database. I am using try catch while establishing connection. I want that I should be able to know what exception was caught, so that, I can show appropriate error message. e.g if I pass incorrect hostname, i should show Wrong hostname provided. One way to do is get class name of runtime exception ... |
56. "Could not find stored procedure" exception coderanch.comHi All, I've been struggling with trying to call a stored procedure on MSSQL server. Everytime I use CallableStatement to call the stored procedure, I get: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'TESTDB.dbo.PROCESSING'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source) ... ... |
57. Begin Nested Exception coderanch.comI'm getting an error called Begin Nested Exception while running my batch file which is used to insert data into MySql database from an Excel. the error as follows com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Connection reset STACKTRACE: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1994) at ... |
58. exception while running my first jdbc code coderanch.comi have make database in my microsoft sql server and created tables and all , then i test the connection in the odbc data source administrator it gives me succesfull result ( ms normally as we do in sql server ) ...thinks are fine till this then i have coded my first jdbc code where i m selecting all the values ... |
59. Database Project keeps throwing Exceptions. java-forums.orgHi, I'm working on a Database project in NetBeans and I'm encountering several problems with my application. I use Vectors in one class to store several variables which is sent to my JTable in another form. I keep getting several exceptions. java.sql.SQLException Cannot find driver for jdbc:odbc and also a lot of : NullPointerExceptions Please help, I'm really lost, please request ... |
60. Exception:Result consisted of more than one row java-forums.orgHi, I am trying to insert variable number of rows in a table using a single insert statement. To do this i am using for loop. It was running fine. But i want to insert values for 4 tables and plus this multiple rows table. the remaining 4 tables insert only one row. i am using stored procedure for this. but ... |
61. getting could not resolve property exception java-forums.org@SuppressWarnings("unchecked") //testing to see if i can get a specfic employee //using the session.createCriteria public List |
62. Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/pool/Orac leDa java-forums.orgHi Everyone, I have installed Tomcat 5.5 and Oracle 9i and JDK 1.6 installed on my machine. I'm just trying to test the connection by running a few sample programs from the oracle sample directory,But seeing the following problems.. Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource at DataSource.main(DataSource.java:20) Caused by: java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at ... |
63. testing oracle-character-set-1 against |
64. Exception java-forums.orgFollowing is the code that I have written to get connection to SQL Server: public class Main { public static void main(String[] args) { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlser ver://localhost:1433;DATABASENAME=Test","mimdad","aaa"); } catch (Exception e) { e.printStackTrace(); } } } and following is the exception that I am getting at the Class.forName(). java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at java.net.URLClassLoader$1.run(URLClassLoader.java: 200) at java.security.AccessController.doPrivileged(Native ... |
65. why this exception java-forums.orgHi all, Im fetching 500 records from an Excel sheet and inserting these in another sheet using jdbc-odbc driver. While this some records are inserting successfully n then Im facing an exception titled 'field cannot be updated'. This behavior is not uniform the row where this exception occurs is different every time. Wat is d problem? Thanx in advance.... |
66. Exception while saving in database java-forums.org |
67. Exception in thread "main" java.lang.NoClassDefFoundError: org/hsqldb/Serve forums.oracle.com |
68. DataBase: how to resolve these exception forums.oracle.com |
69. jdbc and MSQL--SQLException: socket exception: coonect forums.oracle.com |
70. (Class cast Exception)Problem while loading data fro database in java class forums.oracle.comIn my java code i was trying to load the data to a UI. I am successfull in loading the String type value. But while loading date field value,is showing Class cast Exception. What i am doing is Getting the values from database to a String[] array. So my question is how to get the Date field as date field itself,Then ... |
71. JDBC Exception Handling forums.oracle.com |
72. Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/Orac forums.oracle.comHi guys, am having the same problems, I compiled my program and it complied fine, but when I try to run it after setting the necessary classpath, I get an exception Exception in thread "main" java.lang.NoClassDefFoundError: MyClassname When I copy the classes12.jar to the current working directory, I get an exception from the Class.forName statement: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver. I even t |
73. Persistence: Database Exception. forums.oracle.comI used the databsedriver as mysql driver. Won't it work with mysql? Is there any default driver associated with it? I created the application with Java SE by adding the following libraries with it javaee.jar, derbyclient.jar Can anybody give a solution to this problem? Any help to this problem will be greatly appreciated. Thanks, Sreejith. |