on 01-06-2006 5:57 AM
Hi,
I am trying a simple file to DB scenario in XI (without a BPM).
From a single file, data needs to be inserted into 2 tables which are present in the same Database.I am using MS Access as the Database.
Initaially it was able to insert data into 1 table and not in the other table.But now,for both the tables it showing the following error:
"java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks"
Pls help reg this.
Anagha
Hi,
Can AnyBody help me how should i shift from J2EE to SAP.
Basically I am a Java/J2EE Guy with Portal specalization.
I worked on WebSphere & Weblogic Portal Development as well administration.
Which course will best suits to me from SAP?
rgds.
Sathya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Suraj,
I guess we would be able to solve this problem as updation into DB happened using one of the xi servers and sql server (though not from other xi server and access).
For any assistance I would post again.
Thanks anyways.
Regards,
Anagha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Suraj,
Yes, we are using two DB communication channels. But also we tried "Disconnect from DB after processing each message" in Advanced mode of JDBC communication channel.
Regards,
Anagha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anagha,
<b>>>data needs to be inserted into 2 tables</b>
So you are using two DB communication channel. right?
/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
Try checking the checkbox "Disconnect from DB after processingeach message" in Advanced mode of JDBC communication channel.
Hope this will be helpful.
Regards
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I had one doubt in this scenario.can anybody Plz clarify in this scenario File-XI-JDBC.
1)where we have to specify the table name in the receiver JDBC comm channel to insert the data into sql database from file.My doubt is,there are so many tables in existence.in the comm channel i am not mentioning the table name any where.
currently i am using SQL server and created one table name "EMP" with n columns.
2)Is i need to configure this sql driver to the J2ee server or by default this will be shipped with XI?
3)Generally,what are the datbase drivers shipped with XI?
Thanx in Advance
Sridhar
Hi Anagha,
Have a look at these links:
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30
http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/2b/d5653fd1d3b81ae10000000a114084/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm
Regards,
Chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.