Home » Open Source » Programming Interfaces » Oracle Types and JDBC (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production - on all environments)
Oracle Types and JDBC [message #472710] Mon, 23 August 2010 07:37 Go to next message
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
Member

I have received a mail with following description...
do not have much information other than this .....
I tried to serach online but could not get definite answer.
I think it should something related to connections ..
Can anyone have any pointers on the same:

We are facing an issue with Oracle Types. When the JDBC driver converts the Java ObjectStream to Oracle Objects, it looks like Oracle is reading a null value. The deployment is working fine in the Dev environment, but the issue is noted in the QA env. We could notice a difference in the NLS Charset between the two DBs.



Dev Charset - US7ASCII

QA Charset - WE8ISO8859P15



Below is the description of the issue. Let me know if anyone has any pointers on this issue.



Problem:

Application sends an object to the procedure using the Oracle Object Types. Procedure then takes values from the object and performs insert or updates to the tables.

CUE DEV: This currently works on this environment and has no problems getting the values from the object.

CUE QA/UAT/PROD: This currently DOES NOT work on these environments. When the object is passed it gets a null reference for all the vales in the object. Hence the insert or update fails. Following error is returned when the procedure tries to add null values



ORA-01400: cannot insert NULL into BAIS"."BAS_APPNAME_MST"."APP_NAME")

ORA-06512: at "BAIS.USP_COD_ADDAPPLICATION", line 21



Re: Oracle Types and JDBC [message #472711 is a reply to message #472710] Mon, 23 August 2010 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No one can debug a code that (s)he does not see.

Regards
Michel
Re: Oracle Types and JDBC [message #472714 is a reply to message #472711] Mon, 23 August 2010 07:46 Go to previous messageGo to next message
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
Member

Thanks for the reply Michel.
Is there any possiblity that charset could be the cause
something relating to JDBC thin client

Regards
Prajakta K

[Updated on: Mon, 23 August 2010 07:52]

Report message to a moderator

Re: Oracle Types and JDBC [message #472717 is a reply to message #472714] Mon, 23 August 2010 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not between those 2 ones.

Regards
Michel
Re: Oracle Types and JDBC [message #472740 is a reply to message #472717] Mon, 23 August 2010 09:30 Go to previous message
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
Member

Thanks
Previous Topic: characteristics of a project
Next Topic: access a SQL Server database through ODBC
Goto Forum:
  


Current Time: Tue Sep 29 00:37:59 CDT 2020