Click here to Skip to main content
14,924,633 members
Home / Discussions / Database
   

Database

 
GeneralRe: Pruning unused tables in a live database. Pin
Chris Quinn14-Jul-17 0:48
MemberChris Quinn14-Jul-17 0:48 
AnswerRe: Pruning unused tables in a live database. Pin
Eddy Vluggen14-Jul-17 2:39
professionalEddy Vluggen14-Jul-17 2:39 
AnswerRe: Pruning unused tables in a live database. Pin
Tim Carmichael14-Jul-17 8:57
MemberTim Carmichael14-Jul-17 8:57 
AnswerRe: Pruning unused tables in a live database. Pin
jschell15-Jul-17 9:33
Memberjschell15-Jul-17 9:33 
AnswerRe: Pruning unused tables in a live database. Pin
Mycroft Holmes15-Jul-17 14:43
professionalMycroft Holmes15-Jul-17 14:43 
GeneralRe: Pruning unused tables in a live database. Pin
Jörgen Andersson17-Jul-17 10:28
professionalJörgen Andersson17-Jul-17 10:28 
Questionhow to rertrieve only 3 columns out of 7 columns using queryForObject in jDBCTmplate????am unable use correct syntax to retrieve only 3 columns in JdbcStudentDAO Pin
LOKENDRA YADAV12-Jul-17 21:09
MemberLOKENDRA YADAV12-Jul-17 21:09 
SuggestionRe: how to rertrieve only 3 columns out of 7 columns using queryForObject in jDBCTmplate????am unable use correct syntax to retrieve only 3 columns in JdbcStudentDAO Pin
Richard Deeming13-Jul-17 7:57
mveRichard Deeming13-Jul-17 7:57 
LOKENDRA YADAV wrote:
select username,password,role from studentstable

Not an answer to your question, but there's a more fundamental problem with your code: You're storing passwords in plain text.

NEVER do that. And don't use reversible encryption either. Store a salted hash of the password, using a unique salt per record.

Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


QuestionWant to Import Data from Salesforce into SQL Server using SSIS Pin
indian14312-Jul-17 10:35
Memberindian14312-Jul-17 10:35 
AnswerRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
Mycroft Holmes12-Jul-17 14:23
professionalMycroft Holmes12-Jul-17 14:23 
GeneralRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
indian14317-Jul-17 8:02
Memberindian14317-Jul-17 8:02 
GeneralRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
Richard MacCutchan17-Jul-17 9:48
mveRichard MacCutchan17-Jul-17 9:48 
AnswerRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
Member 1362406015-Jan-18 6:13
MemberMember 1362406015-Jan-18 6:13 
QuestionGet following Error when Loading the SSIS Package using C# Code Pin
indian1436-Jul-17 14:04
Memberindian1436-Jul-17 14:04 
AnswerRe: Get following Error when Loading the SSIS Package using C# Code Pin
Richard Deeming7-Jul-17 0:47
mveRichard Deeming7-Jul-17 0:47 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian1437-Jul-17 8:44
Memberindian1437-Jul-17 8:44 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian14310-Jul-17 9:37
Memberindian14310-Jul-17 9:37 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
Richard Deeming10-Jul-17 9:50
mveRichard Deeming10-Jul-17 9:50 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian14310-Jul-17 11:17
Memberindian14310-Jul-17 11:17 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
Richard Deeming11-Jul-17 1:28
mveRichard Deeming11-Jul-17 1:28 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian14312-Jul-17 7:38
Memberindian14312-Jul-17 7:38 
QuestionI am not able to view my data in my oracle forms 6i database is 11g Pin
Member 128515166-Jul-17 0:59
MemberMember 128515166-Jul-17 0:59 
AnswerRe: I am not able to view my data in my oracle forms 6i database is 11g Pin
CHill606-Jul-17 1:35
mveCHill606-Jul-17 1:35 
AnswerRe: I am not able to view my data in my oracle forms 6i database is 11g Pin
ChuckIsThatYou26-Jul-17 18:59
MemberChuckIsThatYou26-Jul-17 18:59 
Questionms access 2016 database Pin
Mayank Kumar2-Jul-17 21:22
MemberMayank Kumar2-Jul-17 21:22 

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.