Menu
▾
▴
php-java-bridge-users
|
From: <php...@li...> - 2011-04-08 10:21:23
|
Hi Rocio,
Instead of returning "no", you should display the exception message, that
would help you to solve the problem for sure.
Hope this helps,
JM.
On Fri, Apr 8, 2011 at 5:08 PM, <php...@li...
> wrote:
> Hello, I’m trying to use php-java bridge, but I find it impossible!
>
>
>
> Basic examples work without problem, now, I want to connect php with mysql
> using java.
>
>
>
> This is my code:
>
>
>
> Java :
>
>
>
> public class pruebaLog {
>
>
>
> public static String connectDB(){
>
> Connection conn = null;
>
> String returned;
>
> try {
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
>
> conn = DriverManager.getConnection("jdbc:mysql://localhost/spb",
> "root", "Administrad0r");
>
> returned= “open”;
>
> } catch (Exception e){
>
> returned = "no";
>
> }
>
> return returned;
>
>
>
> }
>
> }
>
>
>
> And the php:
>
>
>
> <?php
>
>
>
> require_once('./JavaBridge/java/Java.inc');
>
>
>
> java_require('/var/www/bridge/java/pruebaLog.jar');
>
>
>
> try{
>
> $prueba = new Java('pruebaLog');
>
> echo $prueba -> connectDB();
>
> } catch (JavaException $e){
>
> echo "ERROR". "<br>". $e;
>
> }
>
>
>
> ?>
>
>
>
> It shows “no”, I can’t understand why!
>
>
>
> Thank you so much!!
>
>
>
>
>
> Saludos
>
> Rocío Gómez Escribano
>
>
>
>
> ------------------------------------------------------------------------------
> Xperia(TM) PLAY
> It's a major breakthrough. An authentic gaming
> smartphone on the nation's most reliable network.
> And it wants your games.
> http://p.sf.net/sfu/verizon-sfdev
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>
|
|
From: <php...@li...> - 2011-04-08 10:41:37
|
JM!! Thanks! It helped!! But I can't understand it
This is the exception
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Maybe it can't find the driver? If I execute the java class with java it
works, so, I quite sure it should work...
Thank you so much!!
Saludos
Rocío Gómez Escribano
-----Mensaje original-----
De: php...@li...
[mailto:php...@li...]
Enviado el: viernes, 08 de abril de 2011 11:55
Para: php...@li...
Asunto: Re: [Php-java-bridge-users] help with php-java-bridge and mysql
Hi Rocio,
Instead of returning "no", you should display the exception message, that
would help you to solve the problem for sure.
Hope this helps,
JM.
On Fri, Apr 8, 2011 at 5:08 PM, <php...@li...
> wrote:
> Hello, Im trying to use php-java bridge, but I find it impossible!
>
>
>
> Basic examples work without problem, now, I want to connect php with mysql
> using java.
>
>
>
> This is my code:
>
>
>
> Java :
>
>
>
> public class pruebaLog {
>
>
>
> public static String connectDB(){
>
> Connection conn = null;
>
> String returned;
>
> try {
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
>
> conn =
DriverManager.getConnection("jdbc:mysql://localhost/spb",
> "root", "Administrad0r");
>
> returned= open;
>
> } catch (Exception e){
>
> returned = "no";
>
> }
>
> return returned;
>
>
>
> }
>
> }
>
>
>
> And the php:
>
>
>
> <?php
>
>
>
> require_once('./JavaBridge/java/Java.inc');
>
>
>
> java_require('/var/www/bridge/java/pruebaLog.jar');
>
>
>
> try{
>
> $prueba = new Java('pruebaLog');
>
> echo $prueba -> connectDB();
>
> } catch (JavaException $e){
>
> echo "ERROR". "<br>". $e;
>
> }
>
>
>
> ?>
>
>
>
> It shows no, I cant understand why!
>
>
>
> Thank you so much!!
>
>
>
>
>
> Saludos
>
> Rocío Gómez Escribano
>
>
>
>
>
----------------------------------------------------------------------------
--
> Xperia(TM) PLAY
> It's a major breakthrough. An authentic gaming
> smartphone on the nation's most reliable network.
> And it wants your games.
> http://p.sf.net/sfu/verizon-sfdev
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>
----------------------------------------------------------------------------
--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
php-java-bridge-users mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
|
|
From: <php...@li...> - 2011-04-08 14:12:26
|
Hi again! I tried to solve my problema, but it didn't work:
Java :
public class pruebaLog {
public static String connectDB(){
Connection conn = null;
String returned;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn =
DriverManager.getConnection("jdbc:mysql://localhost/spb",
"root", "Administrad0r");
returned= open;
} catch (Exception e){
returned = e.toString();
}
return returned;
}
}
And the php:
<?php
require_once('./JavaBridge/java/Java.inc');
java_require('/var/www/bridge/java/pruebaLog.jar');
java_require('/var/www/bridge/mysql-connector-java-5.1.15-bin.jar');
try{
$prueba = new Java('pruebaLog');
echo $prueba -> connectDB();
} catch (JavaException $e){
echo "ERROR". "<br>". $e;
}
?>
And the same exception
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
It's driving me crazy! Any idea??
Thank you so much!!!
Saludos
Rocío Gómez Escribano
-----Mensaje original-----
De: php...@li...
[mailto:php...@li...]
Enviado el: viernes, 08 de abril de 2011 12:39
Para: php...@li...
Asunto: Re: [Php-java-bridge-users] help with php-java-bridge and mysql
JM!! Thanks! It helped!! But I can't understand it
This is the exception
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Maybe it can't find the driver? If I execute the java class with java it
works, so, I quite sure it should work...
Thank you so much!!
Saludos
Rocío Gómez Escribano
-----Mensaje original-----
De: php...@li...
[mailto:php...@li...]
Enviado el: viernes, 08 de abril de 2011 11:55
Para: php...@li...
Asunto: Re: [Php-java-bridge-users] help with php-java-bridge and mysql
Hi Rocio,
Instead of returning "no", you should display the exception message, that
would help you to solve the problem for sure.
Hope this helps,
JM.
On Fri, Apr 8, 2011 at 5:08 PM, <php...@li...
> wrote:
> Hello, Im trying to use php-java bridge, but I find it impossible!
>
>
>
> Basic examples work without problem, now, I want to connect php with mysql
> using java.
>
>
>
> This is my code:
>
>
>
> Java :
>
>
>
> public class pruebaLog {
>
>
>
> public static String connectDB(){
>
> Connection conn = null;
>
> String returned;
>
> try {
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
>
> conn =
DriverManager.getConnection("jdbc:mysql://localhost/spb",
> "root", "Administrad0r");
>
> returned= open;
>
> } catch (Exception e){
>
> returned = "no";
>
> }
>
> return returned;
>
>
>
> }
>
> }
>
>
>
> And the php:
>
>
>
> <?php
>
>
>
> require_once('./JavaBridge/java/Java.inc');
>
>
>
> java_require('/var/www/bridge/java/pruebaLog.jar');
>
>
>
> try{
>
> $prueba = new Java('pruebaLog');
>
> echo $prueba -> connectDB();
>
> } catch (JavaException $e){
>
> echo "ERROR". "<br>". $e;
>
> }
>
>
>
> ?>
>
>
>
> It shows no, I cant understand why!
>
>
>
> Thank you so much!!
>
>
>
>
>
> Saludos
>
> Rocío Gómez Escribano
>
>
>
>
>
----------------------------------------------------------------------------
--
> Xperia(TM) PLAY
> It's a major breakthrough. An authentic gaming
> smartphone on the nation's most reliable network.
> And it wants your games.
> http://p.sf.net/sfu/verizon-sfdev
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>
----------------------------------------------------------------------------
--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
php-java-bridge-users mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
----------------------------------------------------------------------------
--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
php-java-bridge-users mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
|
|
From: <php...@li...> - 2011-04-08 19:04:03
|
Just add mysql driver. See http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html > java_require('/var/www/bridge/mysql-connector-java-5.1.15-bin.jar'); Err, what does that supposed to do?!? |
|
From: <php...@li...> - 2011-04-11 07:41:33
|
Thank you so much, but I can't getting it up.
I create a link from mysql-connector to /usr/share/tomcat8/lib,
I create a new folder in /var/lib/tomcat6/webapps/ called mysql, where I
create a folder WEB-INF, I create a file web.xml in it, it contains this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<java:comp/env>
<description>
</description>
<res-ref-name>
jdbc/EmployeeDB
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
<java:comp/env>
<Context java:comp/env>
<Resource name="jdbc/EmployeeDB"
auth="Container"
type="javax.sql.DataSource"
username="dbusername"
password="dbpassword"
driverClassName="org.hsql.jdbcDriver"
url="jdbc:HypersonicSQL:database"
maxActive="8"
maxIdle="4"/>
</Context>
Now the java method is:
public String connectDB(){
String returned;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
envCtx.lookup("jdbc/EmployeeDB");
Connection conn = ds.getConnection();
//... use this connection to access the database ...
conn.close();
returned = "bne";
} catch (NamingException ne) {
returned = ne.toString();
} catch (SQLException e){
returned = e.toString();
}
return returned;
}
I have this answer:
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
It's driving me crazy!!!
Saludos
Rocío Gómez Escribano
-----Mensaje original-----
De: php...@li...
[mailto:php...@li...]
Enviado el: viernes, 08 de abril de 2011 21:04
Para: php...@li...
Asunto: Re: [Php-java-bridge-users] help with php-java-bridge and mysql
Just add mysql driver. See
http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html
> java_require('/var/www/bridge/mysql-connector-java-5.1.15-bin.jar');
Err, what does that supposed to do?!?
----------------------------------------------------------------------------
--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
php-java-bridge-users mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
|
|
From: <php...@li...> - 2011-04-11 11:08:07
|
I finally solved it. Thank you so much for your help!! Rocío Gómez Escribano r....@in... Polígono Campollano C/F, nº21T 02007 Albacete (España) Tlf:967-504-513 Fax: 967-504-513 www.ingenia-soluciones.com -----Mensaje original----- De: php...@li... [mailto:php...@li...] Enviado el: lunes, 11 de abril de 2011 9:39 Para: php...@li... Asunto: Re: [Php-java-bridge-users] help with php-java-bridge and mysql Thank you so much, but I can't getting it up. I create a link from mysql-connector to /usr/share/tomcat8/lib, I create a new folder in /var/lib/tomcat6/webapps/ called mysql, where I create a folder WEB-INF, I create a file web.xml in it, it contains this: <?xml version="1.0" encoding="ISO-8859-1"?> <java:comp/env> <description> </description> <res-ref-name> jdbc/EmployeeDB </res-ref-name> <res-type> javax.sql.DataSource </res-type> <res-auth> Container </res-auth> <java:comp/env> <Context java:comp/env> <Resource name="jdbc/EmployeeDB" auth="Container" type="javax.sql.DataSource" username="dbusername" password="dbpassword" driverClassName="org.hsql.jdbcDriver" url="jdbc:HypersonicSQL:database" maxActive="8" maxIdle="4"/> </Context> Now the java method is: public String connectDB(){ String returned; try{ Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup("java:comp/env"); DataSource ds = (DataSource) envCtx.lookup("jdbc/EmployeeDB"); Connection conn = ds.getConnection(); //... use this connection to access the database ... conn.close(); returned = "bne"; } catch (NamingException ne) { returned = ne.toString(); } catch (SQLException e){ returned = e.toString(); } return returned; } I have this answer: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context It's driving me crazy!!! Saludos Rocío Gómez Escribano -----Mensaje original----- De: php...@li... [mailto:php...@li...] Enviado el: viernes, 08 de abril de 2011 21:04 Para: php...@li... Asunto: Re: [Php-java-bridge-users] help with php-java-bridge and mysql Just add mysql driver. See http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html > java_require('/var/www/bridge/mysql-connector-java-5.1.15-bin.jar'); Err, what does that supposed to do?!? ---------------------------------------------------------------------------- -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ php-java-bridge-users mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users ---------------------------------------------------------------------------- -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ php-java-bridge-users mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users |
|
From: <php...@li...> - 2011-04-13 15:07:56
|
Hello! I'm so confused... I have a java code which works fine, but it
doesn't with php.
I create a log file, it should open the existing one (/home/tomcat6/log) and
write on it, but it creates a new file (/home/tomcat/log.1,
/home/tomcat/log.2,...) when I execute my code, this is it (java):
import java.io.IOException;
import java.util.logging.FileHandler;
import java.util.logging.Logger;
import java.util.logging.SimpleFormatter;
public class log {
public static Logger log;
static{
try {
FileHandler fh = new
FileHandler("/home/tomcat6/log.log", true);
fh.setFormatter(new SimpleFormatter());
log = Logger.getLogger("log.class");
log.addHandler(fh);
log.info("hello!!");
}
catch (IOException e) {
}
}
}
I suppose it could be a permission problem, so, I tried with chmod 777 but
it didn't work, do I need some extension to install or something like that?
Thank you in advance!!
|
Thanks for helping keep SourceForge clean.
X