We're having a debate at work on this topic and I'd like to get input from all you gurus out there. We have written a web-based java application for writing insurance policies. When a user is ready to rate the policy we have to assemble all of our data (about 700 fields) into several very ...
Comments (24) | Promote | Bookmark
ORA-00600 [ttcgcshnd][0][ ][ ] ...problemWed, 16 Jul 2008 19:42:00 GMThello all,I'am trying to connect to Oracle database using Type-4 driver.The problem is the driver gets loaded...I get the connection object.I also get the statement object form the con obj.But when i try to call executeQuery() on stmt I get the following error...SqlException...internal error...
Comments (5) | Promote | Bookmark
setAutoCommit()Wed, 16 Jul 2008 19:25:00 GMTHi, I am a bit confused about setAutoCommit(). What happens when we set it to true? Whatever commands that is in its Statement will be executed right a way(immediately commits)?What happens when we set it to false?...
Comments (4) | Promote | Bookmark
Acces DataBaseTue, 18 Sep 2007 17:33:00 GMTI need to connect to an acces database, please help me where can i find something obout it. ...
Comments (4) | Promote | Bookmark
problem with hibernate 3.0Sun, 23 Sep 2007 20:38:00 GMTHi all I am new to hibernate and i'm using hibernate 3.0. My problem is I am not able to get the configuration object.I am getting null pointer exception.My code is follows:Configuration cfg = new Configuration().addClass(Contact.class);SessionFactory sessionFactory = ...
Comments (3) | Promote | Bookmark
selction query for dateTue, 25 Sep 2007 00:38:00 GMTi have a interface there user can enter two dates . in my servlet program i am getting it as string by using request .get parameter. i wanan to know how to write sql query for selecting data from database with between clause...
Comments (3) | Promote | Bookmark
JDBC thick driver & AIXMon, 11 Feb 2008 11:57:00 GMTHi All,I was wondering what jdbc jar (ojdbc14.jar or classes12.jar) to use with 9i when using the thick client connection (oci8) on an AIX box with ibm jvm 1.4.1. Seems ojdbc14.jar causes a unsatifiedlinkerror. We switched to classes12.jar and it worked but I was concerned about using a xxxx12.j...
Comments (3) | Promote | Bookmark
Resultset ObjectTue, 18 Sep 2007 21:12:00 GMTcan any one out there please tell me about how to retrive resultset object through RMI as resultset is not serializable? or should i have to do somthing other than RMI. (which actually i don't want to) ...
Comments (3) | Promote | Bookmark
Problem with a simple queryFri, 21 Sep 2007 15:31:00 GMTHey. I've got a table which contains only one entry:Table "users":id | date | user | pass | profile | last_logged1 | ... | evo | ... | ...| ...My query is: "SELECT * FROM users WHERE user=evo". The problem is that im always gettings a null pointer exception, but if I get the data by refering ...
Comments (2) | Promote | Bookmark
Jdbc with MS-excelWed, 16 Jul 2008 19:31:00 GMTPlease tell me how to use jadc with MS-excel worksheet. Say I have a file "Emp" in excel and I want to retrieve the data from it. How to do it. It will be of great help if steps and code are given.Thanks ...
Comments (2) | Promote | Bookmark
Hibernate errorSun, 23 Sep 2007 01:32:00 GMTi get this kind of error when i add this to my Team.hbm.xml file<set name="players" cascade="all"><key column="team"/><one-to-many class="model.Player"/></set>this is the errorException in thread "main" java.lang.NoClassDefFoundError: org/odmg/DSetwhat is wrong, if i ...
Comments (2) | Promote | Bookmark
Databases & MVCThu, 20 Sep 2007 22:39:00 GMTHi,I have an MVC structure for my web-application. Now I need to integrate database transactions into my javabeans.I use a database pool manager for this. How can I create one instance of the database pool manager so it is known in my web-application (beans)?Thanks...
Comments (1) | Promote | Bookmark
JDBC-ODBC Bridge seems to slow down after a whileTue, 18 Sep 2007 04:13:00 GMTHi,I've got a weird problem going on with an application I'm writing. I hope someone can tell me what I'm doing wrong.The problem I'm encountering is in he code shown below. The function getAllGamesForATeam is creating a list of items in an ArrayList and passing it back to an Event handler ...
Comments (1) | Promote | Bookmark
mysqlWed, 16 Jul 2008 19:38:00 GMTHi all,I remember doing this at uni but I cant remember how. I am creating a database in mysql and entering all of the commands. I wanted to put these in a file and then execute the file. Just incase I have to move the site to another machine later on.I have created a file called lodge.sqlit con...
Comments (1) | Promote | Bookmark
javax.servlet.ServletException: General errorFri, 21 Sep 2007 01:45:00 GMTHi I have successfully uploaded and saved images into oracle(8.1.5) table DATA_TYPE(dtid number, iconname varchar2(30), icon blob). When I try to retrieve icon from the database, I get "javax.servlet.ServletException: General error" at:PreparedStatement pstmt = ...
Comments (1) | Promote | Bookmark
types of drivers & examplesWed, 16 Jul 2008 19:56:00 GMTHello is there any article which explains the different types of drivers and what those drivers are with examples. can anyone explain about the drivers.thanks....
Comments (1) | Promote | Bookmark
PreparedStatement , setting multiple values as an array in a placeholderThu, 20 Sep 2007 12:30:00 GMTHi!I need to know how to set multiple values (variable size) to a bind parameterThe prepared statement looks like this -SELECT * from EMP where emp_id in (1,2,3,4,5,6,7,8, ........)...here (1,2,3,4,5,6,7,8, ........) are the values which could be of n sizeIs there any way wherein an array could ...
Comments (1) | Promote | Bookmark
Array of StatementsThu, 20 Sep 2007 20:20:00 GMTIs it possible to have an array of statements?Statement[] ArrayStatements;I have a program that uses multiple statments that I just want to index in an array?Thanks,Eric...
Comments (1) | Promote | Bookmark
Number of Records from DBWed, 19 Sep 2007 06:15:00 GMTIs there anyway to get the number of records returned by the execution of a SQL query?.I want to execute SINGLE QUERY which returns both number of records and the individual records..For eg.. Number of employee records and each employee record.Its urgent..Please help.Thanx in ...
Comments (1) | Promote | Bookmark
SQL Query for Airline ReservationWed, 16 Jul 2008 19:52:00 GMTIn Airline Reservation System, I want to determine the various connectivities between two different cities.There might be N combinations for the above query.i.e A-->B-->C-->DA-->E-->F-->DA-->E->DHow will I solve this problem in MS-SQL, do we have the facility for recursio...
Comments (1) | Promote | Bookmark
returning recordset from stored proceduresSun, 10 Feb 2008 04:16:00 GMTHiI am trying to get a stored procedure to return multiple values (i.e. a recordset) and want to access them from JDBC. Is that possible?Frankie =:>...
Comments (1) | Promote | Bookmark
is this tomcat problem or Driver problem?Wed, 16 Jul 2008 19:46:00 GMTHi we are developing application that supports unicode fonts. we are usingIDE : JdeveloperFont:Lohit TamilDriver: JDBC type-4 Thin driverWhile testing application in jdeveloper , No problem for retrieving and storing unicode data in postgres.But am getting problem with tomcat server.it retreives...
Comments (0) | Promote | Bookmark
DatabaseMetaData error when connect to Linux or Solaris Database ServerSun, 10 Feb 2008 10:20:00 GMTI write some code to display table structure of a table,when I connect to sybase,sql server,oracle on Windows or HP or AIX, it works well,but when I connect to Oracle 8.1.7 or Oracle 9.0.1 on Linux and Solaris, these code does not work correctly. My oracle jdbc driver is 9.0.1....
Comments (0) | Promote | Bookmark
Missing Data From ExcelWed, 16 Jul 2008 19:26:00 GMThi,while reading the data from excell file, values for some of the fields returning as null eventhough thses cells contains the data. please tell me how to solve this problem.byeglkishore...
Comments (0) | Promote | Bookmark
Function in Callable StatementWed, 16 Jul 2008 19:51:00 GMTCan we use function in Callable Statement?...
Comments (0) | Promote | Bookmark
sqlj execution errorSat, 09 Feb 2008 23:01:00 GMTHi,I am developing a product on sqlj. I am usingoracle8.1.6 with jdk1.2.2. I able to generate the java file and compile it. But when I execute it I get the following error.NetCNM:driver designator not found.Kindly give me a solution for the above problemWith regardsAnuradha...
Comments (0) | Promote | Bookmark
JDBC & Combo boxesMon, 24 Sep 2007 02:08:00 GMTI am tring to update a table on an SQL database using values from a combobox selection but it gives me an error saying i cant you a name, either constants and variables are allowed. please send me a sample code that reads data from a combo box ans update a certain table on my database....
Comments (0) | Promote | Bookmark
Sql loaderSun, 10 Feb 2008 02:45:00 GMTThe character set ID was obtained from the database server, theSQL*Loader client does not have knowledge of the given characterset ID. Possible mismatch of NLS data on the client and serverside....
Comments (0) | Promote | Bookmark
MS SQL Server 2000 & MS JDBC SQL Server driver problems. (ConnectionWed, 30 Apr 2008 12:06:00 GMTHi. In order for the jdbc driver to connect to the DBMS, the DBMS needs to beconfigured to listen for TCP connection requests. It does not do this by default.Ie: "Mixed mode" connections in setup. 1433 is the default port for a SQLServerto use for tcp connections. You should verify that the DBMS...
Comments (0) | Promote | Bookmark
DB Development Tools (DB2/OS390)?Wed, 16 Jul 2008 19:43:00 GMT(Hope this is an appropriate topic for this forum.) I'm currently researching tools to help speed up the java development process, and I was wondering what, if any, DB development tools other java developers are using? I'm primarily interested in tools which support DB2 on OS390. I only...
Hi we are developing application that supports unicode fonts. we are usingIDE : JdeveloperFont:Lohit TamilDriver: JDBC type-4 Thin driverWhile testing application in jdeveloper , No problem for retrieving and storing unicode data in postgres.But am getting problem with tomcat server.it retreives...
I write some code to display table structure of a table,when I connect to sybase,sql server,oracle on Windows or HP or AIX, it works well,but when I connect to Oracle 8.1.7 or Oracle 9.0.1 on Linux and Solaris, these code does not work correctly. My oracle jdbc driver is 9.0.1....
hi,while reading the data from excell file, values for some of the fields returning as null eventhough thses cells contains the data. please tell me how to solve this problem.byeglkishore...
Can we use function in Callable Statement?...
Hi,I am developing a product on sqlj. I am usingoracle8.1.6 with jdk1.2.2. I able to generate the java file and compile it. But when I execute it I get the following error.NetCNM:driver designator not found.Kindly give me a solution for the above problemWith regardsAnuradha...
I am tring to update a table on an SQL database using values from a combobox selection but it gives me an error saying i cant you a name, either constants and variables are allowed. please send me a sample code that reads data from a combo box ans update a certain table on my database....
The character set ID was obtained from the database server, theSQL*Loader client does not have knowledge of the given characterset ID. Possible mismatch of NLS data on the client and serverside....
Hi. In order for the jdbc driver to connect to the DBMS, the DBMS needs to beconfigured to listen for TCP connection requests. It does not do this by default.Ie: "Mixed mode" connections in setup. 1433 is the default port for a SQLServerto use for tcp connections. You should verify that the DBMS...
(Hope this is an appropriate topic for this forum.) I'm currently researching tools to help speed up the java development process, and I was wondering what, if any, DB development tools other java developers are using? I'm primarily interested in tools which support DB2 on OS390. I only...
In Airline Reservation System, I want to determine the various connectivities between two different cities.There might be N combinations for the above query.i.e A-->B-->C-->DA-->E-->F-->DA-->E->DHow will I solve this problem in MS-SQL, do we have the facility for recursio...