Hey,
now I found the solution for my problem.
you were right...my "con" was null, because the mysql drivers for windows
are not the same as for linux.
I changed the drivers from com.mysql.jdbc.Driver to org.gjt.mm.mysql.Driver.
Now everything works fine.
Thanks to all !!
Max
On 8/16/07, Mondain <[EMAIL PROTECTED]> wrote:
>
> Your "con" is null, my guess is your not getting a connection in your
> linktomysql() and your swallowing the exception.
>
> Paul
>
> On 8/16/07, Max Gieselmann <[EMAIL PROTECTED]> wrote:
> >
> > Hey Carl!
> > Thanks for your answer!
> >
> > I took a look at line 60. But I can't see any error.
> >
> > Line 60: stmt = con.createStatement();
> >
> > stmt is declared as Statement stmt = null;
> >
> > con is linked to a funtion that connects to the mysql database as I
> > wrote in my last mail.
> > con = linktomysql();
> >
> > The whole function:
> >
> > public static String streamName(String sid) {
> > Connection con = null;
> > Statement stmt = null;
> > ResultSet rs = null;
> > String StreamName = "noname";
> >
> >
> > try {
> > con = linktomysql();
> >
> > stmt = con.createStatement(); //LINE 60 !!!
> >
> >
> > rs = stmt.executeQuery("SELECT `stream_name` FROM
> > `eingeloggte_user` WHERE `sid`='"+sid+"'");
> > while ( rs.next() ){
> > StreamName = rs.getString(1);
> >
> > }
> >
> > rs.close();
> > stmt.close();
> > con.close();
> > }
> >
> >
> >
> >
> >
> > catch ( SQLException e ){
> > e.printStackTrace();
> > System.exit(1);
> > }
> >
> >
> >
> >
> > return StreamName;
> > }
> >
> >
> >
> > Thanks
> > Max
> >
> > On 8/15/07, Carl Sziebert <[EMAIL PROTECTED]> wrote:
> > >
> > > Actually the exception is pointing to something else missing from your
> > > application class:
> > >
> > > Caused by: java.lang.NullPointerException
> > > at video.application.streamName(application.java:60)
> > > ... 19 more
> > >
> > > Take a look at line 60 of application.java and make sure that all the
> > > variables there have been initialized properly.
> > >
> > > Carl
> > >
> > > On 8/15/07, Max Gieselmann < [EMAIL PROTECTED]> wrote:
> > > > Hey,
> > > >
> > > > I developed an application for red5 which connects to a Mysql
> > > database and
> > > > SELECTs a set of data. On my Windows PC everything works fine.
> > > > I installed the mysql-connector-java-5.0.7-bin.jar. I made
> > > > a directory called "lib" in the WEB-INF folder of my project and
> > > copied the
> > > > mysql-connector-java-5.0.7-bin.jar to this location.
> > > >
> > > > When I try to use the application on Linux it crashes with the
> > > following
> > > > error message:
> > > >
> > > > (streamName is a function of the application.java.)
> > > > [ERROR] 498512 pool-3-thread-2:(
> > > > org.red5.server.service.ServiceInvoker.invoke ) Error
> > > > executing call: Service: null Method: streamName Num Params: 10:
> > > > 08355b01d350a3467802eeea612fdbde
> > > > [ERROR] 498517 pool-3-thread-2:(
> > > > org.red5.server.service.ServiceInvoker.invoke ) Service
> > > > invocation error
> > > > java.lang.reflect.InvocationTargetException
> > > > at
> > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > > at
> > > > sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java
> > > > :39)
> > > > at
> > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:25)
> > > > at java.lang.reflect.Method.invoke(Method.java:585)
> > > > at org.red5.server.service.ServiceInvoker.invoke
> > > > (ServiceInvoker.java:181)
> > > > at
> > > > org.red5.server.service.ServiceInvoker.invoke (ServiceInvoker.java
> > > :115)
> > > > at
> > > > org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java
> > > :154)
> > > > at org.red5.server.net.rtmp.RTMPHandler.onInvoke
> > > > (RTMPHandler.java:368)
> > > > at
> > > > org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(
> > > BaseRTMPHandler.java:143)
> > > > at
> > > > org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(
> > > RTMPMinaIoHandler.java:120)
> > > > at
> > > >
> > > org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived
> > > (AbstractIoFilterChain.java:703)
> > > > at
> > > >
> > > org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(
> > > AbstractIoFilterChain.java
> > > > :362)
> > > > at
> > > > org.apache.mina.common.support.AbstractIoFilterChain.access$1100(
> > > AbstractIoFilterChain.java:54)
> > > > at
> > > >
> > > org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(
> > > AbstractIoFilterChain.java
> > > > :800)
> > > > at
> > > > org.apache.mina.filter.executor.ExecutorFilter.processEvent(
> > > ExecutorFilter.java:247)
> > > > at
> > > >
> > > org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(
> > > ExecutorFilter.java:307)
> > > > at
> > > > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
> > > ThreadPoolExecutor.java:650)
> > > > at
> > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(
> > > ThreadPoolExecutor.java :675)
> > > > at java.lang.Thread.run(Thread.java :595)
> > > > Caused by: java.lang.NullPointerException
> > > > at video.application.streamName(application.java:60)
> > > > ... 19 more
> > > >
> > > > I think java cannot find the mysql connector?
> > > > Or do I connect in a wrong way?
> > > >
> > > >
> > > > Some excerpts of my application.java ( I am not so advanced in
> > > programming
> > > > with java ;) ).
> > > >
> > > > import java.sql.*;
> > > > [...]
> > > >
> > > > java.sql.Connection conn = null;
> > > > try {
> > > > Class.forName("com.mysql.jdbc.Driver ").newInstance();
> > > > }
> > > >
> > > > [...]
> > > >
> > > > public static String streamName(String sid) {
> > > > rs = stmt.executeQuery("SELECT `stream_name` FROM
> > > `eingeloggte_user`
> > > > WHERE `sid`='"+sid+"'");
> > > > while ( rs.next () ){
> > > > StreamName = rs.getString(1);
> > > > }
> > > > rs.close();
> > > > stmt.close();
> > > > con.close();
> > > > }
> > > >
> > > > [...]
> > > > conn = java.sql.DriverManager.getConnection (
> > > > "jdbc:mysql://localhost/test?user=m_giesel&password=...");
> > > >
> > > > [...]
> > > >
> > > >
> > > > Thanks!
> > > > Max
> > > >
> > > > _______________________________________________
> > > > Red5 mailing list
> > > > [email protected]
> > > > http://osflash.org/mailman/listinfo/red5_osflash.org
> > > >
> > > >
> > >
> > >
> > > --
> > > Be who you are and say what you feel, because those who mind don't
> > > matter and those who matter don't mind.
> > > - Dr. Seuss
> > >
> > > _______________________________________________
> > > Red5 mailing list
> > > [email protected]
> > > http://osflash.org/mailman/listinfo/red5_osflash.org
> > >
> >
> >
> > _______________________________________________
> > Red5 mailing list
> > [email protected]
> > http://osflash.org/mailman/listinfo/red5_osflash.org
> >
> >
>
>
> --
> It is difficult to free fools from the chains they revere. - Voltaire
> _______________________________________________
> Red5 mailing list
> [email protected]
> http://osflash.org/mailman/listinfo/red5_osflash.org
>
>
_______________________________________________
Red5 mailing list
[email protected]
http://osflash.org/mailman/listinfo/red5_osflash.org
