ak singh

Greenhorn
+ Follow
since Nov 30, 2008
Merit badge: grant badges
For More
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
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by ak singh

Hi All,
I created an unique constraint using the following queries :-


this was done as the column on which the unique constraint was being added had some on unique values.

now when i perform


it doesn't list the above added unique constraint. this is being done to create a sql script from the source user(oracle)/database(mysql) to create its copy
any help for obtaining the constraint will be appreciated.
thanks and regards
I projected the problem in very simplified way.. Actually the problem was : I migrated my application, which is used by upto 500 concurrent user, from Oracle DB to Sql Server 2005. Same peace of code was working fine for Oracle database, but didnt work for Sql Server 2005.
I have fixed the problem. I commited a mistake, I was taking connection from prot 1434 (which is for browser) beacuse I was not able to take the connection from port 1433 (actually it was disabled ) when I enabled the TCS/IP protocal and changed the URL string to 1433 it started working fine.

Error log is ::

I installed sql server 2005 (dev)
I have a java program which takes connection from database
connection string is :
"jdbc:sqlserver://localhost:1434;databaseName=abc"

It works fine, I modified the code now it takes connection and without closing the connection it tries to take another connection (with same database every thing same)Second time it throws an exception msg saying:: "An I/O error occurred while receiving the TDS prelogin response."

I thought its because of maximum no of connections but maximum no of connection is set to 0(ulimited).

what can be the problem and how to fix this PLEASE HELP ME!!!

Peter Johnson wrote:Change the directory security such that only the user account running JBossAS has access to server/xxx/tmp. (Recursively apply that same setting if you already have files in tmp.)


..
Hi,
Our case is a bit different, its equivalent to the fact that, we will be sharing the root password, but want to secure our code (.ear). The problem lies is that when the ear is deployed it explodes in the tmp/, and we want a way to secure or limit the access to this folder
14 years ago
Hi all,

due to some security reasons we have to secure the tmp/ in JBoss server instance.

what are the ways to do the same ?
14 years ago

Andrew Monkhouse wrote:You might want to look at CVS keyword substitution. It has been a really long time since I played with anything like this, but you could try something like:

Check that into your source control system then check it out again. You should see it has been expanded by CVS into something like:



But correct me if am wrong, the revision number is maintained by the CVS, everytime a new check in is made its revised. So it may or may not reflect the current version. Because in our case the current version is different from the "head".

Had 1 query, when we checkout from a version, we checkout from a tag, is there any way to know afterwards that from which tag was the code checked out ?

lalit upadheyay wrote:Ok. I was under impression that you have a separate code branch in CVS for different version of code and tagging is in place for the branches. So anytime you could have reverted to any of the existing versions with correct proeprty file in place.

BTW, how are you maintaing db version info in database ?
Are you just updating the same single row for upcoming versions ?
By db changes do you mean the schema enhancements ?



hi lalit
the db has a table , which contains the versions till date. The latest version is extracted from the table and used whereever needed

lalit upadheyay wrote:You can add a property file like application.properties in your code and load a property say app.version as System property at application startup so that it is accessible throught the code at runtime.

You can check in that to the repository (CVS) and update it for new code branches. As you create new branches, you only need to check out, update the app.version property and check in the property file.

At this time I can think of this way of tracking the application version. Someone having some other idea please do share.



Hi lalit,

The problem with the property file is that, the version changes every week. So to reflect this we need to check in the latest properties file regularly.
Is there any way to find out the tag (version/branch) from which we have checked out the code ?

Andrew Monkhouse wrote:Wow, I would love to help you, but its just too hard to read your post. Perhaps you should use real words.




@Andrew

Thanks for the quick reply, here is the problem again :-

we have a project with oracle as its back end. The code and database are both upgraded regularly. To track this we version the database, for this there is a table in the database which stores the version. But the code does not have any version.
we are currently using CVS(concurrent version systems), and branching and version tagging are also performed .

My problem is that we need to add version to the code also, so that any miss match between the database and code version raises alarm. I am clueless about how to add a version to the code, so that the above comparison can take place.

kindly ask if in doubt.
Hi ,

v have a project with oracle as its back end. The code and database are both upgraded regularly. To track this we version the database, for this there is a table in the database which stores the version. But the code does not have any version.
V are currently using CVS, and branching and version tagging are performed also performed.

My problem is that v need to add version to the code also, so that any miss match b/w the db and code version raises alarm. M clueless about how to add a version to the code.

NEED HELP