We closed this forum 18 June 2010. It has served us well since 2005 as the ALPHA forum did before it from 2002 to 2005. New discussions are ongoing at the new URL http://forum.processing.org. You'll need to sign up and get a new user account. We're sorry about that inconvenience, but we think it's better in the long run. The content on this forum will remain online.
Index › Programming Questions & Help › Integration › connect processing to Oracle DB
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1
connect processing to Oracle DB (Read 1999 times)
roli
connect processing to Oracle DB
Nov 10th, 2009, 7:26am  
Hello,

did someone get this done?

I can't connect to my Oracle DB (Version 9) with this coding...

import oracle.jdbc.rowset.*;
import oracle.sql.converter.*
... all the things from class12.jar...

String connString="jdbc:oracle:thin:@172.16.0.27:1521:LX01";

void setup() {  
 connect();
}

 void connect() {
 OracleDataSource ods = new OracleDataSource();
 ods.setURL(connString);
 ods.setUser("USER");
 ods.setPassword("PASSWORD");
 Connection conn = ods.getConnection();
}

I'm trying for 2 days now, but can't get it to run...


Any help is very welcome!

Thank you in advance...
Back to top
 
 
PhiLho 
Re: connect processing to Oracle DB
Reply #1 - Nov 10th, 2009, 9:06am  
Do you get error messages? Exceptions? Just null results?
Back to top
 
WWW  
roli
Re: connect processing to Oracle DB
Reply #2 - Nov 11th, 2009, 6:21am  
Thank you for your response...

I just get an "Unhandled exception type SQLException" in the info line...

Regards,

Roland
Back to top
 
 
PhiLho 
Re: connect processing to Oracle DB
Reply #3 - Nov 11th, 2009, 11:53am  
Ah, this one is easy to address, since it is a compilation error!
Just put try { ... } catch (SQLException se) { se.printStackTrace(); } around the problematic line(s) (represented by the ... above).
Back to top
 
WWW  
roli
Re: connect processing to Oracle DB
Reply #4 - Nov 12th, 2009, 2:34am  
Fine!

That seems to work...

Many thanks for your help Cool
Back to top
 
 
gmboy
Re: connect processing to Oracle DB
Reply #5 - Nov 18th, 2009, 9:38am  
I am trying to use Processing with Oracle DB.
I have used Eclipse and JDBC in the past.
What other approaches are there?
Please send me information on links etc.

Henry Brown
hbrown@sisna.com
Back to top
 
 
gmboy
Re: connect processing to Oracle DB
Reply #6 - Nov 18th, 2009, 9:41am  
I am trying to use Processing with Oracle DB.
What approaches are there?
I have used Eclipse and JDBC in the past.
Please send any links, etc.
Back to top
 
 
Page Index Toggle Pages: 1
‹ Previous Topic | Next Topic ›