Karthik Rajendiran

Ranch Hand
+ Follow
since Aug 13, 2004
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
1
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Karthik Rajendiran

As per Dave

We tried direct JDBC Thin Client to connect and insert to the DBLInk and got error when columsn included above or equal to 100 in the synonym
we got the same error
Issue is not about hibernate or mssql , it is about the thin client driver only.

Is it known bug when inserting to a dblink getting invalid parameter ?
We are using Thin Client -Oracle in hibernate file  to connect to oracle Database [ SYNONYM]

+ Error comes only if the insert has more than 100 columns in insert

Can we able to find ,what query is sent to the MSSQL server via DB LINk?
Actually Current architecture, we trying to push a data to other application database in MS SQL via DB LInk
- Our application is using hibernate to push the data to synonym present in Oracle
SYnonym iscreated for table in other database MSSQL

How can we solve in this setup?
Is there any way to enable logs, what is being passed to MSSQL or tcp dump?

Dave Tolls wrote:Both SQL Server (the target DB) and Oracle have a max column limit of 1000 (well, I think it's 1024).

Which possibly leaves an issue with the driver?



Ok,
Following scenarios troubleshooting
Lets say Table in Target DB is  MY_CUST in MSSQL

- Is there any issue source Oracle DB [ Synonym/ Table]
Created a dummy table with 103 coums [ Table, and Synonym was working fine]
- The Problem is only with a synonym created for table@ DBLink , unable to trouble shoot is it Hibernate / Env

Can you guide ,what else can be troubleshooted

TO add to above, Found one weird
If we insert with less than 100 colums in our Hibernate, it is working, moment 100th column is introducted it is giving.

Tried - Commenting all columns and only add new columsn - Insert - Worked
      - Added 99 columns - Worked
     - Added 100th column  - Gave error
  - Removed a column with 250 Varchar [ thinking if size is the issue] - Same Error

Is there any limit that hibernate can allow only <100 columns only ?
Dear Forum Members,
We would like to get assistance in a strange error occurred after altering a table in MSSQL and inserting to table via DB LInk in Oracle.

Back Ground
- Database Link was established between our Application Database [ oracle to Customer MS SQL server 2008 R2  SP 3 10.50.600
- Synonym was created in Oracle to Isnert/ Select table residing in Remote MSS QL

Setup was working fine last few years, We recently add 3 columns to the MS SQL Server and it si relfecting in Oracle
when we did Desc <SYNONYM>

But while inserting in hibernate, we are getting following.






Can anyone throw light in this
We have in our application for
query.executeUpdate()

It is returning 0 and data is not getting reflected in Database.

Environment
Microsoft Sql server 2012  + Hibernate 3.0 + jboss 7 + jdk 1.8
Driver used is Microsoft Driver.
Team,
We have an issue in application which was working in tomcat. It is  AuthController application [using spring security, spring security oauth library] found to work ing tomcat
but deployed in weblogic, the
Class
public class AuthorizationServerConfiguration extends AuthorizationServerConfigurerAdapter
public void configure(AuthorizationServerEndpointsConfigurer endpoints) is not getting invoked, but this gets invoked automaticlaly in tomcat



We tried putting a sample app with PostConstruct annotation to test for dependency injection, sample is working. is there any other issue . Please guide uson how we can debug this issue
3 years ago
New Session Id Created in Cluster during Peak Issue.  
We have Apache web-server load balanced front ending weblogic server. During Peak Load, we are getting session id is getting created
in jSessionId  in response header.

We have our application with web.xml compliying to 2.3 dtd. will that be too issue?
Can you throw some troubleshooting steps for this.
3 years ago
Dear Team,

We have a application which is socketChannel Client connects to the server with a single connection. Sending the ISO Transaction request to the server.
Client sends Echo messages at freq interval to the ISO Switch, similarly Server can also send Echo Requests to the client.

In production, we could see lot of messages are not read by client , but in TCPDUMP, it shows server sent the rquest and reached the client.

We have a problem related to packets getting not read by a socketchannel client, where as server responded back to us with response

Please find the code for the socketchannel read [ We are using Blocking Mode]. Kindly suggest the way to tune the code.


Hello Team,

HTTPSession Id is not returning new ids and try to reuse the same ids inspite of calling getSession(true)
on high load times.

6 years ago
Hello All,

Wrt to the contentlength, we are setting setContentLength in our application and it is always going as chunked in transfer encoding.
We have two servlet, It is working in one and other it is not working.

DO content Type has any direct relation to contentLength

response.setContentLength
response.setContentType("text/xml") works fine
response.setContentType("text/html") not working.

Do we have to set anything injboss server level

Content Length was only 157 bytes
6 years ago
Hello Team,
Since a long time, i posted to this forum, We have one design issue in our application

1. Our application has to interface with third party webservices for a functionality [ lets say find Employee details]
2. WSDL is shared

Before going for the approach, we would like to see if we can build a generic solution
Option 1
going for Wsdl2 java stub based approach, but if schema of WSDL changes, we need to regenerate, recompile
Option 2
Going for the xml construction and use Saaj Api wrap the xml with soap
Option 3
Going for the java to xml - Jaxb and attach the SOAP + XML generated from JAXB
Option 4
is there any middleware approch to be gone

Requirement
a. We should have very limited change, even wsdl changes
b. Efficient way to maintain the code oop way


Kindly suggest what design pattrerns to use

Details
a. Jboss 4.2



6 years ago
Hello Sir/madam

Wrt to the socketChannel, we have been facing recently a peculiar issue.
Our Application is a client, which sends request to the thirdparty system transaction Request via socket
the application is in live and it was working perfectly. but recently we face issue

a. We are able to send request to the Server
b. They are able to process request and while sending response, they are flusing and get, client has closed the connection.

Investigation
a. For some transaction -Balance we are able to process response immediately
b. For some, we are getting this issue when server Application trying to write to our client.

Please find the code




Socket creation code


What could be the issue for
Is it soTimeout, causing the issue 30 sec, post which server is not able to write the date

Currently Server team is saying, while sending response flush, they are getting client has closed the socket

Kindly help us with the solution.


Scenario
a. We need to interface with socket Listening System, Lets say that system name is XYZ
Our application is Insta
-Our Insta System needs a Echo Msg, Logon Message in a format to be sent to it [ ISO 8583] to XYZ in frequent intervals
- Our insta system also will send transaction procesing request ot the XYZ in socket

In the same way, XYZ system equally sends us the Echo <logon for which our system has to respond back.


Consideration
a. Our System should be designed to connect to SUch XYZ systems in future
Scenario 1
- XYZ - supports single connection only through which it will send and receive . only one connection and should support more txns per second
can we use single connection to send and receive at the same time
scenario 2
- Send using one IP Port and receive Using different IP and Port

Scenario 3
- Multiple Connections to same Ip and Port - by connection Pooling


Which is the best and efficient way for more tps and how should we start with it. Can anybody throw some light on the same.


>