[err Mon Mar 30 17:33:35 EDT 2009] xmlstr length = 13465
[err Mon Mar 30 17:33:35 EDT 2009] xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
[err Mon Mar 30 17:33:35 EDT 2009] Unable to store server properties from Traction.properties...
[log Mon Mar 30 17:33:35 EDT 2009] javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build 20081024)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
OK, I give up. Running with the OCI driver, etc. It still doesn't work. So XMLType is just not available to our application, far as I can tell.
Thanks everybody for your responses and assistance.
- DAP
On Mar 30, 2009, at 4:48 PM, David Parker wrote:
OH, wait. I just noticed that the Instance Client download for OS X mentions oci, so maybe it's not hopeless after all....
On Mar 30, 2009, at 4:38 PM, David Parker wrote:
The client is running on MAC OS X, and the server is running on CentOS. I'm not sure how I see that this is going to work?
On Mar 30, 2009, at 2:02 PM, Prabaharan Vijayaratnam wrote:
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
--
<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
=============================================
David Parker
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
=============================================
David Parker
