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]