- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: error in writing clob
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 12:21 AM
тАО11-23-2005 12:21 AM
error in writing clob
there is a problem on a java application when it try to insert a clob data.
The error is
java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:292)
at oracle.sql.CLOB.createTemporary(CLOB.java:525)
...
This problem didn't happen until yesterday.
What is changed is the creation of a new instance of OC4J and after a shutdown ad a restart of oracle.
Any idea ?
Thanks in advance
Attilio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 03:35 AM
тАО11-23-2005 03:35 AM
Re: error in writing clob
This error is with the OC4J instance or with another?
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 05:53 PM
тАО11-23-2005 05:53 PM
Re: error in writing clob
your environment has most probably changed.
can you check your CLASSPATH?
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 05:55 PM
тАО11-23-2005 05:55 PM
Re: error in writing clob
Yes is with the OC4J instance on unix.
If I use tomcat (from the PC ), with the same oracle db on unix, it works.
Is possible that use a port of another service ?
Attilio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 06:06 PM
тАО11-23-2005 06:06 PM
Re: error in writing clob
The classpath in OC4J profile is
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip, but is not changed. I have installed another instance of OC4j and a ldap iplanet.
Perhaps some service use the same port ?
I have read that clob use oci driver.
wont other library ?
Thanks
Attilio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 08:02 PM
тАО11-23-2005 08:02 PM
Re: error in writing clob
OC4J is the diminutive of OracleAS Containers for J2EE.
If I understood you ADDED another instance and, because of that, you may be facing bug 3009532 (MEMORY LEAK):
https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=4232279
What is your RDBMS version??
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 09:37 PM
тАО11-23-2005 09:37 PM
Re: error in writing clob
yes I added another instance of OC4J, setting with different port, and a iplanet ldap. I don't know if this is the reason of the failure.
The version of oracle is 8.1.7.2
best regards
Attilio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2005 12:53 AM
тАО11-24-2005 12:53 AM
Re: error in writing clob
What is the server's physical memory and Oracle init.ora parameters shared_pool_size and db_block_buffers?
Please attach the vmstat.log resulting from:
#vmstat -n 6 33 > vmstat.log
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2005 01:32 AM
тАО11-24-2005 01:32 AM
Re: error in writing clob
shared_pool_size = 52428800
db_block_buffers = 2048
in the server there are 4 gb of ram.
but there are also other two instance of oracle, clearcase server, lpdap server that use it.
in attach there is the output of vmstat command;
best regards
Attilio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2005 04:34 AM
тАО11-24-2005 04:34 AM
Re: error in writing clob
As a test, reduce all instances shared_pool_size to 256M (stop & restart them) and check if this issue continues to happen...
Regards,
Eric Antunes