To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90114 Issue #|90114 Summary|Cannot get XClob on a long varchar column via SDBC-JDB |C Component|Database access Version|OOo 2.4.0 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|michaelstrobel
------- Additional comments from [EMAIL PROTECTED] Thu May 29 15:56:16 +0000 2008 ------- Hi, it seems to be impossible to get a XClob instance on a long varchar column via SDBC-JDBC. Calling getClob(x) on a XRow instance returns always null. This occures at least with MySQL and Ingres databases. Possibly a problem with passing the LOB reference from Java to C++ in OOo 2.4? I will attach two small test programs, a JavaApp and a OOoClientApp written in NetBeans, which show up the problem and that it's possible to get a Clob via plain JDBC. How to use the test programs: If you like to use the test programs you will need to install a database, the corrosponding JDBC driver beside OOo 2.4. Further you need to create a Java Application project and a OOo Client Application project in NetBeans, insert the attachent code into the main methods of your projects and adapt the connection URL as well as the connection property "JavaDriverClass" according to your database and driver. You also need to do issue the following statements on the database: create table t1 (c1 int, c2 varchar(), c3 long varchar, primary key(c1)); insert into t1 values (0, 'Hallo', 'OOo'); Micha --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
