java.sql.SQLException: No suitable driver

[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]

Abgeschickt von Dennis am 13 Oktober, 2004 um 23:12:47

Hi,

I'm a newbie with using the JDBCAppender and I'm having a problem.

After setting up my log4j.properties file to make use of the JDBCAppender as follows:

# db: appender to log to database
log4j.appender.db=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.db.url=jdbc:mysql//localhost:3306/test
log4j.appender.db.dbclass=com.mysql.jdbc.Driver
log4j.appender.db.username=test
log4j.appender.db.password=test
log4j.appender.db.sql=INSERT INTO log (date, level, location, message) VALUES ('Oct-10-2004','INFO','test.properties','it works!')
log4j.appender.db.layout=org.apache.log4j.PatternLayout
log4j.appender.db.layout.ConversionPattern=%m%n

I get the following error message:

log4j:ERROR JDBCAppender::flush_buffer(), :
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)

I double checked to make sure my driver (com.mysql.jdbc.Driver) exists in my build path, but still have no luck in getting an entry created in my data table and I have the above error message.

I'm using Log4j v1.2.8
My server is JBoss v3.2.4
My database is MySql v4.0.2d
My jdbc driver is connector-j v3.0.15

Any insight on this matter would be appreicated.

Thanks in advance.

Antworten:

play texas holdem play texas holdem 11:42:11 06/1/2005 (0)
texas holdem texas holdem 14:42:16 04/1/2005 (0)
texas holdem texas holdem 09:34:54 04/1/2005 (0)
texas hold em texas hold em 23:41:11 03/1/2005 (0)
online poker online poker 12:26:17 03/1/2005 (0)
texas holdem texas holdem 14:05:30 02/1/2005 (0)
texas holdem <a href=http://www.texas-holdem-p.com texas holdem texas holdem 21:38:59 01/1/2005 (0)
Re: java.sql.SQLException: No suitable driver Dennis 19:40:33 14/10/2004 (7)
- play texas holdem play texas holdem 11:45:27 06/1/2005 (0)
- texas holdem texas holdem 14:46:00 04/1/2005 (0)
- texas holdem texas holdem 09:38:09 04/1/2005 (0)
- texas hold em texas hold em 23:44:20 03/1/2005 (0)
- online poker online poker 12:29:45 03/1/2005 (0)
- texas holdem texas holdem 14:08:51 02/1/2005 (0)
- texas holdem <a href=http://www.texas-holdem-p.com texas holdem texas holdem 21:42:08 01/1/2005 (0)

Ihre Antwort

Name:
E-Mail:

Subject:

Text:
: Hi, : I'm a newbie with using the JDBCAppender and I'm having a problem. : After setting up my log4j.properties file to make use of the JDBCAppender as follows: : # db: appender to log to database : log4j.appender.db=org.apache.log4j.jdbcplus.JDBCAppender : log4j.appender.db.url=jdbc:mysql//localhost:3306/test : log4j.appender.db.dbclass=com.mysql.jdbc.Driver : log4j.appender.db.username=test : log4j.appender.db.password=test : log4j.appender.db.sql=INSERT INTO log (date, level, location, message) VALUES ('Oct-10-2004','INFO','test.properties','it works!') : log4j.appender.db.layout=org.apache.log4j.PatternLayout : log4j.appender.db.layout.ConversionPattern=%m%n : : I get the following error message: : log4j:ERROR JDBCAppender::flush_buffer(), : : java.sql.SQLException: No suitable driver : at java.sql.DriverManager.getConnection(Unknown Source) : I double checked to make sure my driver (com.mysql.jdbc.Driver) exists in my build path, but still have no luck in getting an entry created in my data table and I have the above error message. : I'm using Log4j v1.2.8 : My server is JBoss v3.2.4 : My database is MySql v4.0.2d : My jdbc driver is connector-j v3.0.15 : Any insight on this matter would be appreicated. : Thanks in advance.

Optionale URL:
Link Titel:
Optionale Bild-URL:

[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]