Click here to Skip to main content
15,942,847 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Server and IDENTITY Pin
Mycroft Holmes18-Feb-14 11:46
professionalMycroft Holmes18-Feb-14 11:46 
AnswerRe: SQL Server and IDENTITY Pin
S Douglas26-Feb-14 8:24
professionalS Douglas26-Feb-14 8:24 
QuestionOLAP Cubes in BIDS for Salesforce and PRISM Pin
Karina Notka18-Feb-14 6:30
Karina Notka18-Feb-14 6:30 
AnswerRe: OLAP Cubes in BIDS for Salesforce and PRISM Pin
S Douglas26-Feb-14 8:54
professionalS Douglas26-Feb-14 8:54 
QuestionDelete from MySQL + select affected Pin
Member 993503818-Feb-14 3:41
Member 993503818-Feb-14 3:41 
AnswerRe: Delete from MySQL + select affected Pin
Eddy Vluggen18-Feb-14 7:04
professionalEddy Vluggen18-Feb-14 7:04 
AnswerRe: Delete from MySQL + select affected Pin
ZurdoDev18-Feb-14 15:33
professionalZurdoDev18-Feb-14 15:33 
Questionoracle transaction with multi OracleConnection c # ? Pin
Member 1059782417-Feb-14 9:19
Member 1059782417-Feb-14 9:19 
C#
I have 2 database, 
oracle transaction with multi OracleConnection c # 
Table 1 in the database 1 <pre lang="c#">

Table 2 in the database 2
When save new data to Table 1, I want to save the data in Table 2 in the database 2
How can I do this in oracle transaction
C#
<pre lang="c#"><pre lang="c#"><pre lang="c#">
using (OracleConnection connection1 = new OracleConnection(connectionstring1) )// databsse1
{OracleConnection connection2=new OracleConnection (connectionstring2);//database2
connection.Open();

OracleCommand command = connection.CreateCommand();
OracleTransaction trans;

trans = connection.BeginTransaction(IsolationLevel.ReadCommitted);
command.Transaction = trans;
try
{
command.Text =sql1//insert into table1 in database1
command.ExecuteNonQuery();
command.Text =sql2//insert into table2 in database2
//Here the problem by looking for a solution
How can I do that
trans.Commit();
}
catch (Exception ex)
{

trans.Rollback();
}
}

AnswerRe: oracle transaction with multi OracleConnection c # ? Pin
Shameel18-Feb-14 0:00
professionalShameel18-Feb-14 0:00 
AnswerRe: oracle transaction with multi OracleConnection c # ? Pin
Simon_Whale18-Feb-14 0:46
Simon_Whale18-Feb-14 0:46 
QuestionHandling ISODate in mongoDB when Deserializing from JSON Pin
ThetaClear16-Feb-14 19:48
ThetaClear16-Feb-14 19:48 
QuestionWhere to do the processing Pin
Mycroft Holmes15-Feb-14 22:28
professionalMycroft Holmes15-Feb-14 22:28 
AnswerRe: Where to do the processing Pin
Eddy Vluggen15-Feb-14 23:25
professionalEddy Vluggen15-Feb-14 23:25 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:14
professionalMycroft Holmes16-Feb-14 1:14 
AnswerRe: Where to do the processing Pin
Kornfeld Eliyahu Peter15-Feb-14 23:30
professionalKornfeld Eliyahu Peter15-Feb-14 23:30 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:05
professionalMycroft Holmes16-Feb-14 1:05 
GeneralRe: Where to do the processing Pin
Kornfeld Eliyahu Peter16-Feb-14 1:14
professionalKornfeld Eliyahu Peter16-Feb-14 1:14 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:18
professionalMycroft Holmes16-Feb-14 1:18 
GeneralRe: Where to do the processing Pin
Kornfeld Eliyahu Peter16-Feb-14 1:27
professionalKornfeld Eliyahu Peter16-Feb-14 1:27 
GeneralRe: Where to do the processing Pin
Tim Carmichael16-Feb-14 7:43
Tim Carmichael16-Feb-14 7:43 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 11:44
professionalMycroft Holmes16-Feb-14 11:44 
AnswerRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:17
professionalGuyThiebaut17-Feb-14 0:17 
GeneralRe: Where to do the processing Pin
Mycroft Holmes17-Feb-14 0:34
professionalMycroft Holmes17-Feb-14 0:34 
GeneralRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:39
professionalGuyThiebaut17-Feb-14 0:39 
AnswerRe: Where to do the processing Pin
Jörgen Andersson17-Feb-14 0:59
professionalJörgen Andersson17-Feb-14 0:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.