PDA

View Full Version : connecting Mysql to Jboss server

Jimmywu
02-22-2004, 10:08 PM
Hi Guys,

i'm new here and i'm having some problems with my jboss connection to mysql

here's my mysql-ds.xml:

<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/Login</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>x</user-name>
<password>y</password>
</local-tx-datasource>

</datasources>

i have put the mysql jdbc.jar file into my /{app}/lib

but it still doesn't work...:\

have i missed out anything? please help me.... i'm totally lost..:S

regards
Jimmy
Singapore
_underdog
02-22-2004, 11:21 PM
I think your connection url is wrong. I believe that it should be of the form jdbc:mysql://[host]:[port]/[database] . So if Login is not a database then that would be the problem. Try 'jdbc:mysql://localhost:3306/mysql' that should work.
Jimmywu
02-22-2004, 11:28 PM
Originally posted by _underdog
I think your connection url is wrong. I believe that it should be of the form jdbc:mysql://[host]:[port]/[database] . So if Login is not a database then that would be the problem. Try 'jdbc:mysql://localhost:3306/mysql' that should work.

hi _underdog,

login is the name for my database.
:\

anything that i should add to my currect jboss other than

copying mm.mysql-2.0.4-bin.jar into my jboss/lib folder?

regards
Jimmy
Jimmywu
02-22-2004, 11:36 PM
here's my file calling for the database... anything wrong with it?

login.html:

<html>
<head>
<title>My Login Form</title>



<body bgcolor="blue">


</p>


</p>
<form action="/coleman/Login2.jsp" method="POST">

</p>


<font size="3" face="Georgia, Times New Roman, Times, serif"><u>Login</u></font></p>
<table border=0 align="left">
<tr>
<td><div align="right">Username: </div></td>
<td> <div align="left">
<input name="name" type="text" size="30" maxsize="30">
</div></td>
</tr>
<tr>
<td><div align="right">Password: </div></td>
<td> <div align="left">
<input type="password" name="pass" size="10" maxsize="10">
</div></td>
</tr>
<tr>
<td colspan="2" align="center"> <p align="left">
<input name="Submit" type="submit" value="Submit">
</p></td></td>
</table>

</form>


</p>


</p>


</p>
</body>
</html>

login2.jsp:

<%@ page
import = "javax.servlet.http.*,
java.sql.*"

try
{
Statement Stmt = Conn.createStatement();
thisStatement = "SELECT Username, Password FROM Users WHERE Username = request.getParameter("name"), Password = request.getParameter("pass")";

// get the form variable
String username2 = request.getParameter("name");
String password2 = request.getParameter("pass");

// create a session
session.putValue("username2", username);

// set a timeout period
session.setMaxInactiveInterval(180);


}
catch (SQLException E)
{
out.println("<b style=\"color: red;\">No such record[/b]");

}

%>


<html>
<head>
<basefont face="Arial"
</head>

<body>

Thank you for using this service.</br>
Click <a href=rootshell.jsp>here</a> for root access
</body>
</html>
Jimmywu
02-22-2004, 11:57 PM
i encountered the blow problems:

org.apache.jasper.JasperException: /Login2.jsp(5,2) equal symbol expected
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:428)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:126)
at org.apache.jasper.compiler.Parser.parseAttribute(Parser.java:169)
at org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:136)
at org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:149)
at org.apache.jasper.compiler.ParserController.figureOutJspDocument(ParserController.java:254)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:173)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:153)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:227)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:369)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.jav a:549)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
at java.lang.Thread.run(Thread.java:536)
Jimmywu
02-23-2004, 02:15 AM
hi guys,

problem solved..:)

regards
Jimmy
_underdog
02-23-2004, 09:48 AM
just curious... how did you fix it?