db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rogerio Leis" <roge...@kaizen.com.br>
Subject Re: Fw: OJB+BLOB Oracle
Date Mon, 27 Oct 2003 16:40:13 GMT
Hi Per,
firstly, thanks for your reply

So, in the bean, my data attribute must be a byte[] and in the column of the
table a BLOB. Ok??

What url's configuration will i use in the repository_database.xml file? If
use thin, the URL is "thin:@10.10.10.254:1521:kd". To oci would be this:
"oci8:@10.10.10.254:1521:kd". I tried but hadn't sucess..
Detail, i have the client Oracle instaled in my computer because i know that
is necessary to use oci driver.

The response of the my attempt it was:

java.sql.SQLException: ORA-06401: NETCMN: designador de driver inválido

[org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR:
Error getting Connection from DriverManager with url
(jdbc:oracle:oci8:@10.10.10.254:1521:kd) and driver
(oracle.jdbc.driver.OracleDriver)
ORA-06401: NETCMN: designador de driver inválido

Can you help-me with this??
Regards,
Rogerio


----- Original Message -----
From: "Per-Olof Noren" <pelle@alma.nu>
To: <ojb-dev@db.apache.org>
Sent: Monday, October 27, 2003 12:45 PM
Subject: Re: Fw: OJB+BLOB Oracle


> Hi Rogerio,
>
> Storing BLOB's in Oracle is a real mess.
> The reason for this is that the jdbc spec leaves room for interpretation
> regarding BLOB's and Oracle's interpretation differs from what would be
> the "natural" interpretation.
>
> Storing BLOB's work as expected (to my knowledge) only with the the OCI
> driver.
>
> There has been several initiatives on solutions and since I switched to
> use the oci driver I haven't monitored the development any further.
>
>
> We used a simple mapping without conversion, the bean contained a byte[]
>
> <field-descriptor column="binary_column" id="2" jdbc-type="BLOB"
> name="binaryValue" nullable="true"/>
>
>
> Regards,
>
> Per-Olof Norén
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message