Message from WebSQL - staff Most recent post: 10/22/2007 3 authors and 4 replies. This is a web based application that can be installed on a web server in your environment to manage your database over a browser. At moment is available only a demo, try it now and let us know what you think about. Home page: http://www.websq.eu Demo page: http://www.hostingJAVA.it/-websql/ Regards, WebSQL staff. read more about [ANN] WebSQL - web based database administrator tool
Message from Grzesiek Most recent post: 10/21/2007 2 authors and 2 replies. Hi , I can access Microsoft Access database using the folowing code: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String filename = "d:/dataBase.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; Connection con = DriverManager.getConnection( database ,"",""); and it works fine. But I have a question. What DriverID stands for? Why you write DriverID=22. Are there possible other values of DriverID? Thanx in advance :-) read more about DriverID in JDBC-ODBC bridge
Message from jasiu85 Most recent post: 10/19/2007 2 authors and 2 replies. Hi, I have two questions regarding JPQL and operations on dates and times: 1) I have a table where I store datetime intervals, like this: (dt_start, dt_end). I want to find all intervals that contain given date, i.e. those for which following inequality holds: dt_start <= given_date AND given_date < dt_end. How to write such query in JPQL? 2) How can I add some seconds to a date in JPQL? Can I build an expression like that? I'm using MySQL and I can write those queries in its SQL, so I could use native queries, but I'd like to stick to JPQL, if possible. Regards, Mike read more about date operations in jpql queries
Message from K Gaur Most recent post: 10/18/2007 3 authors and 3 replies. hello everybodyi tried the following jsp code to query cloudscape db : __________________________________________________- <%@xxxxxxxxxxx page import="JAVA.io.StringWriter" %> <%@xxxxxxxxxxx page import="JAVA.io.PrintWriter" %> <%@xxxxxxxxxxx page import="JAVA.sql.*" %> <html> <body> <b><h1>Search Page</h1></b><br><br> <!-- here handle the request parameters and give control to apt func. --> <% String varpname=request.getParameter("pname"); String vardepname=request.getParameter("depname"); String vardocname=request.getParameter("docname"); String jdbcurl="jdbc:derby:C:\Program Files\IBM \Cloudscape_10.0\frameworks\NetworkServer\bin\projdb"; jdbcurl= JAVA.net.URLDecoder.decode(jdbcurl).trim(); String query="select pname,dname,statusfld from status,ptb,dtb where status.pid=ptb.pid and status.did=dtb.did order by pname"; query= JAVA.net.URLDecoder.decode(query).trim(); %><!-- user form for search --> <form name="searchForm" action="search.jsp"> <table> <tr> <td> Party Name:</td> <td> <input type="text" size="30" name="pname"> </td> </tr> <tr> <td> Department Name:</td> <td> <input type= read more about problem with jdbc url and query in jsp code
Message from francan00 Most recent post: 10/18/2007 2 authors and 2 replies. I'd like to create a single Database connection point that I can use for several of my classes in my JAVA Web Application. Here is my ConnectionManager Class: public class ConnectionManager { private static Connection activeConnection = null; public static Connection getConnection() { if (activeConnection = null) { Class.forName("OracleThinInfoHere..."); activeConnection = DriverManager.getConnection("jdbc:oracle:thin:@xxxxxxxxxxx:1234:orcl", "scott", "tiger"); } return activeConnection; } } Now how'd I access the ConnectionManager in each one of my classes? For example here is one: public class MainClass { public ConnectionManager.getConnection(); public Connection connection; //I tried my db connection as this and it didnt return any results public MainClass(connection) { this.connection = ConnectionManager.getConnection(); } public int matcher(BeanClass abc) { try { new OtherDbClass(connection).insertDbMethod(abc); } catch(Exception e) { e.printStackTrace(); } finally { //closing statements here }Another Class looks like this: public class OtherDbClass { private Connection connection; public OtherDbClass(Connection connection) { this.connection = ConnectionManager.getConnection(); } public int insertDbMethod(BeanClass abc) { ... ... } Please advise. read more about Single Connection attempt
Message from Rupert Woodman Most recent post: 10/16/2007 3 authors and 4 replies. I have a MySQL (5) database which has a table containing an ENUM column. I'd like to (programatically) get a list of what the valid options are for this ENUM. I have looked through the metadata but can not see anything. Can someone point out what I'm missing? Many thanks read more about Finding valid ENUM values
Message from Corona4456 Most recent post: 10/14/2007 4 authors and 9 replies. How'd you go about getting a list of tables from db2 using jdbc? read more about jdbc and DB2
Message from K Gaur Most recent post: 10/12/2007 3 authors and 7 replies. hello friends, I am using apache tomcat 6.0, jdk 6, and I want to upload .doc files to cloudscape 10 database. I want to know if there is no API (application programming interface)in JAVA to upload files. if not then how do I proceed to get this done. please help thanks in advance read more about problem with uploading files
Message from Knut Fjellheim Most recent post: 10/4/2007 2 authors and 2 replies. What'd be the best approach to achieve this? More specifically, our customers have long description texts that need to be searched. Are there alternative strategies that'd be better suited than trying to search CLOBs? read more about Searching CLOBs through Hibernate
Message from pjvleeuwen Most recent post: 10/4/2007 6 authors and 12 replies. Hi all, I'm quite new to all jdbc, but so far working with resultset's over SQL seemed easy so far, but I'm having some problems writing a blob to the database. What I try to do is two steps: 1. read an image from the web and write it to a blob 2. read the blob and display it as an image I did the same thing before without trying to write to the blob, but I want to store the images in DB because the only stay on the web for a couple of weeks. Googling for UpdatableResultset updateBlob AbstractMethodError gets me lost. Any help is well appreciated. By the way: the image is 18257 bytes and max_allowed_packet of MySQL is 1048576 Anyone? thanx ### stderr output ### Exception in thread "main" JAVA.lang.AbstractMethodError: com.mysql.jdbc.UpdatableResultSet.updateBlob(LJAVA/lang/String;LJAVA/ io/InputStream;)V at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA: 52) ######### JAVA class ### package nl.vanleeuwenwilmot.housing.search.woonnet.app; import JAVA.awt.BorderLayout; import JAVA.awt.Image; import JAVA.io.IOException; import JAVA.io.InputStream; import JAVA.net.URL; import JAVA.sql.Connection; import JAVA.sql.DriverManager; import JAVA.sql.ResultSet; import JAVA.sql.SQLException; import JAVA.sql.Statement; import JAVAx.imageio.ImageIO; import JAVAx.swing.ImageIcon; import JAVAx.swing.JFrame; import JAVAx.swing.JLabel; public class Test { /** * @xxxxxxxxxxx args * @xxxxxxxxxxx IOExc read more about com.mysql.jdbc.UpdatableResultSet.updateBlob gives AbstractMethodError
Message from Dyreatnews Most recent post: 10/2/2007 2 authors and 3 replies. --=-=-= Content-Type: message/rfc822 Content-Disposition: inline X-From-Line: dt136804 Mon Oct 1 14:04:19 2007 Return-path: <derby-user-return-7747-Dyre.Tjeldvoll=sun.com@xxxxxxxxxxx> Received: from mail-emea.EU.sun.com [192.18.6.130] by khepri29 with IMAP (fetchmail-6.3.4) for <dt136804@xxxxxxxxxxx> (single-drop); Mon, 01 Oct 2007 14:04:19 +0200 (CEST) Received: from fe-emea-10.sun.com ([192.18.6.120]) by emea3-mail1.uk.sun.com (Sun JAVA System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTP id <0JP8000XNETTM660@xxxxxxxxxxx> for dt136804@xxxxxxxxxxx; Mon, 01 Oct 2007 13:03:29 +0100 (BST) Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun JAVA System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JP800I01CHXX000@xxxxxxxxxxx> for dt136804@xxxxxxxxxxx (ORCPT Dyre.Tjeldvoll@xxxxxxxxxxx); Mon, 01 Oct 2007 13:03:29 +0100 (BST) Received: from phys-emea3-1.uk.sun.com ([192.18.6.12]) by fe-emea-10.sun.com (Sun JAVA System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTP id <0JP800HLEETLGVD0@xxxxxxxxxxx> for dt136804@xxxxxxxxxxx (ORCPT Dyre.Tjeldvoll@xxxxxxxxxxx); Mon, 01 Oct 2007 13:03:22 +0100 (BST) Received: from dm-norway-02.uk.sun.com ([129.156.101.226]) by emea3-mail1.uk.sun.com (Sun JAVA System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTP id <0JP8000UTETMM660@xxxxxxxxxxx> for dt136804@xxxxxxxxxxx read more about [Aaron J Tarter] Re: [comp.lang.JAVA.databases] Derby eclipse install
Message from RedGrittyBrick Most recent post: 10/1/2007 6 authors and 12 replies. It's a bit quiet in comp.lang.JAVA.databases so I hope no-one minds a database question that is not particularly related to JAVA or JDBC (though that's what I am actually using). I have an app, several bits of which allow a user to maintain simple tabular reference data that is stored in database tables. When the user elects to maintain one of these tables, I pop up a new window that contains a JPanel containing a JTable, an "OK" button and a "Cancel" button. In the JPanel's constructor I get a JAVA.sql.Connection instance and thus open a connection to the DBMS. Whilst the user edits the data in the JTable I am firing off the appropriate executeUpdate methods to send updates to the DBMS. When the user clicks OK I invoke commit() and close() on the connection. If the user clicks Cancel I invoke rollback() and close() on the connection. -- * -- However if the user does a few changes and then wanders off for lunch, the database table is left in a locked state that obviously is likely to cause problems for other users (or other threads in the user's app). The only improvements I can think of are to track the changes inside the app and only do getConnection(), executeUpdate(), close() in the "OK" button's ActionListener. Keeping a log of changes or comparing before and after versions of a List<foo> in a table model seems a bit tedious. Maybe I should do the getConnection(), executeUpdate(), close() for each read more about (Mis)use of transactions
Message from Russell171 Most recent post: 10/1/2007 2 authors and 2 replies. The install instructions for Derby 10.3.1.4 in Eclipse 3.3 implies that = it is as simple as having the Eclipse\plugins directory containing these = three directories: org.apache.derby.core_10.3.1, org.apache.derby.ui_1.1.1, and = org.apache.derby.plugin.doc_1.1.1, as obtained from extracting the zip = files. And afterwards, the Apache Derby menu item should appear when the = project folder is right-clicked. In my case, that doesn't happen. There must be something small which is = understood by experienced users, who write the instructions, that isn't = so obvious for beginners. Can someone point me in the right direction? Thanks. read more about Derby eclipse install
Message from Aakash Most recent post: 9/28/2007 4 authors and 4 replies. i am a faculty in NIIT, INDIA. I am working over ms-windows and sqlserver2000 as backend. I want to know if there is any way to connect to a database without creating a DSN(Data Source Name) which we've to create in-order to connect to a database. read more about about connecting to a database
Message from thushianthan15 Most recent post: 9/27/2007 6 authors and 9 replies. Hi everyone, I got an error, when I tried to connect mysql with JAVA. Any suggestions ? Thank you. Bug Report ========== OS : RedHat Fedora Core 6 JSDK version : JAVAc 1.5.0_12 [Linux version] MySQL version : mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using readline 5.0 MySQL/JConnector version : mysql-connector-JAVA-5.0.7 Query used for creating the db ============================== drop database movies; create database movies; use movies; create table movie ( id int not null auto_increment, title varchar(50), year int, price decimal(8,2), primary key(id) ); insert into movie (title,year,price) values("FirstMovie",1901,14.95); insert into movie (title,year,price) values("SecondMovie",1902,15.33); JAVA code ========= import JAVA.sql.Connection; import JAVA.sql.DriverManager; import JAVA.sql.SQLException; public class Test { public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); System.out.println("Registering Driver...[OK]"); } catch(Exception ex) { System.out.println("Cannot register the driver"); } try { Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/ movies?"+"user=thushanthan&password=phpmysql"); System.out.println("Establishing Connection...[OK]"); } catch(SQLException ex) { System.out.println("SQLExce read more about JDBC/mysql error...
Message from kartechy Most recent post: 9/24/2007 6 authors and 10 replies. Hi, I have some JAVA code to make connection and insert some data into Oracle 10g via Ibatis framework, its failing for CLOB data type, Can you please help me to resolve this ? see the JAVA code flow below FileA.JAVA ------------- SqlMapClient sqlMap = SQLConfig.getSqlMapInstance(); // this sqlconfig xml contains all the login details.. sqlMap.StartTransaction(); FileB_Object.setExampleText(myStringBuffer.toString()); // this file contains get/set methods sqlMap.insert("insertExampleText", FileB_Object); sqlMap.CommitTransaction(); FileB.JAVA ----------------- private String exampleText; public String getExampleText() { return exampleText; } public void setExampleText(String exampleText) { this.exampleText =exampleText; } FileC.XML ---------------- which contains all the SQLs , Properties , reference to FileB.Class - part of IBatis and I added the following line also. <result property="exampleText" column="exampleText" jdbcType="BLOB"/> The same code is working fine if the length is less than 4000 and failed for more than 4000 chars I am getting this error com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in c:\temp\FileC.xml. --- The error occurred while applying a parameter map. --- Check the insertExampleText-InlineParameterMap. --- Check the parameter mapping for the 'exampleText' property. --- Cause: JAVA.sql.SQLException: Data size bigger read more about CLOB issue with JDBC, IBATIS and Oracle 10g
Message from Luis Angel Fdez. Fdez. Most recent post: 9/24/2007 4 authors and 6 replies. Hi! I'm trying this: [...] Vector<String> vNames = new Vector<String>(); String[] names; try { ResultSet myRs; Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); con = DriverManager.getConnection("jdbc:derby:/home/koxo/tmp/db/tests/ ubicharge"); myRs = con.getMetaData().getColumns(null, null, "bornes", "%"); while (myRs.next()) { String str = myRs.getString("COLUMN_NAME"); vNames.add(str); } } catch (SQLException sqle) { System.out.println(sqle.toString()); } catch(Exception e) { System.out.println("getColumnNames: "+e.toString()); e.printStackTrace(); } [...] The connection is made, and the 'bornes' table exists, but the loop is never executed. What's wrong? Thanks in advance. Bye! -- Slackware 11.0.0 (kernel 2.6.22 i686) Gnome 2.16.3 Intel(R) Core(TM)2 Quad CPU (2260.386 MHz) up 6 days, 1:28 Hattrick: ZanzabornÃn (1457021) X.1762 # Jabber: laffdez@xxxxxxxxxxx Sokker: C.D. Arrancatapinos (18088) IV.57 # Linux User #99754 read more about How to know columns names in Derby database table
Message from Allen Shao Most recent post: 9/19/2007 2 authors and 2 replies. How can I open, read and convert foxpro DBF file in JAVA? Do I need to use "sun.jdbc.odbc.JdbcOdbcDriver" to code from scratch? Or are there some JAVA class or 3party java API (application programming interface)can ease the job? regards, read more about open, read and convert foxpro DBF file
Message from Tmuldoon Most recent post: 9/17/2007 4 authors and 8 replies. Hello, Running an app that uses jdbc to connect to my sql 2005 database. I am getting a error: JAVAx.servlet.ServletException: Error initializing BEA ALI Studio - Error starting database connection pooling. - SQLException occurred in JDBCPool: com.inet.tds.SQLException: JAVA.net.UnknownHostException: TESTDB\SQL2K5 params: com.inet.tds.TdsDriver, jdbc:inetdae7:TESTDB\SQL2K5:1433? database=studiodb. Please check your username, password and other connectivity info. I tested the connection useing a Microsoft Datalink object (.udl), it connects fine. How can I test the JDBC connection? Thanks, Tmuld. read more about Testing a JDBC connection
Message from Roedy Green Most recent post: 9/4/2007 3 authors and 8 replies. I have composed a table of JDBC literals. It may contain errors or be incomplete. Please have a look and pass on improvements. See http://mindprod.com/jgloss/jdbc.html#LITERALS -- Roedy Green Canadian Mind Products The JAVA Glossary http://mindprod.com read more about JDBC literals
Message from kmaule Most recent post: 8/31/2007 6 authors and 9 replies. Hi there, Newbe here. I'm unable to connect via JDBC using OpenOffice 2.2.1 Base to an Informix 7.01 UC1 std edition database. My Classpath is correct and passes the connection test. Using a known good user name/ password to a known good database fails with "Database not found or no system permission" -329 error. I can connect OK via ODBC to this same database with same credentials. Is there anything on the DB server that may need to be done to enable JDBC connectivity? Cheers, Kirk read more about JDBC connect to dabase fails, OK using ODBC
Message from Mario Most recent post: 8/31/2007 5 authors and 5 replies. Maybe my question is stupid and wrong but I hope that you'll understand. So, image that you need to create web application which will used by many peoples in one LAN. They processing some documents and every person has the particular number of documents in particular order (1. person has documents from 1 to 100, second from 101 to 200 etc), which process with the particular number (first document -> number 1 in a database). If they all work in a same time, what is the easiest and the most safety way to manage that? Adding number manually is the logical solution but if 2 person put the same number, can they freeze the database or databases are imune on that ? read more about record numbers
Message from k.adamczyk Most recent post: 8/29/2007 2 authors and 2 replies. Hi, I have a problem when I want to sort entities (order by) by a boolean field. TopLink throws following exception: ... Caused by: Exception [TOPLINK-8021] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Invalid ORDER BY item [e.active] of type [JAVA.lang.Boolean], expected expression of an orderable type. Thoes it mean that TopLink can not sort by booleans? Is there any workaround? As far as I remember Hibernate had no problems doing this. I'll be grateful for any help. Best regards, Chris read more about TopLink: sorting entities by boolean value
Message from flarosa Most recent post: 8/28/2007 7 authors and 9 replies. Hi, My application is a JAVA program using the Spring JDBC framework. For a connection pool, I'm using the org.apache.commons.dbcp.BasicDataSource class. I have several complex queries that take 500-1000 milliseconds to run. When I run these queries within my application, they take about the same time to run no matter when I run them, even if I run the same query several times in a row. However, if I run the query from within the MySQL query browser, I notice a different behavior. The first time I run I get the normal execution time, but if I run again, I get a much shorter time. I presume that this is due to the server caching the results. I do have query caching enabled on the server. I can reproduce the behavior of the JAVA application if I add the SQL_NO_CACHE hint to the query. I'm wondering what if anything I can do to get the caching behavior to appear in my JAVA application. Obviously there are significant differences between executing a query in JAVA and running it in the query browser. For one, the JAVA application is using a prepared query whereas the query browser has the arguments expressed as literals. I did enable prepared statement pooling in BasicDataSource by setting poolPreparedStatements=true, but this does not seem to have much effect. Thanks, Frank read more about Query caching issue
Message from James Appleby Most recent post: 8/27/2007 4 authors and 9 replies. I'm trying to add support for Apache Derby to a piece of software that already has support for Oracle, SQL Server and MySQL. There is a lot of DB specific coding involved to get the best performance possible. Several of these queries involve checking to see if a nested query returns a value and substituting 0 if no rows are returned. In Oracle the function is called: nvl In SQL Server the function is called: IsNull In MySQL the function is called: IfNull I can not find an equivalent for Derby. Does one exist? read more about JAVADB / Apache Derby equivalent to the SQL Server IsNull, Oracle nvl and MySQL IfNull
Message from James Appleby Most recent post: 8/27/2007 5 authors and 7 replies. Hello, I am currently adding Derby support to an application that already has support for multiple DBMS via JDBC. I have found it to be significantly slower than SQL Server or MySQL when performing the same task. To provide this, I have created an exact duplicate database within both Derby and SQL Server and ran the same query on both, gathering timings. The test query returns about 16,000 rows from a table with about 100,000 on it, grouping data using a timestamp that is converted to the nearest second. This is one of the heaviest queries within the application and what chosen to put the DBMS under the most strain. To prevent caching interferring with the result, I made sure to restart the DBMS before running the query. SQL Server was at least 4 times quicker returning the results compared to Derby. I had expected SQL Server to outperform Derby, but not by such a huge factor. Is this result what is expected? The initial test was based on a default, untuned installation. I then followed tuning guidelines for Derby, increasing the page size to 32K and increasing the maximum page count to far in excess of what should be needed to return the amount of data I am testing. This gave some improvements but it is still takes three times that of the same query time on SQL Server. As Derby is marketing itself on the same level as MySQL (Apache provide performance figures comparing it to this) then I anticipated similiar performance, but instead read more about Apache Derby performance disappointing
Message from Lee Fesperman Most recent post: 8/26/2007 3 authors and 6 replies. I'm pleased to announce the beta availability of SQLfX (SQL for XML). SQLfX is a brand new paradigm for database access to XML. It uses the [often unrecognized] hierarchical operations built into SQL92 to bring power and scalability to XML query and manipulation. SQLfX is a next generation alternative to complex navigational facilities like XQuery, XPath and XSLT. My company (FFE) worked with Advanced Data Access Technologies, Inc. to implement a beta middleware version of SQLfX with a GUI front-end. The SQLfX Beta is available for free download and evaluation at their site: http://www.adatinc.com/aboutthissite/sqlfxprdownload.html -- Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com) read more about [ANN] SQLfX Beta
Message from Monica Most recent post: 8/21/2007 2 authors and 2 replies. Hello everyone, I am attempting to create access logs on a per web application basis, using a single virtual host in my server.xml file. Here is what I have so far: <Host name="www.mysite.com" autoDeploy="false" deployOnStartup="false" deployXML="false"> <alias>www.mysite.com</alias> <Valve className="org.apache.catalina.valves.AccessLogValve" prefix="mysite_access" suffix=".log" pattern="common" directory="${jboss.server.home.dir}/log"/> <Context path="" docBase="html" debug="0" reloadable="true"/> <DefaultContext cookies="true" crossContext="true" override="true"/> <Context path="/Web1" docBase="C:\jboss-4.0.1RC2\server\default \deploy" debug="0" reloadable="true"> <Valve className="org.apache.catalina.valves.AccessLogValve" directory="${jboss.server.home.dir}/log" prefix="my_web1" suffix=".log" resolveHosts="false" pattern="combined"/ </Context>
</Context>
Message from joeNOSPAM Most recent post: 8/21/2007 3 authors and 3 replies. ??? read more about Can we do something about the persecution of this newsgroup? (EOM)
Message from david.karr Most recent post: 8/17/2007 5 authors and 5 replies. This is more of a general database question, not specific to JAVA, but can someone describe an actual realistic use of outer joins? I'm familiar with how it works, and some trivial examples, but I'm frankly unsure of why you'd actually need to use it. read more about Examples of real usage of outer joins?
Message from Thomas Kellerer Most recent post: 8/16/2007 4 authors and 9 replies. Hello, I'm trying to insert a values for a CLOB column in a portable way. So far using PreparedStatement.setCharacterStream() together with a Reader to read the CLOB contents from a local file was working quite well (with various JDBC drivers). Now I stumbled across a bug in my code that raised it ugly head when using Apache Derby. When reading the contents of a file with a multi-byte encoding I can not seem to find a way to pass the correct length of the data into the setCharacterStream() method. What I did so far: File f = new File("sourcfile.txt"); Reader r = new InputStreamReader(new FileInputStream(f), "UTF-8"); preparedStatement.setCharacterStream(1, r, f.length()); which worked fine for most JDBC drivers except for Derby as Derby (rightfully) complains that the value supplied (f.length()) doesn't match the number of characters read from the stream. I can not image a way where I can supply the correct length when using a Reader to supply the Clob content. If I was able to "create" Clob instance in a generic way, I think this could solve the problem as the Clob interface contains a setCharacterStream() which doesn't require a length parameter. But how'd I create the Clob instance if I do not know which driver will be used at runtime? Any input appreciated. Thanks in advance Thomas read more about INSERTINg a Clob in a portable way
Message from matanel Most recent post: 8/14/2007 3 authors and 3 replies. when I am trying to use ojdbc1.4 with Oracle 10g express the jvm is crash I use JAVA 1.6 update 2 the message is : # # An unexpected error has been detected by JAVA Runtime Environment: # # Internal Error (43113F2C2932215353454D424C45523F491418160E4350500470), pid=3400, tid=680 # # JAVA VM: JAVA HotSpot(TM) Client VM (1.6.0_02-b06 mixed mode) # If you'd like to submit a bug report, please visit: # http://JAVA.sun.com/webapps/bugreport/crash.jsp # --------------- T H R E A D --------------- Current thread (0x0aad1400): JAVAThread "CompilerThread0" daemon [_thread_in_native, id=680] Stack: [0x0ae30000,0x0ae80000) [error occurred during error reporting, step 110, id 0xc0000005]Current CompileTask: C1: 4% ! oracle.jdbc.driver.OraclePreparedStatement.executeBatch() [I @xxxxxxxxxxx 508 (548 bytes)--------------- P R O C E S S --------------- JAVA Threads: ( => current thread ) 0x0b301c00 JAVAThread "Timer-0" daemon [_thread_blocked, id=276] 0x0b212c00 JAVAThread "ReaderThread" [_thread_in_native, id=3280] 0x0aad3400 JAVAThread "Low Memory Detector" daemon [_thread_blocked, id=2880] =>0x0aad1400 JAVAThread "CompilerThread0" daemon [_thread_in_native, id=680] 0x0aac5000 JAVAThread "JDWP Command Reader" daemon [_thread_in_native, id=3516] 0x0aac3800 JAVAThread "JDWP Event Helper Thread" daemon [_thread_blocked, id=3408] 0x0aac1800 JAVAThread "JDWP Transport Listener: dt_socket" daemon [_threa