db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahler Thomas <thomas.mah...@itellium.com>
Subject RE: Fw: OJB+BLOB Oracle
Date Mon, 27 Oct 2003 17:02:05 GMT
Hi,

if the thin url is: thin:@127.0.0.1:1521:orcl
then the oci8 url is:
oci8:@(description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(conne
ct_data=(sid=orcl)))

cheers,
Thomas

> -----Original Message-----
> From: Rogerio Leis [mailto:rogerio@kaizen.com.br]
> Sent: Monday, October 27, 2003 5:40 PM
> To: OJB Developers List
> Subject: Re: Fw: OJB+BLOB Oracle
> 
> 
> 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.ConnectionFactoryAbstractIm
> pl] 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
> 


---------------------------------------------------------------------
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