You don't need to have be on same machine as DB neither you need Oracle
Client installed on your client machine:
For your app, set following in the client machine, for example:
- setenv ORA102_CLIENT_HOME /path to DB_host/path to
DB_install/oracle/product/10.2.0/db_1
- setenv LD_LIBRARY_PATH $ORA102_CLIENT_HOME/lib
- db.oci.url="">
- db.driver=oracle.jdbc.OracleDriver
- have "xdb.jar" in classpath
David Parker wrote:
As far as I know, OCI is not an option, since our client
is not on the same machine as the database, and there is no Oracle
installation on the client other than the jdbc jar files. OCI requires
the C libraries, doesn't it?
On Mar 30, 2009, at 1:36 PM, Prabaharan Vijayaratnam wrote:
Please make sure you're
using Oracle JDBC driver in OCI mode, not THIN.
XMLType support available thru Oracle XDB which is available in OCI
connection.
regards,
Praba Vijayaratnam
David Parker wrote:
I have not heard anything back on this, nor have I been
able to get any answers on the oracle technet forum, though I've seen
some posts in the past year with other people having the same problem
(on the oracle forum, which were never answered). I suspect this is an
Oracle bug, but I don't have access to metalink to download patches, if
such exist.
So I'm looking for another way. It seems that one poster was able to
get his xml into an XMLType by creating a temporary CLOB in code -
writing directly to the JDBC api. Is there a way to do something
comparable with eclipselink?
I need this insert to happen in the same transaction as other
operations, so it needs access to the connection being used by a given
EntityManager. Is it possible to do this through a createNativeQuery,
or do I need to get the Connection object?
Thanks.
- DAP
On Mar 27, 2009, at 2:01 PM, David Parker wrote:
I have a JPA object with a String
attribute that is bound to a database column of XMLType (Oracle 10g
R2). When I try to persist the object, I get the error
ORA-01461: can bind a LONG value only for insert into a LONG column
I have seen some posts in various places about problems of this kind
with writing to an XMLType. I am just using XMLType for the first time,
so I may be missing some configuration, but I am able to insert into it
OK from SQL*Plus.
Is there specific support in Eclipselink somewhere for XMLType fields,
or has anybody run into this?
=============================================
David Parker
dap@xxxxxxxxxxxxxxxxxxxx
=============================================
David Parker
dap@xxxxxxxxxxxxxxxxxxxx
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
--
<oracle_sig_logo.gif>
Praba Vijayaratnam | Principal Member Technical Staff |
Phone: +6137834594
Oracle Server Technologies
ORACLE Canada | O'Connor Street | K1P1A4 Ottawa
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
=============================================
David Parker
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
--
Praba Vijayaratnam | Principal Member Technical Staff |
Phone: +6137834594
Oracle Server Technologies
ORACLE Canada | O'Connor Street | K1P1A4 Ottawa
 |
Oracle is committed to developing practices and
products that help protect the environment |
|
