java - Tomcat MySQL Connection DataSource not working -

-

i hard coding db connection in app, , right trying make better. issue seems that's supposed done, , still fails.

1- download binary distribution appropriate platform, extract jar file, , copy "$catalina_home/lib" - done.

2- configure mysql database jndi resource. resource in application's context elemen , resource reference in application's "web-inf/web.xml" file.

<resource name="jdbc/storagerdb"              auth="container"              type="javax.sql.datasource"              username="root"              password="admin"              driverclassname="com.mysql.jdbc.driver"              url="jdbc:mysql:/localhost:3306/storagerdb"              maxactive="15"              maxidle="3"/>   <resource-ref> <description>mysql datasource example</description> <res-ref-name>jdbc/storagerdb</res-ref-name> <res-type>javax.sql.datasource</res-type> <res-auth>container</res-auth> 

public class dataaccessobject {  private customlogger logger = new customlogger(dataaccessobject.class);  private statement stmt; private connection conn; private datasource ds; private context ctxt;  /**  * queries creates db.  */ private static final string[] db_creation_queries = new string[] {          "create database if not exists storagerdb;", "use storagerdb;",          "create table if not exists user(id int not null primary key auto_increment,"                 + "username varchar(25) not null, password varchar(250) not null,"                 + "salt varchar(250) not null, email varchar(35) not null);",          "create table if not exists header(id int not null primary key auto_increment,"                 + "user_id int, foreign key (user_id) references user(id)," + "server varchar(50) not null,"                 + "content_type varchar(50) not null," + "status_code int not null," + "url varchar(250) not null);"  };  /**  * constructor jdbc driver initialized , loaded in tomcat/lib  * @throws namingexception   */ public dataaccessobject() {     try {         ctxt = new initialcontext();         ds = (datasource)ctxt.lookup("java:comp/env/jdbc/storagerdb");         conn = ds.getconnection();          stmt = conn.createstatement();          (string query : db_creation_queries) {             stmt.execute(query);         }      }   catch (sqlexception | namingexception e) {         logger.logexceptionmessage("dao constructor sql", e.getstacktrace());     }  }

it fails on "ds = (datasource)ctxt.lookup("java:comp/env/jdbc/storagerdb")".

exception in thread "main" javax.naming.noinitialcontextexception: need specify class name in environment or system property, or applet parameter, or in application resource file:  java.naming.factory.initial @ javax.naming.spi.namingmanager.getinitialcontext(unknown source) @ javax.naming.initialcontext.getdefaultinitctx(unknown source) @ javax.naming.initialcontext.geturlordefaultinitctx(unknown source) @ javax.naming.initialcontext.lookup(unknown source) @ com.wordpress.belichev.model.dataaccessobject.<init>(dataaccessobject.java:58) @ com.wordpress.belichev.model.dataaccessobject.main(dataaccessobject.java:279)

the reason getting noinitialcontextexception running application standalone app. ignore web.xml file, resource-definition it. need run webapp give chance work.

getting npe in next line (as mentioned in comment) due app not having found datasource after context lookup. different problem, related web.xml usage. suggest taking @ post see main points.


Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea
Read more

c# - two queries in same method -

-
i trying execute 2 queries in same method gives me exception. can red of exception declaring new command there way use same command? string id="hi"; connection.open(); oledbcommand command1 = new oledbcommand(); command1.connection = connection; string query1 = "select * products category='" + combobox1.text + "' , subcategory = '" + combobox2.text + "' , sizes='" + combobox3.text + "'"; command1.commandtext = query1; oledbdatareader reader = command1.executereader(); while (reader.read()) { id = reader[0].tostring(); } textbox1.text = id; string query = "insert category_in (category_id,amount,amount_in) values ('"+ id+"' ,500,300)"; command1.commandtext = query; command1.executenonquery(); messagebox.show("saved"); connection.close();
Read more