Martin, Thank you very much. I tried to use JDeveloper some time ago but I gave up because I didn't find a way to use it with MySql. Now I'll try again. It's a fantastic tool.
Marcus Em Ter, 2003-12-23 Ãs 22:20, Martin Gainty escreveu: > Marcus > <doc> > > Registering a New Third-Party JDBC Driver > > If you plan to use a third-party JDBC driver, register it with JDeveloper so > that it will be available when you define the connection. > > To register a new third-party JDBC driver: > >From the main menu, choose Tools | P references. > In the Preferences dialog, select Database Connections. > On the Database Connections page, the Registered JDBC Drivers list displays > the third-party JDBC drivers currently registered with JDeveloper. > To add a new entry to the list, click New. > A new, entry appears in the list and in the Driver Class field, with a > default driver class name. > In the Driver Class field, alter the new entry to reflect its fully > qualified class name. > Make sure that the correct entry is still selected in the Registered JDBC > Drivers list. > > >From the Library dropdown list, select a library to associate the driver > with. > To define a new library, click New. > Be sure to include this library in any project that uses the third-party > driver. > Click OK. > > The driver will now appear in the list of available third-party JDBC drivers > both in this dialog (once you return to it) and in the Create Connection > wizard > > </doc> > *Yes as long as the driver is a JDBC Driver which can be/is registered to > JDeveloper then you can implement that connection from JDeveloper* > > Saludos, > -Martin > ----- Original Message ----- > From: "Marcus Peixoto" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, December 23, 2003 1:24 PM > Subject: Re: converting a FormFile to a Blob object > > > > Martin, > > > > Does JDeveloper work with any database or just with Oracle ? > > > > Marcus > > > > Em Ter, 2003-12-23 Ãs 18:53, Martin Gainty escreveu: > > > 1)you're going to have to download and install JDeveloper > > > http://otn.oracle.com/software/products/jdev/index.html > > > The nice thing about JDeveloper is you can create a WebTier/Struts from > > > File/New > > > > > > 2)then read up on the Oracle Blob manipulation > > > http://otn.oracle.com/sample_code/products/jdev/files/images/sample.html > > > > > > Both of these downloads take a while..you might want to try it during > lunch > > > assuming you have an unobstructed 100 MB/s connection > > > Follow the instructions on the 2nd link for downloading, Install, Create > and > > > populate DB Tables, creating connection, developing and deploy > > > This is the only way I know how to capture BLOB and persist to an Oracle > DB > > > Get in touch if you need any help..Been there done that! > > > Good Luck, > > > -Martin > > > NB: I had to torque up to 1.5 GB Ram on my box so JDeveloper would run > in an > > > expeditious manner.. > > > > > > ----- Original Message ----- > > > From: "Claire Wall" <[EMAIL PROTECTED]> > > > To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > > > Sent: Tuesday, December 23, 2003 9:43 AM > > > Subject: converting a FormFile to a Blob object > > > > > > > > > hi, > > > > > > I have a jsp page which uploads a file to a database. I have no problems > > > storing the file in an SQLServer or MySQL database by using the > > > setBinaryStream() method of a PreparedStatement. The file gets upload no > > > problem. > > > > > > However, when I try to upload this file to an oracle database (BLOB > column) > > > it does not work. I'm sure that i have to use the setBlob() method of > the > > > PreparedStatement, however, my dilemma is that I cannot find a way to > > > convert my file from FormFile format to sql Blob format. Does anybody > know > > > how to do this as I've looked everywhere and haven't come up with a > > > solution. > > > > > > Any help would be much appreciated > > > > > > > > > thanks > > > claire > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > -- > > Marcus Peixoto <[EMAIL PROTECTED]> > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Marcus Peixoto <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
