<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic connect to oracle 10g in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231583#M184713</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I want to connect alfresco enterprise 3.2 with oracle 10g and i write this code..&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;import java.sql.*;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;public class OracleOciConnection {&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; public static void main(String args[])&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;{&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;try&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;{&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Class.forName("orac­le.jdbc.driver.Oracl­eDriver");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Connection con = DriverManager.getConnection("jdbc&lt;img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;racle:thin:@localhost:1521&lt;img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;rcl","orcl","orcl");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Statement stmt=con.createStatement();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;ResultSet rset =stmt.executeQuery("select * from table1");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;while(rset.next())&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;{&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;System.out.print(rset.getString(1));&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;System.out.println("connected to oracle using oci driver");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;con.close();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;catch(Exception ex)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;{&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;ex.printStackTrace();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;it okey when i compile but there have error when i execute..like..&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;java.lang.ClassNotFoundException: orac­le.jdbc.driver.Oracl­eDriver&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.net.URLClassLoader$1.run(URLClassLoader.java:200)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.security.AccessController.doPrivileged(Native Method)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.net.URLClassLoader.findClass(URLClassLoader.java:188)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.ClassLoader.loadClass(ClassLoader.java:307)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.ClassLoader.loadClass(ClassLoader.java:252)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.Class.forName0(Native Method)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.Class.forName(Class.java:169)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at OracleOciConnection.main(OracleOciConnection.java:10)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;have any get the solution?? :?:&amp;nbsp; or other solution :idea: &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;should i set the class path =C:\oraclexe\app\or­acle\product\10.2.0\­server\jdbc\lib\ojdb­c14.jar&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;but in my pc there only C:\oracle\product\10.2.0..and haven't the server folder..why it occur like that :!:&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 20 Jan 2010 05:40:58 GMT</pubDate>
    <dc:creator>snowaja</dc:creator>
    <dc:date>2010-01-20T05:40:58Z</dc:date>
    <item>
      <title>connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231583#M184713</link>
      <description>I want to connect alfresco enterprise 3.2 with oracle 10g and i write this code..import java.sql.*;public class OracleOciConnection {&amp;nbsp;&amp;nbsp;&amp;nbsp; public static void main(String args[]){try{Class.forName("orac­le.jdbc.driver.Oracl­eDriver");Connection con = DriverManager.getConnection("jdbc&lt;IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;racle:thin:@local</description>
      <pubDate>Wed, 20 Jan 2010 05:40:58 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231583#M184713</guid>
      <dc:creator>snowaja</dc:creator>
      <dc:date>2010-01-20T05:40:58Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231584#M184714</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Please see my comment in &lt;/SPAN&gt;&lt;A href="http://forums.alfresco.com/en/viewtopic.php?f=14&amp;amp;t=24394" rel="nofollow noopener noreferrer"&gt;your other post&lt;/A&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Mike&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 20 Jan 2010 08:59:33 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231584#M184714</guid>
      <dc:creator>mikeh</dc:creator>
      <dc:date>2010-01-20T08:59:33Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231585#M184715</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Your posting does not seem related to Alfresco.&amp;nbsp;&amp;nbsp; But yes you will need the oracle driver.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 20 Jan 2010 09:50:58 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231585#M184715</guid>
      <dc:creator>mrogers</dc:creator>
      <dc:date>2010-01-20T09:50:58Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231586#M184716</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I have oracle driver ojdbc14.jar and i put in C:\Alfresco\tomcat\lib&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I should have others driver?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Jan 2010 01:31:52 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231586#M184716</guid>
      <dc:creator>snowaja</dc:creator>
      <dc:date>2010-01-21T01:31:52Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231587#M184717</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;A href="http://forge.alfresco.com/projects/oracle" rel="nofollow noopener noreferrer"&gt;http://forge.alfresco.com/projects/oracle&lt;/A&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 26 Jan 2010 07:20:14 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231587#M184717</guid>
      <dc:creator>paulweb</dc:creator>
      <dc:date>2010-01-26T07:20:14Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231588#M184718</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Its alfresco community 3.2 can connect to oracle 10g? :?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Jan 2010 01:07:04 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231588#M184718</guid>
      <dc:creator>snowaja</dc:creator>
      <dc:date>2010-01-28T01:07:04Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231589#M184719</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;Its alfresco community 3.2 can connect to oracle 10g? :?&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt;No, Oracle is not supported by Alfresco in the Community version. PaulWeb's forge project may help (see link above).&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Mike&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Jan 2010 08:16:01 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231589#M184719</guid>
      <dc:creator>mikeh</dc:creator>
      <dc:date>2010-01-28T08:16:01Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231590#M184720</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;But this link from PaulWeb &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;&lt;A href="http://forge.alfresco.com/projects/oracle" rel="nofollow noopener noreferrer"&gt;http://forge.alfresco.com/projects/oracle&lt;/A&gt;&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt; about oracle for alfresco community.. :?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Jan 2010 08:32:59 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231590#M184720</guid>
      <dc:creator>snowaja</dc:creator>
      <dc:date>2010-01-28T08:32:59Z</dc:date>
    </item>
    <item>
      <title>Re: connect to oracle 10g</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231591#M184721</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;But this link from PaulWeb &lt;BR /&gt; &lt;BLOCKQUOTE class="jive-quote"&gt;&lt;A href="http://forge.alfresco.com/projects/oracle" rel="nofollow noopener noreferrer"&gt;http://forge.alfresco.com/projects/oracle&lt;/A&gt;&lt;/BLOCKQUOTE&gt; about oracle for alfresco community.. :?&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt;Yes. The Forge is an area for community contributions. They are &lt;/SPAN&gt;&lt;STRONG&gt;not supported&lt;/STRONG&gt;&lt;SPAN&gt; by Alfresco.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Mike&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Jan 2010 09:15:58 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/connect-to-oracle-10g/m-p/231591#M184721</guid>
      <dc:creator>mikeh</dc:creator>
      <dc:date>2010-01-28T09:15:58Z</dc:date>
    </item>
  </channel>
</rss>

